Compare database schemas can be tricky, here I show you how I managed to compare thousands of databases’ schemas at once Working with databases is always fun and you never know what…
Tag: TSQL
T-SQL Tuesday #112 – Dipping into your Cookie Jar
In this post I want to share those scripts that I use probably every day This post is part of the T-SQL Tuesday, which is a monthly blog party on the second…
T-SQL Tuesday #104 – Finding tables and columns in SQL Server
In this post I want to share a script that I use quite often because its flexility This post is part of the T-SQL Tuesday, which is a monthly blog party on…
Here is your index, now what?
This story might sound familiar for most of the DBA’s out in the wild. Our job to keep databases up and running, and sometimes, make them to go faster (I’m not going…
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…
Database design matters, seriously
All those rules and best practices about database design exist for a reason. Today I want to show you something very simple for you to see how a good design might improve…
Divide and Conquer Date Search Hack
Divide and Conquer Date Search Hack (because binary search sounds boring) Divide and Conquer Date Search Hack (because binary search sounds boring) This week has been an amazing experience, not only I have…