I would agree that legal speculation isn't valuable unless you are a legal professional with experience here. Even then, the way western law systems work is that despite precedent,  the...

In the upper right of this forum is the outline of a person. Click this and then edit profile. In the profile, there are a series of tabs across the...

The size of the db doesn't necessarily matter, except for the cost in Azure.

What you need to work on the database from two machines is  connectivity.  As long...

I don't think that there is any chance of Windows being abandoned for Linux, unless it's a Linux shop that was forced to introduce a couple Windows Servers.

This...

Yes, execute in SQL Agent, but could be with another scheduler. Some companies I work at have had enterprise schedulers with agents on each machine, but I've tended to stick...

I hate centralized systems. That creates a single point of failure that depends on lots of stuff (Security, networking, etc.) working correctly.

I do think PoSh works well for...

Thanks, that would be great.

Thanks,...

The points system changed slightly because we have new ways to award points based on answers and marking / liking posts. I had a list, but need a final one...

Most people just seem to assume if the server is up, things are working. This usually leads to constant fixes as still broken items are fixed on the fly. One...

I would follow David Burrows advice above. Join inserted to the original table in the trigger.

Thomas, take it.

Eric, there is no original article listed. I noted that it should be similar to a TDE article, any one. How to enable and then set...

If you're updating, then why not put the UPDATE in the trigger? Something like this:

ALTER TRIGGER [dbo].[tr_datediff] ON [dbo][JOURNAL]  FOR INSERT,UPDATE
AS
Update mytable
set mycol = DATEDIFF(d,start_date,end_date)[diff]