Thanks, corrected.

This is a basic article on how to capture things in SSMS. Plenty of people don't want VS, or can't use db projects depending on version, so this is...

Me either. One question led to another, and another. I think we're almost done with this set, but wrote like 10 one day based on someone's question.

That makes total sense. SHA1 is bad, though I'd have hoped they would have a trace flag on at least 2012 to switch this.

What I suspect you'll need to do...

Did you open the key? Here's what I did, and I'll write this up as an article for  a repro, but on a local 2017 server, I did this:

            
November 15, 2019 at 1:23 am
            
#3697922

            
            
                                                
        

For data mining, I think the Data Mining levels from Daniel are good. They'll get you going, though some are a bit dated. I started this book, https://amzn.to/32Ir1fK, which...

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