Running a SQL Server Azure Container Instance in a virtual network

Up until now Azure Container Instances only had one option to allow us to connect. That was assigning a public...

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

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