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 TimeTrack 1 - Room: 100Track 2 - Room: 105Track 3 - Room: 106Track 4 - Room: 108Track 5 - Room: 109Track 6 - Room: 110Track 7 - Room: 111
07:30 AMSQLSaturday 255

Registrations

Level: Non-Technical
SQLSaturday 255

Registrations

Level: Non-Technical
SQLSaturday 255

Registrations

Level: Non-Technical
SQLSaturday 255

Registrations

Level: Non-Technical
SQLSaturday 255

Registrations

Level: Non-Technical
SQLSaturday 255

Registrations

Level: Non-Technical
SQLSaturday 255

Registrations

Level: Non-Technical
08:00 AMSQLSaturday 255

Opening

Level: Non-Technical
SQLSaturday 255

Opening

Level: Non-Technical
SQLSaturday 255

Opening

Level: Non-Technical
SQLSaturday 255

Opening

Level: Non-Technical
SQLSaturday 255

Opening

Level: Non-Technical
SQLSaturday 255

Opening

Level: Non-Technical
SQLSaturday 255

Opening

Level: Non-Technical
08:30 AMDavid Stein

Biml - The Next Step in Agile Data Warehousing

Level: Intermediate
Ami Levin

Physical Join Operators

Level: Advanced

download
Mark Rosenberg

Optimizing Stored Procedures

Level: Intermediate

download
Mike Byrd

Nuts and Bolts of Table Compression

Level: Intermediate

download
Vicky Harp

Care and Feeding of Your System Databases

Level: Beginner

download
Allen Smith

Intro to SharePoint BI

Level: Beginner

download
Kathi Kellenberger

Women in Tech Panel

Level: Beginner
09:30 AMSQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
09:45 AMRyan Adams

SQL 2012 AlwaysOn Quickstart

Level: Beginner

download
Bryan Smith

Let's Hadoop!

Level: Beginner

download
Mark Verret

Introduction to SQL Spatial Analysis and Reporting

Level: Intermediate

download
Tim Costello

Window Functions in SQL Server 2012

Level: Intermediate
Chaitanya Khaladkar

Real-Time Analytics with Power View and SSAS Tabular in DirectQuery Mode

Level: Intermediate

download
Christine Assaf

Mastering your Resume & Interview: Tips to Get Hired

Level: Beginner
Matthew Brimer

SQL Security Best Practices & Shrinking Your Attack Surface

Level: Intermediate

download
10:45 AMSQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
11:00 AMAndy Leonard

Hacking the SSIS 2012 Catalog

Level: Beginner
Mike Hotek

SQL Server 2014 – In memory OLTP Development

Level: Intermediate

download
Denzil Ribeiro

SQL Transaction Log Internals

Level: Advanced

download
Jeff Johnston

Analytical MDM with Master Data Services 2012

Level: Intermediate

download
Steven Ormrod

SQL Server Amnesia - Memory Troubleshooting

Level: Beginner

download
Juan Soto

Wish you could live the glamorous consulting life?

Level: Beginner
Russ Loski

SSRS data driven subscription using SSIS

Level: Advanced

download
12:00 PMMicrosoft Lunch Session

Welcome to SQLServer 2014

Level: Beginner
Violin Memory Lunch Session

Overview of flash storage technologies, effective deployment strategies, and how they modernize DBs.

Level: Beginner
Dell Lunch Session

A New Paradigm for Database Performance Monitoring

Level: Beginner
Corsource Lunch Session

Transform your Company with Business Intelligence

Level: Beginner
Pure Storage Lunch Session

Pure Storage

Level: Beginner
Slalom Lunch Session

5 ways to amaze your boss with Microsoft BI

Level: Beginner
SQLSaturday 255

Lunch Break

Level: Non-Technical
01:30 PMWilliam Assaf

SQL Server Permissions and Security Principals

Level: Beginner

download
Tim Mitchell

