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

No word. I'll bump the message if I don't see something later today

Cache is by database, not by instance. You need to run this in each db. You can script that, but i'd include the name of your db in the result...

It's easy to do, but there are potential issues, as Dino pointed out.

You might read this: https://www.red-gate.com/simple-talk/sql/sql-development/beginner-guide-to-in-memory-optimized-tables-in-sql-server/

I don't think it's an issue, but I get your concern. I'll send a query to MS.