This week, I am honored to be speaking at the most excellent 8KB conference. If you aren’t aware of this conference, it’s ran by several members of the SQL Community. It is designed to be a deep dive internals conference. While it starte... The post The Magic Behind ADR: My 8KB Talk appeared first on Denny Cherry & Associates Consulting .
As I’ve been spending more time working with Contained Availability Groups (CAGs), I’ve run into something that I think is an issue as they become more prevelant in the wild. To be honest, I do not have a lot of clients running CAG’s ... The post SSMS Needs Improved Visual Indicators for Contained Availability Groups appeared first on Denny Cherry & Associates Consulting .
Today (July 15, 2026) is Microsoft MVP Award day, when existing Microsoft MVPs get their MVP Awards reawarded (if they are renewed for another year). This year, DCAC had four MVPs reawarded, with two MVPs getting awarded in two different categories at the same time. Congrats to both our MVPs (Denny Cherry, Joey D’Antoni, Monica […] The post Congrats 2026 Microsoft MVP Award Winners appeared first…
Most companies set up a DMARC record and call it done. The problem is that publishing the record is only half the job — and ignoring the other half is how you end up with attackers sending phishing emails to your customers using your domain while you have no idea it’s happening. What DMARC Actually […] The post Someone Might Be Sending Email From Your Domain Right Now appeared first on Denny…
Are you a user of VS Code, but you wish that the MSSQL extension had more of the SQL Server Management Studio features? Good news, there’s now a VS Code Plugin that gives you those capabilities in VS Code by using the “SSMS Tools for SQL Server” extension. Once the extension is installed, use the […] The post SSMS Tools in VS Code appeared first on Denny Cherry & Associates Consulting .
Microsoft Fabric is software-as-a-service platform for data processing, business intelligence reporting, and even online transaction processing apps. Fabric has been generally available since November, 2023. Building planet scale platforms is hard, and I have a great deal of sympathy for engineers and architects who are dealing with layoffs, constant pressure for new features, and the […] The post…
Microsoft introduced Read-Only Routing to Always On Availability Groups many versions of SQL Server ago. However, Microsoft never added any sort of UI to SQL Server Management Studio. Years ago, DCAC released a Windows application to manage your Read-Only Routing configuration. We’ve converted our Windows application into a VS Code extension called SQL Always On […] The post SQL Server Always On…
Contained availability groups solve some real operational problems, especially around logins, jobs, permissions, and supporting metadata. They can reduce drift between replicas and make failover cleaner. That does not mean they are magic. The post Contained Availability Groups: Issues to Watch Out For appeared first on Denny Cherry & Associates Consulting .
In the first post, I introduced contained availability groups and how they bring contained versions of master and msdb along with the Availability Group. That matters because many applications depend on more than just user databases. Two of the biggest... The post Contained Availability Groups: Jobs and Security Objects appeared first on Denny Cherry & Associates Consulting .