SQL Server 2014 – A new and exciting journey !!! “Into the cloud”

Today Microsoft announced their next major version of SQLServer, SQL Server 2014 at Tech-Ed NA 2013.
This version of SQLServer is indeed a reflection...

Book Review – Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

Today I will talk about a book  titled  ” Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

When I...

SQLSaturday Redmond(SQLSat212) – A quick recap !

That was indeed a great day at Redmond. I had a great time talking to some of the best SQLServer minds...

SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?

This is my first SQLSaturday and I’m super excited to attend this event.

SQLSaturday’s are always a great opportunity to learn something exciting,...

The Activity Monitor is unable to execute queries against the server !

I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check...

Linked Server created using a script is missing Product name and Data source fields !

Today I will discuss about an issue which was observed while creating a linked server via script.
The existing linked server was scripted...

SQLServer Log Shipping Work File ! What is this all about ?

A short and sweet post for a gorgeous morning -
Have you seen a file with extension .wrk in the log shipping copy folder...

CU3 for SQL2012 SP1 – Couple of interesting hotfixes.

Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from

http://support.microsoft.com/kb/2812412

Similar to CU2 there...

Apply CU2 for SQL2012 SP1 – Fix for Windows Installer starting repeatedly and causing CPU spikes !

CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have...

Adding a Linked Server with ‘Oracle Provider for OLE DB’ as the provider – Proceed with caution !

Adding a linked server is an easy task which can be done at any point of time. I was under...