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: Some speakers alternately upload their sessions to their own blog sites, which you can locate their site when you click on their session below.

Start TimeAppDev - Room: Room 1.143AppDev - Room: Room 1.141BI - Room: Room 1.147BI - Room: Room 1.148BI - Room: Room 1.149DBA - Room: Room 1.115DBA - Room: Room 1.117DBA - Room: Room 1.142DBA \ BI \ Cloud - Room: Room 1.113Prof Dev \ Cloud - Room: Room 1.145
07:30 AMSQLSaturday 308

Registrations

Level: Non-Technical
SQLSaturday 308

Registrations

Level: Non-Technical
SQLSaturday 308

Registrations

Level: Non-Technical
SQLSaturday 308

Registrations

Level: Non-Technical
SQLSaturday 308

Registrations

Level: Non-Technical
SQLSaturday 308

Registrations

Level: Non-Technical
SQLSaturday 308

Registrations

Level: Non-Technical
SQLSaturday 308

Registrations

Level: Non-Technical
SQLSaturday 308

Registrations

Level: Non-Technical
SQLSaturday 308

Registrations

Level: Non-Technical
08:30 AMTim Costello

Windowing Functions

Level: Beginner
Karen Lopez

Database Design Contentious Issues

Level: Intermediate
James Serra

Best Practices to Deliver BI Solutions

Level: Beginner

download
David Stein

Writing Your First BimlScript

Level: Beginner
Garret Edmondson

Data Warehouse ETL

Level: Intermediate

download
Ryan Adams

SQL 2012 AlwaysOn Quickstart

Level: Beginner

download
Dane Schilling

Taming the T-Log

Level: Beginner

download
John Sterrett

Proactive Monitoring with PBM and CMS

Level: Intermediate

download
Scott Klein

SQL Server 2014 OLTP Deep Dive

Level: Advanced
Jennifer McCown

DBA Career Roadmap

Level: Beginner
9:45 AMAaron Cutshall

The Lost Science of Set Theory and Relational Algebra

Level: Beginner

download
Aaron Bertrand

T-SQL : Bad Habits & Best Practices

Level: Intermediate

download
Denny Cherry

Table Indexing for the .NET Developer

Level: Intermediate

download
Mark Moore

Introduction to PowerBI

Level: Beginner
Tim Mitchell

Scripting in SSIS

Level: Beginner
Joseph D'Antoni

SQL Server--All About HA and DR

Level: Intermediate

download
Michael Bourgon

SQL Watchdog - find out instantly when SQL changes in production

Level: Intermediate

download
Amit R S Bansal

Mind your IO: Resource Governor shows you How

Level: Intermediate
Vicky Harp

Care and Feeding of Your System Databases

Level: Beginner
Amy Herold

Making the Leap from Developer to DBA

Level: Non-Technical
11:00 AMKris Hokanson

Beyond the Where: Full Text Search tips and tricks

Level: Intermediate

download
Rudy Rodarte

Expand your TSQL: Intersect, Except, and Apply

Level: Beginner

download
Carl Speshock

Microsoft Predictive Analytics/Data Mining Overview

Level: Intermediate

download
Robert Stewart

SSAS - An Introduction to Multidimensional Cubes

Level: Intermediate

download
Russ Loski

SSIS project deployments with multiple developers

Level: Advanced

download
Sean McCown

DIY Performance Reporting

Level: Intermediate
Mike Hays

Troubleshooting Your Network Connections

Level: Beginner

download
Mindy Curnutt

SQL Server Bingo – Install, Migration & Config

Level: Beginner

download
Scott Klein

Top 5 SQL Server 2014 Hybrid Features

Level: Intermediate
James Serra

Enhancing your career: Building your personal brand

Level: Beginner

download
12:00 PMSQLSaturday 308

Lunch Break

Level: Non-Technical
SQLSaturday 308

Lunch Break

Level: Non-Technical
SQLSaturday 308

Lunch Break

Level: Non-Technical
SQLSaturday 308

Lunch Break

Level: Non-Technical
SQLSaturday 308

Lunch Break

