Extended Event To Track Data And Log File Size Changes
One of the things that a DBA tries to avoid/prevent are automatic file growths in data and log files. We generally like to plan for these things and size the …
Corruption With Backup Compression And TDE In SQL 2017
Last week I spent a good bit of time dealing with a corruption issue, and as it turns out I may actually have found a bug in SQL Server 2017. …
Notes From A SQL 2017 Azure Install – Using A Cloud Witness With An Availability Group
As I build out my new SQL Server 2017 Availability Group in Azure, running on Windows 2016, I’m wanting to leverage some of the new technologies available. I’ve already written …
Slides From Nashville SQL Server User’s Group December 8th Presentation
The slides from my session, Lessons Learned From An Azure Migration, are attached here. Thanks to everyone who attended! If you happened to attend my session, please leave a comment …
Speaking At Nashville SQL Server User’s Group On December 8th
Next Friday, December 8th 2017, I will be speaking at the Nashville SQL Server User’s Group. My topic will be “Lessons Learned From An Azure Migration”, where I will be …
SQL Server Permissions Manager
Last week I announced 3 new open source SQL Server projects that I have on GitHub. One of those projects is SQL Server Permissions Manager, and today I would like to …
Slides From Adobe ColdFusion Summit 2017
The slides from my session, Building Better SQL Server Databases, are attached here. If you happened to attend my session, please leave a comment below and let me know what you …
3 New Open Source SQL Server Projects
Today I would like to officially unveil 3 new open source SQL Server projects that I have on GitHub! I will have upcoming blog posts that discuss each project in …
Notes From A SQL 2017 Azure Install – Using A Load Balancer As An Availability Group Listener
When setting up SQL Server Availability Groups on Azure virtual machines, one of the requirements is that you use a load balancer for your Availability Group listener. The load balancer stores the …
Notes From A SQL 2017 Azure Install – Using Group Managed Service Accounts
One of the new features that I’m excited about implementing on my Windows 2016 SQL Server 2017 servers is the ability to use Group Managed Service Accounts, or “gMSA” for short. …