A badly timed toothache

(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

(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

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

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!

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

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

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

Breaking the silence

I’ve been slacking. I know. I have not published any new pages to the Execution Plan Reference since September. The last release of new content for the Execution Plan Video Training is even longer back, that was in May. No other blog posts, except from a few promotional posts. And until last Monday, nothing added to my YouTube channel either. Okay, I did still speak at various conferences. I answered the odd question at the #sqlhelp Twitter channel. I think I responded to all mails I received (but if not … my apologies and feel free to re-send!). So you…
Read More

Here’s the execution plan … now what?

No Comments
I was really surprised, but also honoured, when I was asked to participate in the Query Tuning Learning Pathway at the 2021 PASS Community Summit. I immediately knew I wanted this to be a new session, and I wanted it to be special. After a few mails between Allen White (the pathway coordinator) and me, the idea was born to build a session aimed at bridging the gap between on the one side the simplified classroom examples typically used to explain a concept, and on the other side the big and messy execution plans you’ll encounter when trying to apply…
Read More

Black Friday sale

“If Brent does it, it has to be smart, right? Right?” As a European, I have always struggled with the concept of Black Friday sale. For many reasons. It’s called Black Friday. Why does the sale for many retailers actually last a full week, or even a month? The discounts offered during the Black Friday sale are, often, huge. Why would anyone still buy any non-perishables at any other time of the year? But as a European, I also see the popularity of Black Friday sales increasing, in my own country and many other countries throughout the world. As well…
Read More

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.