Most common database used with Rails is mySQL but if you ever need to use SQL Server, here is a quick how to.

I am using  Windows Vista, SQL Server 2008, Rails 2.2.

1)  Install  activerecord-sqlserver-adapter gem

 > gem install activerecord-sqlserver-adapter

2) Create a new Login for this new database (say testuser) using SQL Server Management Studio

3) Create a new database in SQL Server 2008 for your project (say testproject) and choose testuser as Owner

4) Create a …

So you have an old Quasar Microwave from the 80’s or 90’s and it’s time to set back/forward the clocks.

I find myself checking online for instructions every six months and finally tinkering to get the clock changed, so for the records this is how you change the clock on a Quasar Microwave.

To set the time on a Quasar Microwave.

1. Press Hold/Clear.
2. Press the Clock button twice.
3. Press the10 Min and 1 Min buttons until the proper hour is displayed (press 10 min once for 10-12, then 1 min once for 11, twice for 12, etc).
4. Press the 10 Sec and 1 Sec buttons until the proper minute is displayed (i.e. press 10 Sec four times and 1 Sec six times for 46).
5. Press Clock to finish setting the time.

Now to either replace this ancient microwave or contact my local representative to have daylight savings time repealed.

MariaDB 5.1 beta is almost out, so it’s time to cover some of its features. The biggest optimizer feature is MWL#17 Table Elimination.

The basic idea behind table elimination is that sometimes it is possible to resolve the query without even accessing some of the tables that the query refers to. One can invent many kinds of such cases, but in Table Elimination we targeted only a certain class of SQL constructs that one ends up writing when they are querying highly-normalized data.

The sample queries were drawn from “Anchor Modeling”, a database modeling technique which takes normalization to the extreme. The slides at anchor modeling website have an in-depth …

MySQL Proxy is a really neat tool. I remember a few years back when I first saw Jan talking about it. Back in those days it was significantly different than it is now, but the concept remains the same: direct your database traffic through a man-in-the-middle. Chris Calender’s post on capturing erroneous queries with MySQL Proxy shows one use for Proxy. But wait. MySQL Proxy is just inspecting the MySQL protocol.

Ohloh is a fun site. It automatically collects statistics and show some useful analytics about your subversion projects. They picked up Kontrollbase when they ran an automated scan against the Google Code website and I saw it using Google Alerts with the ‘kontrollbase’ keyword alert. Check out the page they have for Kontrollbase and give [...]

Dave Stokes posted earlier that the official list of MySQL Certified will be going away. There has been a MySQL Certified Professionals LinkedIn group for almost 2 years now. It's community managed by myself and Dave, and is open to all MySQL Certified DBAs & Developers, as well as recruiters & hiring managers.

-- Mark
mark@thetajoin.com
http://www.thetajoin.com - The Drupal Hosting & Performance CompanyMySQL DBA & Programming Blog by Mark Schoonover

Dave Stokes posted earlier that the official list of MySQL Certified will be going away. There has been a MySQL Certified Professionals LinkedIn group for almost 2 years now. It's community managed by myself and Dave, and is open to all MySQL Certified DBAs & Developers, as well as recruiters & hiring managers.

-- Mark
mark@thetajoin.com
http://www.thetajoin.com - The Drupal Hosting & Performance CompanyMySQL DBA & Programming Blog by Mark Schoonover

Drizzle is one of the really great pieces of technology to emerge from the MySQL diaspora--a lightweight, scalable, and pluggable database for web applications. I am therefore delighted that Marcus Erikkson has published a patch to Tungsten that allows replication from MySQL to Drizzle. He's also working on implementing Drizzle-to-Drizzle support, which will be very exciting.

Marcus has submitted the patch to us and I have reviewed the code. It's quite supportable, so I plan to integrate it as soon as we are done with our next Tungsten release, which will post around 5 November. You will be able to build and run it using our new …

It's been almost two months since I have posted anything on the Scale-Out Blog, as our entire team has been heads-down working on Tungsten. We now have a number of accomplishments that are worth writing articles about. Item one on that list is community builds for Tungsten clusters.

Tungsten community builds offer a bone-simple process to check out and build Tungsten clustering software. The result is a fully integrated package that includes replication, management, monitoring, and SQL routing. The community builds work for MySQL 5.0 and 5.1 and also allow you to set up basic replication from MySQL to Oracle.

Community builds do not include much logic for autonomic management, including automated failover and sophisticated rules that keep databases up and running rain or shine. Those and other features like floating IP address support are part of the …

Gartner has released a few days ago the Top 10 Strategic Technologies for 2010 list. Here you can see the wordle cloud:




While I don't want to spend time talking about  the usual suspects (Cloud, Green, Mobile and Virtualization) I wish to share my thoughts on two topics: Advanced Analytics and Reshaping the Data Center.

Advanced Analytics  
I'm not surprised that a branch of Business Intelligence is still in the list after years of top priority amongst CIOs. Business Intelligence is one of the fields that I love and it's promise is to transform in gold everything it touches, like …