The New Azure Data Factory – Now with SSIS Compatibility

The New Azure Data Factory – Now with SSIS Compatibility

Recently, Microsoft released to General Availability, the newest version of Azure Data Factory (which you will see referred to as V2 in Azure). This is a major release that is a huge step up from the previous version of Azure Data Factory (read about the new features here). One of the most interesting new features is support for SQL Server Integration Services (SSIS) packages.…

Read More
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

10 Best Practices for High Performance ETL Processing

Every database administrator deals with this ETL headache at some point in their career. As data volumes grow, ETL processes start to take longer to complete. Cue the complaints from business users: “Why do our data loads take so long to run?” “Why can’t we get our reports out earlier?” “I get to the office early and need to be able to see results by the...

Read More

Challenges of Data Warehouse Carve-Outs

Carving out a data warehouse can look like a straightforward task on the surface. The path of least resistance would seem to be to replicate the parent’s environment as-is in the carve-out organization, using the exact same software and architecture. However, this is not always going to be the best solution.…

Read More

Challenges of data warehouse carve-outs

Carving out a data warehouse can look like a straightforward task on the surface.  The path of least resistance would seem to be to replicate the parent’s environment as-is in the carve-out organization, using the exact same software and architecture.  However, this is not always going to be the best solution. …

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