SQLMCM

Become an expert in SQL Server Performance Tuning & Troubleshooting!

08/04/2014 / By / .NET German, SQLMCM, SQLServer, SQLServerPedia

Since September 2012 I’m a Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server that is currently available. Because I want to share my performance tuning & troubleshooting knowledge, and because of the huge demand on performance tuning I’m running again this year my popular SQL Server Performance Tuning …

Become an expert in SQL Server Performance Tuning & Troubleshooting! + read more

Service Broker Adventures: Stucked Queue Monitors

08/04/2014 / By / .NET German, SQLMCM, SQLServer, SQLServerPedia

This week I’m in London helping a client with its large scale Service Broker deployment, mainly troubleshooting some strange problems with Service Broker and helping to improve the overall scalability and messaging throughput. Today I want to share a strange scenario with you, how a badly written Activated Stored Procedure isn’t really activated by Service …

Service Broker Adventures: Stucked Queue Monitors + read more

SQLMCM Training – Day 18

08/04/2014 / By / .NET German, Conferences, SQLMCM, SQLServer, SQLServerPedia

Today we covered the topics Full Text Search, Change Data Capture, Change Tracking, and Service Broker. I have taken no notes on Service Broker, because I have well documented that topic a few years ago here. Full Text Search Fulltext Index is changed automatically in the background (by default) Fulltext Catalog is a container for …

SQLMCM Training – Day 18 + read more

SQLMCM Training – Day 17

08/04/2014 / By / .NET German, Conferences, SQLMCM, SQLServer, SQLServerPedia

Today Bob spoke about Auditing, SQLCLR, XML, and Spatial Data. Because I already know these concepts very well, my study notes for today are very sparse. Auditing SQL Trace has too much drawbacks from Auditing Separate program Column Level GRANT overrides a DENY Auditing audits changes to Auditing Auditing Targets can’t be shared Auditing uses …

SQLMCM Training – Day 17 + read more

SQLMCM Training – Day 16

08/04/2014 / By / .NET German, Conferences, SQLMCM, SQLServer, SQLServerPedia

Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting data. It was really hard content, and sometimes it was really hard to follow, because of too much PowerPoint slides. I already miss Paul’s whiteboard drawings… 😉 Here are my study notes. SQL Server Setup SQL Server VSS Writer Needed for …

SQLMCM Training – Day 16 + read more

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.