Is the number of entries consistent? Or could there be 2, 3, 4, or more in the brackets?

Look at PATINDEX() and CHARINDEX() with SUBSTRING here. What you really want to...

I will say that being multiple developers on a project is a real challenge that Access does not solve at all on its own. Are you saying you have...

Gonna be a big week, just barely hanging into fourth place here and more byes that hurt this week

That's a good solution, albeit slow, and it will burn DTUs, but it should work.

This would make a great article or tutorial if you want to write it up.

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