Skip To Main Content
with Failed Execs on Muck Rack

with Failed Execs

As seen in: SQL Server Central
Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work. Claim your profile
Back to with Failed Execs’s profile

Articles by with Failed Execs

ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase – SQLServerCentral

|
By Frank A. Banin, with Failed Execs, D. DayNumber Desc
| SQL Server Central
Introduction You are a SQL Developer or BI architect, and you get news that your scheduled production ETL Job(s) that were running “perfectly” are taking “longer” and “longer” to run. The problem is there are over 300 individual child SSIS packages that stage data, load a Data Warehouse (WH), load Data Marts,  process SSAS Cubes and manage your Database and Cube Partitions. Some of the questions that could be asked would be: What is “longer”, or what is the benchmark for that complaint?
Open in Who Shared Issue with article?

ETL Performance Auditing - Part 2: Auditing Data Staging Phase – SQLServerCentral

|
By Frank A. Banin, with Failed Execs, D. DayNumber Desc, N'Singapore' as
| SQL Server Central
Introduction You are a SQL Developer or BI architect, and you get news that your scheduled production ETL Job(s) that were running “perfectly” are taking “longer” and “longer” to run. The problem is there are over 300 individual child SSIS packages that stage data, load a Data Warehouse (WH), load Data Marts,  process SSAS Cubes and manage your Database and Cube Partitions. Some of the questions that could be asked would be: What is “longer”, or what is the benchmark for that complaint?
Open in Who Shared Issue with article?
Show More