IoT is certainly going to be interesting to watch.  It's been coming for a while now and I do agree that the developers absolutely, positively, MUST bake in decent security...

OK, bit of a rant time...
Trying to get SSIS Catalog working in a server migration, come to find out that while you can move the SSISDB between servers, yeah,...

So, the talk about what people do or don't know about SQL got me thinking...
How would *you* describe (in general) your knowledge base, not only of SQL but of...

Chris, while your query might perform a bit better, one thing it doesn't do that JHaddens does is adjust for when the holiday in question falls on a weekday.

Never mind, I found a solution, create a dedicated login with create database, and backup on the target database, then use that for the exec as login.

Creating an Audit (server or database) requires two things:
1.  An Audit definition at the server level (Server->Security->Audits) which defines *where* the audit will be saved (File, Application Log, or...

Gotta love when you're poking through a SQL install log trying to figure out why it failed, and you find a line with this in it:

Hello, I'm your...

Any bets that the OP in this topic: https://www.sqlservercentral.com/Forums/1871933/SQL-Server-detected-a-logical-consistencybased-IO-error-incorrect-checksum is now cursing "that person on the internet that *told* me to do the repair" right now?