TRAIN!!! FREE SQL Server Training: 4/20/13 SQL Saturday Orange County

If you're anywhere near Huntington Beach this week, and you're interested in SQL Server, data,

analytics or any combination of those, come check out SQL Saturday #201.

All day long (8-5), there will be non-stop sessions on a wide variety of data topics.  From DBA fundamentals to Big Data to Business Intelligence to Cloud to Data Mining...  The list goes on.  Did I mention it's FREE...

Check out the schedule here:
http://www.sqlsaturday.com/201/eventhome.aspx

References for ETL Design Patterns talk

4/4 San Diego SQL BI User Group:

Here are those references I mentioned in my 4/4 talk on ETL Design Patterns.  Lots of good content in here.  And for those that haven't studied Project REAL yet, definitely recommend giving it a look.  Even though it is a few years old, still very relevant for many implementations.




Considerations for High Volume ETL Using SSIS (2008)
     http://msdn.microsoft.com/en-us/library/cc671624.aspx

CodePlex SSIS components
     http://sqlsrvintegrationsrv.codeplex.com/

Thomas Kejser - early-arriving facts with partial-cache lookup & proc
     http://blogs.msdn.com/b/sqlcat/archive/2009/05/13/assigning-surrogate-keys-to-early-arriving-facts-using-integration-services.aspx

Partition Mgmt project on CodePlex
     http://sqlpartitionmgmt.codeplex.com/

Matt Masson - Design Patterns
     http://blogs.msdn.com/b/mattm/archive/2010/06/29/ssis-performance-design-patterns-video.aspx

Masson - SCD Tuning
     http://blogs.msdn.com/b/mattm/archive/2010/08/05/optimizing-the-slowly-changing-dimension-wizard.aspx

Veerman - Project REAL
     http://technet.microsoft.com/en-us/library/cc966416.aspx

Jamie Thomson - blog
     http://sqlblog.com/blogs/jamie_thomson/