Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had about SQLCMD.
SQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer)
Just another day I received following error while starting my agent. As soon as I received following error I felt like Deja Vu. I had similar feeling few days ago. I quickly looked at my blog post history and I found out following article SQL SERVER – Fix : Error…
Read More
SQL SERVER – Import CSV File into Database Table Using SSIS
It is very frequent request to upload CSV file to database or Import CSV file into database. I have previously written article how one can do this using T-SQL over here SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server.
SQL SERVER – expressor 3.2 Release Review
I have been following expressor software for some time now and they have recently released a new version of their expressor Studio desktop ETL application. I am pleased to find out that the download and installation experience of this application has been greatly simplified. expressor Studio no longer requires users to install a license key after they download and install the product. They have also eliminated a Microsoft Visio dependency from their product. Removing the license requirement and Visio dependency has made download and installation much easier.
SQL SERVER – Common Table Expression (CTE) and Few Observation
This blog post is written in response to the T-SQL Tuesday hosted by Bob Pusateri. He has picked very interesting topic which is related to APPLY clause of the T-SQL. When I read the subject, I really liked the subject. This is very new subject and it is quite a…
Read MoreSQL SERVER – SQL Server Management Pack Guide for System Center Operations Manager 2007
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and…
Read MoreSQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?
Recently I was talking with Vinod Kumar regarding NOLOCK. Suddenly he asked me do I know what kind of lock WITH(NOLOCK) hint takes on object. The immediate response of mine was that NOLOCK does not take any lock. He responded suggesting that I should think more and answer. I realized…
Read More