Ola's scripts will give you files. You can use PoSh to to restores in parallel with Start-Process or something similar, but you'd need a way to parse and script each...

replicate returns 8k

https://learn.microsoft.com/en-us/sql/t-sql/functions/replicate-transact-sql?view=sql-server-ver16

I'll add one more. I have a customer that has some databases that don't need to be backed up (QA or similar purposes). If the db were lost, they'd recreate...

If you're trying to get started, one thing I'd recommend is make a REPO to keep your code review checklists. You can alter/change those as well with a PR and...

It's helpful if you give a create table and insert statements, so we understand the structure of the query.

A tally/numbers table can help you get the days of the month....

I lost track of this. I'll ping the author and ask if they will continue this.

No idea if this helps, but new releases: https://techcommunity.microsoft.com/t5/sql-server-blog/update-hotfixes-released-for-odbc-and-ole-db-drivers-for-sql/ba-p/3951162

For those Azure customers with zone-redundancy enabled, it would be interesting to know how much loss of availability they experienced. Theoretically, it should be been a couple minutes at...

I wonder what percentage of people find conferences a means to really establish friendships with people, as you describe Steve.  I have been to a handful of SQL Saturdays...

I never really went to conferences while working, but over the years had both regular and rare social situations with co-workers.  The most pleasant ones were when we...

Good basics, though what about scheduling classes multiple times?

I need to change the author. It defaults to me, and I rarely add articles for others, so I always forget.

Most SQL Saturdays use sessionize, in fact, most conferences do. PASS Summit used it last year (2022), but not this year. I think because the platform they use already has...

This is a good article, but I've got a question or two for clarification. The first involves the release notes and feature changes that hackers use to devise ways...

...

Inadequately secured cloud tech may be at the forefront of people's minds but how secure is the ancient stuff quietly running the world.  What damage could a motivated, hostile...