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: February 2013

SQL Server Discovery Report

How can I check what all SQL server features and version are installed on my Machine ?

It’s a frequently asked question. You need to study your environment, need to login each instance to check version & other details, to answer this question.

Till SQL Server 2005, you have no… Read more

0 comments, 444 reads

Posted in MSSQLFUN on 25 February 2013

Cumulative Update – 5 for SQL Server 2008 R2 Service Pack 2 Is Now Available !

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

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

0 comments, 627 reads

Posted in MSSQLFUN on 19 February 2013

Cumulative Update – 6 for SQL Server 2012 Is Now Available !

The 6thcumulative update release for SQL Server 2012 is now available. Cumulative Update 6 contains all the hotfixes released since the initial release of SQL Server 2012.

Those who are facing severe issues with their environment, they can plan to test CU6 in test environment & then move to Production… Read more

0 comments, 426 reads

Posted in MSSQLFUN on 19 February 2013

Cumulative Update – 11 for SQL Server 2008 R2 Service Pack 1 Is Now Available !

The 11thcumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 11 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP1.

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

0 comments, 408 reads

Posted in MSSQLFUN on 19 February 2013

Backup not starting for Database with Full Text Catalog…………..Failed to change the status to RESUME for full-text catalog in database. Error: 0×80043607

Issue :-

One of our Database with Full Text Catalog is not getting backed up. When I checked, backup keeps pending on 0% without any progress. In SQL server error log, I also found error related to Full text catalog that SQL server is facing issue in setting Full test… Read more

0 comments, 334 reads

Posted in MSSQLFUN on 14 February 2013

Connect PerfMon to a Remote Server

It seems to be a simple & easy thing to connect Perfmon to a remote server.

GO TO RUN > Perfmon > Right Click “Connect to Another Computer” > Enter server name & you are done

But I face several connectivity issue during connecting Perfmon from remote server.

ISSUE 1:… Read more

1 comments, 429 reads

Posted in MSSQLFUN on 14 February 2013

How to get list of all available parameter of .EXE file ?

Today, We discuss How to get list of all available parameter of .EXE file OR How to find list of SQL Server setup parameters ?

Major problem is of all available parameter details. Sometime, We need to pass parameter to .EXE file to get some different & superior functionality.

We… Read more

1 comments, 423 reads

Posted in MSSQLFUN on 13 February 2013

Refresh Intellisense in SSMS(SQL Server Management Studio) 2008 & above

Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy.

But Sometimes I find that intellisense becomes stale and you start getting the wavy red lines when writing code. Even though object exists in database but Intellisense is not able to… Read more

3 comments, 690 reads

Posted in MSSQLFUN on 11 February 2013

Move or Relocate the files of Resoruce Database in SQL Server 2005

The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain… Read more

3 comments, 331 reads

Posted in MSSQLFUN on 7 February 2013

Microsoft SQL Server License Helpline

Microsoft SQL Server license has lots of flavors in terms of user based \ CAL or processor based license, license based on versions or license based on environment (physical or virtual).

Although, Microsoft release license guidelines for each & every SQL server version. But there are more complex scenarios for… Read more

0 comments, 347 reads

Posted in MSSQLFUN on 5 February 2013