Category Archives: Uncategorized
Query the status of SQL Agent jobs
I’ve been involved in building a solution on top of SQL Server peer to peer replication (SQL 2014 SP1) and slowly building up a script library for general DBA tasks within that solution. One common task is to add a … Continue reading
Migrating SQL Server logins
Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During some recent migration work I realised that SQL Server Management Studio could do most of the work of sp_help_revlogin. I … Continue reading
Don’t believe everything you read: Reconfigure flushes the plan cache
I’ve been doing a fair bit of research and investigation into theĀ behaviorĀ of the plan cache recently. So I was concerned when I read somewhere that the reconfigure statement causes the SQL Server plan cache to be flushed. If this is … Continue reading
Hello world!
After years chasing culinary rockstar-dom I have done a career about face and now find my self a ripened old junior DBA. I thought that I might follow the fashion and start a blog. My intention is to use this … Continue reading