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

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

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

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

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

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

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

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

1. To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out

DECLARE @AGENT_ERRORLOG NVARCHAR(255)

EXECUTE MASTER.DBO.XP_INSTANCE_REGREAD N’HKEY_LOCAL_MACHINE’,

N’SOFTWAREMICROSOFTMSSQLSERVERSQLSERVERAGENT’,

N’ERRORLOGFILE’,

@AGENT_ERRORLOG OUTPUT,

N’NO_OUTPUT’

SELECT @@SERVERNAME SERVERNAME, @AGENT_ERRORLOG AGENTERRORLOGLOCATION

This command will work for both default & named instance.

2. To modify location and name of SQLServer… Read more

1) Open Installation Wizard

2) Select Feature You want to install

3) Provide installation configuration

4) Now that you have the configuration file, copy it to your own folder or network share where you want to start the… Read more

The 2nd cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 2 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can plan to test CU2 in test environment… Read more

The 9th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 9 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 plan to test CU9 in test environment… Read more

Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm that SQL Server really Reserve 1 user connection for DAC (Dedicated Administrator Connection).

So I decide to show a demo for the same. I have changed the no. of… Read more

Read more

Problem :

Yesterday Night, One of my team member called & report that some users are getting below error no. 1 while connection to SQL server & error no. 2 while trying to open Management folder.

Error 1 : Cannot display policy health state at the server level, because the… Read more

Today, I am willing to do demo that under which user my SQL Agent Job run, SQL Agent Service Account or SQL Agent Job Owner ?

Normally, We think its SQL Agent Service account user under which SQL jobs runs. But it’s not true in all cases, It depend on… Read more

Read more

Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB but whenever user try to run SQL Agent job, it get below error message.

We have Checked that SQL Agent job related DB role is properly given to user.… Read more

CMD code to upload file direct into root of FTP site of server

@ echo off

REM ******** this batch file is to upload file

echo user username> ftpcmd.dat

echo password>> ftpcmd.dat

echo bin>> ftpcmd.dat

echo lcd D:\Filelocation>>ftpcmd.dat

echo put filename.csv>> ftpcmd.dat

echo quit>> ftpcmd.dat

ftp -n -s:ftpcmd.dat 172.xx.xx.xxx

del… Read more

We all know that SQL Server can have 1 default instance & many named instance.

But I want to check, How SQL Server Setup behave, If I tries to use instance name that is already being used by some existing SQL server on my system.

I am already having 2… Read more