Three years later since my last post here … and I am back again. My Microsoft employment journey has been paused and I will be…
Dear readers, It’s been a week since I joined Microsoft and after the initial excitement, it is now time to get my blogging home moved.…
Did you know that disabling a clustered index actually blocks the access to the underlying table? Below is a script you can use to test it,…
This is a very simple approach to generate mass script for changing database owner of all user databases. Why would you need that? Well there…
Microsoft CSS team released a new post of their learning series on SQL Server 11 HADRON. In this article they share how is the synchronous…
CSS SQL Escalation Services are continuing their learning series on SQL Server 11 HADRON. In their latest article they write about page level repair and…
Following is a video of a step-by-step setup of SQL Server 11 AlwaysOn availability group feature from Gopal Ashoc (Product manager for SQL Server High…
The goal of automating administration across a large organization is aiming at simplifying the day-to-day job of the DBA and also ease some dataflow tasks…
The following step-by-step guide is provided by Microsoft SQL Server CSS engineers based on the CTP version of SQL Server 11 or code-name Denali. The…
The latest post from this series discusses running consistency checks on a replica database. Most of you probably have struggled with running DBCC on a…