Changing the Collation of the SQL Server Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?

Need to change the collation at ALL levels? Prefer to avoid reloading all objects and data? Learn what the "sqlservr -q" option does, and doesn't, do.

Enable Group Policy Editor (gpedit.msc) on Windows 10 Home Edition

(last updated: 2020-07-05 @ 12:45 EST / 2020-07-05 @ 16:45 UTC ) Occasionally I want / need to change a Windows setting that is not configurable via Control Panel or Settings. For example: Enabling long-path support (long = paths over 259 characters) Disabling all Live Tiles The instructions usually require using Group Policy Editor (gpedit.msc).… Continue reading Enable Group Policy Editor (gpedit.msc) on Windows 10 Home Edition