Sorry, this should help: https://techcommunity.microsoft.com/t5/Azure-Database-Support-Blog/Using-Certificates-in-Azure-SQL-Database-Import/ba-p/368949

From FILE doesn't work, but you can FROM BINARY.

You cannot recreate the certificate. You get a new cert. For the symm key ( I assume sym key), this requires the same identity value and key source (and algorithm)...

Updated the verbiage for the initial rebalance and mentioned that this is for clustered indexes.

Re: Adding a new filegroup, that's a fairly big decision for most people. If you have 400GB, that may make more sense, but it really depends on what you are...

As for keeping up, I think that reading announcements and keeping an eye on news isn't bad. It's just awareness, but topics that seem promising or valuable will get additional...

Lol, I'm not really pre-briefed. I know about things, but I don't know what will release when. For example, I knew about Query Store about 3 years before SQL Server...

Habit, didn't check previous versions on this, so trying to specify versions more to ensure repeatability.

With 2017+, there are no SPs. The lifecycle will always be on the RTM release + CU/GDR

Good catch. The docs are wrong, and I have launchpads for both 2016 and 2017, but this does indeed appear for 2017. Changed the answer.

I would say look for patterns that cause problems. Whether in code structure/smells, indexing, or something else. Then try to show the developers why things are problematic and let them...

I'm only at pre-cons Mon/Tue, and not at the Tue night party. I will try to swing by networking on Monday (Yardhouse) around 6-630.

Anyone feel free to grab me for...

No idea if this is legend or true, but it's certainly something our platforms need to consider.

I think I've messed up this sort of change in C in the past.

That's great. I saw...

I haven't loved the focused box because it hides some things I'm looking for. I didn't realize this was contacts based, which makes some sense, but doesn't quite seem right...

For the meat cookers: https://www.engadget.com/2019/10/25/harvard-barbecue-desora-kamado-joe-cinder-grills/