Free Newsletters:
DatabaseDaily  
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum DBA Videos
internet.com

» Database Journal Home
» DBA Videos
» Database Articles
» Database Tutorials
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap

News Via RSS Feed



follow us on Twitter

Marketplace Partners
Be a Marketplace Partner

internet.commerce
Be a Commerce Partner


















Mariposa Bot Shipped With Vodafone Smartphone

IT Job Market Heating Up: Report

Bing Makes Strides But Momentum Stalls

internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers


Database Journal | DBA Support | SQLCourse | SQLCourse2







JAVA Developer – Trading Industry (NYC)
Next Step Systems
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Featured Database Articles

MS SQL

December 10, 2002

William E. Pearson, III

CPA, CITP, CMA, CIA, MCSE, MCDBA
Microsoft SQL Server MVP

Bill Pearson 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
Part 77: The LEVEL_NUMBER Member Property
Part 76: The LEVEL_UNIQUE_NAME Intrinsic Member Property
Part 75: Intrinsic Member Properties: The HIERARCHY_UNIQUE_NAME Property
Part 74: Intrinsic Member Properties: The DIMENSION_UNIQUE_NAME Property
Part 73: Further Combination of BottomCount() with Other MDX Functions
Part 72: Combine BottomCount() with Other MDX Functions to Add Sophistication
Part 71: Basic Set Functions: The BottomCount() Function, Part I
Part 70: Intrinsic Member Properties: The MEMBER_VALUE Property
Part 69: Intrinsic Member Properties: The MEMBER_UNIQUE_NAME Property
Part 68: Intrinsic Member Properties: The MEMBER_NAME Property
Part 67: Intrinsic Member Properties: The MEMBER_KEY Property
Part 66: Intrinsic Member Properties: The MEMBER_CAPTION Property
Part 65: Set Functions: The StripCalculatedMembers() Function
Part 64: Set Functions: The AddCalculatedMembers() Function
Part 63: MDX Numeric Functions: The Min() Function
Part 62: MDX Numeric Functions: The Max() Function
Part 61: Set Functions: The .AllMembers Function
Part 60: MDX Essentials: Set Functions: The MeasureGroupMeasures() Function
Part 59: String Functions: The .Properties Function, Part II
Part 58: String Functions: The .Properties Function
Part 57: Logical Functions: IsGeneration(): Conditional Logic within Filter Expressions
Part 56: MDX Scripting Statements: Introducing the Simple CASE Statement
Part 55: Logical Functions: IsGeneration(): Conditional Logic within Calculations
Part 54: Logical Functions: IsAncestor(): Conditional Logic within Filter Expressions
Part 53: MDX Clauses and Keywords: Use HAVING to Filter an Axis
Part 52: Logical Functions: IsAncestor(): Conditional Logic within Calculations
Part 51: Logical Functions: IsSibling(): Conditional Logic within Filter Expressions
Part 50: Logical Functions: IsSibling(): Conditional Logic within Calculations
Part 49: MDX Operators: The IsLeaf() Operator: Conditional Logic within Filter Expressions
Part 48: MDX Operators: The IsLeaf() Operator: Conditional Logic within Calculations
Part 47: MDX Numeric Functions: The .Ordinal Function
Part 46: Other MDX Entities: Perspectives
Part 45: MDX Operators: The IS Operator
Part 44: MDX Set Functions: The Distinct() Function
Part 43: MDX Set Functions: The ToggleDrillState() Function
Part 42: Set Functions: The DrillUpLevel() Function
Part 41: Set Functions: The DrillDownLevelTop() and DrillDownLevelBottom() Functions
Part 40: MDX Set Functions: DrillDownLevel()
Part 39: MDX Set Functions: The DRILLUPMEMBER() Function
Part 38: Set Functions: The DRILLDOWNMEMBERTOP() and DRILLDOWNMEMBERBOTTOM() Functions
Part 37: Set Functions: The DRILLDOWNMEMBER() Function
Part 36: Drilling Through with MDX: The DRILLTHROUGH Statement
Part 35: String Functions: The .UniqueName Function
Part 34: String Functions: The .Name Function
Part 33: String / Numeric Functions: The CoalesceEmpty() Function
Part 32: Basic Set Functions: The TopCount() Function, Part II
Part 31: Basic Set Functions: The TopCount() Function, Part I
Part 30: Enhancing CROSSJOIN() with Calculated Members
Part 29: Set and String Functions: The GENERATE() Function
Part 28: The CROSSJOIN() Function: Breaking Bottlenecks
Part 27: String / Numeric Functions: More on the IIF() Function
Part 26: String / Numeric Functions: Introducing the IIF() Function
Part 25: Logical Functions: The IsEmpty() Function
Part 24: Basic Set Functions: The EXTRACT() Function
Part 23: Numeric Functions: Introduction to the AVG() Function
Part 22: Basic Member Functions: The .Item() Function
Part 21: Basic Set Functions: Subset Functions: The Subset() Function
Part 20: Basic Set Functions: Subset Functions: The Tail() Function
Part 19: Basic Set Functions: Subset Functions: The Head() Function
Part 18: Basic Set Functions: The CrossJoin() Function
Part 17: Basic Numeric Functions: The Count() Function
Part 16: Basic Set Functions: The Filter() Function
Part 15: Basic Set Functions: The EXCEPT() Function
Part 14: Basic Set Functions: The Intersect() Function
Part 13: Basic Set Functions: The Union() Function
Part 12: Basic Set Functions: The Order() Function
Part 11: MDX Time Series Functions, Part III: The LastPeriods() and ParallelPeriod() Functions
Part 10: MDX Time Series Functions, Part II: The OpeningPeriod () and ClosingPeriod() Functions
Part 9: MDX Time Series Functions, Part I: PeriodsToDate() and Kindred Functions
Part 8: MDX Member Functions: "Relative" Member Functions
Part 7: MDX Member Functions: The Cousin () Function
Part 6: MDX Member Functions: More "Family" Functions
Part 5: MDX Member Functions: The "Family" Functions
Part 4: MDX Members: Introducing Members and Member
Part 3: MDX Operators: The Basics
Part 2: Structure of the MDX Data Model
Part 1: MDX at First Glance: Introduction to MDX Essentials


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




Tools:
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








Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
Inner and outer select mussab 2 March 10th, 04:16 AM
SQL server 2008 in windows 7 pro problem theresatan 2 March 6th, 08:35 PM
code for re-build index and shrink db or file? mib 7 March 5th, 08:50 AM
sql maintenance plan fails database missing tbrownch 3 February 24th, 08:53 AM









The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers