Running SQL Server 2019 CTP in a Docker container

If you’ve been anywhere near social media this week you may have seen that Microsoft has announced SQL Server 2019.
I...

Azure Data Relational Services

Today I’d like to talk about the Azure Relational Data Services Platform. This is an important foundational component for many...

Azure SQL Database Managed Instance

As of October 2018, Azure SQL Database Managed Instance is now generally available in the general purpose tier. Business Critical...

how to embed a PowerBI report into HTML code

PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the focus of this tool is to be able to...

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

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