Every time when I talk about the benefits of Docker, I get the same question -over and over again: “How do you deal with persistent data in Docker Containers? When you remove the Docker Container, the generated data inside the Container is also lost, which is a no-go for a SQL Server Container”. Let’s try …
It’s now a week ago, since Microsoft has finally released SQL Server 2019. Therefore, I’m running on December 9, 2019 an online training about Intelligent Query Processing in SQL Server 2017/2019. The Intelligent Query Processing feature family includes new functionalities that improve the performance of existing OLTP/OLAP workloads with almost no query rewrites. During this …
SQLpassion Online Training about Intelligent Query Processing + read more
Today I’m quite happy to announce my upcoming SQLpassion Trainings for the next few months. Currently I have scheduled the following online trainings: SQL Server on Linux, Docker, and Kubernetes SQL Server Performance Troubleshooting I’m quite happy to provide a brand-new training about how to run SQL Server on Linux, Docker, and Kubernetes. The first …
My goal for last week was to get familiar with the HammerDB load generator and test-drive the TPC-C workload in my powerful Home Lab. This sounds like an easy task, because HammerDB automates all the necessary tasks for you. You can create the schema of the TPC-C database, and HammerDB will also populate the database …
One of the coolest new performance improvements in SQL Server 2019 is a better support for Scalar Valued Functions. As you (hopefully) know, Scalar Valued Functions always introduced a huge amount of performance problems – based on their implementation in SQL Server. Scalar Valued Functions prior SQL Server 2019 I don’t know a database which …
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.
