SQL Server Data Warehouse Concepts, Schema Design, and Implementation

Companies generate a huge amount of data on a daily basis from such things as sales transactions, inventory changes, and customer interactions. This data originates from different data sources and is stored in operational databases called OLTP (Online Transaction Processing) systems that primary focuses on transactions like data inserts, updates or deletes. Maintaining the transactional data in an OLTP database is important. However, if you need to analyze or report on the data, storing the data in a centralized repository in well-structured schema is necessary.

Data Warehouse Considerations - SCD Type 2 vs Overwrite Dimension Tables

How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions versus overwriting tables.

The Load of Real Time Data Warehouses

How much load do real time updates place on a data warehouse? Steve has a few thoughts on the analysis of the Amazon Redshift dataset, Redset.

How do you secure sensitive data in a modern Data Warehouse?

In 2019 Canadian Broadcasting Corporation (CBC) news reported a massive data breach at the Desjardins Group, which is a Canadian financial service cooperative and the largest federation of credit unions in North America. The report indicated, a "malicious" employee copied sensitive personal information collected by Desjardins from their data warehouse. The data breach compromised the […]

In which situations would you use Calculated Measures?...

When are ROLAP dimensions used? Sponsored by Apress...

What is the difference between a data warehouse...

You are a new DBA at MegaSoftware and...

You are running setup for SQL Server 2000...

You have a data warehouse and cubes built...