If you do go to Azure SQL Database, while there are cross-database queries possible, the architecture is very different from any other implementation, so that will be a somewhat limiting...

Bacpac will not capture active transactions. So if you start a bacpac and while it's running some number of transactions complete, they won't be a part of the bacpac. It's...

Probably powershell. Run a scheduled check that can read the table list and compare it to a list of files. Have an IF statement that then fires off additional commands.

Then why not a table with Hotel,...

Be cautious about building this kind of catch-all query. Here's some great advice from Gail Shaw on the topic. Note that she has multiple posts on the topic. It's...

Sounds like two joins. Once on hotel1 to the table2 id, then on hotel2 to table2 id. This is psuedo code, but you get the idea;

SELECT ha.HotelName...

There's no way to know without testing it on the system you're running it against. Query performance is not simply the T-SQL itself (although that alone is a huge factor)....

Cheers!

"fuel save pro   compatibility to ethernet in addition to Wi-Fi, and for that reason enable completely wireless operations and data ment. The consumer can switch the retrieved information by...

Happy New Year to you, too, Grant.

I only ever made one New Year's resolution (many years ago), and that was not to make any New Year's resolutions in the...

There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.

Other...

There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.

Other...

There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.

Other...

Hourly log backups may not be frequent enough. Think of it like this. If the server crashed, you may lose up to an hour of data if you couldn't get...

You might try looking at the connectivity_error_ring_buffer_recorded Extended Event. It's one mechanism to track timeouts on connections. I think it might, possibly, maybe (did I put enough weasel words in?)...