Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Anup SivaDas handles the Database Engineering initiatives for Expedia, Inc. (, having IT experience of more than 9 years. Anup is an active blogger with, and can also be found on MSDN SQLServer forums and He has handled multiple SQLServer projects for various fortune 500 companies, and gained enrich proficiency within Database Administration, Database Architecture for Cloud, Consulting, Virtualization, Build, and Production Support activities. Blog | Twitter | LinkedIn

Archives: March 2013

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 ?

What is this all about, Curious? Then here is the answer -

When the transaction log backup files are copied from the primary server to… Read more

0 comments, 1,570 reads

Posted in on 29 March 2013

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

Similar to CU2 there are some interesting hotfixes which are included in this CU release, and its worth testing it out.

The ones which attracted my attention are -



Read more

2 comments, 903 reads

Posted in on 21 March 2013

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 found this very much needed for all my SQL2012 SP1 deployments. This CU contains a very important fix(KB2793634).

Note - The choice to deploy CU2 or just the fix (KB2793634)… Read more

2 comments, 1,641 reads

Posted in on 15 March 2013

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 this same assumption until I came across a strange scenario.

Here is the scenario for you all.

Use SSMS to create a New Linked Server and choose provider as ‘Oracle… Read more

2 comments, 1,981 reads

Posted in on 13 March 2013