Big Data in my little head

I recently attended internal training on Microsoft Big Data presented by our partner in this space Horton Works. It was a bit of a learning curve as the world of Big Data is a paradigm shift to the relational world, or so I thought. It turns out it isn’t that remarkably different. The Horton Works…

2

SQL Server Integration Services (SSIS) Best Practices

I was recently just asked for some best practices on SSIS, and put together a collection of the below whitepapers/articles that discuss good practices for SSIS package design/development. · Top 10 SQL Server Integration Services Best Practices – http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx · Best Practices for Integration Services Configurations – http://technet.microsoft.com/en-us/library/cc671628.aspx · Using the Microsoft Connector for Oracle…

4

How to measure SSIS component/transformation performance

To assist in improving performance of your SSIS packages, you are essentially looking at performing a process of elimination performance analysis. You can remove transformations isolating just the source and destination to see if the transforms are causing the issue, remove the destinations and replace them with a terminator such as the derived column or…

0