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…
Category: Articles
Articles mostly focused on SQL Server technologies
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…
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…
T-SQL Tuesday #94 – Lets get all Posh! Creating VMs with PS
In this post I want to share how we can use powershell to automate Hyper-V virtual machines creation for easiness and consistency This post is part of the T-SQL Tuesday, which is…
T-SQL Tuesday #92, Lessons learned the hard way. Wrapping up
Wrap up for the #tsql2day event for July 2017. The topic for this month is "e;Lessons Learned the Hard Way"e; #tsql2sday is a monthly blog party on the second Tuesday of each…