(Conor O’Mahony) Now that the IBM Information on Demand (IOD) and International DB2 User Group (IDUG) conferences are behind me, I have time to blog about some of the great announcements from those conferences. Probably the announcement that generated the most interest among conferences attendees is
Other News
Quick way to know all computed columns across tables
(Madhivanan) A computed column in SQL Server is an expression which is based on another column in the same table. Consider the following example
Tuning Up ADO.NET Connection Pooling in ASP.NET Applications
(Dmitri Khanine) Opening a database connection is a resource intensive and time consuming operation. Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request.
Deserializing Objects from XML in C#
(Kris Johnson) Here’s another C# code snippet that takes me way too much time to recreate by just reading the documentation.
Solving __OAUX_GENXSD_.TOP.XSD with BPEL
(Edwin Biemond) When you use an external web service in combination with a BPEL service component in an Oracle SOA Suite 11g composite and you follow this great AIA blog about Best Practices for Decoupling Services and Avoiding Invalid Composites at Server Startup then you can get this __OAUX_GENXSD
The DB2Night Show #63: BIG DATA – BIG DEAL!
(Klaas) In episode #63 our special guest Dirk deRoos (IBM’s World-Wide Technical Sales Leader) continued where Dan left off in the previous show. Dirk gives unveils how IBM processes big data, both in rest and in motion. No idea what that means? Watch the show and get educated in BIG Data!
Global transaction ID support for PECL/mysqlnd_ms
(Ulf Wendel) The catchy theme/motto of the PECL/mysqlnd_ms 1.2 release will be Global Transaction ID support. Hidden behind the buzzword are two features.
DataBinding with a ComboBox in FSharp
(Alok Pandey) We create a DataBase for getting records into a ComboBox. Here, in this example, the DataBase name is student_record, table name is student and Columns are Roll_No and Name. I have written code below for creating this database.
Add and Subtract Dates using DATEADD in SQL Server
(Tim Cullen) Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function.
HOWTO: Implement Versioning via Oracle XMLDB
(Marco Gralike) Since a long time, the database has had some versioning capabilities, long before features like “Edition Based Redefinition” in Oracle 11gR2 appeared. This versioning, via XMLDB functionality, is based on its XDB Repository access to the database.