Tuesday, April 16, 2013

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:

Saturday, April 6, 2013

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)

CodePlex SSIS components

Thomas Kejser - early-arriving facts with partial-cache lookup & proc

Partition Mgmt project on CodePlex

Matt Masson - Design Patterns

Masson - SCD Tuning

Veerman - Project REAL

Jamie Thomson - blog