Managing DB2 for z/OS databases becomes more challenging each year. The complexity and volume of data continue to explode exponentially, as applications stretch the limits to provide instantly accessible information. Data warehouses handle multiple terabytes of data. Web-enabling legacy databases h
Other News
Column qualification best practice
(Laurent Schneider) Lazyness at the development can have dramatic costs in production and maintenance. I want to summarize why and where you should always qualify your columns.
Sending binary data from Oracle Application Server to WCF through MTOM: Part II
(John Charles Olamendy) The first to do is to launch Oracle JDeveloper IDE, create a new Empty project from File| New on the main menu and name it MTOM_Server. Then go to the Applications Navigator windows, right-click on the project MTOM_Server and select the New option from the context menu. In th
Tip: How to use Atom’s slug header when you publish content
(Nicholas Chase) One advantage of the Atom Publishing Protocol is the ability to not only retrieve information, but also to add or edit information. In this tip, learn to use Atom’s Slug header to influence the final URL for this information. This tip uses the Blogapps server, which supports draft 1
How Automated Updates Provided by MySQL Enterprise Can Save You Time
(Rob Young) Having spent the first 15 years of my IT career in applications development and database administration I can say with utmost confidence that I invested much more time debugging problems and responding to issues than I ever did building new applications. While the teams I worked with imp
Setting of Optimizer_Index_Cost_Adj parameter! Is it required?
(Vivek Sharma) What is optimizer_index_cost _adj and why do you need to set this parameter ?
SQL Server Management Objects
(John Papa) Not only must database developers query and manipulate data, but they must also perform administrative tasks on a regular basis. SQL Server™ Management Objects (SMO) offer developers a robust toolset for operations such as backing up and restoring databases, and issuing Data Definition L
Piecemeal restore with SQL Server 2005
(Baya Pavliashvili) With each release of the software Microsoft has made great strides in improving their primary database platform. SQL Server 2005 is a true enterprise class database platform capable of supporting scalability and availability needs of the largest and most complex databases. Not th
DB2 and Ruby on Rails, Part 2: DB2 and pureXML with Ruby on Rails
(John Chun, Christine Law, Salvador Ledezma and Alex Pitigoi) XML is one of the most common data interchange formats on the Web today. DB2 support for pureXML, combined with the parsing and generating XML APIs (REXML) available to Ruby on Rails, provides a powerful combination for Web application de
XQuery, the Server Language
(Kurt Cagle) Over the years, I’ve had the chance to program in a lot of different server-side scripting languages–C, Perl, ASP, JSP, PHP, ASP.NET, Python, Ruby, among others. It seems every few years that we programmers decide that we’re bored with the current language and would like to try somethi