For those that work with Active Directory environments, but (for whatever reason) prefer to keep their computer off the domain (consultants — that’s probably you!), you DO have the option to run SQL Server Management Studio using Windows Authentication from your non-domain user account. I only recently discovered this, and I can’t believe it took […]
Category: Database Servers
How to Install SQL Server Management Studio 2005 on Vista 64-bit
If you have tried to install the 64-bit version of SQL Server Management Studio on Vista 64-bit, then you have probably run into the following error: Product: Microsoft SQL Server Management Studio Express — The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code […]
Delete Duplicate Rows/Records in MySQL Table
Most articles on removing duplicate rows from a MySQL table involve 3 steps, but the following query is what I use for purging dupe records in one simple query. DELETE FROM `myTable` WHERE id NOT IN (SELECT t1.id FROM (SELECT id, groupByColumn FROM `myTable` ORDER BY id DESC) as t1 GROUP BY t1.groupByColumn) – “myTable” […]
How to Copy or Move a Joomla Website
Intro If you manage one or more Joomla websites, eventually you’ll have to move them elsewhere. It’s pretty much fact. Performance requirements will change, you’ll find better pricing elsewhere, your dedicated server died, etc. There are a few options most people have to choose from: FTP client and phpMyAdmin method (aka the long, boring method) SSH/Shell […]
Cloud Hosting – Scaling Websites the Easy Way
One often has to make a choice when it comes to website hosting. You weigh the variables and decide on the best solution for your hosting needs. Cloud hosting makes this decision a WHOLE lot easier. Let’s break it down. Price. You want to get the best deal possible. Shared hosting probably comes to mind […]
How-to Backup Joomla! 1.5 to Amazon S3 with Jets3t
Introduction to backing up a Joomla website to Amazon S3 storage using Jets3t. We all know backups are important. I’ve found what I consider a pretty good backup solution using Amazon S3. It’s super cheap, your backups are in a secure location, and you can get to them from anywhere. For my backup solution, I’m […]
Tips on Load Balancing a Joomla Cluster with HAProxy
For the past several weeks, I have been working with Joomla in a clustered environment. We have a single load-balancer running HAProxy that sends requests to two web servers synchronized with unison. One server is a hybrid and includes both the MySQL database as well as Apache2/PHP5. The other web server is strictly Apache2/PHP5. We […]
Dreamhost Hosting Review
Soon after I opened my own Dreamhost account, my company needed an external hosting environment for Joomla instances, and I recommended Dreamhost. I mentioned it supported unlimited domains, MySQL databases, etc., and had a large amount of space/bandwidth for any of our sub-projects within the company. They even have a One-click install for Joomla! It […]