Over the years have seen many solutions that use SQL Express on the back end.  We started using this
The best part about DB Health assist is that it...

Very Nice! Sorry I tried to give an excellent rating, but my mouse malfunctioned.

I'll try the size history method that you mentioned, looks like a clever approach.

We use a...

I agree - I prefer to not use temp tables if I can.

yes you are correct

I actually devised a script to change the collation of every object, but then realized that the other constraints were blocking me.

It would have been...

Sorry - it actually means "code page 1"

SQL_Latin1_General_CP1_CI_AS:- Latin1-General, case-insensitive,

accent-sensitive, kanatype-insensitive, width-insensitive for Unicode

Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data

I never dreamed it could...

I didn't supply an explicit collation string, the string"COLLATE DATABASE_DEFAULT", tells the temp table to use the default collation of the database that was restored no matter what the collation...

shouldn't it read: While the Server and ConnectionData fields may seem redundant, the ConnectionData field may contain an (not and) IPV4 or IPV6 address?

BTW: I like your article and I...

me too.

In multi-tier applications where you don’t necessarily know how the client will connect, ie browser from a computer, wi-fi, cellular, iPhone app,… and the application may be hosted or in...

Apologies, for the miscommunication. NOT lazy DBA’s, lazy developers. Not all developers are lazy, just many that I’ve met. It is not personal.