Category | Databases

How To Set Up A Version Cue Server

How To Set Up A Version Cue Server

Adobe Version Cue is a fantastic tool for managing your images, photos and videos. Here is the complete reference guide on how to configure Version Cue so that you can use it in your production environment. [...]

Apple, Databases, General, Linux, Microsoft, Networking, Security, Servers, Ubuntu, Windows Vista, Windows XP Comments Off

How to Find and Replace Text in MySQL

How to Find and Replace Text in MySQL

A common question I get asked is how to find and replace text in a MySQL database. There is a simple answer to that question and it’s staring you in the face. REPLACE.  Here is how to use it properly. [...]

Databases, General Comments Off

Automatically Check MySQL Health

Automatically Check MySQL Health

MySQL is in my opinion the best Database system out there pound for pound – dollar for dollar.  Oh wait…it’s FREE!  It’s still a fantastic system.  Even though it’s a fantastically robust database server the tables may get fragmented with overhead due to continuous update, or delete and insert operation on data stored in database.  The solution is to check the DB for integrity.  And wouldn’t it be nice if that automagically happened? Here’s how. [...]

Databases, General Comments Off

MySQLTuner

MySQLTuner

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. [...]

Databases, General, Linux, Servers Comments Off

Computing Without The Price – Microsoft Azure vs Amazon EC2

Computing Without The Price – Microsoft Azure vs Amazon EC2

Microsoft recently announced a new operating system for the cloud called Windows Azure. Azure is a services platform that is hosted by Microsoft in Microsoft data centers around the globe and is completely scalable and affordable.  Amazon.com also offers a hosted and scalable solution that they host.  Here is the rundown on how to have reliable services without having to drop a ton of cash for your own servers, data center or infrastructure. [...]

Databases, Disaster Recovery, General, Linux, Microsoft, Networking, Security, Servers, Tech News, Ubuntu, Web 2.0, Windows Vista, Windows XP Comments (1)

Oracle to offer Hardware for their Database Servers

Oracle to offer Hardware for their Database Servers

SAN FRANCISCO (MarketWatch) -- In a move the company is billing as its first foray into the hardware business, Oracle Corp. said Wednesday it will begin selling server computers that come with its database software pre-installed. [...]

Databases, Servers, Tech News Comments Off

How To Create RSS Feeds Easily

How To Create RSS Feeds Easily

Control your RSS destiny with ListGarden.  You might want to provide alternative RSS item descriptions, or to manually select which RSS items to publish. While you can code an RSS feed by hand, you can use a tool like ListGarden and make it a no brainer. It can help you to not only create and manage RSS feeds, but also to do more advanced tasks like publish the feeds on a remote server, back up the feeds, generate an HTML page, and much more. [...]

Databases, General, Google, Linux, Ubuntu Comments Off

Easiest WAMP Install Ever

Easiest WAMP Install Ever

A lot of open source applications out there run on php, apache and mysql.  This in combination gives you a LAMP installation.  There is an unbelievably easy way of setting up a fully functioning, full featured PHP, Apache and MySQL on Windows XP,2K,2K3 complete with PEAR, CURL and SOAP and here are the instructions. [...]

Databases, General, Linux, Microsoft, Servers, Windows Vista, Windows XP Comments Off

TV Listings Simplified

TV Listings Simplified

You have most likely heard of apps such as Maxemum, OnTV and FreeGuide to grab TV listings on UBUNTU.  My question is why bother with the hassle?  Even if it works, what are you really gaining?  If you are using a PVR then use Freevo or MythTv and be happy, to see TV listings, go back to basics. [...]

Databases, General, Linux, Microsoft, Ubuntu, Windows Vista, Windows XP Comments Off

100 MySQL Tips You MUST Know

100 MySQL Tips You MUST Know

Here are 100 Tips, Tricks and Optimizations that you absolutely MUST know and learn if you are going to run MySql. [...]

Databases, Linux, Microsoft, Networking, Servers Comments Off

« Previous Entries

Categories

Archives