Yeah, it comes down to some of the choices in picking software that works in different ways. For these forums, limited choices and lots of code already written that uses...

Stairway Series: https://www.sqlservercentral.com/stairways

What Grant said, and practice different skills, see what you like and have an aptitude for. Ask lots of questions, what people do in their jobs, what their...

I tend to agree with Grant's views. I usually use surrogate keys because what I find is that many business people swear there's a natural key, and there is, until...

Stop. Rewind. Reverse that.

You could query sys.sysservers in master to get the linked servers, then with a cursor you can loop through them.

You'd need to define what you want the trigger to do and we can then help you. As Thom noted, this is flawed code.

Some basics: https://www.sqlservercentral.com/articles/learning-about-dml-triggers

Wow, can I ask how long a journey and #people/apps? This would make a great series of articles if you have time.

And we have a test item. Asked in Slack, and a DevOps deploy to prod: https://www.sqlservercentral.com/newsletter-archive

Yes, a bug is open here. The resource files moved, but the linkages got mangled. Not as simple as I had hoped. If there are specific ones, I Can manually...

Looks like they've been removed or hidden already.

Thanks, will check.

We don't have an index right now. The current site uses a new mechanism, and there is a personalized link for newsletters. We're working to migrate that and render a...

OK, I did some work on this and got an article I'll publish next week, but the short answer is that this is both easy and complex.

I've used certs for...

What does "two line ids" mean? You haven't really explained how you set this up or what the data looks like. It would help to have a small repro of...

If you are missing the newsletter, send a note to the webmaster. Likely something is broken, but we can tell you. Mostly we find that we moved services, so some...