(Chris Gruber) The news of the yearly subscription opens new business models for DB2. DB2 Express-C is a free database without any limits in database size. I could go on and on about how many free database offerings limit your deployments, but I won’t.
Other News
Query XML data from a table with XML data type
(Muthusamy Anantha Kumar) The objective of this article is to guide Microsoft SQL Server Database Administrators on how to: –Create XML Schema –Create a table with XML data type –Import XML file to the table with XML data type –Query the XML file –Query the XML file and produce resu
High Availability: Meeting the Global Challenge
(Michael Di Stefano) Distributed computing environments are being deployed in topology and scale never before seen. As implementations multiply, this revolutionary era in computing brings with it a number of unique challenges and possibilities, such as high availability. As global firms strive to ma
Multitable insert
(MD) Multitable insert is a feature I’ve read about many times, but I’ve never taken the time to read up on it or play with the way this SQL statement works. I figure making a post about it will give me the reason I need to learn more about it.
Choosing between CLR and T-SQL stored procedures: a simple benchmark
(Greg Larsen) In my previous article (Building my First SQL Server 2005 CLR) I wrote about my experiences coding and implementing my first SQL Server 2005 CLR procedure. The idea was to: –Provide a “learn through my pain” tutorial for people considering adoption of CLR functionality –Demonstr
Recovering MEMORY tables during slave start up
(Il Corra) Using MEMORY tables in MySQL is very useful; they are stored in memory and they are usually not so big in order to avoid a huge utilization of RAM. They are very fast.
BPEL fault handling in WebSphere Integration Developer and WebSphere Process Server
(Vikram Desai and Tom McManus) This article takes an in-depth look at fault handling within a business process, to provide a clearer understanding of business process faults and their handling. We explain how a fault is classified, when it can occur (from business related to system failure), and wha
IBM and Oracle Trade Barbs over Databases
Officials at IBM are throwing verbal haymakers at Oracle as Big Blue touts its successes in the database market.
Terrific Transformations
(Rod Stephens) If you read my DevX article “Beautify Your UIs with Perfect Pen and Brush Control,” then you know all about how to draw lines that are thick or thin; dashed, striped, or solid; beveled, mitered, or rounded; and that have standard or customized end caps. You also know how to fill areas
Returning a week number for any given date and starting fiscal month
(Paul Alcon) Sql Server comes with a host of built in functions such as ISNULL, CONVERT and CAST. Now if that wasn’t enough rope to hang ourselves with, as of Sql Server 2000 we gained the ability to create our own user defined functions. In this article I will be looking at the three main date func