Thank you, RevOX11.

I've been thinking of wringing a Sudoku Solver for years now, just haven't made time to do it, yet.  My personal interest isn't so much "can a computer...

I'm also curious how, being a write-only solution, your NoSQL implementation handles deletes, and by "delete" I mean in the logical sense, where, for some reason, the Homer record and...

In "Julianized Calendars" the image after your text "Here is an example from 2007" is the same as the image above it.  I wasn't quite getting the intent, as I...

Maybe this is the year we decide to stop requiring passwords from our users, removing one more barrier for _them_ to get all of their passwords under control?

Gibson Research has...

• This reply was modified 4 years, 10 months ago by  Dan Bragg.
• This reply was modified 4 years, 10 months ago by  Dan Bragg.

Excellent article!  We haven't had much call for MERGE yet, but it's good to know that OUTPUT will work fine with it, and your instructions make it clear what we...

Good point.  Then, I'd guess that "toasters" would fall into categories (pick any one, as one's pretty much as good as another):
- A web browser
- A file compressor/decompressor

Ninite, for installing/updating software.  Never start a new computer without it.  Any time any of my software complains it's out of date, I run Ninite to update them all (well,...

In 25+ years of coding, my reasons for commenting code have changed, and it's currently focused on the Who, When and Why of the code, only dealing with the What...

What I've found to be very handy when writing batch files like this is to have an option to get a reminder of what the batch does, and what parameters...

It would be good to be aware of what newer constructs you are using that will limit the backward-compatibility of your solution.  CURRENT_TRANSACTION_ID only exists in SQL Server 2016, and...

Great article, and I'll definitely be keeping this in my tool belt.
One really minor, nit-picky thing: In your list of examples, "1 -- debug only - no truncation" should...

13.0.1400.0

Yes, http://www.sqlservercentral.com/articles/Stairway+Series/121633/ states that it was introduced in "SQL Server 2012" not "SQ LServer 2016"

Does the file's source have to be on the server where SQL Server is installed? or, can this retrieve a file from a remote location, like a user's local...