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

I insisted on attaching meaningful business comments to DB objects and had a nightly process that generated DB Documentation website using a competitor to Redgate SQLDoc.  This was disparaged...

I've done both, and I like the advice above from Jeffrey, Lynn, and Abhay.

ddl corrected

Great comments, and they often mirror what I see. Some people love AI and use it productively, some don't find it helpful.

I'm on the fence. Some things are very handy...

Agreed, too much stuff is built not to last, or not to be repaired. I'm amazed how poorly some modern things are set up that it's not even possible to...