Featured Database Articles MS SQL
December 10, 2002William E. Pearson, III
CPA, CITP, CMA, CIA, MCSE, MCDBA
Microsoft SQL Server MVP
Bill has been working with computers since before becoming a "big eight" CPA, after which he carried his growing information systems knowledge into management accounting, internal auditing, and various capacities of controllership. Bill entered the world of databases and financial systems when he became a consultant for CODA-Financials, a U.K. - based software company that hired only CPA's as application consultants to implement and maintain its integrated financial database - one of the most conceptually powerful, even in his current assessment, to have emerged.
At CODA Bill deployed financial databases and business intelligence systems for many global clients. Working with SQL Server, Oracle, Sybase and Informix, and focusing on MSSQL Server, Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base over the years since. Bill's background as a CPA, Internal Auditor and Management Accountant enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Moreover, as a Certified Information Technology Professional (CITP) - a Certified Public Accountant recognized for his or her unique ability to provide business insight by leveraging knowledge of information relationships and supporting technologies - Bill offers his clients the CPA's perspective and ability to understand the complicated business implications and risks associated with technology. From this perspective, he helps them to effectively manage information while ensuring the data's reliability, security, accessibility and relevance.
Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, focusing his practice (since the advent of MSSQL Server 2000) upon the integrated Microsoft business intelligence solution. He leverages his years of experience with other enterprise OLAP and reporting applications (Cognos, Business Objects, Crystal, and others) in regular conversions of these once-dominant applications to the Microsoft BI stack. Bill believes it is easier to teach technical skills to people with non-technical training than vice-versa, and he constantly seeks ways to graft new technology into the Accounting and Finance arenas. Bill was awarded Microsoft SQL Server MVP in 2009.
Hobbies include advanced literature studies and occasional lectures, with recent concentration upon the works of William Faulkner, Henry James, Marcel Proust, James Joyce, Honoré de Balzac, and Charles Dickens. Other long-time interests have included the exploration of generative music sourced from database architecture.
Introduction to MSSQL Server Analysis Services Series
Part 88:
Introduction to Security in Analysis Services
Part 87:
Cube Storage: Planning Partitions from a SQL Server Management Studio Perspective
Part 86:
Cube Storage: Planning Partitions (Business Intelligence Development Studio Perspective)
Part 85:
Cube Storage: Introduction to Partitions
Part 84:
Introduction to Cube Storage
Part 83:
Attribute Discretization: Customize Grouping Names
Part 82:
Attribute Discretization: Using the “Clusters” Method
Part 81:
Attribute Discretization: Using the “Equal Areas” Method
Part 80:
Attribute Discretization: Using the Automatic Method
Part 79:
Introduction to Attribute Discretization
Part 78:
More Exposure to Settings and Properties in Analysis Services Attribute Relationships
Part 77:
Attribute Relationships: Settings and Properties
Part 76:
Introduction to Attribute Relationships in MSSQL Server Analysis Services
Part 75:
Attribute Member Values in Analysis Services
Part 74:
MSSQL Analysis Services - Attribute Member Names
Part 73:
Attribute Member Keys – Pt 2: Composite Keys
Part 72:
Attribute Member Keys – Pt 1: Introduction and Simple Keys
Part 71:
Dimension Attributes: Introduction and Overview, Part V
Part 70:
Dimension Attributes: Introduction and Overview, Part IV
Part 69:
Dimension Attributes: Introduction and Overview, Part III
Part 68:
Dimension Attributes: Introduction and Overview, Part II
Part 67:
Dimension Attributes: Introduction and Overview, Part I
Part 66:
Dimensional Model Components: Dimensions Part II
Part 65:
Dimensional Model Components: Dimensions Part I
Part 64:
Manage Unknown Members in Analysis Services 2005, Part II
Part 63:
Manage Unknown Members in Analysis Services 2005, Part I
Part 62:
Alternatively Sorting Attribute Members in Analysis Services 2005
Part 61:
Introduction to Linked Objects in Analysis Services 2005
Part 60:
Distinct Counts in Analysis Services 2005
Part 59:
Positing the Intelligence: Conditional Formatting in the Analysis Services Layer
Part 58:
Administration and Optimization: SQL Server Profiler for Analysis Services Queries
Part 57:
Mastering Enterprise BI: Time Intelligence Pt. II
Part 56:
Mastering Enterprise BI: Time Intelligence Pt. I
Part 55:
Design and Documentation: Introducing the Visio 2007 PivotDiagram
Part 54:
Actions in Analysis Services 2005: The URL Action
Part 53:
Actions in Analysis Services 2005: The Drillthrough Action
Part 52:
Mastering Enterprise BI: Introducing Actions in Analysis Services 2005
Part 51:
Mastering Enterprise BI: Introduction to Translations
Part 50:
Mastering Enterprise BI: Introduction to Perspectives
Part 49:
Introduction to the Analysis Services 2005 Query Log
Part 48:
Mastering Enterprise BI: Working with Measure Groups
Part 47:
Mastering Enterprise BI: Introduction to Key Performance Indicators
Part 46:
Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. II
Part 45:
Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. I
Part 44:
Process Analysis Services Objects with Integration Services
Part 43:
Usage-Based Optimization in Analysis Services 2005
Part 42:
Named Sets Revisited
Part 41:
Migrating an Analysis Services 2000 Database to Analysis Services 2005
Part 40:
Introducing Data Source Views
Part 39:
Reporting Options for Analysis Services Cubes: MS Excel 2003 and More ...
Part 38:
Mastering Enterprise BI: Create Aging "Buckets" in a Cube
Part 37:
Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube, Part II
Part 36:
Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube
Part 35:
Process Analysis Services Cubes with DTS
Part 34:
Presentation Nuances: CrossTab View - Same Dimension
Part 33:
Point-and-Click Cube Schema Simplification
Part 32:
Manage Distinct Count with a Virtual Cube
Part 31:
Distinct Count Basics: Two Perspectives
Part 30:
Semi-Additive Measures and Periodic Balances
Part 29:
Performing Incremental Cube Updates - An Introduction
Part 28:
Partitioning a Cube in Analysis Services - An Introduction
Part 27:
Basic Storage Design
Part 26:
Derived Measures vs. Calculated Measures
Part 25:
Creating a Dynamic Default Member
Part 24:
Another Approach to Local Cube Design and Creation
Part 23:
Introduction to Local Cubes
Part 22:
Actions in Virtual Cubes
Part 21:
Putting Actions to Work in Regular Cubes
Part 20:
Reporting Options for Analysis Services Cubes: ProClarity Part II
Part 19:
Reporting Options for Analysis Services Cubes: ProClarity Professional, Part I
Part 18:
Using Calculated Cells in Analysis Services , Part II
Part 17:
Using Calculated Cells in Analysis Services, Part I
Part 16:
MSAS Administration and Optimization: Toward More Sophisticated Analysis
Part 15:
MSAS Administration and Optimization: Simple Cube Usage Analysis
Part 14:
Build a Web Site Traffic Analysis Cube: Part II
Part 13:
Build a Web Site Traffic Analysis Cube: Part I
Part 12:
Reporting Options for Analysis Services Cubes: Cognos PowerPlay
Part 11:
Reporting Options for Analysis Services Cubes: MS FrontPage 2002
Part 10:
Reporting Options for Analysis Services Cubes: MS Excel 2002
Part 9:
Drilling Through to Details: From Two Perspectives
Part 8:
Custom Cubes: Financial Reporting - Part II
Part 7:
Custom Cubes: Financial Reporting
Part 6:
Exploring Virtual Cubes
Part 5:
Working with the Cube Editor
Part 4:
Parent-Child Dimensions
Part 3:
Handling Time Dimensions
Part 2:
Working with Dimensions
Part 1:
Creating Our First Cube
MDX Essentials Series
MDX in Analysis Services Series of Tutorials
MS Access for the Business Environment Series of Tutorials
MSSQL Server Reporting Services
Part 71:
Introducing the Tablix Data Region: Basic Grouping Concepts
Part 70:
Introducing the Tablix Data Region in Reporting Services 2008
Part 69:
100% Stacked Column Chart for Analysis Services Data
Part 68:
XY (Scatter) Chart for Analysis Services Data
Part 67:
Simple Doughnut Chart for Analysis Services Data
Part 66:
Exploded Pie Chart for Analysis Services Data
Part 65:
Stacked Bar Chart for Analysis Services Data
Part 64:
Line Chart for Analysis Services Data
Part 63:
Stacked Column Chart for Analysis Services Data
Part 62:
A More Advanced Pie Chart for Analysis Services Data
Part 61:
Simple Pie Chart for Analysis Services Data
Part 60:
Simple Bar Chart for Analysis Services Data
Part 59:
Simple Column Chart for Analysis Services Data
Part 58:
Introducing Reporting Services Charts for Analysis Services
Part 57:
Mastering OLAP Reports: Parameterized Grouping
Part 56:
Mastering OLAP Reports: Parameterizing Number of “Top” Items with the MDX TopCount() Function, Part II
Part 55:
Mastering OLAP Reports: Parameterizing Number of “Top” Items with the MDX TopCount() Function, Part I
Part 54:
Mastering OLAP Reports: Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part II
Part 53:
Mastering OLAP Reports: Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part I
Part 52:
Support Parameterization from Analysis Services – Parameter Defaults
Part 51:
Parameterization from Analysis Services – Cascading Picklists
Part 50:
Support Parameterization from Analysis Services
Part 49:
Parameter Support Objects, Pt II: Support OLAP Parameter Defaults with Datasets
Part 48:
Reporting Services: Customize Automatically Created Parameter Support Objects
Part 47:
Snapshot Reports II: SQL Server Management Studio Perspective
Part 46:
Snapshot Reports I: Report Manager Perspective
Part 45:
Report Execution Caching II: Report Manager Perspective
Part 44:
Black Belt Administration: Report Execution Caching I: SQL Server Management Studio Perspective
Part 43:
Black Belt Administration: Caching Options: Report Session Caching
Part 42:
Black Belt Administration: Reporting Services Configuration Manager
Part 41:
Intelligent Layering: Leverage Conditional Formatting Logic from Analysis Services
Part 40:
Black Belt Administration: Performance Dashboard for Microsoft SQL Server, Part II
Part 39:
Black Belt Administration: Performance Dashboard for Microsoft SQL Server, Part I
Part 38:
Mastering OLAP Reports: Extend Reporting Services with Custom Code
Part 37:
Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. II
Part 36:
Black Belt Components: Support Simple Navigation with a Document Map
Part 35:
Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. I
Part 34:
Black Belt Components: Interactive Sorts within a Matrix Data Region
Part 33:
BlackBelt Authoring: Conditional Drillthrough to Multiple Reports
Part 32:
Mastering OLAP Reporting: Prototype KPIs in Reporting Services
Part 31:
BlackBelt Administration: Linked Reports in SQL Server Management Studio
Part 30:
BlackBelt Administration: Linked Reports in Report Manager
Part 29:
Mastering OLAP Reporting: Reporting with Analysis Services KPIs
Part 28:
Report Builder: Creating a Report Model
Part 27:
Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part II
Part 26:
Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part 1
Part 25:
Mastering OLAP Reporting: Display a Dataset Field in a Report Page Header
Part 24:
Interactive Sorting Within Reporting Services
Part 23:
Mastering OLAP Reporting: Multiple Value Selection in a Parameter Picklist
Part 22:
Mastering OLAP Reporting: Drilling Through Using MDX
Part 21:
Mastering OLAP Reporting: Relationally-Based Picklists for OLAP Reporting
Part 20:
Mastering OLAP Reporting: Extending Conditional Formatting: SWITCH and Drilldown Defaults
Part 19:
Mastering OLAP Reporting: Percent of Total - Chart Presentation Nuances
Part 18:
Mastering OLAP Reporting: Percent of Total - Two Perspectives
Part 17:
Mastering OLAP Reporting: Ad Hoc TopCount and BottomCount Parameters
Part 16:
Black Belt Components: Ad Hoc Sorting with Parameters
Part 15:
Black Belt Administration: "Governor" Capabilities: Report Execution Timeout
Part 14:
Black Belt Administration: Execution Log Performance and Audit Reports
Part 13:
Black Belt Administration: Prepare the Execution Log for Reporting
Part 12:
Black Belt Components: Ad Hoc Conditional Formatting for OLAP Reports
Part 11:
Black Belt Components: Manage Nulls in OLAP Reports
Part 10:
Reporting Services Basics: Create a Reusable Template Report
Part 9:
Master Chart Reports: Track Exchange Rates in a Line Chart
Part 8:
Master Chart Reports: Pie Charts in Reporting Services
Part 7:
Mastering OLAP Reporting: Cascading Prompts
Part 6:
Managing Reporting Services: Data-driven Subscriptions, and External Data Sources for Subscriber Data
Part 5:
Managing Reporting Services: Report Execution and Standard Subscriptions
Part 4:
Managing Reporting Services: Data Connections and Uploads
Part 3:
The Authoring Phase: Overview Part II
Part 2:
The Authoring Phase: Overview Part I
Part 1:
A New Paradigm for Enterprise Reporting
Add databasejournal.com to your favorites
Add databasejournal.com to your browser search box
IE 7 |
Firefox 2.0 |
Firefox 1.5.x
Receive news via our XML/RSS
feed
MS SQL Archives