Went to see "The Circle" over the weekend and I have to say, talk about a movie that seemed to be building up to a particular message, then bailed out...

*sigh*
It never rains, but it pours...
So last night I finally got off my butt to cut my lawn for the first time since around September.  Lawnmower fired right...

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.