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

If you save .sql files in a folder under your HTML/etc files, and this is a repo, you can open the entire folder in VS Code and edit any file....

I have no idea, but I'd lean towards networking. I'd be sure that firewalls on the machine, as well as routers are open here.

A few searches show things like basic...

I'm not worried about AI, but I do think it's a tool that I need to learn more about how to use effectively.

There isn't a setting in SSMS I'm aware of.

Is this what you and your colleague are doing: https://www.mssqltips.com/sqlservertip/4814/exporting-and-importing-sql-server-always-encrypted-certificates-for-client-access/

As Perry noted, make sure you and your colleague understand how this...

SSN can be used as a reliable primary key for a table called Customer_SSN. It should be linked to a CustomerID, just like phone number(s) and email address. But...

Good examples, and that's the type of thing I run into. I worry what we'll do when we do have issues with SSNs, maybe we'll have to have an "active...