SSMS 2012 || Connect to Server (Additional Connection Parameters Page)

The Connect to SQL Server Management Studio presents a new Additional Connection Parameters Page. Use the Additional Connection Parameters page...

Become Microsoft Community Contributor …..

Become Microsoft Community Contributor.
I am very happy after receiving this affiliation from Microsoft last month.
My MCC badge is visible now...

SQL Server || Compress & UnComprees Backups in one Media\File

Today, We try to check of SQL server when trying to take Compress & UnCcomprees Backups in one Media\File.
Query No. 1
BACKUP...

Happy Diwali………….

Wishing You a Very Happy Diwali…………….
KAHI TIMTIMAHAT HAIN DIYO KI, KAHI SHOR HAAN ATHISBAZI KA
CHAMAK HAAN DIL MAIN, UMEEDO KI...

Why SQL Server Named Instance connect without specifying instance name ?

Issue :
Today Evening, I was just about to leave the office and at same time I got a call from...

How to open and view a deadlock graph .xdl file with SSMS ?

How to open and view a deadlock .xdl file with SSMS ?
Solution 1 :
On the File menu in SQL Server...

SQL Server 2012 SP1 Is Now Available !

After a wait of around 8 months, Microsoft has released SQL Server 2012 SP1.
Microsoft SQL Server team has released SQL...

How to save deadlock graph events as .xdl file in SQL Server ?

How to save deadlock graph events as .xdl file ?

On the File menu, click New Trace, and then connect to...

SQL Server – List of all the Error codes or messages

Question:
I want list of all error codes & messages of SQL server.
Answer:
Once some ask this thing to you or this though...

Come Back From vacations…..

Hey Friends
I missed you so much in my vacations.
I come back from my leaves & hope now we have regular interactions.