Pragmatic Works, WROX, SQL Server Central, and SQL Server Magazine have teamed up again with the bestselling authors in the SQL Server industry. It's not often you can get free training from the people that write the books.
In these sessions you will learn how to design a data warehouse, load it using SSIS, place a cube on top of it using SSAS and report against it using SSRS. Finally, you'll see how to performance tune and scale the data warehouse using common techniques.
The April speakers are:
Brian Knight
Advanced SSIS tips and Tricks
April 20, 2010 11:00 a.m. EDT
In this webinar SQL Server MVP, Brian Knight will show you some of the neat tips and tricks you can do in SSIS to handle larger scales of data, parallelism and restart ability. He'll also show you how to create work queues for multi-server processing of data and integrating data mining into your package.
Jessica Moss<
SSIS scripting and custom components
April 22, 2010 11:00 a.m. EDT
Can't find an SSIS Task that does what you need? Script it! The Script Task, Script Component, and Custom Components in SSIS are extremely powerful and flexible. In this session by Jessica Moss you will learn how to customize SSIS functionality using Script objects, best practices for script development, script troubleshooting .
Rodney Landrum
Use SSRS and SSIS to create a DBA Repository
April 27, 2010 11:00 a.m. EDT
At it's heart, the DBA Repository solution employs SSIS and SSRS and in late 2009 was updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS along with some new reports.
Brent Ozar
Virtualization and SAN Basics for DBAs
April 29, 2010 11:00 a.m. EDT
- Three things you should NEVER do when virtualizing SQL Server,
- Three things you should ALWAYS do when using SQL Server on a SAN.
- Three metrics you should always capture on every SQL Server whether it's virtual or SAN-connected or none of the above.
The sessions will fun from April 20 – April 29, 2010.
Click here to see the schedule and reserve your free seat. Space is limited.
