Azure SQL DW Identity Column Bugs

Azure SQL DW Identity Column Bugs

Those of you who are seasoned at implementing SQL Server have probably used the identity column feature. It is a great tool for generating surrogate keys in your tables without needing to include logic in your code. With any new feature, comes the good and the bad. The good news if you looking at Azure SQL Data Warehouse (SQL DW) for your next implementation is that Microsoft introduced...

Read More
Is Data Warehousing really dead?

Is Data Warehousing really dead?

Traditional data warehousing was pioneered by Ralph Kimball and Bill Inmon in 1970s to address growing problem of accessing data for reporting and analytics from multiple disparate data sources. Key drivers and goals of data warehousing are: Collect data from multiple sources into a single repository Expose data for reporting and analytics in a performant way Keep full history of data...

Read More

Data for Good: Tackling the Open Data Movement

Last month, I had the opportunity to attend O’Reilly’s Strata Conference as a representative of West Monroe’s Advanced Analytics team. Strata focuses on trends in Big Data and Analytics, two of the hottest topics in the technology world today. At Strata, I was exposed to emerging Big Data architectures and design patterns, and had the chance to meet passionate and influential technologists in...

Read More

Tips on supercharging your ETL

We live in the era of big data explosion with data volumes growing at exponential pace.  At the same time data driven organizations increasingly demand more real time data availability. Given these trends, ETL performance is quickly gaining business importance. Let’s look at a few approaches that could be considered to maximize performance of data processing.…

Read More

Data Warehouse Architecture: Inmon CIF, Kimball Dimensional or Linstedt Data Vault?

Corporate Information Factory (CIF) data warehouse architecture was pioneered by Bill Inmon. It is also referred to as top-down approach because it represent complete view of enterprise data. Data is stored in 3rd normal form (3NF) closely resembling source system structures. To capture historic data changes timestamps are added to each table key columns.…

Read More
Phone: 312-602-4000
Email: marketing@westmonroepartners.com
222 W. Adams
Chicago, IL 60606
Show Buttons
Share On Facebook
Share On Twitter
Share on LinkedIn
Hide Buttons