Updated the answers with the correct spelling.

Certainly should have semi colons. That's what I get for writing code in the form and not with SQL Prompt

Apologies, poorly worded question. This should have been amount of used space, not free space.

DR isn't a thing, as in, I have or don't have DR for my company.

We all have to make choices. We all have to work within constraints. I may have...

We used to use ML type systems a decade ago to read marks on wood from a scanner. These were used to grade the wood and help workers reduce the...

Can you show a repro with some code?

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