Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

MSSQLFUN

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

Archives: November 2012

SQL Server 2012 SP1 CU1 Is Now Available !

The 1st cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site.

SQL Server 2012 SP1 CU1 contains fixes released in SQL Server 2012 RTM CU 3 & 4. For those who are upgrading to Service Pack 1 from SQL… Read more

0 comments, 1,086 reads

Posted in MSSQLFUN on 22 November 2012

SQL Server 2008 SP3 CU8 Is Now Available !

The 8th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft Support site. Cumulative Update 8 contains all the hotfixes released since the initial release of SQL Server 2008 SP3.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 527 reads

Posted in MSSQLFUN on 22 November 2012

Restoring a SQL Server 2005 Full-Text Catalog to SQL Server 2012

Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 is to restore a full database backup to SQL Server 2012.

The full database backup will include the full-text catalog is required for upgrading & importing a SQL Server 2005 full-text catalog.

Backup from SQL Server 2005 Read more

0 comments, 1,252 reads

Posted in MSSQLFUN on 19 November 2012

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 to add more connection parameters to the connection string.

Steps to get Additional Connection Parameters page

  1. In Management Studio, on the Query menu, point to Connection, and then click Connect.

Read more

0 comments, 1,867 reads

Posted in MSSQLFUN on 16 November 2012

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 on MSDN.

Profile Page : http://social.msdn.microsoft.com/profile/rohitgarg/

 

 

 

 

Reference : Rohit Garg (http://mssqlfun.com/)


Read more

0 comments, 590 reads

Posted in MSSQLFUN on 15 November 2012

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 DATABASE DB2

TO DISK = ‘D:\DB2_FULL.BAK’ WITH COMPRESSION

GO

BACKUP DATABASE DB2

TO DISK = ‘D:\DB2_FULL.BAK’ WITH NOINIT

Result : Run Successfully

Explanation : Backup file is… Read more

0 comments, 1,166 reads

Posted in MSSQLFUN on 14 November 2012

Happy Diwali………….

Wishing You a Very Happy Diwali…………….

KAHI TIMTIMAHAT HAIN DIYO KI, KAHI SHOR HAAN ATHISBAZI KA

CHAMAK HAAN DIL MAIN, UMEEDO KI KHANAK HAAN

MITHAIYO KA ANAND HAAN, PATHAKO KI JHADI HAAN

YE JEET HAAN SACH KI, YE JASAN HAAN DIWALI KA


Read more

1 comments, 384 reads

Posted in MSSQLFUN on 13 November 2012

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 one of my friend. He is not running under any production issue but bit confused with SQL server behavior while connecting with port no. in case of named instance. Read more

3 comments, 1,540 reads

Posted in MSSQLFUN on 12 November 2012

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 :

  1. On the File menu in SQL Server Management Studio, point to Open, and then click File.
  2. In the Open File dialog box, select your .xdl file & click open.

Solution 2 :

  1. Go to the…

Read more

0 comments, 856 reads

Posted in MSSQLFUN on 9 November 2012

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 Server 2012 Service Pack 1 (SP1). Both, the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. SQL Server 2012 SP1 contains fixes… Read more

2 comments, 605 reads

Posted in MSSQLFUN on 8 November 2012

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

How to save deadlock graph events as .xdl file ?

  1. On the File menu, click New Trace, and then connect to an instance of SQL Server.
  2. In the Trace Properties dialog box, type a name for the trace in the Trace name box.
  3. In the Use the template list, select…

Read more

0 comments, 1,708 reads

Posted in MSSQLFUN on 7 November 2012

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 comes to your mind, I am sure most of us will start goggling or looking into BOL for the details

But SQL server also Contains one… Read more

7 comments, 6,831 reads

Posted in MSSQLFUN on 5 November 2012

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.


Read more

2 comments, 239 reads

Posted in MSSQLFUN on 5 November 2012