SQLSaturday 89

Atlanta, United States

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Sep 17 2011 at Georgia State University - Alpharetta location, 3775 Brookside Pkwy, Alpharetta, Georgia, 30022, United States

Register Now

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

Icon  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 BI topics.

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 seminar.

Topics will include:

-          Laying out a framework for your ETL

o   Logging

o   Restartability and Recoverability

o   Auditing

-          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   Transactional

o   Periodic Snapshot

o   Accumulating Snapshot

o   Advanced Fact Patterns

-          Errors

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  

Icon  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 consideration.

Event Location

Event news

No Event News entered. Please come back later and check again


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids