For DBA’s it is important to have the ability to recover databases quickly in case of disaster. In order to maximize the potential we need to have our databases ready but sometimes…
Month: March 2017
Not the typical story about key lookups
Query plans are very useful to tune queries, but some operations are usually avoided or blamed for performance problems when not always are the culprit, let me show you one of those…
T-SQL Tuesday #88 – The security audit WTF
In this post I want to share the stored procedure I wrote to audit the different logins and server permissions within an instance. This post is part of the T-SQL Tuesday,…
Benchmarking storage using Diskspd.exe
One of the most important things when something goes wrong is to have an idea how your environment looks like in a normal day. Let me show you how to easily get…