Showing posts from June, 2010

How to Setup High Performance (asynchronous) Mirroring with No Witness

Principal Instance - Put the database you want to mirror in FULL recovery mode. For example: 1: BACKUP DATABASE AdventureWorksLT2008 2: TO DISK = 'c:\AdventureWor…

How To: Reset Identity column in SQL Server

This is one of those simple tip posts that may seem obvious and taken for granted by those of us who have been working with SQL Server for a while now but maybe a newbie or two out there will find th…

Free SQL Server tools that might make your life a little easier

This list will grow as I find new tools. So if you know of some not on this list do post them in the comments. SQL Server Management Studio Add-in's SSMS Tools Pack - an add-in with lots…
Subscribe Our Newsletter