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

SQLSailor.com

Anup SivaDas handles the Database Engineering initiatives for Expedia, Inc. (http://www.expedia.com/), having IT experience of more than 9 years. Anup is an active blogger with SQLSailor.com, and can also be found on MSDN SQLServer forums and BeyondRelational.com. 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,126 reads

Posted in SQLSailor.com 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
http://support.microsoft.com/kb/2812412

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 -

2800013

(http://support.microsoft.com/kb/2800013/…

Read more

2 comments, 774 reads

Posted in SQLSailor.com 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,473 reads

Posted in SQLSailor.com 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

1 comments, 1,630 reads

Posted in SQLSailor.com on 13 March 2013