In this post I show you a problem that has been bothering me since the first version of SSMS 17 to the point that I have been using SSMS 16 until now This…
I spoke at @SQLBits and you won’t believe what happened
Aha! Gotha! First my apologies for the click bait headline, I just wanted to do a little experiment 🙂 But, Yes! I did manage to speak at SQLBit 2018 and it was…
T-SQL Tuesday #99 – Great Debates : Unicode
In this post I want to share my opinion about using UNICODE data types by default for strings stored in SQL Server This post is part of the T-SQL Tuesday, which is…
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…
Getting perfmon data into SQL Server, Part III
In this post I show you how to deploy in a simple way the solution previously proposed to Getting perfmon data into SQL Server to multiple servers running multiple SQL Server instances. I…
SSMS Configurations for SQL Server Speakers
In this post I want to go through some settings I recommend for SQL Server Management Studio when we present either online or in person Last week I saw this post from Tim…
Getting perfmon data into SQL Server, Part II
This week we will retake my last’s post topic to finish that job off and get in and out our Perfmon data to and from our SQL Server. This week we will retake…
Getting perfmon data into SQL Server, Part I
In this post I want to show you how to create Data collectors in the Performance monitor and the different options we have to get the output and later on inserting in…
My first dual language post in English and Spanish
First port I publish in Spanish and English at the same time, hope you will enjoy it. To be honest I never thought about writing my blog in Spanish because when I think…
Using tokens in SQL Agent Jobs and renaming output files
In this post, I want to tell you about some useful feature that can be used within SQL Agent jobs in SQL Server This post I want to tell you about an error…