Playing around with your live SQL Server cluster is always something to be extra careful with. Especially when you have to remove some old storage…
As strange as it might be, my next post is going to be about how to get the query designer working in Visual Studio. …
The Analysis, Migrate and Report tool (AMR) is part of SQL Server Management Studio 2014 and it aims at helping you evaluate your workloads and…
If you need to check if there is any database on your SQL instance, related to replication, you have couple of different options – from…
Activity monitor is something that I do not use very often – it is just easier for me to work with the DMVs and 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…
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 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…