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

Agreed, though in the query I am picking a long future date, which could change and not necessarily impact the query. If I have to look for the value, then...

So, what do you think of the advice? Is it that much different than you'd get from a colleague? Likely it depends.

I had a client that brought my consulting firm in to help crank out reports for their transactional system. It was a rudimentary intranet social media app. They had...

Allowing no NULL in valid_from / valid_to seems to be a good idea. But implement it with a DEFAULT = '18991231'  on BOTH columns (as at one of my...