Wednesday March 13th 2024 I had the honor of speaking at the Redgate Summit in Atlanta and got to meet a lot of new people and get to hang out with several good friends. I’ll be posting about that in a few days. A small group of us went out for dinner after the event […]
Category: Uncategorized
There Is Insufficient Free Space on Disk Volume To Create the Database
I have been involved in countless database migrations. Most of the time I have access to the existing source servers and future destination servers. In cases where you have access to both environments, it is very easy to evaluate and clean up any issues with the source databases. In situations where you are only provided […]
Getting Started With SQL Server Always Encrypted
Azure SQL Database and SQL Server 2016 introduced a new security feature for SQL Server databases called Always Encrypted. Always Encrypted is a feature designed to protect sensitive data, such as national/regional identification numbers (Social Security numbers for those in the USA), credit card numbers, and other highly sensitive types of data. Always Encrypted allows […]
What is Azure SQL
I get asked about Azure SQL very often. This is a topic that I’ve written about and taught many times. To be honest, this is a rather large topic that can go in many different directions. For this post, I want to cover what I consider the basics of Azure SQL. For me, that is […]
SQL Server 2022 is Here!
SQL Server 2022 becoming generally available was announced on Nov 16th 2022. This is the most Azure-enabled release of SQL Server yet, which is pretty exciting. A major Azure-enabled feature is the ability to leverage Azure SQL Managed Instance for disaster recovery, which also means we can backup and restore from Azure SQL Managed Instance […]
MVP for Another Year 2021-2022
A few minutes ago, I received an email from Microsoft presenting me with the 2021-2022 Microsoft Most Valuable Professional (MVP) award. This is my 8th award and I am just as excited and amazed as I was for my first one. This award is extra special this year considering the challenges and struggles of the […]
SQL Saturday Louisville
Are you coming to town for SQL Saturday 883 in Louisville KY, if you are going to be around the area on August 2nd, I’ll be presenting an all day session on Common SQL Server Mistakes and How to Correct Them. This session is gear for the junior to mid-level DBA that is responsible for […]
SQL Saturday Baton Rouge
Hello Baton Rouge! David Pless and I will be teaching an all day workshop on Performance Tuning and Optimization for Modern Workloads (SQL Server 2017, Azure SQL Database, and Managed Instance) on Friday August 16th. This is a fun and interactive day of learning about how to improve overall SQL performance in Azure and on-premises. […]