Month: May 2023

New videos ready!

It has taken a long time. Partly due to my health, but definitely also to a good extent as a result of my perfectionism. But I can now finally declare that the next set of videos for the Execution Plan Video Training is ready, and pre-order sales have opened, with an insane discount for early deciders! Joins (and more) The focus of block 3 of the SQLServerFast Execution Plan Video Training is on everything related to combining data from multiple sources. Most of the time, data is combined by using one of the four join operators, so they get the…

Plansplaining, part 20. SQL Graph (part 1)

Welcome to part twenty of the plansplaining series. It has been a long time since I last wrote a plansplaining post, partly because of my health, but also for a large part because I was out of ideas. But recently I decided to dig a bit deeper into a feature that was released in SQL Server 2017 and that I had so far not played with: SQL Graph. SQL Graph is the name for a set of features, introduced in SQL Server 2017 and extended in SQL Server 2019, that bring graph database functionality into SQL Server. See here for…

New trailers and an updated chapter

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

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…

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