Make Your SSIS Packages Run Faster: 15 Quick Tips

Level: Intermediate
marek koenig

Tell Better Stories with Microsoft BI and PowerMap

Level: Beginner

download
Rohit Nayak

Moving to Windows Azure SQL Database(WASD)

Level: Intermediate

download
Glenda Gable

The ABCs of SSIS

Level: Beginner

download
Christine Assaf

Interview Tips for Managers

Level: Beginner

download
Hakim Ali

T-SQL Throwdown

Level: Intermediate
02:30 PMSQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
02:45 PMJoe Celko

Nested Sets model for Trees & Hierarchies

Level: Intermediate
Suresh Kandoth

Explore and Troubleshoot the power-packed new features of SQL Server 2014

Level: Intermediate

download
Reinaldo Kibel

Tips and Tricks for architecting a BI infrastructure on SQL 2012 Power View

Level: Advanced

download
Russ Loski

Introduction to the XML source

Level: Intermediate

download
Michael Bourgon

Master of All I Survey - track code changes and more across your environment

Level: Intermediate

download
AJ Mendo

Without A SQLTrace-Getting To Know Extended Events

Level: Beginner

download
Sri Sridharan

Turbo charge your DBA career

Level: Beginner
03:45 PMSQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
SQLSatruday 255

Coffee Break

Level: Non-Technical
04:00 PMGrant Fritchey

Common Problems in Backup and Recovery and How to Handle Them

Level: Beginner
John Sterrett

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

Level: Beginner
Greg Galloway

Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services

Level: Intermediate

download
Mike Hotek

Extreme Design – A Real World 10+ Exabyte Data Warehouse

Level: Intermediate

download
Erin Welker

A Systematic Approach to ETL Performance Tuning

Level: Intermediate

download
Pat Sinthusan

Leveraging Flash Technologies for Increased SQL Server Performance

Level: Intermediate
Kathi Kellenberger

Writing Better Queries with Window Functions

Level: Advanced

download
05:15 PMSQLSaturday 255

Raffle

Level: Non-Technical
SQLSaturday 255

Raffle

Level: Non-Technical
SQLSaturday 255

Raffle

Level: Non-Technical
SQLSaturday 255

Raffle

Level: Non-Technical
SQLSaturday 255

Raffle

Level: Non-Technical
SQLSaturday 255

Raffle

