Interesting to hear thoughts, and I am very torn on the ways in which things are handled. I will say at Redgate we try to be reasonable. We ask,...

If you look at the code I posted, the text to describe what happens says that "When the fractional precision of the datetime2(n) value is greater than three digits,...

I doubt Windows will lose 1/2 share as a laptop OS.

As a mobile device OS, yes, as I think iOS/Android and tablets are more and more common for many people....

select *

from a inner join b on a.x = b.x collation latin_ci_ai

inner join c on b.y = c.y collation latin_cs_ai

Apologies, my typo. It is UDP 1434

Points awarded back

Hi all,

Our approach is quite rigid: all components (web sites, services) must first be taken offline, then any upgrade scripts are applied to the database, then the components are...

I would prefer DB first because getting the data model right is something that will serve the business functionality well for years and probably serve many generations of applications,...

Call me a dinosaur if you like, but I'm 100% with Alex Gay - don't use it and wouldn't use it for code I can write myself. Nearest...

Awfully Infuriating

Amazing and Idiotic

Assistance Included

This sounds like something doable, but likely something that is done outside of T-SQL. I only see a few dbatools replication commands, but for something like this, which is a...

Good points. As the only DBA in a few places, I haven't had a ton to do after the first 6 months when I clean up the environment. In those...

Short answer, ID10T error.

Longer answer, I was editing this as we had a formatting problem and I think I changed the answer here and then changed the question, without testing....

I see some SSIS people moving to ADF, but mostly just running SSIS from the connector.

Some non MSSQL people seem to like dbt, but that looks like a wild, crazy...

I think this is an Azure size. What do you want to change? Cores or RAM?

I would lean towards DesNorton's solution as I dislike triggers and I think they get hidden/lost from future devs/DBAs.