|
|
-
|
|
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 this earlier strategy of ignoring CU’s.
I have decided to focus on CU’s too...
|
|
-
|
|
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 an impression that the zip file might be corrupt.
This might be tru...
|
|
-
|
|
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 will rate this book with
I am pretty confident to say that t...
|
|
-
|
|
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 TB.
If you are interested in reading a lot about VAS,then I would recommend you reading the article wri...
|
|
-
|
|
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 Plans’ cachestore (part of plan cache) due to some database maintenance or rec...
|
|
-
|
|
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 the answer is No,”Have never followed any best practice...
|
|
-
|
|
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 compression is enabled for the instance with the main intention of reduci...
|
|
-
|
|
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 around and out of that one will be a domain controller.
Once all the VM’s were ...
|
|
-
|
|
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 SQL 2005 SP3 (Yes,you heard it right !) and the only .NET f...
|
|