(Ashish Singhal) In this article we will see how to fetch data from a database in XML format.
Author: SSWUG Research
DB2 for z/OS and DB2 Tools: A Common ‘Cents’ Solution to Reduce Cost and Complexity
Today’s global economy drives high demands for IT. You’re expected to manage new and growing workloads while maintaining operational costs—and without sacrificing service levels to users. What’s required is an efficient and flexible database server to manage multiple complex workloads, including OLT
DataStage tip: What do you mean I need to optimise small jobs?
(Vincent McBurney) There is a lot of focus on the performance improvement techniques for large jobs, but one of the important tips is how making smaller jobs faster can make larger jobs faster.
Restore basics: How to restore SQL Server using Enterprise Manager
(Greg Robidoux) You probably already have a process in place to back up SQL Server databases on some set schedule, but what do you do when you need to recover a database? (R)
SQL Injection Attacks by Example
(Stephen J. Friedl) A customer asked that we check out his intranet site, which was used by the company’s employees and customers. This was part of a larger security review, and though we’d not actually used SQL injection to penetrate a network before, we were pretty familiar with the general concep
On XMLish Things: Oxygen
(Kurt Cagle) There are times lately where I feel like I’ve strayed far from my original mandate of focusing on XML and it associated technologies. I’ve wrapped up the SVG chapter for the Firefox book, am beginning to dig in-depth into the realm of extensions before heading back into the deeper realm
SQL Server 2005 Application Performance Management
Want to optimize your applications that run on SQL Server? Then take advantage of Symantec’s offer for free SQL Server 2005 Application Performance Management whitepapers in eBook format, and get an in-depth education. (R)
Upgrade Oracle 9i RAC to Oracle 10g RAC
(Vincent Chan) This article provides the procedures for converting Oracle 9i (9.2.0.4) RAC to Oracle 10g (10.2.0.1) RAC on Red Hat Enterprise Linux 3 (RHEL3).
Implementing Row- and Cell-Level Security in Classified Databases Using SQL Server 2005
(Art Rask, Don Rubin, and Bill Neumann) This paper describes how SQL Server 2005 can be used to support row- and cell-level security (RLS/CLS). The examples provided in this white paper show how RLS and CLS can be used to meet classified database security requirements.
DataTable offers .NET developers a resource-friendly option
(Tony Patton) Most .NET developers are familiar with the often overused DataSet objects. The DataTable object receives much less attention, which is unfortunate since DataTable objects provide plenty of features that are more appropriate in many development scenarios—especially when performance is a