Talk about Technologies, Software Architecture and Management

Tip: Get list of columns for the table

When you dealing with dynamic SQL or unknown table structure, SQL meta data could help recover the missing information. There are two main system tables which give you such information: dbo.sysobjects dbo.syscolumns Example below shows how to gather column list for specified table. DECLARE @TABLENAME varchar(256), @COLUMNS varchar(4000) SET @TABLENAME = 'mytable' SET @COLUMNS = '' SELECT @COLUMNS = @COLUMNS + c.name + ', ' FROM syscolumns c INNER JOIN sysobjects o ON o.id = c.id WHERE o.name = @TABLENAME AND o.xtype='U' ORDER BY colid SET @COLUMNS = SUBSTRING(@COLUMNS, 1, Datalength(@COLUMNS) – 2) SELECT @COLUMNS or if you prefer more generic approach DECLARE @TABLENAME varchar(256), @COLUMNS varchar(4000) SET @TABLENAME = 'mytable' SET @COLUMNS = '' SET @COLUMNS = '' SELECT Read more

By Serguei Dosyukov, ago

CodeGear’s revenues in Q1

Borland has published revenues for CodeGear in Q1. As a matter of fact we could compare ALM and CG part.               Three Months Ended      Three Months Ended                 March 31, 2008           March 31, 2007           Enterprise    CodeGear ||  Enterprise   CodeGear           ALM    DPG      IDE  ||  ALM    DPG      IDE   || Licenses 9,415  9,122 |  9,283  || 19,120  8,302 | 9,740 || -5% Service 22,972  4,549 | 2,933  || 24,216  5,290 | 4,298 || -32% Total    32,387 13,671 | 12,216  || 43,336 13,592 | 14,038 || -13%

By Serguei Dosyukov, ago

CodeGear has been sold. Difference from two years ago.

As we all know, CodeGear will have a new home in a few months when merger is completed. Considering the size of two companies, I do see it more as a merger then acquisition at this point. Future movements will define the term better in the sense that if some of the CG gems would be tossed away then it was an acquisition of the desired technologies, otherwise it is a beneficial alliance. Being a Delphi developer for many years, I have my concerns… will see… We are back to square one for the Delphi product future from what we were two years ago. Many remember talks then… The difference from two years ago when spin-off of development division was announced Read more

By Serguei Dosyukov, ago

CodeGear… Going Once, Going Twice,… Sold…

News of the day – CodeGear being finally and quietly sold… to Embarcadero Technologies… At Embarcadero Technologies we know databases, we understand the important role they play in every organization and we love meeting their challenges. It took two+ years for story to end. From original $100M+, it now came to just $23M+$7M(AR). Not to much of the surprise though Revenue for ALM products and services for the first quarter of 2008 was $32.4 million. Deployment (DPG) products and services revenue was $13.7 million and CodeGear (IDE) products and services revenue was $12.2 million. (more) The company says the loss was larger with a $13.3 million impairment charge related to CodeGear, $1.3 million in restructuring expenses and other costs. With Read more

By Serguei Dosyukov, ago

MySQL is ‘not’ an Open Source project

Thank to Andreano Lanusse for posting a link which confirms some of worries about the current state of the MySQL as an Open Source project discussed earlier: Michael Widenius (often called Monty), the main author of the original version of the open-source MySQL database and a founding member of the MySQL AB company, explain in this presentation the future of MySQL and why he believes MySQL is not a  Open Source project, very interesting presentation. There is a catch though. MySQL team wants it to be such. It is just hard in current state and there is a desire to change the product evolution direction to attract a “new blood”, to learn from PostgreSQL business/development model.

By Serguei Dosyukov, ago