With the announcements for making SQL Server 2022 available for public preview, it’s challenging to catch up with all the learning. This is one of the reasons why we still see software applications that do not support features of the latest SQL Server versions even though they are already running on top of it. Developers […]
PostOutsourcing Your SQL Server Data Archival Process
When I first started driving in North America, one of the things that I noticed along the freeway is a self-storage facility. Having not seen one before, I asked my dad what they were for – they are space rented out on a short-term basis where you can keep your personal stuff. If people don’t have enough space […]
PostThe US$ 50,000 Nested Parenthesis
In a previous blog post, I talked about the new SQL Server 2016 Availability Groups Load Balancing of Read-Only Replicas feature (I know that’s a mouthful but it’s how I understand the concept.) I explained how the precedence rules in defining how the read-only workload is balanced across multiple readable secondary replicas using nested parenthesis. […]
PostIntroducing the New SQL Server 2016 Availability Groups Load Balancing of Read-Only Replicas
About four years ago, I did my very first webcast on the Availability Groups feature in SQL Server 2012. The premise of the presentation was how we can provide high availability features to existing SQL Server workloads without making changes to the underlying storage. For my demo, I used an existing database mirroring configuration for high […]