Save 50% on my SQL Server Performance Tuning & Troubleshooting Workshop

As you might know, I’m running next week in Utrecht/Netherlands my SQL Server Performance Tuning & Troubleshooting Workshop. The agenda of this deep-dive workshop is quite impressive: Performance Tuning Fundamentals Extended Events Working with large Databases Transactions & Currency Lock Escalations Deadlocking Latches & Spinlocks Troubleshooting TempDb Performance Monitoring Performance ...

Read more

SQL Server on Linux – how does it actually work?

Over the last few weeks I have already written a lot about how to run SQL Server on Linux, Docker, and Kubernetes. But I haven’t yet talked about how SQL Server can actually run on Linux. Therefore, it’s time today to unveil this little secret 🙂 . Drawbridge When Microsoft ...

Read more

Upgrading SQL Server on Linux

Today I want to show you a very quick blog posting how easy it is to upgrade SQL Server on Linux. As you know from my previous blog posting I’m currently running in my Home Lab a Linux Ubuntu Virtual Machine, where I have installed SQL Server 2019 CTP 2.3. ...

Read more

Installing and Configuring SQL Server on Linux

I have already shown you in the past how to install and run SQL Server in Docker Containers, and how to deploy Availability Groups and stand-alone SQL Server Instances into Kubernetes Clusters. In today’s blog posting I want to continue this discussion and you will learn how to install and ...

Read more

Removing an In-Memory OLTP File Group

Yesterday evening I came across a very interesting behavior in SQL Server: a customer has told me that they have some problems by removing a file group that was used for In-Memory OLTP. Unfortunately that is NOT possible! You can’t remove an In-Memory OLTP file group! A simple example Let’s ...

Read more
SQLpassion

Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top