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

Passing status messages and results back from Databricks to ADF

When we use ADF to call Databricks we can pass parameters, nice. When we finish running the Databricks notebook we often want to return something back to ADF so...

Passing status messages and results back from Databricks to ADF

When we use ADF to call Databricks we can pass parameters, nice. When we finish running the Databricks notebook we often want to return something back to ADF so...

Protect Your Prod Databases in Azure DevOps / TFS: Three Control Points

When implementing any kind of automation for database deployments, it’s important to implement safeguards for your production environment. This is needed even in the best conditions when team members...