Not a good matchup this week, and I think I play Luis. Good luck all.

I really think most of us will move to Linux over time. A decade, but we'll find it much easier as we move to SQL 2017+ and start to not...

Thanks, fixed that. That's what I get for trying to edit the code after it's pasted in. Trying to set better examples with schema qualification and was just racing through...

I suspect that someone starting as a data analyst in this case isn't really technical, but maybe is a business person that got pointed to a SQL article or given...

Hmmm, I'll have to try this out myself. This looks right, though honestly, you ought to be able to just create the sym key, no cert needed, and see if...

Good for you, John. I think you'd be surprised how strong you are if you did something else.

I used to bike 12mi each way, but I'd drive Mon am with...

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