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

This sounds like more of an Access question than modeling. I assume you want tblExportInformation .PermitID to link to values in the permit table. Have you tried a FK?

Nice to see I'm not alone. I agree this isn't that hard, and it's nice to keep an eye on if something goes sideways.

I tend to agree, AI isn't going to kill us, but it is going to change things. I expect AgenticAI to run in limited circumstances where it saves people time,...

Thanks, just testing performance and replies.

You don't have to hardcode the values. You can use values from tables as well, so this could get some dynamic-type sql choices. I have a table of beers and...

That's a great reply

Maybe. I'm definitely not the AG expert or cluster guy here. You might send Perry Whittle a DM and ask him to respond here. He wrote the Stairway on clustering/AGs...

Basic AGs: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-ver16

As noted, to go beyond this Enterprise is needed, which is $$$. There are a few features (including RAM/CPU limits that are higher in EE, but they...

This help?

DECLARE @code VARCHAR(1000) = '[{"ChannelName":"LOT4 - Telephone","ChannelRecordId":"42c49edf-9aa1-ec11-b85f-00155d640f76","Removed":false},{"ChannelName":"LOT4 - Video","ChannelRecordId":"46c49edf-9aa1-ec11-b85f-00155d640f76","Removed":false}]'
SELECT ISJSON(@code)
SELECT 
    JSON_VALUE(value, '$.ChannelRecordId') AS ChannelRecordId
FROM OPENJSON(@code) AS oj