(Willie Favero) DB2 10 has a new system parameter on the DSN6SYSP macro: DEL_CFSTRUCTS_ON_RESTART.
Other News
SkySQL Builds MySQL Reference Architecture
(Sean Michael Kerner) Deploying a MySQL database today to meet modern infrastructure demands isn’t as easy as it used to be.
Tune your Informix database for top performance, Part 1: Tuning the data model and the application
Author Jack Parker analyzes the “Fastest DBA benchmark” to explain some basic principles of how to tune your IBM Informix database application to get the best possible performance. In Part 1 of the series, he examines how the data model and the application, together with ensuring that you have updat
How to use an outerjoin to synchronise data
(Erwin Vrielink) There is often a need to synchronize data from a query. For example reading external data and update the tables. Sometimes it can be achieved by a single merge statement, but this is not always possible. Mind, for example, the need to update more than one table, or updating the data
Managing IBM DB2 10 for z/OS Using the IBM DB2 Administration Tool for z/OS Version 10
(Paolo Bruni, Tom Crocker, Elaine Morelli, Richard Schaufuss and Jane Yang) Today’s business environment has increased in the complexity and rate of change that a database administrator must control. The ability to respond quickly to a changing environment is constantly challenged by the explosion o
Exporting Visual Studio 2010 Pinned DataTips
In an earlier article I described how you can pin DataTips to your source code in Visual Studio 2010, allowing you to monitor multiple variable values concurrently within the code whilst debugging without hovering the mouse over the variable name.
SQL Server Service Broker Poison Message Handling
(Arshad Ali) Have you ever figured out why your Service Broker queue gets disabled automatically? What causes your Service Broker queue to get disabled in the first place? What is a poison message with respect to Service Broker? Is there anything new in SQL Server 2008 R2 for managing poison message
Do You Write SOLID Code – Day 5
Do You Write SOLID Code – Day 5 We have been discussing the different components of the SOLID acronym from Robert Martin, defining five basic principles of object oriented programming. As stated previously, these principles apply to any object oriented language, and even to some that are hybrid or non-object oriented languages. The five principles of SOLID are: • Single […]
Do You Write SOLID Code – Day 4
DBTechCon – Spring 2011 DBTechCon was a blazing success last week. Feedback on the sessions was awesome. Thousands of people worldwide attended the more than 70 seasons on diverse topics. If you missed this Virtual Conference, you can register to view the sessions On Demand, or receive them on DVD. Click here to go find out more. SOLID Code – […]
Obtaining Identity Column Values in SQL Server
(Gregory A. Larsen) In my last article I discussed identity columns. In that article I discussed one programming issue associated with explicitly setting an identity column while inserting data into a table. In this article I will be expanding the programming discussion to explore other programming