Blog - Page 8 of 25 - SQLServerFast

New trailers and an updated chapter

May 10, 2023

Today I am announcing some updates to the free content that is part of the SQLServerFast Execution Plan Video Training. The first announcement is the release of a new set of trailers, to replace the old trailer that was the same for each block and each level. The second announcement is the update of one of the chapters in the free basic level of block 1. Trailers When I started my work on the execution plan video training, I realized I needed a platform that could host my videos, but that could also handle sales for me, and ensure that…

T-SQL Tuesday 162 – Execution plans according to ChatGPT

May 9, 2023

Hugo Kornelis

No Comments

I have skipped a lot of T-SQL Tuesdays, because either I did not have the time to write anything, or I felt I had nothing useful to write. That changes with edition #162, hosted by Tomaz Kastrun (b|t). He invites us to talk about data science in the time of ChatGPT. To be fair, I am not going to cover that literal topic. But rather, I used his invitation as an excuse to do something that I have been wanting to do, and yet postponing, for a few months already. And that is to try to assess whether ChatGPT can…

Which execution plan icons are relevant today?

April 17, 2023

Hugo Kornelis

Back in 2018, when I started working on the SQL Server Execution Plan Reference, I spent quite some time thinking about what icons to show for all operators. I chose at that time to include four sets of icons: the version of the icons in the then current version of SQL Server Management Studio (SSMS); the version that was used in SSMS before the complete art rework in SSMS 17.4; the version that was at that time used in the execution plan viewer of Azure Data Studio (ADS); and the version used in SQL Sentry’s free tool, Plan Explorer. This…

Back home, but still a long way to go

April 5, 2023

Hugo Kornelis

(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 eleventh 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. Back home I’m writing this on April 5th. A long time since my previous health update. Most of that time was spent in the hospital, bur I was discharged…

Relational database design

March 31, 2023

Hugo Kornelis

Over nine years ago, early 2014, I published a video course on Pluralsight. The subject: relational database design. My expectation back then was that there would be some interest in this topic, but not really much. Success story I was wrong. The number of viewers was high right from the start, and has continued to be high all through the years. This course attracted an average of almost 6,000 viewers per year, with almost 15,000 hours per year of view time. Those numbers far exceeded any expectation I had ever had. And what’s more, the numbers are not declining ……

The final lap

February 10, 2023

Hugo Kornelis

(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 tenth 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. Back in the hospital It’s February 10. And I am back in the hospital. Finally. First planned for December 2. Then postponed to January 19, in order to remove…

Good news, bad news

January 19, 2023

Hugo Kornelis

(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 ninth 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. Not a joke We all know them. We all have told them. Jokes (often not very funny) that start with a doctor telling their patient that they’ve got good…

A quiet period

December 20, 2022

Hugo Kornelis

(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 eighth 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. Kidney gone, cancer gone It’s been almost a month since my last health update, here on my blog. High time to share the current status. Only thing of real…

Black Friday Charity summary

December 2, 2022

Hugo Kornelis

No Comments

All through November this year, I have run a variation on Black Friday Sale, called Black Friday Charity. The idea was to take the discount I would have applied for Black Friday Sale, but instead of giving it as a discount, I would give it to charity. You can read all about it in this blog post. November is now over. That means that the Black Friday Charity period is over. Time to summarize the results. Total November sales When I started the Black Friday Charity drive, my hope was to raise at least a thousand dollars for the Leukemia…

When it rains, it pours

November 25, 2022

Hugo Kornelis

(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 seventh 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. Second round of chemotherapy As I write this, I am back home. I was released from the hospital last week. At that time I was still recovering from the…

New trailers and an updated chapter

T-SQL Tuesday 162 – Execution plans according to ChatGPT

Which execution plan icons are relevant today?

Back home, but still a long way to go

Relational database design

The final lap

Good news, bad news

A quiet period

Black Friday Charity summary

When it rains, it pours

How TOP wrecks performance (part 2)

The DIY guide for local-global aggregation

Upcoming presentations. And an offer.

The sniffing database

Misconceptions on parameter sniffing

Three new sessions in three months

Willkommen, Bienvenue, Welcome

The many (too many?) reads of a many to many Merge Join

Plansplaining, part 1. The unexpected aggregation and assert

Plansplaining, part 2. Why scan and spool instead of seek?

Hugo Kornelis

Subscribe via Email

Meta

Archives