Level: Non-Technical
SQLSaturday 255

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
“I See a Control Flow Tab. Now What?” (Level 100)Andy LeonardBeginner
5 ways to amaze your boss with Microsoft BISlalom Lunch SessionBeginner
7 Great things you can do to improve and manage customer relationshipsJuan SotoBeginner
A heap of clustersAmi LevinAdvanced
A New Paradigm for Database Performance MonitoringDell Lunch SessionBeginner
A Systematic Approach to ETL Performance TuningErin WelkerIntermediate
Agile Data Warehouse DesignTim CostelloBeginner
An Introduction to High Performance ComputingBryan SmithBeginner
An Introduction to NoSQL with Azure Table Services & Azure CachingBryan SmithBeginner
Analytical MDM with Master Data Services 2012Jeff JohnstonIntermediate
Asynchronous Messaging with Service BrokerEric HumphreyIntermediate
Automate your daily checklist with PBM and CMSJohn SterrettIntermediate
Best Practices for Database DeploymentGrant FritcheyIntermediate
Biml - The Next Step in Agile Data WarehousingDavid SteinIntermediate
Build a Scalable Data Validation FrameworkMike HotekIntermediate
Building Your First AlwaysOn Failover Cluster InstanceJohn SterrettBeginner
Care and Feeding of Your System DatabasesVicky HarpBeginner
Change Tracking: A Near Bullet-Proof ETL Synchronization ControlMike ByrdIntermediate
Coffee BreakSQLSatruday 255Non-Technical
Column Level EncryptionDavid DyeBeginner
Common Problems in Backup and Recovery and How to Handle ThemGrant FritcheyBeginner
ConfigMgr 2012 - Whats the big deal?Steven RachuiBeginner
Creating an SSIS template using BIMLRuss LoskiIntermediate
Creating an SSIS template using BIMLRuss LoskiIntermediate
Data cleaning with SSIS - SQL 2012Mark VerretBeginner
Data Modeling – From Conceptual Model to Database DeploymentMike HotekIntermediate
Data Quality Framework - Fixing the Garbage PileMike HotekIntermediate
DBA Survival Guide: Daily Checklist and Server MonitoringAJ MendoBeginner
Dealing With Errors in SSIS 2012David DyeAdvanced
Designing a Scalable, Flexible SSIS FrameworkMike HotekIntermediate
Enhancing your BI Solution with Power BI Jeff JohnstonBeginner
Explore and Troubleshoot the power-packed new features of SQL Server 2014Suresh KandothIntermediate
Explore the cloud options for a SQL Server DBASuresh KandothIntermediate
Extreme Design – A Real World 10+ Exabyte Data WarehouseMike HotekIntermediate
Getting Control of Your Data - Master Data ManagementMike HotekIntermediate
Giving FeedbackChristine AssafBeginner
Good habits with dynamic SQLKenneth FisherBeginner
Hacking the SSIS 2012 CatalogAndy LeonardBeginner
Heterogeneous systems management with ConfigMgr 2012 - Unix/Linux/Mac/DevicesSteven RachuiIntermediate
High Performance Aggregates Using Windows FunctionsMike HotekAdvanced
Implement High Performance, Agile, BI MethodologyMike HotekIntermediate
Implementing Auditing in SQL Server 2012David DyeBeginner
Indexes: The BasicsKathi KellenbergerBeginner
Interview Tips for ManagersChristine AssafBeginner
Intro to SharePoint BIAllen SmithBeginner
Intro to T-SQLMark RosenbergBeginner
Introduction to Business IntelligenceGanesh LohaniBeginner
Introduction to BIG DATASuresh RajappaIntermediate
Introduction to BIML and BIMLScriptRuss LoskiIntermediate
Introduction to SQL Spatial Analysis and ReportingMark VerretIntermediate
Introduction to the XML sourceRuss LoskiIntermediate
Is AlwaysOn really as powerful? Tips and Tricks from the fieldReinaldo KibelAdvanced
Kung Fu Migration to Windows Azure SQL DatabaseScott KleinIntermediate
Let's Hadoop!Bryan SmithBeginner
Let's Hadoop! Part 1Bryan SmithBeginner
Let's Hadoop! Part 2Bryan SmithBeginner
Leveraging Flash Technologies for Increased SQL Server PerformancePat SinthusanIntermediate
Lunch BreakSQLSaturday 255Non-Technical
Make Your SSIS Packages Run Faster: 15 Quick TipsTim MitchellIntermediate
Managing Hierarchies in SQL ServerMike HotekIntermediate
Master of All I Survey - track code changes and more across your environmentMichael BourgonIntermediate
Mastering your Resume & Interview: Tips to Get HiredChristine AssafBeginner
Moving to Windows Azure SQL Database(WASD)Rohit NayakIntermediate
MS Access with SQL Server Strategies and TipsJuan SotoBeginner
Nested Sets model for Trees & Hierarchies Joe CelkoIntermediate
Nuts and Bolts of Table CompressionMike ByrdIntermediate
OpeningSQLSaturday 255Non-Technical
Operational Recovery and why it’s different from Disaster RecoveryKenneth FisherBeginner
Optimizing Stored ProceduresMark RosenbergIntermediate
Overview of flash storage technologies, effective deployment strategies, and how they modernize DBs.Violin Memory Lunch SessionBeginner
Performance Tuning of Tabular Models in SQL Server 2012 Analysis ServicesGreg GallowayIntermediate
Physical Join OperatorsAmi LevinAdvanced
Pure StoragePure Storage Lunch SessionBeginner
RaffleSQLSaturday 255Non-Technical
Real-Time Analytics with Power View and SSAS Tabular in DirectQuery ModeChaitanya KhaladkarIntermediate
RegistrationsSQLSaturday 255Non-Technical
Run Laps around SQL Error Logs with Excel on SteroidsPeter O'GormanBeginner
Running SQL Server in a Windows Azure Virtual Machine – Deep DiveScott KleinAdvanced
Speeding Up Aggregations with Indexed ViewsSteven OrmrodBeginner
SQL 2012 AlwaysOn QuickstartRyan AdamsBeginner
SQL Admin Best Practices with DMV'sWilliam AssafIntermediate
SQL for the ConfigMgr AdminSteven RachuiIntermediate
SQL Security Best Practices & Shrinking Your Attack SurfaceMatthew BrimerIntermediate
SQL Server 2014 – In memory OLTP DevelopmentMike HotekIntermediate
SQL Server 2014 – In memory OLTP ManagementMike HotekIntermediate
SQL Server Amnesia - Memory TroubleshootingSteven OrmrodBeginner
SQL Server IndexingMike HotekAdvanced
SQL Server Permissions and Security PrincipalsWilliam AssafBeginner
SQL Server Statistics InternalsMike HotekAdvanced
SQL Server Storage InternalsMike HotekAdvanced
SQL Server Unit TestingMike HotekIntermediate
SQL Transaction Log InternalsDenzil RibeiroAdvanced
SSIS 2012 Configuration and Deployment EnhancementsBrian GogleIntermediate
SSIS Configurations Vs. ParametersAllen SmithIntermediate
SSRS data driven subscription using SSISRuss LoskiAdvanced
Table Partitioning: the Secret Weapon for your Big Data Problems.John SterrettBeginner
Tableau: Delivering Self-Serve BITim CostelloBeginner
Tell Better Stories with Microsoft BI and PowerMapmarek koenigBeginner
The ABCs of SSISGlenda GableBeginner
The Art of the Mythical DemoMike HotekIntermediate
The BI DBARandy DyessAdvanced
The WINDOW or OVER() clauseJoe CelkoIntermediate
Tips and Tricks for architecting a BI infrastructure on SQL 2012 Power ViewReinaldo KibelAdvanced
Tips and Tricks for Virtualization and Consolidation of SQLReinaldo KibelAdvanced
Transform your Company with Business IntelligenceCorsource Lunch SessionBeginner
Troubleshooting ConfigMgr like a prSteven RachuiAdvanced
T-SQL ThrowdownHakim AliIntermediate
T-SQL Tips & TricksAaron CutshallIntermediate
T-SQL Tips & Tricks Part 2Aaron CutshallIntermediate
Turbo charge your DBA careerSri SridharanBeginner
Turn Data into an Asset - Enterprise Data GovernanceMike HotekIntermediate
Using BIML as an SSIS Design Patterns Engine Andy LeonardAdvanced
Using PowerShell With SQL ServerRandy DyessAdvanced
Welcome to SQLServer 2014Microsoft Lunch SessionBeginner
Where did I put my (primary) keys?Ami LevinAdvanced
Why You Should Achieve CertificationRandy DyessBeginner
Window Functions in SQL Server 2012Tim CostelloIntermediate
Windows Azure SQL Database for the DBAScott KleinIntermediate
Windows Azure SQL Database Troubleshooting and Query Tuning Scott KleinAdvanced
Wish you could live the glamorous consulting life?Juan SotoBeginner
Without A SQLTrace-Getting To Know Extended EventsAJ MendoBeginner
Women in Tech PanelKathi KellenbergerBeginner
Writing Better Queries with Window FunctionsKathi KellenbergerAdvanced


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.

SQLSaturday Home
PASS