Wow it’s getting a habit now to write a blog in the later evening about the great PASS Summit currently taking place in Seattle. I simply hope that what I write up here can be useful for anybody else as well…so please give me a short feedback if you like these kind of blog posts or let me know what I could do better. Note: I have just got to know that Kenneth Fisher has a far more extensive writeup…
Today was the first conference day at PASS Summit. Originally I expected the venue to be much more crowded and that there would be some sessions packed with people standing in the back. Most surprisingly it was quite a nice experience and no session I visited had people standing but instead a good share of free seats left. However Markus Ehrenmüller-Jensen told me that he has been to really packed sessions and it often is difficult for the organizers to…
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…
TLDR Dear potential reader: I realize that this blog post is quite long and everyone’s time is limited nowadays. I am still excited about the result of the Hackdays and the solution I helped to build. So I tried to share as much as possible with you. Feel free to skip over some headings faster and delve into details in other paragraphs. My message is that contributing successfully to a hacking event is absolutely doable even if you are not…
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…
This is my contribution to TSQL Tuesday #99: Dealer’s Choice hosted by Aaron Bertrand this month. I choose door #2 to write about T-SQL bad habits. One thing that comes to my mind immediately is how to handle id columns and which data type to choose. First of all: I don’t think there is any one-size-fits-all-approach you could use without thinking twice. My experience is based on working for a mid-sized business with fairly small sized tables which rarely have…
Introduction First of all, I do not consider myself a professional let alone an expert on PowerShell. However, I think the learning curve of PowerShell is very appealing especially if you have got some background in programming. The first programming language I learned was Java…way back in 2005 at University. Well, frankly speaking my first programming language was Basic on a Commodore C128 computer…but that time as a teen I didn’t really get a deep understanding and ended up retyping…
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…
The problem During the last few months I have done a lot of performance tuning. Being thrown in at the deep end I did my best and boldly changed existing indexes. Our server had problems regarding too much IO done therefore it didn’t seem right to just add one new index after another. However, doing this for the first time I happened to change an index which made the one query perform better but another query I have tuned a…
Some time ago my boss asked me for advice on a report he just created. Here’s an example with sample data of what he liked to visualize: For different dates we have a count of objects which had a specific final status. You can reproduce the sample data using the following select statement: query-with-inline-sample-data Goal of the visualization should be to show the distribution across the different status and the overall development of the measured data. Our first approach was…