Changing the Collation of the 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

Occassionally 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). Unfortunately, I am using Microsoft Windows 10 Home Edition, and that does… Continue reading Enable Group Policy Editor (gpedit.msc) on Windows 10 Home Edition