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?

Oh.
Joy.
We made a reservation at...