(Darren Fuller) In part 3 Darren Fuller listed the requirements to implement an automated approach to database change management and highlighted some of the benefits. In this fourth and final article in the series, he continues the list of benefits that can be realised by adopting an automated meth
Other News
arcplan dynaSight Expands Connectivity to IBM DB2 Cube Views
arcplan, a leading provider of business intelligence (BI) software, announced the immediate availability of its IBM DB2 Cube Views connector for its flagship dynaSight product. Support for DB2 Cube Views enables arcplan customers and partners to leverage IBM’s latest generation of enhanced OLAP capa
Monitoring the Managed Meta Data Environment
Your enterprise is only as good as the meta data that supports it. Join David Marco, founder and president of EWSolutions for an informative and eye-opening session on the Managed Meta Data Environment (MME). A MME is vital for any organization looking to manage the complexity of their IT environm
The Oracle 10g Scheduler, Part 3: Advanced Features
(Jim Czuprynski) Oracle 10g’s new DBMS_SCHEDULER package offers significant advanced features over its predecessor, DBMS_JOB, that any reasonably skilled Oracle DBA can use to insure that sufficient resources will always be available for processing complex business requirements. This article – the f
‘sysperfinfo’ in SQL Server
(Muthusamy Anantha Kumar) The system table, ‘sysperfinfo,’ is the representation of the internal performance counters of SQL Server. This article demonstrates how to retrieve and store information from ‘sysperfinfo’ to a CSV file, so that it can be analyzed.
Hands-on: Understanding the importance of SQL Server Database Log
(Palak Patel) This document outlines steps to create a test database, create a sample table and populate the sample table with actual data, taking full and transaction log backups of the test database, simulate a crash and then recover the database. In the process, it helps to understand SQL Server
Learning ASP.NET for the ASP developer – Part 2
(Nihal J. Mehta) This week, in Part 2 of our tutorial, we will continue our investigation of ASP.NET from a classic ASP developer’s perspective. In Part 1, we showed how ASP.NET allows us to cleanly separate presentation markup from server side script code. Today, we will delve deeper and demons
HOWTO: Use an XML DataSource with the Office Chart Component
This article illustrates how you can bind the Office Chart component to an ActiveX Data Objects (ADO) recordset that is persisted in Extensible Markup Language (XML).
Grouping related data from selected columns into a single column
Use the Pivot data transformer to group related data from selected columns in the source table, which are called pivot columns, into a single column, called a pivot group column, in the target table. You can create more than one pivot group column. Before you begin this task, a source table must
Beyond the DataGrid: An Architectural View of the Data Source Model in ASP.NET 1.x and 2.0
(Dino Esposito) Most developers learnt it in the field already, found their own countermeasures, and live happy today. Other developers just wait for Microsoft to fix it in the next version of ASP.NET and perhaps live restless and uneasy today. What am I talking about? The leading topic of this