One of the really great things about Azure is the capability to easily create servers in other data centers, in other parts of the country or world (referred to as …
One of the neat features introduced with SQL Server 2016 was the automatic seeding of availability groups. And while it seems to work pretty well in most cases, if you …
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 …
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 …
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 …
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 …
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. …
Like most Database Administrators, I have a standard set of Trace Flags that I implement on my SQL Servers. These are my tried and true trusty companions, used to help …
Now that SQL Server 2017 is out it’s time for everyone to start migrating to it, right? RIGHT? Well, in my case, the answer actually is “Yes!” At my day …
