I do think you need a new key, decrypt and encrypt again. A pain, but better than getting into a situation where you're stuck.

Scott has given you the hint. You join the two with a left join, and you get some rows from Department that are not in Student, and are filled with...

Very, very slightly uphill

I do agree and apologies. Not sure what I was thinking when I wrote this one based on an issue. It is a gray area, as nothing has executed. This...

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...