Rohit Garg

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.

All authors

Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !

by Rohit Garg

MSSQLFUN

The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...

2014-08-26

706 reads

How to kill a negative SPID (like SPID -2 or -3) in SQL Server?

by Rohit Garg

MSSQLFUN

Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all...

2014-08-25

25 reads

How to kill a negative SPID (like SPID -2 or -3) in SQL Server?

by Rohit Garg

MSSQLFUN

Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not...

2014-08-25

7,368 reads

Renaming or Changing SQL Server Cluster Instance

by Rohit Garg

MSSQLFUN

Renaming or Changing SQL Server cluster instance process is bit different from renaming a stand-alone instance.
Refer : Rename or Change SQL...

2014-08-12 (first published: 2014-08-04)

16,425 reads

SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE

by Rohit Garg

MSSQLFUN

Error : Database backup is getting fail with below reason. The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is not online. Check errorlog file for the...

2014-08-11

5 reads

SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE

by Rohit Garg

MSSQLFUN

Error : Database backup is getting fail with below reason.
The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is...

2014-08-11

1,138 reads

Rename or Change SQL Server Standalone Named Instance

by Rohit Garg

MSSQLFUN

Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance.
Renaming or Changing SQL...

2014-08-05 (first published: 2014-07-29)

9,104 reads

Rename or Change SQL Server Standalone Named Instance

by Rohit Garg

MSSQLFUN

Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance. Renaming or Changing SQL Server Standalone Named Instance is almost same as...

2014-07-29

4 reads

Steps to install Service Pack for SQL Server 2005 – Multiple Instances

by Rohit Garg

MSSQLFUN

Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :-
Step 1 : First page of...

2014-07-28 (first published: 2014-07-21)

8,004 reads

Cumulative Update – 1 for SQL Server 2012 Service Pack 2 Is Now Available !

by Rohit Garg

MSSQLFUN

The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 1 contains all the hotfixes...

2014-07-27

4 reads

All authors

Rohit Garg

Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !

How to kill a negative SPID (like SPID -2 or -3) in SQL Server?

How to kill a negative SPID (like SPID -2 or -3) in SQL Server?

Renaming or Changing SQL Server Cluster Instance

SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE

SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE

Rename or Change SQL Server Standalone Named Instance

Rename or Change SQL Server Standalone Named Instance

Steps to install Service Pack for SQL Server 2005 – Multiple Instances

Cumulative Update – 1 for SQL Server 2012 Service Pack 2 Is Now Available !

Blogs

Query Intelligence in SQL Server 2025: What Developers Need to Know

Finding and Killing Blockers with Redgate AI Tech

Back at Small Data SF in 2025

Forums

Large posts full of code not allowed anymore?

Data > Hype

Create and Read the Analysis Services Flight Recorder

Question of the Day

Slipstream parameters