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

DB Mail error “File attachment or query results size exceeds allowable value of 1000000 bytes”

by Rohit Garg

MSSQLFUN

Issue : One email report is working fine from long time but suddenly it failed today with below error.
Error :
Msg 22051,...

2017-11-01

1,301 reads

SSMS error – Unable to Connect to SSIS – The Specified Service Does Not Exist as an Installed Service

by Rohit Garg

MSSQLFUN

Issue: SQL Server Integration Service (SSIS) 2016 unable to connect from SQL Server Management Studio (SSMS) 17.0.
Error:
Connecting to the Integration...

2017-10-23

2,325 reads

How to Perform and schedule SSAS Backups ?

by Rohit Garg

MSSQLFUN

Steps to configure schedule SSAS Cube \ OLAP database backups :-
1. For each SQL Server Analysis Services Environment. In order to...

2017-10-16

1,403 reads

What is DBCC CLONEDATABASE ?

by Rohit Garg

MSSQLFUN

DBCC CLONEDATABASE is new feature comes up with SQL Server 2014 Service Pack 2 and above. DBCC CLONEDATABASE is used...

2017-10-13 (first published: 2017-10-09)

2,429 reads

Database snapshot issue with sqlserver

by Rohit Garg

MSSQLFUN

Database snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with...

2017-05-23

676 reads