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 TimeRoom 313 - Room: Room 313Room 314 - Room: Room 314Room 315 - Room: Room 315Room 325 - Room: Room 325Room 329 - Room: Room 329Room 330 - Room: Room 330
09:00 AMJeremiah Peschka

Fundamentals of SQL Server Internals

Level: Intermediate
Jeff Mlakar

Using SQL Azure in an SSMS Addin*

Level: Beginner
Chris Skorlinski

Part 1 - Introduction to Change Data Capture*

Level: Beginner
Michael Coles

Introduction to SQL Server Spatial Data*

Level: Intermediate
Sam Nasr

Programming with FileStreams*

Level: Intermediate
Mike Walsh

As a DBA, Where Do I Start?!

Level: Beginner
10:15 AMErin Stellato

Baselines first, troubleshooting second*

Level: Beginner
Tim Chapman

Writing faster queries

Level: Advanced
Chris Skorlinski

Part 2- Integrating CDC with SSIS*

Level: Intermediate
Brian Davis

Service Broker...What's That & How Do I Use It?*

Level: Beginner
Deepak Puri

Excel 2010: everyman's OLAP client just got better*

Level: Beginner
Aaron Bertrand

What's new in SQL Server 2011 ("Denali")?*

Level: Beginner
11:30 AMPaul Hiles

Take Your Automation Script to the Next Level*

Level: Beginner
Joe Kuemerle

Encryption in SQL Server*

Level: Intermediate
Steve Jones

The Modern Resume - Building Your Brand*

Level: Beginner
Kendra Little

(NOLOCK) FOR YESFUN: Games with Isolation Levels

Level: Beginner
Rob Collie

PowerPivot: BI & Massive Data Analysis for Humans

Level: Beginner
Craig Purnell

Database Mirroring in the Real World*

Level: Intermediate
01:30 PMErin Stellato

Who's responsible? The vendor or the DBA?*

Level: Beginner
Jeff Moden

The "Tally" Table & High Speed "Pseudo Cursors"*

Level: Beginner
Evan Basalik

Troubleshooting SSRS Performance Issues *

Level: Intermediate
Eddie Wuerch

Drive SQL Server Performance: I/O For Developers*

Level: Intermediate
Sandra Mueller

Developing Date and Role-Playing Dimensions *

Level: Intermediate
Thomas LaRock

Waits and Queues and YOU!

Level: Beginner
02:45 PMJoe Kuemerle

Technical Professionals….Are We Just a Commodity?*

Level: Beginner
Michael Coles

Build Your Own Search Engine With SQL Server*

Level: Intermediate
William Pearson

Getting Started with MDX

Level: Beginner
Karen Lopez

Database Design Contentious Issues

Level: Intermediate
Sam Nasr

BI Development*

Level: Intermediate
Kendra Little

Table Partitioning: Evaluation, Planning, Options

Level: Beginner
04:00 PMAllen White

Gather SQL Server Performance Data with PowerShell*

Level: Advanced
Aaron Bertrand

T-SQL : Bad Habits to Kick*

Level: Beginner
Ira Whiteside

(SSIS, TSQL and MDS) - Record Linkage(Fuzzy Match)*

Level: Intermediate
jeremiah Peschka

Modeling Muddy Data

Level: Beginner
Joe Fedak

Analysis Services Troubleshooting and Optimization*

Level: Intermediate
Grant Fritchey

Gathering and Interpreting Performance Metrics*

