(Michael L. Gonzales) For years, organizations have invested in data warehouse and business intelligence (BI) environments in search of actionable insight — the promise of any BI system. But for many, this promise remains an illusion. That’s because BI, in and of itself, is never enough.
Author: SSWUG Research
Handle errors in the data tier with SQL Server
(Tony Patton) Developers work hard to graciously handle exceptions so users don’t have to worry about the arcane system error messages. For this reason, exception handling is a standard part of every .NET application. The try/catch block allows you to catch exceptions and control application executi
Use cube partitions to improve Analysis Services performance
(Baya Pavliashvili) Microsoft Analysis Services (MSAS) is a great tool for enabling business stakeholders to analyze data from various perspectives — and its growing popularity can be primarily attributed to its exceptional performance. (R)
Data Replication Using Oracle Downstream Capture
(Vincent Chan) The ever increasing demand of sharing, consolidating and synchronizing critical enterprise data and the ability to provide secondary access to updated information without compromising production system performance require a technology like Oracle Streams.
Unit Testing using Visual Studio 2005
(Satheesh Kumar) Visual Studio Team System (VSTS) comes with many tools integrated in it for the developers & testers and also for architects and managers. The unit testing tool that comes with Visual Studio 2005 enables the developers to generate the test classes and methods. Team Test does not pro
Working with the MySQL Access Privilege System
(Paul Dubois) MySQL has an advanced but non-standard security/privilege system. This section describes how it works.
pureXML in DB2 9: Which way to query your XML data?
(Matthias Nicola and Fatma Ozcan) The pure XML support in DB2 offers efficient and versatile capabilities for managing your XML data. DB2 stores and processes XML in its inherent hierarchical format, avoiding the performance and flexibility limitations that occur when XML is stored as text in CLOBs
A Primer On .Net Caching: The Cache API
(George P. Alexander Jr.) We had a look at the “what” and “why” of caching along with an introductory write-up on .Net Caching the last time. We closed that article with a look at Output Caching provided by ASP.Net 1.1.
Getting Acquainted with the Microsoft Expression Family
(Marius Bancila) In a previous article, I introduced you to Windows Presentation Foundation (formerly code-named ‘Avalon’), XAML (the new language for designing user interfaces and the link between designers and developers) and ‘Cider’ (the graphic designer for the next version of Visual Studio, cod
XSL Transformations in .NET 2.0
(Thiru Thangarathinam) One of the main benefits of XML is that it separates data from its presentation. Without further elaboration, this claim seems ordinary. However, if you combine XML data with an XSL Transformations (XSLT) style sheet, you will then have a powerful way to dynamically transform