During the month of April 2012 Microsoft released CU1 for SQL Server 2012. Earlier I was focusing only on Service Packs (SP) whenever they are released. I moved on from…
Have you ever encountered this error message when tried to extract zipped backup files using built in ‘Extract All‘ facility of Windows – The error message will first give you…
I’m really happy and excited to write my first book review. I just completed reading the wonderful book SQL Server Hardware written by deep SQL Server Technical Expert Glenn Berry(B/T) I…
We all know that the user mode VAS(Virtual Address Space) limit for x86 bit server is 2GB and the same value for x64 bit server is pretty huge,and its 8…
You might have seen the below messages in SQL Server error log at some point of time – SQL Server has encountered 1 occurrence(s) of cachestore flush for the ‘Object…
How many times have you followed the best practices check list whenever you are deploying a mission critical solution like Database Mirroring,Log shipping or even Failover cluster instances ? If…
How many times you have seen heavy CPU utilization,heavy disk I/O happening when ever a backup job is running on a production SQL server.The CPU utilization hits top values if backup…
Last week I was pretty much focusing on setting a lab environment to test SQL 2012 Availability Groups and Failover Cluster Instances. I had to setup 3 VM’s to play…
Today I opened SSMS in one of my SQL 2005 box,and to my surprise I got this error right away “The file C:\WINDOWS\Microsoft.NET\Framework\%version%\mscorlib.tlb could not be loaded.” I was running…