SQLpassion BLOG

SQLpassion Live Training about running SQL Server in Microsoft Azure

From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training about Design, Deploy, and Optimize SQL Server on Microsoft Azure. Unlock the power of Microsoft Azure and master the art of designing, deploying, and optimizing SQL Server with this cutting-edge online live training course! Course Overview: Learn expert strategies for crafting …

SQLpassion Live Training about running SQL Server in Microsoft Azure + read more

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

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

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