I’m having a sale on SQL Saturday slide decks, two for the price of one.
The last two weekends I’ve presented at two different SQL Saturday events, so as I’m pretty lazy I’m posting the decks for both weekends in a single blog post. SQL Saturday 47 – Phoenix Back to Basics; Getting Back to the Basics of SQL Server SQL Server Clustering 101 Where should I be encrypting my […]
ANSI Settings can have all the difference in the world.
So a little while back we noticed that we had some high CPU load coming from a single stored procedure in the Session State database. This single procedure (TempUpdateStateItemLong) was taking up 80% of the CPU time that the database was using (we used Spotlight for SQL Server Enterprise from Quest software). But in another […]
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 […]