By Russ Whitney – MDX is powerful, but it can be more complex than SQL. You can make MDX’s complex queries easier to handle if you break them into smaller parts. Here’s a two-part method for making complex MDX manageable.
Author: SSWUG Research
SQL Server 2000 Active Directory Integration
SQL Server 2000 was designed to operate as an integral part of the Windows 2000 domain environment. Unfortunately, the new features that best exemplify this integration are rarely taken advantage of. Marcin Policht presents an overview of these features.
Migrating Access 2000 Databases to SQL Server 2000
As your business grows and demands more high-level performance from your database system, you may have to move from the file-server environment of the Microsoft® Access 2000 Jet engine to the client/server environment of Microsoft SQL Server™ 2000.
Exhausted Tablespace Alert
by Jayant Kulkarni – I have attempted to write a SQL script that takes care of the MAXSIZE feature and avoids generating false-alarms for the “tablespace alert”. Ideally this script can be embedded in a cron’d shell script to email or page the DBA in case a tablespace is going to run out of extents,
Data row structure in MS SQL 6.5
In this article, Alexander Chigrik shows you the data row structure in SQL Server 6.5.
Save Database Trips
by Bill Wagner – Use the System.Data.DataSet class to ease database code creation and deliver more features.
Oracle predicts a much simplified future
by Antony Adshead – The next 10 years in IT will be characterised by simplicity if you believe Ian Smith. Oracle’s senior vice-president and managing director for the UK, Ireland and South Africa thinks there will be fewer suppliers, providing fewer products to IT directors who will manage simple sy
IBM XML Forms Package
The IBM XML Forms Package is a toolkit consisting of software components designed to showcase the possibilities presented by XForms, an emerging W3C standard (W3C Candidate Recommendation). The package consists of two main components: the data model component and the client component.
XML in Enterprise Applications
by Hitesh Seth – To appreciate the value that XML brings to enterprise applications, I spoke with technology executives of leading enterprise application vendors who have started to see the benefits of their investments in technologies such as XML and Web services.
How to Make Your .NET Windows Forms Configuration Files Dynamic
Although Windows Forms configuration files are read-only within the framework, they become dynamic XML databases when you create this AppSettingsManager class.