SQLServer

SQLpassion Live Training about running SQL Server in Microsoft Azure

03/04/2024 / By / Azure, SQLServer / Leave a Comment

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

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

I’m speaking at the Data Saturday Holland!

08/01/2023 / By / Conferences, SQLServer / Leave a Comment

As you may have noticed, the agenda for Data Saturday Holland was recently published. I’m delighted to share that I will be conducting a full-day precon on October 7, along with a one-hour session the following Saturday. Here’s a brief overview of what you can expect from each of my presentations: Friday’s Precon: Design, Deploy, …

I’m speaking at the Data Saturday Holland! + 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.