New online course: Why Physical Database Design Matters

Kimberly’s first Pluralsight online training course went live today: SQL Server: Why Physical Database Design Matters It’s 4 hours long and is the first in a multi-part series on performance. The modules in this course are: Introduction Data Types and Row Size Data Types and Index Size Data Types and Query Performance You can get to […]

Real world story of DBCC PAGE saving the day

Last week I answered a question on Twitter about DBCC PAGE and asked if I could be sent more details about the problem. The person was gracious enough to send me a detailed explanation, and it’s such an interesting scenario that I asked for and received permission to share this cut-down, anonymous version of the […]

How to tell who changed a log file characteristic?

My good friend Orson Weston (@weston12) posted a question to #sqlhelp on Twitter earlier: Is there a way out of the box to find when and who changed the max file size for a log file? You can’t tell this from the default trace as that just logs that the database was altered, not the log […]

New online course: Detecting and Correcting Database Corruption

My latest Pluralsight online training course went live today: SQL Server: Detecting and Correcting Database Corruption It’s 4 hours long and is the first in a two-part series, with a more advanced course coming in a few weeks. The modules in this course are: Introduction Causes of Database Corruption Detecting Page Corruption Consistency Checking DBCC […]

Death of the MCM program

Last week, in the immediate aftermath of the sudden announcement by Microsoft of the cancelling of the MCM/MCSM (Microsoft Certified Master) program, I kicked off a survey asking how the decision affects you. I hoped it would be one more data point that would help persuade Microsoft Learning (MSL) that the MCM program should continue. […]

Survey: SQL Server MCM cancellation – does it affect you?

I’m sure most of you have heard the news now that Microsoft has effectively cancelled the MCM/MCSM/MCA program abruptly, with a cold email sent at 10pm last Friday night. There’s a lot of anger in the community about the way it was done – with only one month’s notice for people to attempt the exams […]

New classes for 2014 in Tampa, Chicago, Bellevue, Australia open for registration

Kimberly’s been hard at work finalizing details of the classes we’ll be offering in the first half of 2014 and we have 17 new classes open for registration, covering the whole range of courses we teach. Where are we going? We’re heading to Tampa, Chicago, and Bellevue in the US, plus Australia (see below) and […]