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

Azure IP Advantage

In today’s Azure Every Day post, I’d like to talk about something a little different from our normal posts, and...

Quick PoSh SQL Provision Databases for New Developers

As part of some presentation work, I wanted to demonstrate some onboarding of new developers. To that end, as part...

Giant Azure SQL Databases

Okay it is not really called Giant Azure SQL Database but its close. There is a new public preview vCore...

Sharding: Horizontal Scaling in Azure SQL Database

David has produced a talk all about Sharding. Or if you prefer  horizontally scaling your Azure SQL database.

You can view...

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

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

The Developer’s Guide to Azure–A Good Overview

Someone sent me a link a few weeks back  about a free book from Microsoft. It’s the Developer’s Guide to...

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

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