Some of you may have noticed that I haven’t posted for a while. The 12th May was the date of my last post. Well, in the last few weeks I have been on holiday. Me and the family took a trip to the USA and the Sunshine state to celebrate… Read more

Ever come across a scary error in the SQL Server log when running CHECKDB against your databases. The error looks something like this:

1 transactions rolled back in database 'CHECKDB' (32). This is an informational message only. No user action is required.

Are transactions rolled back when CHECKDB runs?

No. Read more

I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it. For some of the larger databases that I manage I change how this is run but on my consolidated instances which can house several different smaller databases I run the… Read more

My first post in my replication series gave a brief overview of replication, before I dive into setting up and configuring the different types of replication I wanted to look a little more closely at the respective agents and the role they play in the different types of replication. Read more