I started my career in IT nearly 10 years ago and have remained influenced and driven by two particular technology initiatives - Business Intelligence and Data Warehousing. Opportunities for partnership, learning, and innovation will continue to present themselves as we strive to meld people, business, and technology. I look forward to these opportunities as I am fulfilled by my membership to a scientific community that is driven by the development and execution of technology solutions that enhance the way we live and conduct business.

Data Warehousing Tip: T-SQL Script to Create DEFAULT Constraints by Data Type

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle...

2013-09-11

717 reads

Data Warehousing Tip: T-SQL Script to Create DEFAULT Constraints by Data Type

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle Poolet summarizes it beautifully – “consider the data warehouse...

2013-09-11

7 reads

Data Warehousing Tip: Using T-SQL vs SSIS for Slowly Changing Dimension (SCD) Types 1 and 2

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

Here’s an example of using T-SQL to process a Slowly Changing Type 1&2 Dimension . Note: SSIS has an SCD transform...

2013-09-11

1,073 reads

Data Warehousing Tip: Using T-SQL vs SSIS for Slowly Changing Dimension (SCD) Types 1 and 2

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

Here’s an example of using T-SQL to process a Slowly Changing Type 1&2 Dimension . Note: SSIS has an SCD transform ,however, it does not process large dimensional datasets...

2013-09-11

21 reads

Parallel Data Warehouse (PDW) Tip: Useful Appliance Queries

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

This post contains the following queries that support development and operational tasks within a Microsoft Parallel Data Warehousing (PDW) Appliance...

2013-04-20

6,822 reads

Data Warehousing Tip: Surrogate Key Generation

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to...

2013-04-12

918 reads

Data Warehousing Tip: Surrogate Key Generation

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to do a table based surrogate key assignment or use...

2013-04-12

4 reads

SSAS How-To: Create Dynamic Time Calculations To Reuse Over Any Measure

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

Rather than making individual time calculations for each measure in an SSAS cube (i.e. YTD, Prior YTD, YTD Variances, etc), one can...

2013-02-07

1,886 reads

SSAS How-To: Create Dynamic Time Calculations To Reuse Over Any Measure

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

Rather than making individual time calculations for each measure in an SSAS cube (i.e. YTD, Prior YTD, YTD Variances, etc), one can use a more dynamic approach to time calcs applicable to all...

2013-02-07

63 reads

SSRS How-To: Simple Method to Pass MDX Multi-Select Parameters to MDX Datasets

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

SSRS Tip: Simplest Method to Pass MDX Multi-Select Parameters to MDX Datasets
I recently ran across a poorly covered topic in regards...

2013-02-07

3,233 reads

All authors

Data Warehousing Tip: T-SQL Script to Create DEFAULT Constraints by Data Type

Data Warehousing Tip: T-SQL Script to Create DEFAULT Constraints by Data Type

Data Warehousing Tip: Using T-SQL vs SSIS for Slowly Changing Dimension (SCD) Types 1 and 2

Data Warehousing Tip: Using T-SQL vs SSIS for Slowly Changing Dimension (SCD) Types 1 and 2

Parallel Data Warehouse (PDW) Tip: Useful Appliance Queries

Data Warehousing Tip: Surrogate Key Generation

Data Warehousing Tip: Surrogate Key Generation

SSAS How-To: Create Dynamic Time Calculations To Reuse Over Any Measure

SSAS How-To: Create Dynamic Time Calculations To Reuse Over Any Measure

SSRS How-To: Simple Method to Pass MDX Multi-Select Parameters to MDX Datasets

Blogs

Monday Monitor Tips: Searching Permission Changes

SQL Bits 2025 Wrap

Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed

Forums

SQL Server 2008 to SQL Server 2022

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

Question of the Day

Using Heaps