David Westerfield

Theology. Culture. Technology.

Tag: database

Migrating a Host-Named Site Collection (HNSC)

Since I had to piece together how to accomplish the migration of a host-named site collection (HNSC) I had already setup in SharePoint 2013, from one farm to another, I figured I would outline exactly how to do it. In my case, I needed the HNSC to be in its own content database, I’m targeting a particular web app with the HNSC as opposed to using a wildcard web app to handle the hostnames, and all of this is assuming you have your rights setup to be able to carry out all of this; SQL, SharePoint farm account and otherwise. With that said…

Read More

The Annoyance of WordPress Revisions – And the Fix

After getting this new blog up and running, I noticed one of the features that was added in version 2.5 of WordPress: revisions. It got me to thinking about how the database was impacted after moving all of those entries over. After running a query in the DB, the result came back with 1723 rows, yet I only have 684 entries. The rest (minus pages and attachments) were all revisions of blog posts and pages. Each revision is a full blog entry. Over time, that could add up to a lot of data, depending on how often you post entries and how many revisions you create in the process of each post.

Read More

Powered by WordPress & Theme by Anders Norén