Schedule

Here is our schedule for the upcoming event. We've done our best to provide a good mix of topics and skill levels, we hope you'll find something of interest throughout the day. Our thanks to the speakers listed below for volunteering their time, we couldn't do it without them. If there are schedule changes we will make them here as they happen. We encourage you to check back a few days before the event just in case we have had to move one of your favorite sessions.

Note: Session titles with an '*' have a download available.

Start TimeTrack 1Track 2Track 3Track 4Track 5Track 6Track 7
09:00 AMBrian Knight
Introduction to SSIS
Jorge Segarra
SQL University 101:Starting the SQL Journey*
Jack Corbett
Why Should I Use Stored Procedures?*
Bayer White
Getting Started with AppFabric Caching (Velocity)
Michael Mollenhour
Accurate MDX RoadTrip
Troy Gallant
Introduction to Transactional Replication*
Michael Antonovich
XML 101 for the SQL Developer*
10:15 AMEric Wisdahl
SSIS - A Beginning Framework*
Jeffrey Garbus
Choosing Indexes for Performance
Plamen Ratchev
Refactoring SQL for Performance*
Andy Warren
Social and Not So Social Networking for the DBA
Aaron Nelson
PowerShell for Data Professionals*
David Taylor
Using SSRS with Trending Reports*
Nathan Heaivilin
Introduction to Execution Plans
11:30 AMBrian Knight
Iron Chef Competition: Loading a Data Warehouse
Dmitri Korotkevitch
Getting familiar with SQL Server Storage Engine*
Plamen Ratchev
Common SQL Programming Mistakes*
Jason Strate
Using XML to Query Execution Plans
Chad Miller
PowerShell ETL*
Mark Landry
Building a Near-Realtime Operational Dashboard
Telmo Sampaio
SQL Server Beyond Relational
12:30 PMBrian Knight
Rapid BI Development with Pragmatic Works
Michael Ruland
SSIS users: Turbocharge your ETL with expressor
Janis Griffin
Real-World Performance Tuning
SQLSaturday Event
LUNCH
   
01:30 PMScott Gleason
PGP encryption using SSIS
Geoff Hiten
Clustering for Mere Mortals
Jeffrey Garbus
Bad, less Bad, not Bad; rewriting bad SQL Code
Kevin Boles
Care and Feeding of TempDB*
Ronald Dameron
Database Hardening via PowerShell*
Vikas Hawaldar
Data Mining and Predictive Analysis using SQL 2008
Michael Stark
SQLServer 2008 Spatial Data *
02:45 PMChristian Loris
SSIS and Slowly Changing Dimensions
Jonathan Kehayias
Real Time Problem Identification with Event Notifi*
Jorge Segarra
Policy-Based Management 101*
Herve Roggero
SQL Azure
Patrick LeBlanc
SQL Server Data Compression 101
Patricia (Pat) Baxter
5 Resolutions to Build Your Professional "Brand"*
Kathy Malone
Access SQL Back-End Gets Better Option
04:00 PMMike Davis
Advanced Parameters in SSRS 2008
Jason Strate
ABCs of CTEs*
Elijah Baker
Database Table Partitioning, The Next Step
Scott Klein
Developing with SQL Azure
Adam Jorgensen
Zero to Cube in 60 Minutes
Janis Griffin
Tuna Helper for SQL Server DBA's*
Kevin Boles
SQL Server Service Broker*


Submitted Sessions

Here is the list of sessions submitted so far. Our goal is to feature as many different speakers and topics as possible, but space limitations prevent us from accepting every session. This list is also a great way for those thinking about speaking to see what might be on the agenda and enter a session that doesn't collide with an existing one.

