Series : SQL DBA Cheatcode


cheatcode

SQL DBA Cheatcode is a series or you can say a collection of those SQL Server scripts which we find very useful while troubleshooting issues day to day. These scripts are trusted and tested however there are some chances that a script may not work with some versions of SQL Server.

SN Date Topic
Part 1  January 13, 2015 Few Important Queries for any DBA – Database Related
Part 2  February 1, 2015 Few Important Queries for any DBA – Replication
Part 3  February 21, 2015 Few Important Queries for any DBA – Backup Restore
Part 4  April 8, 2015 Few Important Queries for any DBA – Table and constraints
Part 5  June 2, 2015 Playing with indexes
Part 6  June 4, 2015 Know your SQL Server – SQL Server Related
Part 7  June 26, 2015 Who deletes the databases?
Part 8  July 13, 2015 SQL Server properties
Part 9  July 14, 2015 15 Things about SQL Server Error logs