(Rick Isom) Many corporations have customers spread across the entire country. Analyzing and forecasting large and complex corporate applications containing vast amounts of data present an ongoing challenge for a capacity planning group. For example, analysts of large and complex DB2 applications mu
Other News
Custom SSIS Control Flow Component
(Ray Gorski) This article is targeted towards the developer with experience in web or desk applications and who is beginning to develop custom components. A recent search for a tutorial on creating a custom control for SQLServer 2005 Integration Service (SSIS) revealed a shallow pool of available to
Allocating Small Data Structures
(Jim Mischel) Most .NET programs I’ve worked with don’t have to take into account their memory footprint. As long as the programmer isn’t doing totally crazy things like trying to buffer the results of a huge database query, there is usually plenty of memory on the computer for whatever the .NET pro
MySQL – Testing failing non-transactional statements
(Ronald Bradford) I was asked recently to confirm a consistent state of data in a non-transactional MySQL table after a failing statement updating multiple rows did not complete successfully.
Explore AutoPilot’s Other XPath Evaluation Methods
(Jimmy Zhang) VTD-XML encapsulates all XPath related functions in AutoPilot class. To use those functions, one usually go thru the following steps: –Instantiate an AutoPilot object –Bind the AutoPilot object to a VTDNav object –Select the XPath expression using AutoPilot’s selectXPath(…)
Simplified User Maintenance
(JP Vijaykumar) On a regular basis, I create multiple userids in Oracle databases. Every userid requires the execution of three sql statements: 01 create user … identified by … account unlock password expire; 02 grant create session to …; 03 grant role_name to …;
One more reason to stay current on your DB2 maintenance
(Willie Favero) I have discussed the importance of staying current on DB2 for z/OS maintenance many times on this blog. Staying current helps you avoid potential problems by allowing you to fix that problem before it hurts you. However, do you have any idea how often a PTF slips through that gives y
Optimize disk configuration in SQL Server
(Denny Cherry) One of the easiest ways to improve the lifetime performance of a SQL Server database is proper setup of the physical and logical drives. While it’s an easy technique, proper disk subsystem configuration is often overlooked or handled by a member of the IT staff other than a SQL Server
Debugging Stored Procedures in Visual Studio 2005
(Chris Rock) This article walks through the basics of debugging stored procedures using Visual Studio 2005. It covers breakpoints, watches and stepping through code.
Foreign Keys and their States
(András Belokosztolszki) Foreign keys enforce referential integrity and in this way contribute to the database’s consistency. However, sometimes it is necessary to disable them temporarily. I have seen some confusion as to how one re-enables these disabled constraints in such a way that the database