I am still at PASS Summit in Seattle, USA and today was the second day of preconference sessions. I took the SQL Server 2019 Workshop by Bob Ward and would like to share a few things. As with my previous post on Day 1 please be kind in your judgement…it has been a long day and I am just gonna write about some short and most impressive takeaways. So first of all, what was that all about? It was nothing…
I am currently at the PASS Summit in Seattle, USA. This is a great conference for data professionals. Actually I am already fast asleep as it is like 2:40am in Germany by now. However I would like to use the chance to write up some quick learnings. The day was terrific. Erin Stellato delivered a great workshop. Here’s a picture of me with Erin Stellato: I would like to share two (rather easy) things which were new to me: Query Store…
A few days ago Kendra Little did a great Podcast about Write Ahead Logging in SQL Server. Key point is that all transactions are written to the transaction log first and then to the data file. This enables SQL server to fulfil the Durability requirement (one of the ACID properties of transactions). Kendra did a good job of explaining but I didn’t get her right the first time and did some research myself on roll backs and roll forwards. The…
As the title suggests this blog post is about a neat trick, which a decent DBA typically wouldn’t consider if he/she had other options. It worked for me and it was a well thought option to go for. I am not very proud of this trick (therefore “dirty”) however it saved my day and perhaps it’s a valid option for you to go as well. Remember that you use SQL server in a non-supported way doing this and don’t blame…