Call today 0845 643 6463

Integration Services

  • Forecasting the Performance of SSIS packages

    October 29th, 2010 in Blog, Integration Services

    SQL Server Integration Services (SSIS) packages are used in numerous scenarios for moving data from A to B. Often they are developed and tested against a cutdown, often static, subset of data. One of the problems with this is that yes you’re testing the functionality of the package as it’s being developed, but there’s no way to determine whether the performance will scale up to a full size production environment. This level of testing is…

    » Read more

  • SQL Server 2008 R2 – PowerPivot and Master Data Services

    May 18th, 2010 in Analysis Services, Blog, Integration Services, Reporting Services, SQL Server

    Purple Frog spent a very interesting day at Microsoft last week, at one of their many events promoting the launch of SQL Server 2008 R2. Rafal Lukewiecki presented an entertaining (as always!) and informative series of talks covering the release, focusing on the enhanced Business Intelligence tools available. The primary changes to note are Power Pivot – An in memory, client side add-in to Excel, that allows users to create virtual cubes on…

    » Read more