Should a SQL Server DBA Know Windows Clustering?

Should a SQL Server DBA know how a Windows cluster works, and or how to create a Windows cluster, or troubleshoot a cluster? Or should we, as DBAs, stay in our lane? In some organizations, a line is drawn between what a DBA can and can’t do and the System Administrator (SA) has the Infrastructure … Read more

Curious Case of SQL Server Shutting Down Whenever a Job Runs.

SQL Server case study of the week

This is a post in our new Case of the Week series — short write-ups from the real SQL Server issues our team of 17 SQL Server experts helps clients solve every day. Case of the Week: Quick Summary A client reported that their SQL Server service was “randomly shutting down”. They would restart SQL … Read more

SQL Server Partition Management Job Failure After Migration to Availability Group.

SQL Server case study of the week

This is the first post in our new Case of the Week series — short write-ups from the real SQL Server issues our team of 17 SQL Server experts helps clients solve every day. Case of the Week: SQL Server Partition Job Failure after Migration from AWS FCI to AWS AG. Quick Summary A client … Read more