SSIS - Using the Merge Join Transform8/30/2010 - Learn how to use the Merge Join transform in SSIS. Learn what the join options are and what the results will look like.
Sorting Varchar as Number with T-SQL and SSIS8/16/2010 - Learn how to sort a Varchar or any string column as numeric even when there are multiple separators between the varchar numbers. Learn how to do this in T-SQL as well as SSIS.
MDX Time Calculations Done the Right Way8/11/2010 - In this article Devin shows you a unique way of writing time calculations. These calculations are dynamic so no matter what measure is used it will show it YTD, Previous Period, etc...
Creating your first Data Mining Structure and Model8/9/2010 - Learn how to built a Data Mining Structure and Model. Understand how a view is set up to support the Data Mining.
SQL Server Parallel Data Warehouse (Madison) Introduction8/7/2010 - This article covers the basics of the PDW (Parallel Data Warehouse Architecture) and dives into why it is a good fit for some organizations. Adam also jumps in and discusses creating some new object types in this new type of environment.
More Featured Articles