Some of you may have noticed that things are looking different here. Well, they are. But not just “looking” different, are we. We are actually “feeling” different. Under all this visible change are other major changes – changes that will not only make my life easier, but will make the site a bit more stable, reliable, and faster.
What I’ve done is actually migrate [finally] all my sites/blogs/galleries to a single server. I’ve eliminated the old photo gallery server that was an “interim” box and moved that function to the main server. I’ve removed all instances of MySQL and am instead utilizing a single Microsoft SQL Server 2008 instance, which will soon be upgraded to SQL Server 2008 R2 for those that care.
This was harder to do than to write about and much pain and link adjustment/correction was required after migration to make sure everything was working.
In the past, running WordPress required MySQL since the Microsoft database was considered “enterprise” and not “open source”. However, in recent months, some enterprising individuals wrote a WordPress plugin that allows a connection directly to MS SQL instead of MySQL.
Now, all my blog are belong to MSSQL. [Grammatical incorrectness intentional for those not “in the know”, and if you don’t know where that reference comes from, I’m not explaining it to you.]