Speaking at SQLBits 2020

I’m proud to announce that I will be speaking at SQLBits! I had the absolute pleasure of speaking at SQLBits last year for the first time and saw first hand...

Speaking at SQLIntersection Orlando 2020

I’m very pleased to announce that I will be speaking at SQL Intersection April 2020!  This is my first time speaking at SQL Intersection and I’m very excited to...

Speaking at SQLIntersection Orlando 2020

I’m very pleased to announce that I will be speaking at SQL Intersection April 2020!  This is my first time speaking at SQL Intersection and I’m very excited to...

Speaking at SQLIntersection Orlando 2020

I’m very pleased to announce that I will be speaking at SQL Intersection April 2020! This is my first time speaking at SQL Intersection and I’m very excited to...

How Do You Decide When Can Doesn't Mean Should?

An old proverb states, “Fire is a good servant but a bad master.”  Put simply, it means that when controlled, fire is a life-sustaining element.  We need it for...

New .NET Notebooks are here – PowerShell 7 notebooks are here.

Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL kernel where with a little bit of...

SQL Homework – February 2020 – Write a blog post.

Following along with last month’s documentation homework this month I want you to write a blog post. But Ken, what ... Continue reading

Temporarily enable TLS 1.0/1.1? – Be sure you check this keys

There are some actions that we know that will have to be repeated from time to time, but the surprise comes when it’s time to do so and the...

Performance Tuning with Computed Columns

Computed Column can be utilized to optimize the query performance. It can be leveraged, to make the query sargeable, to make proper use of available indexes.

In this article,...

Profiler: Time To Go

I’ve decided that, in fact, it is time to start moving people off the ancient technology, Profiler. Before, I always said, stay where you’re comfortable. However, keeping people comfortable...