AlwaysOn

SQLpassion Live Trainings about SQL Server on Microsoft Azure & Availability Groups

07/22/2024 / By / AlwaysOn, Indexing, SQLServer / Leave a Comment

On November 27 – 28, 2024 and on December 4, 2024 I will run two SQLpassion Live Trainings about SQL Server on Microsoft Azure and SQL Server Availability Groups. SQL Server on Microsoft Azure – Course Overview:Learn expert strategies for crafting robust SQL Server architectures in the Azure environment. Explore best practices for scalability, security, and …

SQLpassion Live Trainings about SQL Server on Microsoft Azure & Availability Groups + read more

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups

01/08/2024 / By / AlwaysOn, Indexing, SQLServer / Leave a Comment

On January 25, 2024 and on February 22, 2024 I will run two SQLpassion Live Trainings about SQL Server Query Tuning Strategies and SQL Server Availability Groups. In the training about SQL Server Query Tuning Strategies I will cover the following areas: Index Tuning Strategies Search Arguments Bookmark Lookup Operations Tipping Point Index Intersection Filtered …

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups + read more

Exploring the Query Store on Secondary Replicas in SQL Server 2022

11/22/2023 / By / AlwaysOn, SQLServer / 1 Comment

SQL Server 2022 introduces an exciting feature: the ability to access the Query Store from a secondary replica in an Availability Group. This enhancement offers a significant advantage, allowing you to redirect troubleshooting tasks to a secondary replica without impacting the performance of the primary replica. It’s crucial to note that all replicas (primary and …

Exploring the Query Store on Secondary Replicas in SQL Server 2022 + read more

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups

04/17/2023 / By / AlwaysOn, Indexing, SQLServer / Leave a Comment

On May 16, 2023 and on June 15, 2023 I will run two SQLpassion Live Trainings about SQL Server Query Tuning Strategies and SQL Server Availability Groups. In the training about SQL Server Query Tuning Strategies I will cover the following areas: Index Tuning Strategies Search Arguments Bookmark Lookup Operations Tipping Point Index Intersection Filtered …

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups + read more

Adding a Replica back into a SQL Server Availability Group

09/25/2017 / By / AlwaysOn, SQLServer / Leave a Comment

In one of my last blog postings I have already described a common pitfall when you try to add a new Replica into an Availability Group. In today’s blog posting I want to talk a little bit more about how you can add a Replica back into an Availability Group – when you have removed …

Adding a Replica back into a SQL Server Availability Group + read more

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.