Quick way to get size of databases on a sql server instance
Here is a dirty little sql that will give you the size of all the databases in your instance :...
SQL Server recovery using differential backup
One of my DBAs said while trying to restore differential backup he was getting  : Fix : Error : Msg...
I call it smart sp_who2
If you have been working on SQL Server, you would have definitely used sp_who2. One of the limitations of sp_who2...
Search for keyword in SQL Server Objects
Have you ever had to search for some keyword in a database object code. Here is a piece of sql...
What if you encounter Error number: 20598 with SQL Server replication ?
Today on one of the sql server I encountered an interesting scenario, one of the dbas accidentally deleted data from subscriber...
SQL Server 2012 Licensing model
With SQL Server 2012, Microsoft has changed its licensing model along with “consolidating” the different types of editions. Gone is...