Level: Non-Technical
SQLSaturday 308

Lunch Break

Level: Non-Technical
SQLSaturday 308

Lunch Break

Level: Non-Technical
SQLSaturday 308

Lunch Break

Level: Non-Technical
SQLSaturday 308

Lunch Break

Level: Non-Technical
SQLSaturday 308

Lunch Break

Level: Non-Technical
12:45 PM     Bill Shields

Cisco Unified Computing System (UCS)

Level: Beginner
Matt Henderson

Strategy to Eliminate Bottlenecks

Level: Beginner
Dean Nelson

Supercharging SQL

Level: Beginner
Amit Parikh

Resolving the Database Performance Problem Blame Game

Level: Beginner
 
1:30 PMBill Barnes

Fill Factor: Performance or Nuisance?

Level: Intermediate

download
Jennifer McCown

T-SQL Code Sins

Level: Beginner
Garret Edmondson

Measuring Data Warehouse Performance

Level: Advanced

download
Aashish Parekh

Speed, Depth & Flexibility - Having it all with real-time SSAS

Level: Intermediate

download
Tim Costello

Pro Tips: Tuning the data flow in SSIS

Level: Intermediate

download
Denny Cherry

Storage For the DBA

Level: Intermediate

download
Lori Edwards

SQL Server Statistics – What Are The Chances?

Level: Beginner

download
Lance Tidwell

SQL Server Agent: The life preserver for the drowning DBA

Level: Beginner
Thomas LeBlanc

Execution Plan Basics - Beginners

Level: Beginner

download
Valentino and Anthony {Tex} Moreign

The Cloud and I

Level: Beginner
2:45 PMJohn Cook

SQL Server 2012 Analytic Functions

Level: Advanced
Vicky Harp

Edge Case Testing for the Database Professional

Level: Beginner
Tamera Clark

45 min to build your first SSRS report

Level: Beginner

download
Russ Loski

Introduction to BIML and BIMLScript

Level: Intermediate

download
Mike Byrd

Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Level: Intermediate

download
Jim Murphy

Mission Possible: Interactive Performance Troubleshooting - Indexes

Level: Beginner

download
Ryan Adams

How Active Directory affects SQL Server

Level: Advanced

download
Carlos Lopez

The Transaction Log Internals

Level: Advanced
Tim Mitchell

15 Quick Tips for SSIS Performance

Level: Intermediate
Karen Lopez

Windows Azure SQL Database Design: Concepts and Trade-offs

Level: Intermediate

download
4:00 PMTom Norman

Converting Unreliable Deployments Into Consistent Releases

Level: Intermediate

download
Aaron Bertrand

Top 5 Ways to Write Effective triggers

Level: Intermediate

download
Derek Wilson

Tabular Data Visualized by PowerView

Level: Beginner

download
John Sterrett

Table Partitioning: the Secret Weapon for your Big Data Problems.

Level: Intermediate

download
Thomas LeBlanc

Attributes & Hierarchies in Analysis Services 2012

Level: Beginner

download
Chris Bell

The Spy Who Loathed Me - An Intro to SQL Security

Level: Beginner

download
Wesley Brown

Fundamentals of SAN, NAS and IP Storage

Level: Intermediate
Jason wong

Ah, ha, how do you automate database administration?

Level: Advanced

download
Joseph D'Antoni

In-Memory Columnstore Indexes--Make Your Data Warehouse Fly

Level: Intermediate

download
Houston Area SQL Server User Group

Lightning Talks

Level: Beginner
5:00 PMSQLSaturday 308

Raffle

Level: Non-Technical
SQLSaturday 308

Raffle

Level: Non-Technical
SQLSaturday 308

Raffle

Level: Non-Technical
SQLSaturday 308

Raffle

Level: Non-Technical
SQLSaturday 308

Raffle

Level: Non-Technical
SQLSaturday 308

Raffle

Level: Non-Technical
SQLSaturday 308

Raffle

Level: Non-Technical
SQLSaturday 308

Raffle

Level: Non-Technical
SQLSaturday 308

Raffle

