The blog has been updated

Now featuring https. For years I’ve been wanting to enable https but WordPress fought me tooth and nail on it (thanks SEO friendly rewriting). Well, I finally figured it out. ?Simply changing the URL in settings was not working, neither was the wp-config by itself. Here is what I ended up adding to wp-config.php. I […]

Read More →

Enable change tracking (CDC) on a MSSQL database when getting Msg 22830

Recently we received a request to enable change tracking on a database but kept getting an error even under a user with the SA role. Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 195 Could not update the metadata that indicates database DBNAME?is enabled for Change Data Capture. The failure occurred when executing the […]

Read More →