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 robust SQL Server architectures in the Azure environment. Explore best practices for scalability, security, and performance. Dive into the step-by-step process of deploying SQL Server seamlessly on Azure. Gain hands-on experience with real-world dep ..read more

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 Indexes Indexed Views Plan Caching Overview Plan Caching Parameter Sniffing Recompilations Query Store In the training about SQL Server Availability Groups I will cover the following areas: Introduction Installation & C ..read more

Ooops, I did it again! Last week I have started with a new Youtube project – my so-called Rust Quickies. If you are familiar with my Youtube channel, you should already know my famous SQL Server Quickies where I talk just in a few minutes about one specific topic in SQL Server. And now I’m doing the same with the Rust programming language. Rust is a low-level system programming language which has the power to replace C/C++ over the upcoming years. Rust is supported on every major OS (Windows, Mac, Linux, Raspberry Pi), and the compiler generates you directly native machine code (without any r ..read more

Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking about SQL Server on Linux ..read more

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 secondary) within an Availability Group share a single Query Store. When you create a new database in SQL Server 2022, the Query Store is enabled by default. This automatic activation is part of the server’s integration with the newl ..read more

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 into the intricate nuances of Neural Networks, delving into their inner workings at the lowest levels of implementation. This journey involves diving into a sea of mathematics, engaging in matrix multiplications, exercising patience, and of course, savori ..read more

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, and Optimize SQL Server on VMware vSphere Running a SQL Server Virtual Machine on VMware vSphere is a straightforward process. However, unlocking the best possible performance from your SQL Server VM requires a deeper understanding of the core resources used by SQL Se ..read more

Last Saturday I’ve released my SQLpassion Weekly Update #3, where I talk about the following topics: VMware vSAN 8.0 U1 Express Storage Architecture DbaTools 2.0 Data Saturday Holland 2023 Schachmatt mit Philip Enjoy! -Klaus ..read more

Today I’ve released my SQLpassion Weekly Update #2, where I talk about the following topics: Vienna City Half Marathon Moshing Data Platform WIT-DEI Mental Health and Wellness Day – 2023 DOS Subsystem for Linux chess-results.com Enjoy! -Klaus ..read more

Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking about SQL Server Availability Groups ..read more