SQLServerCentral - Guest Columnist: Frank A. Banin

MDX Guide for SQL Folks: Part III - Advanced Analysis

Learn everything about MDX drawing only on your T-SQL knowledge in this series. Frank Banin continues talking about Calculated Members, Named Sets, and more in part III. Read more...

By Frank A. Banin 2013/02/14 | Source: SQLServerCentral.com | Category: mdx

Rating:

|

Discuss |

Briefcase | 4,503 reads

MDX Guide for SQL Folks: Part II - Hierarchies and Functions

Learn everything about MDX by drawing only on your SQL knowledge. Read more...

By Frank A. Banin 2012/12/18 | Source: SQLServerCentral.com | Category: mdx

Rating:

|

Discuss |

Briefcase | 6,137 reads

MDX Guide for SQL Folks: Part I - Navigating The Cube

Learn all you need to know about MDX, by drawing only on your current SQL knowledge. Read more...

By Frank A. Banin 2012/11/01 | Source: SQLServerCentral.com | Category: mdx

Rating:

|

Discuss |

Briefcase | 11,630 reads

ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup. Read more...

By Frank A. Banin 2012/06/19 | Source: SQLServerCentral.com | Category: business intelligence

Rating:

|

Discuss |

Briefcase | 3,806 reads

ETL Performance Auditing - Part 2: Auditing Data Staging Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup. Read more...

By Frank A. Banin 2012/06/12 | Source: SQLServerCentral.com | Category: performance tuning

Rating:

|

Discuss |

Briefcase | 4,712 reads

ETL Performance Auditing - Part 1: Introduction to ETL Auditing

This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup. Read more...

By Frank A. Banin 2012/06/05 | Source: SQLServerCentral.com | Category: etl performance

Rating:

|

Discuss |

Briefcase | 8,735 reads

Serving Warm SSIS Errors

Delivering well formated SSIS Package errors through Emails. Read more...

By Frank A. Banin 2012/04/12 | Source: SQLServerCentral.com | Category: html

Rating:

|

Discuss |

Briefcase | 5,936 reads

Managing Data Dictionaries in DW and DSS Database Applications

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation. Read more...

By Frank A. Banin 2011/12/20 | Source: SQLServerCentral.com | Category: bi

Rating:

|

Discuss |

Briefcase | 5,123 reads

Managing Data Removal Using SSIS

Managing Data removal During ETL. First of Comprehensive tools designed for ease of use especially in enterprise Projects. Read more...

By Frank A. Banin 2011/09/13 | Source: SQLServerCentral.com | Category: etl

Rating:

|

Discuss |

Briefcase | 3,751 reads