(Matthias Nicola) DB2 9 introduces pureXML support, which means that XML data is stored and queried in its inherent hierarchical format. To query XML data, DB2 offers two languages, SQL/XML and XQuery. Additionally, DB2 9 has sophisticated XML indexing capabilities and support for XML Schema validat
Author: SSWUG Research
Automatic SQL Server Backup Utility using Sqlserver Agent
(Joshy George) This article will show you how to create a automatic backup in Sql server 2000.
Video: SQL Server Reporting Services 2005 Tutorial
(Steven Smith) This 10 minute video provides a simple step by step tutorial of creating a report using SQL Server Reporting Services 2005. (R, video)
Viewing and Interpreting Showplan XML
(Gargi Sur) As mentioned in our previous blog posting, the Showplan XML feature in SQL Server produces query plan output in XML format. To generate the Showplan output, the query processor compiles the query, but does not execute it. The XML output can be generated in two ways: 1. Using T-SQL SET
Learn Data Warehouse: Defining Goals
(Lewis Cunningham) The first step in any data warehouse project (really any project) is to define your goals. If you don’t know what you want, how will you know if you get it?
Generating Outputs from MySQL with Static Members and Methods in PHP 5
(Alejandro Gervasio) Trying to expand beyond the boundaries of your existing background by learning how to code and use static methods and properties inside your PHP 5 classes? Then look no further. Welcome to the last part of the series “Using static members and methods in PHP 5.” Made up of two in
Identify Tables That Need Space
(Diwaker Johar) This tip lets you identify tables that need more than a specified amount of space. This example uses a size of 1GB.
zIIPing Along
(Willie Favero) ZIIPing and zAAPing away. While that’s a cute opening for this article, it introduces a serious topic. IBM has shown a solid commitment to lowering the cost of running your business on System z. Your potential to increase your processing capacity without increasing your software co
Oracle 10g: A Simple Security Approach – Part 1
(JP Vijaykumar) A detailed discussion on the setup and administration of database access and security is beyond the scope of this document.
Developing Flex 2 Applications with ColdFusion and XML Without Needing FDS or Mystic
(Faisal Abid) Flex is one of the greatest technologies around. Combine it with ColdFusion and it just gets better. Adobe has made it possible to use Flex 2 efficiently with ColdFusion and easily get data across the server to a Flex front-end.