Azure SQL DB Serverless

Microsoft continues to expand the Azure ecosystem rapidly.  One of the most recent delivered improvements was Azure SQL Database Serverless option.    The new serverless model, which is currently in public preview, provides a compute tier for a single database that scales dynamically with the workload.   This new compute tier is optimal for single database […]

Finding the Best Azure Datacenter

When dealing with cloud technology there is a phrase that everybody should remember:  Physics Always Wins.   There isn’t any way to get around the speed of light (2.98 x 108 m/s) other than getting as close to your cloud resources as possible.  I believe that Microsoft does a great job about having data centers in […]

Azure SQL DB Failover Group Orphaned Users

I have a client  that resides in the Azure data platform arena, focusing mainly on Platform as a Service (PaaS) and Azure SQL DB.  They have a decent landscape of Azure resources and currently utilize failover groups within SQL DB to facilitate high availability.  Under the covers, failover groups are essentially Availability Groups and have […]

Getting Your SQL Server Backup Footprint

Recently, I needed to be able to determine the total size for all the most recent full backups for certain servers. Luckily for me these particular servers were using Ola Hallengren’s Maintenance Solution which simplified things since each back up had it’s own specific directory. Powershell has the flexibility to easily provide what I need […]