the AT TIME ZONE and some other math functions don't process as efficiently in exec plans, as a side note. Learned that recently.

UTC storage, is still the best, IMHO.

client tools are always tough.

Column truncation has gotten better with 2019.

bcp is unlikeley to go db to db, but it would be nice.

It requires a mindset that looks long term, not this quarter or year. You have to think that we want to be able to adjust and easily fix our code...

If you always store in UTC, then conversion is easy. Browsers and all desktops store regional settings that a web app or thicker app can read. They can do the...

I'm in, way0utwest Cowboys.

I don't think that's the appropriate answer. It is something that can work, but having spent some time there, and with some developers, few people are interested in that type....

Same. I constantly find people want to make DevOps a set of tools, which my employer sells, and I struggle to get them to realize it's more.

I'd hope that leap seconds get washed out in the Time server sync, but certainly we could have inconsistency here as SQL Server seems to take a discreet amount of...

Glad you liked it and you are welcome.

https://feedback.azure.com/d365community/idea/1fa5cf18-5925-ec11-b6e6-000d3a4f0da0 - vote. I think last login time is great.

Select in OE - SQL Search does this: https://www.red-gate.com/products/sql-development/sql-search/

index time - https://feedback.azure.com/d365community/idea/9fec9e0e-3f25-ec11-b6e6-000d3a4f0da0

Meta-data - extended properties do this

Compare data - checksums...

I didn't see that in the comments, to I only read a few dozen from people claiming to be in the industry. Most of those seemed to say this was...

In SSMS I dream of having the MSX / Multi Server Administration "Manage Target Servers" window to be resizable, like just about every other window in SSMS.  It has...

I wish they would have a create date and modified date (if applicable) for everything created within SQL Server.  Linked servers, Triggers, Alerts, Operators, etc.  When I went from...

Here is something that rubs me on a daily basis:

I hate sprinkling my code with RAISERROR just for the sake of printing status messages, because it's ugly and confusing...

While I don't...