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.

SQL Server 2012 CU4 Is Now Available !

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

Multilanguage Table, How to insert different language text in table ?

Issue :
Today, I received one request from my old friend.
He wants to insert text in different languages in table. He...