-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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…
Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new databases which gets created will have page verify =…
This post is not a detailed explanation of DBCC Memorystatus for SQL2012,but a quick observation I made recently for the node Process/System counters. This is one area to look at…
Lets start New Year with a very simple yet useful topic. I am a big fan of out of box reporting capabilities of SSMS. Some of the reports are really…
“ReFS”, this term was absolutely new to me when I was reading this white paper from Microsoft ‘Storage Windows Server 2012’. ReFS is the next gen file system from Microsoft,…
In theory we cannot backup the log of a database which is in Simple recovery model, however there is a small bug in SQL 2012 which allows you to do…
You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try to declare a variable and assign it a value in…
Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all about. The event kicks off at 12:00 GMT on Sep…
SSMS reports are one of the best ways to pull some great deal of Server level or Database level information within SQLServer. Today I was running the ‘Disk Usage’ report…
A blog post about Microsoft Assessment Planning Toolkit was in my list for quite a while and today I decided to write about it. Let’s assume that you are working for a…
Cloud & SQLSailor 