Rows and Columns

I would like to invite everyone to be involved in the beta testing of our
brand new graphical monitoring tool. The SQL Anywhere Monitor is a
browser-based administration tool that provides you with information about
the health and availability of SQL Anywhere databases and MobiLink servers.
The SQL Anywhere Monitor collects metrics and performance data from
databases and MobiLink servers […]

[Read more →]

I’ve been playing with SQL Anywhere’s support for web services. What is particularly cool is that you can call out to (or consume) a web service right from the database server using a stored procedure. Since I have been playing with blogs, and setting up rss, I wondered if I could consume RSS […]

[Read more →]

Well, I am in the middle of updating the blog to use the “Bad Behaviour” plugin to see if I can cut down on the amount of spam comments I am getting.
Fortunately the work I did to get the blog running on SQL Anywhere in a generic way allowed me to get this plugin up […]

[Read more →]

In my previous article, I explained how I downloaded an XML dump of the wikipedia articles and built a SQL Anywhere database with the data.
In order to test version 11, I created a full text index on the title and article data and populated the index:

CREATE TEXT INDEX "wikidex" ON "DBA"."wikipedia"
( […]

[Read more →]

At the end of my last post regarding blog creation, I had gotten to the point of creating the Wordpress blog based on SQL Anywhere. Unfortunately, the admin. console didn’t work and I couldn’t post or view my new blog.
The problem was the MySQL-specific syntax used in the Wordpress code. Fortunately, SQL Anywhere […]

[Read more →]

I was surfing the internet and found that you can download a dump of the wikipedia article data from Wikimedia
I was learning about the XML capabilities of SQL Anywhere, so I decided to download the XML dump of the article data and load it into a database. From there I could use the database […]

[Read more →]

In the previous article, I talked about the software packages I chose for building the blog. In this article, I am going to detail the setup and development of the SQL Anywhere backed Wordpress 2.3.3 blog that you are reading.
Once I had the basic software components installed (Windows Server 2003, Apache 2, PhP 5, […]

[Read more →]

As mentioned in an earlier post I am planning a series of posts on how I built the blog server.  In my first post, I gave an overview of the process. In this post I will provide further detail on the criteria I used and the components of software that I actually chose to […]

[Read more →]

This will be the first of a few blog entries discussing how I set up the iaBlog server using SQL Anywhere and Wordpress running on Apache.
When we (the SQL Anywhere team) first decided we would like to blog, I set up an internal server from scratch with a test blog for our team so we […]

[Read more →]