SQLpassion BLOG

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

Exploring Neural Networks with TensorFlow in Visual Studio Code Dev Containers

08/09/2023 / By / Artificial Intelligence, Computer Science / Leave a Comment

Over the past few weeks, I’ve rekindled my interest in Artificial Intelligence research, spurred by the recent buzz surrounding topics like ChatGPT’s release a few months ago. Although I delved into this field back in 2016, the rapidly evolving landscape has motivated me to revisit it and delve deeper. My current focus revolves around delving …

Exploring Neural Networks with TensorFlow in Visual Studio Code Dev Containers + 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.