It's not just a lack of contrast... most of them are terrible for color, font, usability, etc.  Seems like most have gone "metro" and, to me, "metro" is seriously uninspired...

Write a stored procedure to do the restore and schedule it as a job?

If you're looking for truly legit certification courses, I'd suggest starting with Microsoft. There, they list a bunch of partners that offer up-to-date training. If you want online,...

Ok... in your last post at  https://www.sqlservercentral.com/forums/topic/how-to-get-last-5-weeks-start-and-end-dates  you wanted the weeks to be calculated based on whatever GETDATE() returned and you used the example of what you wanted on...

You bet.  Thank you for the feedback, Pedro.

Shifting gears a bit, I remembered that I had refactored Peter's good code and found it in my archives.  I redacted that to have a nice flower box and included...

Here's another listing that not only lists the fixed holidays that always occur on the same day of every year but also how to calculate the "movable" holidays.

https://en.wikipedia.org/wiki/Public_holidays_in_Portugal

Here's one...

By now, you know the solution.

Want to make it even better, do not use a SCALAR value function, but turn it into a (in-line)Table valued function ! In most...

The correct answer should have been... find the person that wrote the trigger with an empty CATCH and have a nice pork chop dinner with them. 😀

From the Aritcle:

---

What work is suited for live, in-person interaction? Which aspects of your job benefit from seeing others face-to-face?

BWAAA-HAAA-HAAA!!!  I can think of no thing that would prove...

Can you just create a linked server in SSMS, then just do an "insert into select * from" command in SSMS?

If you cannot create a linked server then, if...

My question would be, why are you using two tables to do one thing?  It looks to me like it should be a single table because there appears to be...

Even though the MS documentation states that literals longer than 4000 characters are cast as NVARCHAR(MAX) this doesn't seem to be the case.

Constants (Transact-SQL) - SQL Server |...

I've searched for a more recent document that mentions performance in terms of overhead percentages but found none.  I wouldn't expect to see such a thing from future MS documentation...

I guess I'll never understand why people...