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

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

Lessons from Iowa’s Caucus Debacle

Earlier this week, the state of Iowa held its caucuses to choose each political party’s nominee for November’s presidential election. Being the first state in each election cycle to...

Power Platform Quick Tips – Episode 04: Hiding Power BI Visuals Interactivity

Welcome back to my series on Power Platform quick tips! In this episode you will learn how to hide the interactive capabilities of your report

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

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