|
|
-
|
|
Yesterday there was an interesting discussion related to OLEDB wait type getting spiked when DBCC is executed.
This was pretty interesting question for me and was curious to really understand if OLEDB wait type has a dependency with DBCC.
OLEDB is a common...
|
|
-
|
|
SQL 2012 comes up with lot of improvements and changes.One of the major change which the DBA’s should be aware is related to how memory allocations are made.
Prior to 2012
Prior to 2012 we had 2 memory managers.One was for handling allocations of 8k ...
|
|
-
|
|
TDE was introduced in SQL Server 2008 as an Enterprise/Developer edition feature.This feature allows to encrypt the whole database and includes database backup’s.
I was interested to test TDE in Denali to understand if there are any major changes ...
|
|
-
|
|
Have you ever done a point in time restore? If not,then consider yourself lucky.
In case you are forced to do a point in time restore in near future,then this new Time line feature in SQL Server 2012 will attract your attention.
I am not a big fan of GU...
|
|
-
|
|
Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.
Policy based management(PBM) is indeed one of my favorite features. I normally like to play around exploring more and more about it,...
|
|
-
|
|
This post is a quick tip to find the version of Windows Installer installed on your box.
You might wonder why I ever need to check this version, so here is my small story -
Today I was installing SQLServer 2008 Upgrade advisor for a Windows Server 2003(SP2...
|
|
-
|
|
Would you love to get a weekly status report of all the databases hosted on your mission critical servers? ,Would you love to get a report which will help you maintain and manage your large shared SQLServer environments neat and clean?
If your answer is Ye...
|
|
-
|
|
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 ‘O...
|
|
-
|
|
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 ...
|
|
-
|
|
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 ...
|
|