(Baya Pavliashvili) Data warehousing is not for the faint of heart; it takes much diligence and dedication to learn the various tools of the trade. In this article, Baya Pavliashvili details some features available with Microsoft Analysis Services, whose Analysis Manager allows you to create and
Author: SSWUG Research
Changing the primary key
(Craig Mullins) I have a DB2 database that uses social security number as employee number, and it is the primary key in over 200 tables. I need to change the primary key to another type of employee number. How do I do this? There are over 300 million rows to update accross the tables. This is a payr
MDX Essentials: Basic Set Functions: The EXTRACT() Function
(William Pearson) In this lesson, we will introduce a function that operates upon a specified set, extracting the dimensions of that set as we dictate. As most references point out, by way of explanation, the EXTRACT() function works in a manner that is the opposite of the CROSSJOIN() function (for
Paging Database Results in ASP.NET
(Scott Mitchell) One of the most common tasks developers are faced with when working with data-driven Web sites is the need to page data. Most data is only worthwhile if it can easily be digested by a human, so a data-driven Web site needs to present data in an easy-to-read format. In situations whe
CodeSnip: Access Database Schema with ASP.NET 2.0
(Andrew Mooney) Retrieving Access database schema with ASP.NET 2.0 is actually very simple. First you create an OleDbConnection to a database. Next, you fill a DataTable with schema information using GetSchema method. Finally, you bind the DataTable to a GridView.
Where’s the simplicity in Web services?
(Martin LaMonica) Has Web services, the technology intended to simplify programming, gotten too complex? A debate is raging over whether the number of specifications based on Extensible Markup Language (XML), defining everything from how to add security to where to send data, has mushroomed out
Tipping the Scales Toward Secure Code
(Rebecca Rohan) Everybody can use more secure code—and sometimes the best way to hone your skills is by listening to other programmers. Here are 18 tips offered by your fellow developers.
Architecture (Sample chapter)
(Rick Greenwald, Robert Stackowiak and Donald Bales) If you understand the architecture of Oracle Application Server, you will have an excellent framework for understanding how the product works. Learning how the various components of Oracle Application Server interact can help you avoid many p
A ‘Pivot’ XML-Based Architecture for Multilingual, Multiversion Documents: Parallel Monolingual Documents Aligned Through a Central Correspondence Descriptor and Possible Use of UNL
(Najeh Hajlaoui and Christian Boitet) Due to the Internet, the number of available documents grows dramatically. There is a strategic need for companies to control information written in more than 30 languages (HP, IBM, MS, Caterpillar). This requires the installation of powerful and effective mana
Multiple flaws found in DB2
(Robert Westervelt) A group of 20 holes in IBM’s DB2 could allow attackers to compromise and crash a vulnerable system running versions 7, 8 and 8.1 of the database. IBM released a partial fix for the vulnerabilities. (R)