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...

Tell Me About Your Worst Database Code Offenders

For years, I’ve done consulting around helping organizations tune their database platforms, both from within the database and underneath, to help boost performance and availability. Some database design or...

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

If you read the title to this post and your first thought was That’s not SQL is it? then you ... Continue reading

I’m a DBA. Do I really need to know Kubernetes?

Welcome to February 2020. It’s the second month of the year 2020! I remember sitting at a server with SQL Server 6.5 installed on it, worrying about the Y2K...

Parameterizing a REST API Linked Service in Data Factory

We can now pass dynamic values to linked services at run time in Data Factory. This enables us to do things like connecting to different databases on the same...