TitleSpeakerLevel
5 Resolutions to Build Your Professional "Brand"Patricia (Pat) BaxterIntermediate
ABCs of CTEsJason StrateIntermediate
Access SQL Back-End Gets Better OptionKathy MaloneIntermediate
Accurate MDX RoadTripMichael MollenhourIntermediate
Advanced Parameters in SSRS 2008Mike DavisAdvanced
Bad, less Bad, not Bad; rewriting bad SQL CodeJeffrey GarbusBeginner
Building a Near-Realtime Operational DashboardMark LandryAdvanced
Care and Feeding of TempDBKevin BolesIntermediate
Choosing Indexes for PerformanceJeffrey GarbusAdvanced
Clustering for Mere MortalsGeoff HitenIntermediate
Common SQL Programming MistakesPlamen RatchevIntermediate
Data Cleansing with SSISBrian KnightAdvanced
Data Mining and Predictive Analysis using SQL 2008Vikas HawaldarBeginner
Database Hardening via PowerShellRonald DameronIntermediate
Database Table Partitioning, The BasicsElijah BakerIntermediate
Database Table Partitioning, The Next StepElijah BakerAdvanced
Develop in SetsDmitri KorotkevitchIntermediate
Developing with SQL AzureScott KleinIntermediate
Disk Partition AlignmentKevin BolesAdvanced
Dynamically Configuring PackagesMike DavisAdvanced
Getting familiar with SQL Server Storage EngineDmitri KorotkevitchBeginner
Getting Started with AppFabric Caching (Velocity)Bayer WhiteIntermediate
Getting To Know Your IndexesJason StrateIntermediate
High Availability options in SQL Server 2008Jeffrey GarbusAdvanced
How Change-Resilient Are You in the Digital Age? Patricia (Pat) BaxterIntermediate
Identifying and Removing Duplicate RecordsMichael AntonovichIntermediate
Implementing Auditing in SQL Server 2008 David DyeBeginner
Indexing for Join OptimizationJeffrey GarbusAdvanced
Intro to Powerpivot with Excel and Sharepoint 2010Patrick LeBlancBeginner
Introduction to Execution PlansNathan HeaivilinBeginner
Introduction to SSISBrian KnightBeginner
Introduction to Transactional ReplicationTroy GallantBeginner
Iron Chef Competition: Loading a Data WarehouseBrian KnightIntermediate
LUNCHSQLSaturday EventBeginner
Migrating DTS Packages to SSISMike DavisIntermediate
PGP encryption using SSISScott GleasonIntermediate
Policy-Based Management 101Jorge SegarraBeginner
PowerShell ETLChad MillerIntermediate
PowerShell for Data ProfessionalsAaron NelsonBeginner
Rapid BI Development with Pragmatic WorksBrian KnightBeginner
Real Time Problem Identification with Event NotifiJonathan KehayiasIntermediate
Real-World Performance TuningJanis GriffinBeginner
Refactoring SQL for PerformancePlamen RatchevIntermediate
Save Time with MERGEMichael AntonovichBeginner
Should You Require The Use of Stored Procedures?Andy WarrenBeginner
Social and Not So Social Networking for the DBAAndy WarrenBeginner
SQL 2008 Data Mining Implementation TechniquesVikas HawaldarAdvanced
SQL AzureHerve RoggeroBeginner
SQL Server 2008 XMLScott KleinIntermediate
SQL Server and SANsKevin BolesAdvanced
SQL Server Beyond RelationalTelmo SampaioAdvanced
SQL Server Data Compression 101Patrick LeBlancBeginner
SQL Server EncryptionHerve RoggeroIntermediate
SQL Server Service BrokerKevin BolesIntermediate
SQL SpatialTelmo SampaioIntermediate
SQL University 101:Starting the SQL JourneyJorge SegarraBeginner
SQL University 201: More DBA FunJorge SegarraIntermediate
SQLServer 2008 Spatial Data Michael StarkIntermediate
SSIS - A Beginning FrameworkEric WisdahlIntermediate
SSIS and Slowly Changing DimensionsChristian LorisIntermediate
SSIS Event Handlers for Auditing and NotificationMike DavisAdvanced
SSIS users: Turbocharge your ETL with expressorMichael RulandBeginner
Thinking in SetsJoe CelkoBeginner
Tuna Helper for SQL Server DBA'sJanis GriffinIntermediate
Unlocking a Goldmine - The Default TraceJack CorbettIntermediate
Using New Data Types and Features of SQL 2008James McAuliffeIntermediate
Using SSRS with Trending ReportsDavid TaylorBeginner
Using XML to Query Execution PlansJason StrateIntermediate
Why Should I Use Stored Procedures?Jack CorbettBeginner
XML 101 for the SQL DeveloperMichael AntonovichBeginner
Zero to Cube in 60 MinutesAdam JorgensenIntermediate
Zero to Cube in 60 MinutesAdam JorgensenIntermediate


Suggested Sessions

Thinking about participating as a speaker but no ideas for the topic? Often our attendees will have an idea for you! Or, submit a suggestion of your own.

Suggested Session TitleSkill Level
Why IT managers should want SQLBeginner