Subscribe to this blog
SQLSailor.com
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, 224 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 |
2 comments, 465 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, 932 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, 325 reads
Posted in SQLSailor.com on 13 March 2013