Level: Non-Technical
SQLSaturday 308

Raffle

Level: Non-Technical


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
$#*! Your Database Says About MeKaren LopezBeginner
12 Steps to Workload TuningJohn SterrettBeginner
15 Quick Tips for SSIS PerformanceTim MitchellIntermediate
45 min to build your first SSRS reportTamera ClarkBeginner
ABCs of SSISGlenda GableBeginner
Ah, ha, how do you automate database administration?Jason wongAdvanced
AlwaysOn - Finally, A usable 'mirror'!Jim MurphyBeginner
AlwaysOn Live DeploymentRyan AdamsIntermediate
Attributes & Hierarchies in Analysis Services 2012Thomas LeBlancBeginner
Back to Indexes; the original culprit !Amit R S BansalAdvanced
Become a BI Independent Consultant!James SerraBeginner
Beginning Automation with PowershellAmy HeroldBeginner
Best Practices to Deliver BI SolutionsJames SerraBeginner
Beyond the Where: Full Text Search tips and tricksKris HokansonIntermediate
Biml – The Next Step in Agile Data WarehousingDavid SteinIntermediate
Building an Effective Data Warehouse ArchitectureJames SerraBeginner
Care and Feeding of Your System DatabasesVicky HarpBeginner
Change Tracking: A Near Bullet-Proof ETL Synchronization ControlMike ByrdIntermediate
Cisco Unified Computing System (UCS)Bill ShieldsBeginner
Converting Unreliable Deployments Into Consistent ReleasesTom NormanIntermediate
Data Quality ServicesGarrett EdmondsonIntermediate
Data Warehouse Architectures and PerformanceGarrett EdmondsonIntermediate
Data Warehouse ETLGarret EdmondsonIntermediate
Data Warehouse IndexesGlenda GableBeginner
Database Design Contentious IssuesKaren LopezIntermediate
DBA Career RoadmapJennifer McCownBeginner
Designing Stored Procedure SolutionsJennifer McCownBeginner
DIY Performance ReportingSean McCownIntermediate
Duration, CPU and Reads ... all you need to troubleshoot most Performance issuesCarlos LopezIntermediate
Edge Case Testing for the Database ProfessionalVicky HarpBeginner
Enhancing your career: Building your personal brandJames SerraBeginner
Execution Plan Basics - BeginnersThomas LeBlancBeginner
Execution Plan Beyond BasicsThomas LeBlancAdvanced
Expand your TSQL: Intersect, Except, and ApplyRudy RodarteBeginner
Fill Factor: Performance or Nuisance?Bill BarnesIntermediate
Fundamentals of SAN, NAS and IP StorageWesley BrownIntermediate
Getting Started with Hekaton (In-Memory OLTP)Brian DavisBeginner
Getting Started with SSAS Tabular and PowerViewDerek WilsonBeginner
Goodbye Next Next Next, Hello Automated InstallsBrian DavisIntermediate
How Active Directory affects SQL ServerRyan AdamsAdvanced
In-Memory Columnstore Indexes--Make Your Data Warehouse Fly Joseph D'AntoniIntermediate
Introduction to BIML and BIMLScriptRuss LoskiIntermediate
Introduction to PowerBIMark MooreBeginner
Introduction to Powershell cmdlets for DBAsJennifer McCownBeginner
Lightning TalksHouston Area SQL Server User GroupBeginner
Lunch BreakSQLSaturday 308Non-Technical
Making the Leap from Developer to DBAAmy HeroldNon-Technical
Measuring Data Warehouse PerformanceGarret EdmondsonAdvanced
Microsoft Predictive Analytics/Data Mining OverviewCarl SpeshockIntermediate
Mind your IO: Resource Governor shows you HowAmit R S BansalIntermediate
Mission Possible: Interactive Performance Troubleshooting - IndexesJim MurphyBeginner
Mission Possible: Interactive Performance Troubleshooting - TSQLJim MurphyBeginner
Modern Data WarehousingJames SerraBeginner
Net Income Analysis with SSAS Garrett EdmondsonIntermediate
Optimizing Protected IndexesChris BellIntermediate
Performance Benefits of Data CompressionMike ByrdIntermediate
Power BI for Office 365James SerraBeginner
Power Query and PowerPivot - Data Analysis on your DesktopRuss LoskiBeginner
Pro Tips: Tuning the data flow in SSISTim CostelloIntermediate
Proactive Monitoring with PBM and CMSJohn SterrettIntermediate
RaffleSQLSaturday 308Non-Technical
Random Acts of Senseless DatabasingKris HokansonBeginner
REGEX for DBAsSean McCownIntermediate
RegistrationsSQLSaturday 308Non-Technical
Resolving the Database Performance Problem Blame Game Amit ParikhBeginner
Scripting in SSISTim MitchellBeginner
Self Service Dashboarding made easy Tim CostelloBeginner
Source Code Control: Revision management for the data dude.Tim CostelloBeginner
Speed, Depth & Flexibility - Having it all with real-time SSASAashish ParekhIntermediate
SQL 2012 AlwaysOn QuickstartRyan AdamsBeginner
SQL Server 2012 AlwaysON (HADR) for dummiesRohan JoackhimIntermediate
SQL Server 2012 Analytic FunctionsJohn CookAdvanced
SQL Server 2014 OLTP Deep DiveScott KleinAdvanced
SQL Server Agent: The life preserver for the drowning DBALance TidwellBeginner
SQL Server Bingo – Install, Migration & ConfigMindy CurnuttBeginner
SQL Server Collations and RegionalizationVicky HarpIntermediate
SQL Server Statistics – What Are The Chances?Lori EdwardsBeginner
SQL Server--All About HA and DRJoseph D'AntoniIntermediate
SQL Server's In Memory Database ObjectsDenny CherryIntermediate
SQL Watchdog - find out instantly when SQL changes in productionMichael BourgonIntermediate
SSAS - An Introduction to Multidimensional CubesRobert StewartIntermediate
SSIS Design ThoughtsDerek DaiAdvanced
SSIS project deployments with multiple developersRuss LoskiAdvanced
SSIS Templates Can Make Your Life EasierBrian DavisBeginner
Storage For the DBADenny CherryIntermediate
Strategy to Eliminate BottlenecksMatt HendersonBeginner
Supercharging SQLDean NelsonBeginner
Table Indexing for the .NET DeveloperDenny CherryIntermediate
Table Partitioning: the Secret Weapon for your Big Data Problems.John SterrettIntermediate
Tabular Data Visualized by PowerViewDerek WilsonBeginner
Tame the distributed data beastKris HokansonIntermediate
Taming the T-LogDane SchillingBeginner
The Cloud and IValentino and Anthony {Tex} MoreignBeginner
The Importance of Networking for IT ProfessionalsDana ManciagliBeginner
The Lost Science of Set Theory and Relational AlgebraAaron CutshallBeginner
The Spy Who Loathed Me - An Intro to SQL Security Chris BellBeginner
The Transaction Log InternalsCarlos LopezAdvanced
Top 5 SQL Server 2014 Hybrid FeaturesScott KleinIntermediate
Top 5 Ways to Write Effective triggersAaron BertrandIntermediate
Trace Flags for DevelopersMike HaysBeginner
Transitioning to a BI roleJames SerraBeginner
Troubleshooting Your Network ConnectionsMike HaysBeginner
T-SQL : Bad Habits & Best PracticesAaron BertrandIntermediate
T-SQL Code Sins Jennifer McCownBeginner
Understanding BackupsSean McCownBeginner
Understanding Storage Systems and SQL ServerWesley BrownBeginner
What exactly is Business Intelligence?James SerraBeginner
What I learned with the Hekaton POCPeter TranIntermediate
Why a Company Should Consider DW/BIJames SerraBeginner
Windowing FunctionsTim CostelloBeginner
Windows Azure SQL Database Design: Concepts and Trade-offsKaren LopezIntermediate
Writing Your First BimlScriptDavid SteinBeginner


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
SQL Server 2012 Analytic Windowing FunctionsAdvanced

SQLSaturday Home
PASS