You can use the UPDATE() or COLUMNS_UPDATED() functions to check if the column has changed. Or use a query to compare inserted.customername with deleted.customername.

https://docs.microsoft.com/en-us/sql/t-sql/functions/columns-updated-transact-sql?view=sql-server-2017

Erikur has given you a start, but here's the thing. If you restore to Azure, and you go over there for DR, how do you get back? That can be...

It's something to think about, but it's also a tough topic. What do we cover? All types of objects? Server tuning v index tuning v query tuning? We've debated it,...

I might break this into two parts to get started. 1) jobs that are finished, 2) jobs that are not.

You could create a couple CTEs that would solve...

This is the same as a file copy. How would you copy a file from Server A to Server B?

You want security. Even if this is your music...

You'll need to group by dates as well, since 1400 occurs on multiple days. If you group by the hour, you'll combine the counts from Monday and Tuesday

To be clear, I don't like NULL for string columns. Often I think we can better describe this as N/A, Unknown, Unassigned, etc. For numbers, it makes some sense, as...

I think it's there now (speed and flexibility over cost), but what we're catching up with is trying to compare some performance on-premises to a cloud. In many cases people...

That's amazing. Didn't realize the text() had that impact. Any idea why?

It could be, but I also have used these in places where we weren't sure of the domain model for an entity. The business is a little flaky, and they...

What is the CLR procedure doing? Can you post the code and namespaces being used?

:), opinions do vary.

I really dislike EAVs, though they do have a very limited place at times. Perhaps someone feels differently and really likes them. Or they...

I think the CA does have some better limits. We'll see how it goes.