Only two flights for me, easily cancelled for credit. Two hotels cancelled, but one was prepaid and they don't seem to want to do anything. I was hoping to push...

Not from MS, but another MVP. A South African, and they said this:

"Set the default regional settings to GB for the box, and then set the collation for SQL Server...

Ignoring the politics, this is interesting: https://www.cnn.com/2020/03/09/politics/coronavirus-airlines-white-house-tensions/index.html

US govt: we want this data

CEO: We don't have that

US govt: You're lying.

CEO: We can collect it with paper, or build an app...

I agree with Jeff, and that's what I've done. Usually removing stuff is a year+ duration. I rename them, have a date so that I can programmatically remove them, and...

You can check dumps here: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-server-memory-dumps-transact-sql?view=sql-server-ver15

If a dump isn't triggered for the hung/reboot, not sure you will see a SQL dump or there's value in producing one later. You're...

Articles here on tsqlt - https://www.sqlservercentral.com/categories/tsqlt

Microsoft has a unit testing framework, which can work with SQL Server: https://docs.microsoft.com/en-us/sql/ssdt/walkthrough-creating-and-running-a-sql-server-unit-test?view=sql-server-ver15

dbunit - http://dbunit.sourceforge.net/

JDE was a mess. I worked there and their philosophy (with 100s of developers on a product) was write crappy SQL once and have it run poorly on every platform....

Well, I'm cancelling my trip next week. Actually, it's already cancelled.

My wife and I decided that the risk of becoming carriers isn't worth it without a strong reason to go....

I'd expect more from people buying commercial applications.

Good points

I am loving these excellent comments.

I will point out that developers have a very short and predictable list of persistence requirements: load a grid, populate a form, save on...

When working with SP inside a .net project feels like Blackbox development. The Code you write looks like it assumes too much and needs a magic trust to what...

In today's cloud world vendor lock-in is an issue with most stored procedures being DB platform specific (MSSQL vs PLSQL vs MySQL).  Having to deploy an additional server just...

"...from a developer point of view..."  Why is it "more difficult" to build with stored procedures:

1. 1. It makes your entire project dependent on the DBA.  Not...

Security is getting better, attacks are getting more creative and complex.

Once we get rid of all these simple attacks, and many of them are simple and easily preventable, it will...