If you see your replication log reader slow down for no reason, here’s some stuff to look at.
So a while back we were seeing some very strange behavior with our SQL Replication. Every once and a while for no apparent reason the log reader would just slow down the pulling of records from a single publisher database. Our replication was setup with a single publisher, and a single distributor with over a […]
For the love of god people, quit screwing around with the base permissions within SQL Server.
I know that security people like to remove permissions from everything before certifying that a server is ready to go into production. And like 10+ years ago that was something that you might have wanted to do (I’m just talking about SQL Server here). However in today’s world of SQL Server 2005 and newer that […]
My MCM Lab experience.
So just in case you missed it, I took and passed the Microsoft MCM lab last Thursday. Since I’m the first person to go through the test in the new format I wanted to put together some comments (as best I can thanks to NDAs). So the MCM gives you 6 hours to complete, and […]
In honor of my receiving my MCM, Amazon has started selling “Securing SQL Server” on the Kindle.
OK, that’s totally BS, but it sounds awesome doesn’t it. But it is sort of true. I was grabbing the URL for my book to send to someone today, and I noticed that the Kindle version had a price listed. The book is $39.96 at the moment (I don’t set the price), so all of […]