We're being forced to upgrade from 2019 to 2022 with my biggest database, as the vendor will no longer support 2019 after their next upgrade which we'll put in...

Interesting. With queue type stuff, I try to use some way to mark that a process has the message quickly and then mark done. In some of the queueing systems...

🙂

It's crazy that someone thought of attacking source code as a way of hacking, but it's an amazingly evil idea.

I'm not sure what temporal tables have to do with this. BACKUP TABLE reports as not implemented.

I also want to say that I really appreciate people who bought Teslas years ago, as I believe that the early adopters paved the way for EVs to be...

Fun article, as I'm passionate about EVs and enjoy learning new things.  However, the reason I don't have an EV right now is because there aren't any on the...

This does happen, but there are always places...

This does happen, but there are always places...

I know from previous experience that it is possible to lock down production.  The caveat being that you have to think through your operational needs and invest as much...

I know from previous experience that it is possible to lock down production.  The caveat being that you have to think through your operational needs and invest as much...

Not necessarily, especially with modern...

Interesting post! Would Dynamic Data Masking be the tool to use here?  I"m assuming not, since the data could be unmasked on the development server. Thus the actual data...

Thanks for the feedback. While this isn't a short piece, there are lots of people who would just want to restore with the GUI and not with the restore command....

AI is an interesting idea.

I might low-tech this and add some sort of over-reaching proc that is called (or a first step in a job), that documents the flows and...