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 you can quickly check what are the currently running...

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

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

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