SQL Rally Schedule

Devin-Knight, 2011-04-05


Thursday, May 12






8:30 – 9:30

SQL Server Parallel Data Warehouse – Under the Hood

Brian Mitchell

The Dirty Dozen: PowerShell Scripts for the Busy DBA

Aaron Nelson

A data-logic approach to EF4

Mattias Lind

Iceberg, Dead Ahead! – Lessons from real life disasters for the database


Mike Walsh

9:40 – 10:40

Performance Management Scorecards – Building a process to achieve top


Scott Schledwitz

Troubleshooting Performance Problems by Reading the Waits

Eddie Wuerch

Deploying Data Tier Applications to the Cloud

Joseph Dantoni

Fragmentation and Performance Issues

Bryan Oliver

10:40 – 11:10


11:15 – 12:45

Reporting Services Boot Camp

Brian McDonald

Understanding Storage Systems and SQL Server

Wesley Brown

Avoid Common Mistakes in T-SQL Programming

Alex Kuznetsov

ETL Head-to-Head: T-SQL vs. SSIS

Tim Mitchell

12:45 – 1:45


1:50 – 2:50

Near Real-Time Data Warehouse

Patrick LeBlanc

The Enterprise SQL DBA

Scott Shaw

T-SQL Code Sins: The Worst Things We Do to Code, and Why

Jennifer McCown

Visual Studio 2010 Database Projects

Randy Knight

3:00 – 4:00

Data Visualizations in SSRS 2008 R2

Stacia Misner

Data Encryption and Key Management in SQL

Said Salomon

Writing faster queries

Tim Chapman

Unlocking the Mystery of MDX

Bryan Smith

4:00 – 4:30


4:35 – 5:35

Business Intelligence with SharePoint 2010 and PowerPivot

Jen Underwood

DBA Disaster Recovery Techniques To Keep Handy

Edwin Sarmiento

What’s new in SQL Server 2011 (“Denali”)?

Aaron Bertrand

SQL University: Lightning Talks

Jorge Segarra


Friday, May 13






8:30 – 9:30


Randy Dyess

Big and Tall: When to Partition

Kendra Little

3rd Normal Form: That’s crazy talk!!!

Thomas LeBlanc

Helping Your Data Warehouse Succeed: 10 Mistakes to Avoid in Data


Rafael Salas

9:40 – 10:40

Using PowerShell to simplify your ETL

Scott Weinstein

SQL Server Troubleshooting

via DMV’s

Steve Schneider

Creating a Metadata Mart with SSIS – Data Governance , Data Profiling &

Code Generation

Ira Warren

The Data Mining Lifecycle

Carlos Bossy

10:40 – 11:10


11:15 – 12:45

Performance Tuning Analysis Services

Devin Knight

Evaluate your daily checklist against 100+ instances of SQL Server while you

get a cup of coffee

John Sterrett

Data Dude for Devs and DBAs – Making Database Development Painless and


Robert Cain

Career Success in the Data Profession During Turbulent Times

Karen Lopez

12:45 – 1:45


1:50 – 2:50

Cool Tricks to Pull from your SSIS Hat

Julie Smith

Deadlocking for Mere Mortals

Jonathan Kehayias

SQL Server Storage Engine under the hood: How SQL Server performs I/O

Thomas Grohser

SQL Azure 201 – Cloud Database Deep-Dive

Scott Klein

3:00 – 4:00

Zero To OLAP Cubes in 60 Minutes

Adam Jorgensen

Windows PowerShell Best Practices for SQL DBA’s

Ed Wilson

SQL Tricks

A. P. Ward Pond

Orders of magnitude: Scale-Out your SQL Server Data

Mark Broadbent

4:00 – 4:30


4:35 – 5:35

Enterprise Data Mining for SQL Server Professionals

Mark Tabladillo

Fundamentals of SQL Server Internals

Jeremiah Peschka

AppFabric Cache and SQL Server 2008

Todd Robinson

Page And Row Compression How, When, and Why

Bradley Ball





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads