Managing List of MSSQL Servers via SSMS in 5 Simple Steps

It is really a hassle to manage a list of Microsoft SQL Servers (MSSQL Server) via Microsoft SQL Server Management Studio (SSMS) especially when it requires you to manage multiple database connections.

I admit that one of the grave mistake that I did was to use the Server name dropdown list in the Connect to Server dialog box to select the database that I wish to connect as highlighted below:

Drop down list in SSMS
If you use this dropdown list, I wish you best of luck!

Read more

Find Missing Identity Numbers in MS SQL Server

While I was doing some support cases, I realized that there might be some rows missing from the database for a particular day. So, I took some time off to confirm that indeed there was missing rows from database before I submit a request to DBA to restore the database.

Example: I will try to retrieve missing rows for the date 2013-03-19.

I did the following query to confirm if there was indeed missing rows:

Read more