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

#PowershellBasics: Get input using Read-Host

Conditions are the life blood of programming. This condition is met so now I need to do this task. That ... Continue reading

Allow users to start/stop Azure VMs

Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of...

Allow users to start/stop Azure VMs

Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of...