SentryOne Team Blog (blogs.sentryone.com)

GroupBy : New Engine Features in SQL Server 2019

This morning I presented a session on SQL Server 2019 (video here, deck and samples here), and the demo gods were very unkind to me. They spoiled not one demo, but two!

The first demo that bombed was ADD SENSITIVTY CLASSIFICATION. I guess I created too many audits preparing for the session and got a wire crossed somewhere.

The second demo that bombed was create resumable index – some timing issue I couldn't nail down between the start of the operation and the pause. This is what was supposed to happen:

  1. Start a lengthy index operation
  2. Jump to a separate tab and pause it
  3. Observe that the index creation was, in fact, interrupted
  4. See how far it got, then resume and let it finish

I've confirmed that running the scripts now, not under duress, they work as expected.

After two demo fails, Kendra suggested I don't cross any streets. How right she was. On the way to the dentist at lunchtime, I picked up a $1,300 deck screw:

I have run-flats, so I was able to drive to the shop. But since I have all-wheel drive and (I'm learning now) a very sensitive DSC system, all four tires have to be replaced so they have nearly identical tread war. So that was fun!

One reply on “GroupBy : New Engine Features in SQL Server 2019”

1 Comment (Comments are now closed.)
  1. Hi,

    I have been working on Microsoft SQL Server 2019 (CTP2.2) and trying to implement Always Encrypted Security Enclave following this post

    https://docs.microsoft.com/en-us/sql/relational-databases/security/tutorial-getting-started-with-always-encrypted-enclaves?view=sqlallproducts-allversions

    When I trying to create New Column Master Key in SSMS v. 18.0 preview 6, I can't see the checkbox 'Allow enclave computations'.

    Do you perhaps know, how to solve this problem?

    Thanks in advance for your reply,

    Darko