Category: Articles

Articles mostly focused on SQL Server technologies

T-SQL Tuesday #99 – Great Debates : Unicode

Posted on Tuesday February 13th, 2018

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?

Posted on Friday February 9th, 2018

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

Posted on Wednesday January 17th, 2018

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

Posted on Tuesday January 2nd, 2018

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

Posted on Wednesday December 27th, 2017

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

Posted on Wednesday December 20th, 2017

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…