Welcome to Atlanta's 4th Annual SQLSaturday! SQL Saturday #89 on 9/17
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Sep 17 2011 at "Georgia State University (Alpharetta Center)". Admittance to this event is free; all costs (with the exception of lunch) are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.
Georgia State University - Alpharetta Location Website
We will be providing the option for lunch at $10.00 per person. This will be for a nice boxed lunch from Bagel Boys (not pizza). An invoice will be sent out where you can make payment via PayPal.
We will have two precon sessions being offered by SQL MVP's. A Database Administration precon by Kevin Kline and a Business Intelligence precon by John Welch.
The precons will be held on Friday Sept 16th at Georgia State University (same location as SQL Saturday Atlanta). The cost of the precon sessions are $99.00
Pre-con 2 - Data Warehousing with SSIS Deep Dive by MS SQL MVP ----John Welch
Click Here to Register
John Welch is BI Architect
with Varigence. Varigence builds tools and frameworks that enable the
creation and management of end-to-end business intelligence solutions
with unprecedented ease and speed. John has been working with business
intelligence and data warehousing technologies since 2001, with a focus
on Microsoft products in heterogeneous environments. He is a Microsoft
Most Valued Professional (MVP), and a frequent presenter on SQL Server
Want to learn more about implementing data warehouse ETL
with SQL Server Integration Services? Attend this full day seminar, and we’ll
cover using SSIS for data warehousing in-depth. You’ll learn everything you need
to know to populate your data warehouse with data. We’ll cover how to develop a
common framework for your packages, automate the creation of rote packages for
staging data, implement common patterns for handling various types of dimensions
and fact tables, and how to instrument your packages to identify and recover
from failures when loading data. We’ll be using the AdventureWorks databases for
the examples, so bring along a laptop configured with SQL Server 2005 or later,
and the AdventureWorks sample databases installed. We’ll also cover how the
upcoming Denali release of SQL Server affects what we discuss in this
Topics will include:
- Laying out a framework for your ETL
o Restartability and Recoverability
- Common SSIS Tasks
o Using FTP to Retrieve Files
o Copying and Archiving Files
o Executing SQL Statements
o Moving Data
- Handling Dimensions
o SCD Type 1
o SCD Type 2
o Advanced Dimension Types
- Handling Facts
o Periodic Snapshot
o Accumulating Snapshot
o Advanced Fact Patterns
o Handling Processing Errors
o Handling Data Errors
o Recovering from Errors
- Performance Tuning SSIS
o Tuning Performance of the Data Flow
o Optimizing Data Warehouse Loads
- Best Practices for Managing Your ETL
Pre-con 1 - Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2 DEEP DIVE by MS SQL MVP ----Kevin Kline
Presenter : Author, expert and Microsoft MVP Kevin Kline Bio of Kevin E Kline Click Here to Register
This full day seminar will teach you introductory, intermediate and advanced techniques for troubleshooting and performance tuning using SQL Server's built-in Dynamic Management Views (DMVs), Performance Monitor, Profiler, Wait Stats, and Extended Events. In troubleshooting, you’ll learn how to detect, diagnose, and resolve problems on SQL Server using the native tools, as well as how to determine where SQL Server is experiencing bottlenecks that prevent it from achieving optimal performance. Bring your laptop with SQL Server 2008 R2 and AdventureWorks R2 to work through the labs as Kevin demonstrates various techniques. (SQL Server 2005 is also allowable, but you will not be able to demo those that are specific to SQL Server 2008 R2).
Topics covered include:
- The “Rocks, Gravel, Sand” Troubleshooting Methodology
o Understanding Wait Stats
o Using beginner, intermediate, and advanced DMVs
o Correlating Performance Monitor and Profiler
o Extended Events
- Determining meaningful key performance indicators thru benchmarking
- Catch problems before your users do thru monitoring
- Preventative Maintenance Best Practices
Seminar includes lunch and refreshments.
SQL Saturday #89, filled with many free sessions and events, will be held the next day.
We do ask that you consider to OPT-IN for the Sponsors of this event.
Without their assistance, we cannot bring this FREE event to you. You
can always opt-out if and when they contact you! Thank you for your
*We do ask that you consider to OPT-IN for the Sponsors of this event. Without their assistance, we cannot bring this FREE event to you. You can always opt-out if and when they contact! Thank you for your consideration.
Click here to view/download event summary in XML format.