Blog - Page 11 of 27 - SQLServerFast

T-SQL Tuesday #150 – My first technical job

May 10, 2022

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…

Execution Plans in Azure Data Studio

March 9, 2022

Hugo Kornelis

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…

Breaking the silence

February 9, 2022

Hugo Kornelis

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…

Here’s the execution plan … now what?

February 8, 2022

Hugo Kornelis

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…

Black Friday sale

October 26, 2021

Hugo Kornelis

“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…

Recorded conference sessions

August 23, 2021

Hugo Kornelis

Since the start of the Covid-19 pandemic, conferences have switched to a virtual format. During the pandemic that had only benefits, since the alternative would be no conference at all. Now that some areas of the world are slowly opening up again and the first few organizers tentatively prepare for live conferences, it will be interesting to see whether we’ll return to in-person delivery only, or whether we’ll see a mixture of in-person events, virtual events, and hybrid events going forward. Session recordings An interesting side effect of the rise of virtual events is that far more sessions than before…

Plansplaining, part 19. Temporal tables (part 4)

July 5, 2021

Hugo Kornelis

Welcome to part nineteen of the plansplaining series, where I will finally wrap up the discussion on temporal tables. In the first three parts, we looked at execution plans for modifying data in a temporal table, and for basic and advanced temporal queries. In this last part, we’ll shift away for execution plans (so the plansplaining tag is perhaps a bit misleading) and look at what happens if you join data from multiple temporal tables. Sample data I once more use the same tables as in all previous post, but this time I want a bit more control over the…

T-SQL Tuesday #139 – Execution plans in a hybrid world

June 8, 2021

Hugo Kornelis

Another month has passed. Another T-SQL Tuesday arrives, with a new host and a new subject. The host is no less than the amazingly awesome (his words, not mine!) Ben Weissman (b|t); his selected topic, based on the realization that the data world is hybrid and will remain so, is to share our experiences with our journey towards or on that hybrid world of on-prem, cloud, and edge. I don’t care … I’ll admit, my first response was to just sit this one out. I am extremely specialized in execution plans, as a tool for query performance tuning. When your…

Free video on percentages in execution plans

May 24, 2021

Hugo Kornelis

A few weeks ago I made a rather embarrassing discovery. I realised I had forgotten to include one of the most basic teachings about execution plans in my video training course. The subject is too important to leave out. It is too broad to add to an existing video. So I decided to add a seventh chapter to the (free!!) basic level of block 1. When I write, present, talk, or record about execution plans, I focus on how operators interact with each other and how that results in the desired results. Understanding performance issues comes automatically once you know…

More Execution Plan Video Training – pre-order now!

T-SQL Tuesday #150 – My first technical job

Execution Plans in Azure Data Studio

Breaking the silence

Here’s the execution plan … now what?

Black Friday sale

Recorded conference sessions

Plansplaining, part 19. Temporal tables (part 4)

T-SQL Tuesday #139 – Execution plans in a hybrid world

Free video on percentages in execution plans

More Execution Plan Video Training – pre-order now!

T-SQL Tuesday #150 – My first technical job

Execution Plans in Azure Data Studio

Breaking the silence

Here’s the execution plan … now what?

Black Friday sale

Recorded conference sessions

Plansplaining, part 19. Temporal tables (part 4)

T-SQL Tuesday #139 – Execution plans in a hybrid world

Free video on percentages in execution plans

Hugo Kornelis

Subscribe via Email

Meta

Archives