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.

Why SQL Server Named Instance connect without specifying instance name ?

by Rohit Garg

MSSQLFUN

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

2012-11-12

2,637 reads

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

by Rohit Garg

MSSQLFUN

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

2012-11-09

2,362 reads

SQL Server 2012 SP1 Is Now Available !

by Rohit Garg

MSSQLFUN

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

2012-11-08

955 reads

Come Back From vacations…..

by Rohit Garg

MSSQLFUN

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

2012-11-05

545 reads

SQL Server – List of all the Error codes or messages

by Rohit Garg

MSSQLFUN

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

2012-11-05

34,211 reads

SQL Server 2012 CU4 Is Now Available !

by Rohit Garg

MSSQLFUN

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

2012-10-16

762 reads

IMPORTANT MESSAGE || http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM

by Rohit Garg

MSSQLFUN

Dear Friends
Firstly, I want to say thanks for your support & liking my blogs that make it possible.
I like to share...

2012-10-15

589 reads

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

by Rohit Garg

MSSQLFUN

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

2012-10-15

2,995 reads

How to move the FullText catalog with SQL Server 2005 ?

by Rohit Garg

MSSQLFUN

4 simple steps to move FullText catalog with SQL Server 2005 :-
1. Detach the database which contains the FullText Catalog....

2012-10-12

1,079 reads

SQL Server 2012 SP1 CTP4 Is Now Available !

by Rohit Garg

MSSQLFUN

Service packs are very critical and important. It is very important from product upgrade & bug fixing point of view.
Microsoft has...

2012-10-11

731 reads

Blogs

T-SQL Tuesday #203: Risk and Reward

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Read the latest Blogs

Forums

Risk Vs Reward, The never ending ROI discussion.

Comments posted to this topic are about the item Risk Vs Reward, The never...

Alamat BCA KCP Roxy Mas Telp:0821-8200-203

By layanan_Bca88

Telp/Wa 628218200203 Komplek Ruko Roxy Mas, Jl. Kh Hasyim Ashari No.6 Blok C.5 No,...

Alamat BCA KCP Reg.Tanah Abang Telp:0821-8200-233

Telp/Wa 628218200233 Ps. Regional Tanah Abang Blk. F, Lt. Dasar, Kp. Bali, Kecamatan Tanah...

Visit the forum

Question of the Day

Hyperscale Replicas IV

In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?

See possible answers