(Dwaine Snow) While databases are becoming more and more self-aware and self-healing, they still require some monitoring to keep them running as efficiently as possible. Just like your car, a database requires some checks to keep it running optimally. This document is broken down into tasks or check
Author: SSWUG Research
SQL & XQuery tutorial for IBM DB2, Part 1: Introduction to Aroma and SQL
(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial introduces readers to the Aroma database to apply Structured Query Language (SQL) and XML Query (XQuery) knowledge to solve typical business questions. Also included are detailed instructions for installing DB2 and the Aroma database. This
Setting Up Transactional Replication with SQL Server 2005
(Baya Pavliashvili) Replication is an advanced feature of Microsoft SQL Server, allowing you to move data and schema changes from one database server to another. In this article, I’ll show you how to set up transactional replication in a simple environment using SQL Server 2005. Subsequent articles
Excel Export Component Using XSL
(Patrick.Alex) I have created an Excel Export component using XSL and XML which can produce very well formatted Excel files. This doesn’t require any Excel library to create Excel files without Charts and macros, but If you want charts or macros in the Excel then you have to have the Excel installed
Benefit from SQL Server 2005’s new schema convention
(Arthur Fuller) One of the coolest features of SQL Server 2005 is the new naming convention, which adds the notion of schema to object names. A fully qualified object name in SQL Server 2005 now includes four parts delimited with dots, like this: [[[server.] [database].] [schema].] database-objec
Dynamic SVG features for browsers
(Uche Ogbuji) Learn how to use dynamic features of Scalable Vector Graphics (SVG) to provide useful and attractive effects in your Web applications. SVG 1.1, an XML language for describing two-dimensional vector graphics, provides a practical and flexible graphics format in XML. Many SVG features pr
DB2 Data Compression Part III: The conclusion…
(Willie Favero) On July 17, I posted a blog entry titled “The incredible shrinking data: DB2’s Compression – Part I” and on Aug 5 I posted “DB2 Data Compression Part II: The saga continues…”. As promised, here is the final chapter.
The Back Side of Exceptions
(Sergei Kitaev) Error handling is a general topic. This article is concerned with the strategy based on exceptions (which are a universal mechanism for raising and reporting an error) in relation to .NET. Here, you will learn about two problems of exception handling (that are not covered enough in e
Assuring Quality Business Processes through Service-Oriented Architecture Testing
(Robert Carmichael) The alignment of business and IT is not just a new management philosophy but a necessary collaboration as business processes are increasingly enabled by systems and user interactions with those systems. To achieve a service-oriented architecture (SOA) environment, the technology
Application Domains in .NET
(Joydip Kanjilal) An Application Domain is a light-weight process. It is a logical and physical unit of isolation built around every .NET application by the Common Language Runtime (CLR) and contains its own set of code, data and configuration settings. Multiple application domains can exist simul