T-SQL Tuesday #159 – What’s Your Favorite New Feature?

Invitation from Deepthi Goguri.

This month, I am inviting everyone to blog about two topics:

  1. Blog about your new favorite feature in SQL Server 2022 or in Azure. Why is it your favorite feature and what are your experiences and learnings from exploring this feature? If you have not explored these new features yet, No worries! Blog about the features you feel interested in exploring.
  2. New year, New Resolutions. What are your new year resolutions and how do you keep the discipline doing it day after day? Here are some examples: new hobby, plan to spend more time doing physical activity, wanted to read list of books (Please mention the names so it may also inspire others to read those books), journaling or any other resolutions you plan for this year.

Here are my answers to above questions:

  1. I am looking forward to learn about my favorite feature Query Store and its advancements in the SQL Server 2022. Query Store feature now supports the read only replicas from availability groups. The other advancement in Query Store is Query Store hints. I have written a blog post about it here. The other new feature is the parameter sensitive plan optimization where multiple plans are stores in plan cache for a single stored procedure reducing the parameter sniffing problems.
  2. This year, my resolution is to include exercise to my daily routine and reading David Goggin’s book all over again “Can’t Hurt me” before I begin to read his second book “Never finished”. It is getting harder to keep the exercise discipline. I had my gaps but I know I will get into the track again. I believe it is all about doing your best when you feel the worst. I am looking forward to listen to your resolutions and your discipline in following them day in and day out.

If you are looking for the latest features in SQL Server 2022, follow this series of videos by Bob Ward and Anna Hoffman explaining the new capabilities and features for SQL Server 2022. For new features in Azure, please check Azure SQL updates here and general overall Azure updates here.

T-SQL Tuesday #154 – SQL Server 2022

Invitation from Glenn Berry.

Your mission, if you choose to accept it, is to write about what you have been doing (if anything) with SQL Server 2022. Maybe you have been doing a lot of testing with the public CTP builds and now RC0. Perhaps you have not had the time (or interest) in doing any SQL Server 2022 testing or research. Whatever you have been doing, now is your chance to talk about it, good or bad.

Maybe you can’t wait for SQL Server 2022 to be released, or perhaps you couldn’t care less about it. I would love to hear what your experience has been and what your opinions are about this release. If SQL Server 2022 is not on your future roadmap, please tell me why.

Just in case you haven’t heard much about SQL Server 2022, here are a few links from Microsoft.