PASS DBA VC Session 25th June

PASS DBA VC Session 25th June

It’s always an honour to be able to speak at an event, but events can be expensive to attend and they don’t always occur at a time or location that is convenient for you. Thankfully those smart people at PASS have created a number of Virtual Chapters so you can watch sessions live from the […]

Spring may be long gone but you still need to clean up MSDB

Spring may be long gone but you still need to clean up MSDB

System databases are often neglected, part of this is due to Microsoft’s message of SQL Server will run and look after itself. In fairness it does to a certain extent (no, that’s not a pun), it’s configured out of the box not to be the fastest, but to be stable. The problem is that SQL […]

Data loss in clustered index occurs when you run online build index in SQL Server 2012

Data loss in clustered index occurs when you run online build index in SQL Server 2012

Scared? Don’t worry, there is a workaround and a hotfix. More on that in a moment. This morning I checked my Twitter feed and saw this post from Nicholas Cain, it’s really important to take note of this so I decided to write a few lines in the hope that more people would see this […]