SQLServerFast

The calm before the storm

Hugo Kornelis
1 Comment
(Warning: This blog post is non-technical but purely personal. I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer and other similar diseases.) This is the fifth post in a series on my personal road from first signs of leukemia, through diagnosis and treatment, to, hopefully, full recovery. Click here to read all posts in this series. I have fallen a bit behind with my writing. I started writing this on Monday, September 26th, and I hope to finish it on Tuesday, September 27th. But this…
Read More

First day in the hospital

Hugo Kornelis
2 Comments
(Warning: This blog post is non-technical but purely personal. I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer and other similar diseases.) This is the fourth post in a series on my personal road from first signs of leukemia, through diagnosis and treatment, to, hopefully, full recovery. Click here to read all posts in this series. I write this on Wednesday, September 21st. My third day as a hospitalized patient on chemotherapy. I was planning to write about the past three days but as I…
Read More

Last day at home

Hugo Kornelis
8 Comments
(Warning: This blog post is non-technical but purely personal. I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer and other similar diseases.) This is the third post in a series on my personal road from first signs of leukemia, through diagnosis and treatment, to, hopefully, full recovery. Click here to read all posts in this series. This post is about Sunday, September 18th. The day before my hospitalization, my last day at home in a long time. Just a typical last day before a prolonged…
Read More

A badly timed toothache

Hugo Kornelis
5 Comments
(Warning: This blog post is non-technical but purely personal. I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer and other similar diseases.) Earlier this week I shared with the community the sad news that I have been diagnosed with leukemia. This post is a follow-up on that one. First of all, thanks to all who responded to my blog and tweets about my health issue. I have received lots of responses: here, on twitter, by mail, and through several platforms. I cannot respond to all…
Read More

Involuntary break from speaking

Hugo Kornelis
23 Comments
(Warning: This blog post is non-technical but purely personal. I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer and other similar diseases.) I was recently forced to cancel two speaking engagements at the last minute – almost literally the last minute. I have also cancelled all upcoming conferences, and withdrawn submissions for events that had not finalized their session selection yet. And I will not submit to any events for the foreseeable future. This is not something I do lightly. I hate having to cancel…
Read More

T-SQL Tuesday #151 – Coding standards

Hugo Kornelis
2 Comments
Edition #151 of T-SQL Tuesday is hosted by Mala Mahadevan (b|t), and her chosen topic is to write about coding standards. Or more specifically, T-SQL coding standards. Uhm … are you trying to tell me that there are other programming languages? 😉 The nice thing about standards … “The nice things about coding standards is that there are so many to choose from”. This quote, usually attributed to Andrew S. Tannenbaum, bears a lot of truth. There are indeed many standards. And the debates over which standard is better and which standard should be burned and buried can rage into…
Read More

Understanding Memory Fractions

Hugo Kornelis
1 Comment
Some time ago a reader reached out to me with a request for help. He showed me a query and accompanying execution plan, and asked if I could help reduce (or, better yet, eliminate) the many hash spills that were killing his performance. While helping him work through the plan, I was once more reminded of one of my pet peeves with execution plans: we get to see the requested memory for the plan (the Memory Grant and MemoryGrantInfo properties), which is of course based on the estimated total memory usage of operators that are active at the same time.…
Read More

More Execution Plan Video Training – pre-order now!

Hugo Kornelis
No Comments
Do you like to learn about execution plans? And do you want to save money? Then this post is for you! Execution Plan Video Training Tuning query performance works best if you understand what you can learn from reading execution plans. And if you want to get the most out of each execution plan you see, then you need to know what all operators and properties tell you. The most in-depth and complete learning resource for that is the SQLServerFast Execution Plan Video Training. The only problem with this resource is that it’s not ready yet. Announcing … block 2,…
Read More

T-SQL Tuesday #150 – My first technical job

Hugo Kornelis
No Comments
I’ll admit, I’ve been slacking the T-SQL Tuesday habit for a much too long time. Almost a year since the last time I joined. Time to get back into it! This month, our host is Kenneth Fisher (b|t). He challenges all the #SQLFamily member to reminiscence about their first ever technical job. Is this a secret plot to figure out who of us are too old to remember that far back? Or just human interest? I’ll always remember my first! No matter how many senior moments I have in my life, I don’t think I will ever forget my first…
Read More

Execution Plans in Azure Data Studio

Hugo Kornelis
3 Comments
Microsoft has two main tools for querying and managing SQL Server databases in a graphical UI. SQL Server Management Studio (SSMS) is for many people still the default choice; it used to be included with a SQL Server installation, it is the most familiar tool for most SQL Server professionals, it gives easy access to (almost) all SQL Server features, and it’s simply the interface we have been used to for as long as we’ve been working with SQL Server. The alternative is Azure Data Studio (ADS). This tool seems to be mostly targeted towards developers. A DBA will notice…
Read More

Hugo Kornelis

Married, father of 2 children.

Awarded 13x MVP (2006-2016; 2019-now), in the areas SQL Server and Data Platform.

Subscribe via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Archives

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close