Policy Based Management or PBM was introduced in SQL Server 2008 initially.This feature will help Database Administrators to create policies and ensure that his/her environment is in compliance with that policy.…
Have you ever faced a situation where in you had to double check what all features you deployed for your SQL Server environment ? Oh! did I selected Full-Text search feature…
Today I decided to leverage performance dash board report for my SQL Server 2008 R2 instance and SQL 2012 RC 0 Instances. SQL 2008 R2 RTM I downloaded the msi…
Just 2 days back I wrote a post of TUF files related to log shipping. You can read the post here Today we will see what is going to happen if…
Today I came across some tools which does smart way of formatting your SQL code.Who does’nt like a code which is well formatted and easy to read. I remember my…
Recently Microsoft SQL Server Team had posted some SQL Server 2012 T Shirt designs in FB,and had asked for feedbacks for selecting the best 3 designs. Today they came out…
I have seen various questions related to TUF files,and one of the discussion was interesting and it was something like below- <Start> John – I don’t understand why we need this…
Partial database availability is an exiting feature,and I decided to write this blog post after observing many doubts related to this feature in forums. Lets assume a situation like mentioned…
Today I witnessed yet another user who was dealing with BACKUP LOG [database] WITH TRUNCATE_ONLY. This is one of the features which got discontinued from SQL Server 2008 and above,and this was…
Today I was thrilled to hear about the new tool which was released by Microsoft yesterday(3rd Jan 2012).The code name for the tool is “SQL Azure Compatibility Assessment Tool” and…