Principal Instance - Put the database you want to mirror in FULL recovery mode. For example: 1: BACKUP DATABASE AdventureWorksLT2008 2: TO DISK = 'c:\AdventureWorks…
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…
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…
In one to many relationships of two tables, sometimes we need to write a query which can return comma separated list of all child values for each parent. Here are two different methods by which yo…
I found many questions regarding the inline named default constraints in many user groups, its actually pretty simple CREATE TABLE dbo.tempabc ( [col1] [ varchar ] (16), [col2] [ int ] NULL CONS…