Today, while I was going over my RSS feeds, I noticed that Microsoft released their Data Explorer as official Preview version. You can read the…
In this short post I will show you how to check for the activities run or being run on your Data Quality Server. First you…
During one of my latest investigations on SQL Server MDW, I had to learn a few things the hard way – there are several stored…
Recently I had a situation where one of the SQL Servers we are supporting had over 1 TB of tempdb log and after a short…
A month ago I noticed a very neat post about finding if a given SQL Server database has been upgraded or not. The original post…
Following one of my old posts, I would like to share one new multiserver query. This script you can use with your CMS (Central Management…
Following my previous post on mass change of PAGE_VERIFY option, I want to share one other script that you can use if you are using…
In the recent days I wanted to change the PAGE_VERIFY option on all databases and make sure I am using CHECKSUM everywhere. First question I…
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,…