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...

You can use an older ADW db, as I show here:

 

However, needs to be in 2022 compat mode

October 2, 2023 at 4:13 pm

#4299784

Bonus points for style.

Also with some "why" this is a good or bad design. A debate.

 

I like the above design for the people entities, but not sure about the scheduling. Scheduling has a...

It's very...