If you're running SQL Server 2022, hold off installing CU4 if you're using the Parameter Sensitive Plan Optimization with Query Store on, OR if you have indexes with a descending order key and you like your ORDER BY clauses to work properly. If you've already installed CU4, turn

T-SQL Gap-Filling Challenge red-gate.com/simple-talk/da…

GM

Being an MVP is a highlight of my life. Beyond the immense professional significance, I got to meet many people who became lifelong friends. It's an honor to get renewed for the 25th year! Here's a photo from one of the early MVP summits. Can you recognize yourself? #mvpbuzz

Tonight I dreamt that I lived in an apartment building made of columnstore; I woke up feeling a bit compressed

I said extra hot, not extra oat

Just posted a new article from Itzik Ben-Gan on the site! red-gate.com/simple-talk/da… Great and important topic about controlling duplicated data!

T-SQL Fundamentals: Controlling Duplicates red-gate.com/simple-talk/da…

His 2022 session was a huge hit with the #data community, and this year we can't wait to hear what Itzik Ben-Gan has in store for us at #PASSDataSummit 2023! Find out more and save your seat rd.gt/3rEs2Iq

My data superhero AI-generated alter ego…

Happy Booksgiving! 🥳 Save up to 55%* when you buy 2+ books & eBooks with discount code BOOKSGIVING. Hurry, deal ends December 1. microsoftpressstore.com/booksgiving 📚Shop titles from Sarah Young Yuri Diogenes Andrew Bettany MCT MVP Rob Miles Andrea Allievi @markrussinovich Alex Ionescu Dino Esposito Itzik Ben-Gan

Two-Dimensional Interval Packing Challenge red-gate.com/simple-talk/da…

T-SQL Fundamentals by Itzik Ben-Gan (Microsoft Press) reviewed by Kay Ewbank who awards it our highest rating (5). i-programmer.info/bookreviews/21…

Azure SQL post Introducing Regular Expression (Regex) Support in Azure SQL DB dlvr.it/T4SYkV

Can’t believe it’s been 25 years. Excited to be part of this inspiring group for another year! #MVPBuzz

Honestly, if you work with data, you must know SQL!    It’s that simple.  No exceptions.  #Honestly #WorkSmart #KnowSQL

When configuring a linked server to Excel finally works…

Time to channel my network. My current contract expires at the end of the month. So I am looking for new opportunities. Do you know anyone who can use a very experienced #SQLServer developer, specialized in query tuning? Please reach out! Reposts appreciated. #OpenToWork