I think the docs are wrong. I was doing a few things here and didn't test the explicit phrase in the docs, which appears to be wrong.

My own tests with...

That likely makes sense. I assume any error stops the repl from running? I might log this as well, just so if someone asks why it's not running, you can...

The changes in cities aren't that people don't go to local busineses, but they go to local ones near them. So many that depended on a volume of business, like...

Anyone on the observability train here? I keep reading about it and seeing stuff about it, and this explanation almost seems to go in circles: https://www.honeycomb.io/blog/observability-telemetry-monitoring

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