SELECT *
FROM Posts
WHERE Tags IN ('TSQL')

Aug
31
2021

How I Compared 1000’s of database’s schemas at once

Working with databases is always fun and you never know what can be knocking on your door, even when you think everything is under control. As the title of this post states, today I…

Continue Reading »

Mar
12
2019

T-SQL Tuesday #112 – Dipping into your Cookie Jar

 This post is part of the T-SQL Tuesday, which is a monthly blog party on the second Tuesday of each month. Everyone is welcome and have the chance to write about SQL Server. This month’s host is my good friend…

Continue Reading »

Jul
10
2018

T-SQL Tuesday #104 – Finding tables and columns in SQL Server

 This post is part of the T-SQL Tuesday, which is a monthly blog party on the second Tuesday of each month. Everyone is welcome and have the chance to write about SQL Server. This month’s host is Bert…

Continue Reading »

Feb
9
2018

Here is your index, now what?

s 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 into what fast mean, just in case). Some other times, we have developers, that want their code to run faster, they seem to…

Continue Reading »

Mar
14
2017

T-SQL Tuesday #88 – The security audit WTF

  This post is part of the T-SQL Tuesday, which is a monthly blog party on the second Tuesday of each month. Everyone is welcome and have the chance to write about…

Continue Reading »

Mar
2
2017

Benchmarking storage using Diskspd.exe

Last week I’ve been testing some new storage at work…

Continue Reading »

Jun
16
2016

Database design matters, seriously

This might sound pretty obvious, but really, database design matters. And all those rules and best practices about database…

Continue Reading »

Oct
17
2015

Divide and Conquer Date Search Hack

Divide and Conquer Date Search Hack (because binary search sounds boring) This week has been an amazing experience, not only I have attended to one of the most valuable SQL Server training you can find (IEPTO2 by @SqlSkills team), I’ve also met really nice people…

Continue Reading »