It’s learning time again…with my first time at SQLBits. Sadly it’s just virtual as there is still a corporate travel ban due to Covid, but I had a great first day and learned a ton. My wife just approached me this morning telling me “Hey if you gonna learn all day take this as a chance for your blog and share what you’ve learnt there…but keep it short and simple and don’t write essays”. With the latter part…I have my…
I already did a quite extensive write-up on some sessions from Conference Day 2 at PASS Summit 2019. Cybersecurity is everyone’s problem: An extract from the Keynote of Day 2 at Pass Summit Survival Techniques for the lone DBA (Pass Summit 2019 Conference Day 2) Successfully communicating with your customers (Pass Summit 2019: Conference Day 2) Here I would like to share the remaining sessions I went to. Design Strategies and Advanced Data Visualization This was quite an interesting session…
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…