Azure SQL Network Security (Vnets, Service Endpoints & Private Link)
In this post I explain how to establish network security for Azure SQL DB and Managed Instance and what Service Endpoints and Private Link bring to party.
Azure SQL DB Reserved Capacity & Dev/Test Pricing
Significant savings to your Azure SQL Databases can be received through “reserving” your databases for fixed period or apply good-old developer edition licensing for non-prod environments.
Azure SQL DB Cross Database Queries with Elastic Queries – the Good, the Bad & the Ugly
Azure SQL DB Singleton database doesn’t support native cross-db/server queries. But there is a work around in the form of Elastic Queries. This post includes a critique, considers the networking configuration, and sample TSQL to see them action.
Azure SQL Server VMs and the SQL Resource Provider
The SQL VM Resource Provider lets you PaaS-ify your Azure SQL Server VMs letting you take advantage of some of the automated management capabilities of PaaS databases
Azure SQL Server Base Flavours
There are 3 ways to run SQL Server in Azure – VMs, SQL DB Singleton & Managed Instance
Migrating Databases to Azure SQL DB & the Impact on Connections in SSIS Packages
Migrating databases to Azure SQL DB means modifications are required to your existing SSIS SQL Server connectors – but what’s involved?
Azure SQL DB Exotic Flavours
A brief summary of the various flavours of Azure SQL DB including Hyperscale, Serverless & Elastic Instance
Follow My Blog
Get new content delivered directly to your inbox.
After 20 years in data... 