Level: Intermediate


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
Analyze and map spatial data with SQL Server 2008Deepak PuriIntermediate
(NOLOCK) FOR YESFUN: Games with Isolation LevelsKendra LittleBeginner
(SSIS, TSQL and MDS) - Record Linkage(Fuzzy Match)Ira WhitesideIntermediate
A SQL Server Video Game?Jeff MlakarBeginner
Analysis Services Troubleshooting and OptimizationJoe FedakIntermediate
As a DBA, Where Do I Start?!Mike WalshBeginner
Attribute Discretization in Analysis ServicesWilliam PearsonBeginner
Automate Policy-Based Management using PowerShellAllen WhiteAdvanced
Baselines first, troubleshooting secondErin StellatoBeginner
Become a Bilingual DBA! Oracle for the SQL Server Randy KnightIntermediate
BI DevelopmentSam NasrIntermediate
Build Your Own Search Engine With SQL ServerMichael ColesIntermediate
Centralizing Database MetaDataKevin DevineBeginner
Creating a Metadata Mart with SSIS - Data GovernanIra WhitesideIntermediate
Database Design Contentious IssuesKaren LopezIntermediate
Database Mirroring in the Real WorldCraig PurnellIntermediate
DBA Best PracticesChris SkorlinskiBeginner
DBA Repository Update 2010 Using SSIS and SSRSRodney LandrumIntermediate
Design and Implement BI Like Edison!William PearsonBeginner
Developing Date and Role-Playing Dimensions Sandra MuellerIntermediate
DMVs- What are they and why should a DBA care? Paul HilesBeginner
Drive SQL Server Performance: I/O For DevelopersEddie WuerchIntermediate
Encryption in SQL ServerJoe KuemerleIntermediate
Excel 2010: everyman's OLAP client just got betterDeepak PuriBeginner
Excel 2010: everyman's OLAP client just got betterDeepak PuriBeginner
Expanding the Million Row HierarchyJeff ModenBeginner
Find Performance Problems by Reading the WaitsEddie WuerchIntermediate
Fundamentals of SQL Server InternalsJeremiah PeschkaIntermediate
Gather SQL Server Performance Data with PowerShellAllen WhiteAdvanced
Gathering and Interpreting Performance MetricsGrant FritcheyIntermediate
Getting Started with Analysis ServicesJoe FedakBeginner
Getting Started with MDXWilliam PearsonBeginner
High Performance SSIS Dimensional Datamart Loads Michael ColesIntermediate
Iceberg, Dead Ahead!Mike WalshBeginner
Indexes and Other Free Performance BoostsJeremiah PeschkaIntermediate
Integrating SQL Server with Active DirectoryCraig PurnellIntermediate
Introduction to SQL Server Spatial DataMichael ColesIntermediate
Management Studio Tips & TricksAaron BertrandBeginner
Many-to-Many: Multiple Calendars in a Single CubeWilliam PearsonBeginner
Modeling Muddy Datajeremiah PeschkaBeginner
Overview of Microsoft Atlanta ProjectChris SkorlinskiBeginner
Overview of Microsoft Replication TechnologiesChris SkorlinskiBeginner
Part 1 - Introduction to Change Data CaptureChris SkorlinskiBeginner
Part 2- Integrating CDC with SSISChris SkorlinskiIntermediate
Performance Tuning Made EasyThomas LaRockIntermediate
Plan guides in SQL 2008Jayanth RamachandranIntermediate
PowerPivot: BI & Massive Data Analysis for HumansRob CollieBeginner
Programming with FileStreamsSam NasrIntermediate
Programming with StreamInsightSam NasrIntermediate
Refactoring SQL ApplicationsJeremiah PeschkaBeginner
Report Services Admin (a BIDs Free Zone) Sandra MuellerBeginner
Secure Your Data @ Rest!Michael ColesIntermediate
Sell Yourself!Michael ColesBeginner
Service Broker...What's That & How Do I Use It?Brian DavisBeginner
Source Control for DBA'sJoe KuemerleIntermediate
SQL and SEO - the FUZION of database and marketingJared NielsenIntermediate
SQL Server 2008 for DevelopersSam NasrIntermediate
SQLIO, Perfmon and a PALMike WalshIntermediate
T-SQL : Bad Habits to KickAaron BertrandBeginner
Table Partitioning: Evaluation, Planning, OptionsKendra LittleBeginner
Take Your Automation Script to the Next LevelPaul HilesBeginner
Technical Professionals….Are We Just a Commodity?Joe KuemerleBeginner
The "Tally" Table & High Speed "Pseudo Cursors"Jeff ModenBeginner
The Benefits of SQL AzureAaron KingBeginner
The Modern Resume - Building Your BrandSteve JonesBeginner
Troubleshooting SSRS Performance Issues Evan BasalikIntermediate
Using SQL Azure in an SSMS AddinJeff MlakarBeginner
Visual Studio 2010 Database Projects Randy KnightBeginner
Waits and Queues and YOU!Thomas LaRockBeginner
What's new in SQL Server 2011 ("Denali")?Aaron BertrandBeginner
Who's responsible? The vendor or the DBA?Erin StellatoBeginner
Writing faster queriesTim ChapmanAdvanced


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
Service Broker Uses and a Real World Example Beginner
Using SQLIO to benchmark IO and Disk PerformanceBeginner