The T-SQL to MySQL procedure converter is of course developed based on what I needed when I made it. I have made it as a window's executable because we run the system on windows (guess that is common with SQL Server installations...). There is no fancy user interface (in fact no user interface at all) because I didn't need it etc.

T-SQL constructs not handled:

• String concatenation: since + is used in T-SQL both for concatenation strings and for addition you need to know the datatype of the arguments to know if it should be converted. The tool does no attempt to do this, even if some cases (text constants, declared variables or parameters) would be quite easy.
• GOTO's and labels: The code I converted contains a lot of GOTO's. A very common construction is: SELECT /UPDATE/DELETE/INSERT
  ....
  SELECT @p_err_num = @@ERROR
  IF (@p_err_num 0) GOTO OnError
  COMMIT TRANSACTION …

Despite Strong Demand, Survey Uncovers Significant Barriers to Adoption of Open Source Databases, Solid (Press Release)

Teradata Delivers Linux for Enterprise-Class Data Warehouses, Teradata (Press Release)

CollabNet Announces Enterprise Commercial Support, Training and Services for Subversion 1.4, CollabNet (Press Release)

Linux lab: GPL clarification needed ASAP, News.com, Stephen Shankland (Article)

…

I’ve bought plane tickets to the upcoming MySQL Camp in November. This is looking like a very fun time, with lots of community members, MySQL employees, and Google developers attending. It’s an “un-conference,” which means there is no set schedule, and it’s up to us to make out of the event whatever we wish it to be. If you’ve been reading my articles or using my tools, is there anything you’d like me to present on?

This key should give you a guide how to best tune you MySQL database systematically... It should also work similar for other RDBMS.

Maybe not breaking news, but I think it’s interesting enough of a point, and I didn’t really find anything about the topic when I googled it. If you do any addition, subtraction, multiplication, or division (and probably a lot more mathematical functions for that matter) and NULL is one of your values, the entire expression will evaluate to NULL.

For example, this statement returns NULL:

select 4 + NULL;

+———-+
| 4 + NULL |
+———-+
| NULL |
+———-+

Normally you wouldn’t do the above in such a simple way, for instance, you might do some addition in a subquery. For example,

select 4 + (select val from table1 WHERE id < 3 LIMIT 1);

+---------------------------------------------------+
| 4 + (select val from table1 WHERE id < 3 LIMIT 1) |
+---------------------------------------------------+
| NULL |
…

Dana Blankenhorn of ZDNet has an interesting interview with Darryl Dewan of VA Software. In the course of the interview, Dana queries Darryl as to whether open source businesses can deliver serious financial heft. The answer?:

Maybe the good old days really are gone for good. But is open source to blame for that? No more, I think, than the end of the gold rush can be blamed on mine automation.

There are still fortunes to be made, Dewan said. Look at the money the founders of MySpace made, or those of YouTube will make, and all the gazillion Google-aires.

"You can create things online and do things online and you don't need to program," Dewan concluded. This is not a bad thing. Unless you want to become a millionaire through programming.

I disagree (with all due respect to Dana, to whom much respect is due). Marten Mickos …

Red Hat this week announced their application stack which includes JBoss, Hibernate and support for MySQL and Postgres open source databases.  Given Red Hat's recent acquisition of JBoss, the announcement was not a surprise, but it's still good to see that they are making progress moving up the stack and providing greater ease-of-use and integration. 

Red Hat remains the number one vendor of Linux and this move shows that Red Hat could be the "market maker" for open source stacks.  They are definitely raising the bar on competitors and that's good news for customers.  Red Hat will now be distributing certified binaries for MySQL as part of this stack and is also providing front line support backed up by our own support organization for complex issues.  Red Hat is offering multiple levels of subscription support for the stack, starting at …

Web applications can easily become very complex. Several hundreds of thousands of lines of code (no HTML templates!) is usual at larger corporate solutions. This also means that your PHP applications follows the standards like object oriented programming, nested classes etc.

When it comes down to detect security vulnerabilities, a lot of tools are available. In a previous post I told you that we developed Chorizo! mainly because we needed a tool that checks for security vulnerabilities (both XSS issues and server side issues) very easily. I think our GUI is very nice :-)

In a previous post I introduced Morcilla to you (see video here and here and …

Today I have some good news to announce! Finally, after quite some struggles and some disappointments because of 'optimistic planning', I can tell you that the first version is working.

It is a testing version which has the following functionality:
- An example sensor publishes random values on the bus;
- A insertion interface reads all sensor data on the bus (it is ready to receive data from multiple sensors) and writes it to the database. It creates tables for every new sensor;
- A selection interface listens to SQL requests and creates data sources which publish data on the bus at a specified interval;
- An example client publishes it's request on the bus and after receiving a data source ID, subscribes to this data source. It will from thereon receive the result periodically.

I will add some logging to the code now so I can extract some meaningful performance information.

…