Remove Witness from SQL Server Database Mirroring

1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2) To remove the witness, delete its server...

Last Weeks Top “Reading” Links #106

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Minion Reindex is here

We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on SQLServerCentral.com, and people have responded so incredibly positively. We’re quite...

A script to list the DTS connection information for every package on the instance.

For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest...

Cumulative Update – 4 for SQL Server 2014 RTM Is Now Available !

The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...

Remove Witness from SQL Server Database Mirroring

1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2)...

Drop and Recreate all Synonyms

Had a quick job the other day restoring a pair of databases under different names which is all straight forward...

Drop and Recreate all Synonyms

Had a quick job the other day restoring a pair of databases under different names which is all straight forward...

EXEC sp_executeSQL

Today I am going to talk about the stored proc sp_executesql and the benefits it has over EXEC @SQL. Microsoft actually recommend that you use the sp_executesql stored procedure...

Oh! I forgot When I took last Database Backup ? How to determine this? TIP # 66

 
In last few tips TIP #64 & TIP #65  we get information  how to take backup & How to ensure it can...