Sorry I haven't been here to respond to you all. I've been traveling quite a bit (typing this in Hong Kong of all places).

What you all say resonates. @EdVassie, yeah,...

Thanks for the feedback Mandeep. Keep up the good work.

Nope! Having too much fun.

Thanks all for the feedback.

For some reason (I'll take the blame, but I don't know what I did) I'm not receiving emails on stuff I'm subscribed to. Weirdness. Working on...

The example from SQLShack is good. Here's the Microsoft documentation on it. You 100% can use it with your linked servers. You just have to code it. Follow the...

Extended Events can't do things. They're monitoring. They observe things. You could code something that sends an email in response to an Extended Event, absolutely. However, the Extended Event is...

• This reply was modified 1 years, 1 months ago by Grant Fritchey.

The biggest issue is where does the processing occur. If you're running a query, with a WHERE clause, across a linked server, most of the time, ALL data will be...

Depends on which cloud platform you're on, but every one of them I've worked with have multiple scheduling mechanisms. There's nothing magical about SQL Agent. It's just running T-SQL commands....

OK, so, importing from Excel and creating a database are two very different operations. Let's focus first on the create database question. In SSMS, either, right click on databases, select...

All great stuff. I could do with reducing TV time as well. Let me get this book rewrite finished because that's taking up my will power at the moment. I...

I feel ya! First thing I learned in PostgreSQL was backup and restore. It's just where my brain goes.

Why not make @Period an actual date and then use date math on the value there? Seems like it'd be easier.

Strong recommendation. Read through the Azure documentation on backups, restores, and retention. Partial recovery is likely to be a challenge (it's a challenge on a local machine). You're going to...

See, this is why I always (usually LoL) skim the directions for something before getting started!

It's amazing, though, how enough "little frustrations" can quickly add up to becoming a...

BTW, finished the awning yesterday, a week later.

And it was horrible. I mean, it looks great, works and all. The process of mounting it was horrible.