Query to determine XE Session status

On a previous post, we discussed what is an extended event (XE) and how to create one.

With the following T-SQL...

Query to determine XE Session status

On a previous post, we discussed what is an extended event (XE) and how to create one.With the following T-SQL you can quickly check what are the currently running...

Shortchanged with International Money in SQL Server

Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with...

SQL Change Automation, Visual Studio, and the “Unknown SQL Server Platform” error

I recently set up Redgate’s SQL Change Automation in Visual Studio 2017, and I ran into a confusing error when I started trying to use it. For any other...

Table Variable Performance “Fixed” in SQL 2019

Reading the new features for SQL 2019 I spotted this:
One of the most popular posts on my blog last year...

What is a DBA anyway?

Some time ago we started a new series here, called Database Fundamentals. The very first post in that series asked...

Go Green with Blue Using Azure

Is your company working on ways to become more environmentally friendly? Taking care of the environment is an important topic,...

Introducing Azure Data Studio

If you’re watching Microsoft Ignite or tracking the information coming out of it on social media, then you know that...

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

Watch this week's video on YouTube
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh,...

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

Watch this week's video on YouTube
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh,...