Headed to Chicago tomorrow for SQL Saturday #67. Heading out a day early to attend a pre-conference seminar on Friday on troubleshooting and performance tuning. While I feel pretty strong in these areas, one thing I haven’t done as good of a job of as I should is keeeping up on new features to assist with this in SQL Server 2005 and 2008. Dynamic Management Views, Extended Events, and so forth. So this should be a good class to help teach an old dog new tricks. Then on Saturday I get to present the XML session again which I created for Utah Code Camp. Looking forward to it.

SQL Server AG Won’t Become Primary After Force Quorum? Here’s Why and How to Fix It
If you’ve encountered a situation where none of your SQL Server Always On Availability Group (AG) replicas become PRIMARY after a cluster failure — you’re not alone. We recently had a customer with this exact scenario (AG won’t become primary after force quorum), and it is both uncommon and difficult to troubleshoot so I thought it would be worth posting about.