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 […]
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 […]
Dynamic Data Masking – SQL Server
Use Dynamic Data Masking to protect your data
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 […]
Why You Should Test Your SQL Server Backups
My number one reason that you should test your backups is to make sure you know how to restore/recover. The absolute worst time to learn how to restore is when a restore is needed. By regularly testing your backups, you build up muscle memory in how to recover. By regularly validating your restore solution, you’ll […]
Children at Technical Conferences Part II
Nearly 10 years ago I wrote a blog post about having my son tag along at various conferences I was speaking at. So much has changed in the past ten years and thankfully I’ve been able to bring my entire family along on various other trips. I was reminded by a Facebook memory about a […]
Microsoft SQL Server Management Studio Error
I came across an issue with SSMS not loading properly recently. Regardless of launching from the start menu with or without administrator, SSMS would error out. Due to this error, I also could not uninstall SSMS to try a repair. After much trial and error and Google/Bing searches I was able to correct the issue […]