MS SQL
6/30
MSAS Architect Bill Pearson leads the
hands-on creation of an exploded pie chart based upon an Analysis Service data
source. 6/29
This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.
6/23
Join BI Architect Bill Pearson as he leads hands-on practice with the
“Clusters” discretization method in Analysis Services. In this article we
continue to explore attribute discretization, as a part of an extended
examination of the dimensional model lying at the heart of the integrated
Microsoft Business Intelligence solution.
more...
Oracle
7/02
Learn how to use Oracle’s Flashback Version Query to not only see past data at a particular point in time but also to see how it changed over time.
6/25
This article - the third in this ongoing series - demonstrates how to extend an existing Data Guard Broker configuration into an Oracle 10g Enterprise Manager Grid Control environment as well as how to configure the appropriate level of data protection between Oracle 11g primary and standby databases.
6/24
Steve Callan recently attended a three day Performance Optimization for Developers – SQL and PL/SQL
class. This article is a review of the training provided by Hotsos.
more...
MS Access
6/19
Garry Robinson demonstrates how you can get a series of email subject line headers into a database table.
6/01
Sending emails from Access is popular but so is creating appointments, tasks and contacts. The ability to read and process Outlook emails is also very useful, as is the ability to extract names and emails from the user's contact list. That's the topic covered in this and next month's articles.
5/15
Garry Robinson demonstrates an Access 2007 template feature that integrates your database with your Outlook contacts.
more...
DB2
2/10
The first thirteen parts of this series introduced some of the many features available within the IBM Data Studio integrated development environment (IDE) that's available for use with the IBM data servers. This installment explains how to apply Extensible Stylesheet Language Transformations (XSLT) to your Web services.
1/13
Paul Zikopoulos continues his series on DB2 9 and Microsoft Access 2007, explaining in this installment how to build forms that run against DB2 data servers.
12/23
Paul Zikopoulos introduces you to the Data Web Services Test Client that's available in IBM Data Studio Version 1.2 or later
more...
