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 TimeBI I - Room: TBDBI II - Room: TBDDBA I - Room: Room 2DBA II - Room: TBDMisc - Room: TBDProfessional Development - Room: TBDSQL 2014 - Room: Room 1
08:30 AMJohn Miner

Effective Data Warehouse Storage Patterns

Level: Advanced
Josh Fennessy

Visual Analytics with HDInsight and Power View

Level: Beginner
Wayne Sheffield

Table Vars & Temp Tables - What you NEED to Know!

Level: Intermediate
Brandon Leach

Treating Tables Like Legos, Partitioning Basics

Level: Beginner
Ayman El-Ghazali

SQL Server Backup and Recovery Fundamentals

Level: Beginner
Paul Rizza

Getting a job with Microsoft

Level: Non-Technical
Allan Hirt

Hybrid Solutions: The Future of SQL Server Disaster Recovery

Level: Intermediate
09:45 AMKerry Tyler

45 Minutes to Your First SSAS Tabular Model

Level: Beginner
Paul Rizza

ETL not ELT! Common mistakes and misconceptions about SSIS

Level: Advanced
Grant Fritchey

Common Problems in Backup and Recovery and How to Handle Them

Level: Beginner
Steve Hood

Indexing Fundamentals

Level: Intermediate
Carlos Chacon

Your SQL Server Environment--Fair or Foul?

Level: Beginner
Dominic Falso

Parsing T-SQL using the TransactSql.ScriptDom library (C#)

Level: Advanced
Joseph D'Antoni

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

Level: Intermediate
11:00 AMStacia Misner

Introducing Power BI

Level: Beginner
Mark Vaillancourt

Analysis Services Terms and Concepts for the DBA

Level: Intermediate
Konstantin Melamud

Performance Tuning - Index Optimization

Level: Beginner
Sebastian Meine

Securing a Multi-Database Application

Level: Intermediate
Ashton Hobbs

Using Apache Solr with SQL for Text Searching

Level: Intermediate
Chris Schmidt

The Business Intelligence Management Data Mart

Level: Advanced
David Bermingham

High Availability with Windows Server 2012 R2 and SQL Server 2014

Level: Intermediate
01:30 PMDan Clark

Using Hive to Query and Process Big Data

Level: Beginner
Ravi Kumar

Think like SSIS and Build a package

Level: Beginner
Edward Pollack

(a Few of) My Favorite DMVs

Level: Intermediate
Karen Lopez

Database Design Contentious Issues

Level: Intermediate
Robert Pearl

DBA for Dummies

Level: Beginner
Josh Fennessy

Failure Lab: An exploration into the benefits of failing

Level: Non-Technical
Timothy Corey

Practical SQL Azure: Moving into the Coud

Level: Beginner
02:45 PMLeonard Lobel

Database Development with SQL Server Data Tools

Level: Intermediate
Joshua Lynn

Bulk Insert, Temp Tables & Computed Columns, T-SQL Techniques

Level: Intermediate
Chris Bell

The Spy Who Loathed Me - An Intro to SQL Security

Level: Beginner
Steve Simon

SQL Server Reporting Services Best Practices

Level: Intermediate
Jeff Burke

Analysis Services Relational Querying – Why Bother?

Level: Intermediate
Jason Brimhall

SQL 2012 Table Compression

Level: Advanced
Timothy McAliley

Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window Azure

Level: Intermediate
04:00 PMMark Wojciechowicz

Optimizing Bulk Insert Operations

Level: Intermediate
Mark Hudson

Put Your Data on the Map

Level: Beginner
Warner Chaves

The Super Trace: Introduction to Extended Events

Level: Intermediate
Slava Murygin

Extended Properties and how to automate DB Documenting process.

Level: Beginner
Justin Dearing

Auditing and administering SQL Server with Powershell

Level: Intermediate
Tamera Clark

Designing & Formatting Reports

Level: Beginner
Brian Davis

Getting Started with Hekaton (In-Memory OLTP)

Level: Beginner


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
Basic Database Design John MinerBeginner
Basic Database ProgrammingJohn MinerBeginner
Full Text Indexing BasicsJohn MinerIntermediate
The Spy Who Loathed Me - An Intro to SQL SecurityChris BellBeginner
$#*! Your Database Says About MeKaren LopezBeginner
(a Few of) My Favorite DMVsEdward PollackIntermediate
45 min to build your first SSRS reportTamera ClarkBeginner
45 Minutes to Your First SSAS Tabular ModelKerry TylerBeginner
A dive into Data Quality ServicesSteve SimonIntermediate
Advanced Tabular DevelopmentChris SchmidtAdvanced
An introduction to Data MiningSteve SimonIntermediate
An Introduction to SQLCLRJustin DearingIntermediate
Analysis Services Relational Querying – Why Bother?Jeff BurkeIntermediate
Analysis Services Terms and Concepts for the DBAMark VaillancourtIntermediate
Auditing and administering SQL Server with PowershellJustin DearingIntermediate
Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window AzureTimothy McAlileyIntermediate
Best Practices for Database DeploymentGrant FritcheyIntermediate
Best Practices for maintaining your Very Large DatabasesWarner ChavesIntermediate
Best SQL Server Programming practicesSlava MuryginBeginner
Building Your First Tabular ModelDan ClarkBeginner
Bulk Insert, Temp Tables & Computed Columns, T-SQL TechniquesJoshua LynnIntermediate
Business Continuity: The Real Reason for HA and DRAllan HirtBeginner
Challenges to designing financial warehouses, lessons learntSteve SimonIntermediate
Common Problems in Backup and Recovery and How to Handle ThemGrant FritcheyBeginner
Crazy Things That Developers DoWayne SheffieldBeginner
Creating efficient and effective SSRS BI SolutionsSteve SimonIntermediate
DANGER: The Art and Science of PresentingMark VaillancourtBeginner
Database Design Contentious IssuesKaren LopezIntermediate
Database design for mere developersSteve SimonIntermediate
Database Development with SQL Server Data ToolsLeonard LobelIntermediate
DAX and the tabular modelSteve SimonIntermediate
DBA for DummiesRobert PearlBeginner
Designing & Formatting ReportsTamera ClarkBeginner
Designing SSIS Solutions for Performance and ScalabilityJon TupitzaIntermediate
Diving Into Query Execution PlansEdward PollackIntermediate
Effective Data Warehouse Storage PatternsJohn MinerAdvanced
ETL not ELT! Common mistakes and misconceptions about SSISPaul RizzaAdvanced
Extended Properties and how to automate DB Documenting process. Slava MuryginBeginner
Extended Properties and how to automate DB Documenting process. Slava MuryginBeginner
Failure Lab: An exploration into the benefits of failingJosh FennessyNon-Technical
Floating on a Hybrid Cloud: SQL Server 2014 & Windows Azure Timothy McAlileyIntermediate
Geospatial Data Types in SQL Server 2012Leonard LobelIntermediate
Get your Mining Model Predictions out to allSteve SimonIntermediate
Getting a job with Microsoft Paul RizzaNon-Technical
Getting Started with Hekaton (In-Memory OLTP)Brian DavisBeginner
HealthySQL 2.0Robert PearlBeginner
High Availability and Disaster Recovery in the Microsoft Azure CloudDavid BerminghamIntermediate
High Availability and Disaster Recovery in the Microsoft Azure CloudDavid BerminghamIntermediate
High Availability with Windows Server 2012 R2 and SQL Server 2014David BerminghamIntermediate
How to audit and prevent unwanted user actions.John MinerIntermediate
Hybrid Solutions: The Future of SQL Server Disaster RecoveryAllan HirtIntermediate
Implementing a HIPAA Compliance Strategy with SQL ServerBrandon LeachBeginner
Implementing Data Warehouse Patterns with the Microsoft BI ToolsKevin GoffIntermediate
Indexing FundamentalsSteve HoodIntermediate
In-Memory Columnstore Indexes--Make Your Data Warehouse Fly Joseph D'AntoniIntermediate
Inside of IndexesSlava MuryginIntermediate
Introducing DAXChris SchmidtBeginner
Introducing Power BIStacia MisnerBeginner
Introduction to Modeling Data Marts and WarehousesJon TupitzaBeginner
Introduction to Windows Azure HDInsightJon TupitzaBeginner
Judge, Jury, and Executioner--A First Look At Execution PlansCarlos ChaconBeginner
Making Predictions with Microsoft Data Mining ToolsMark HudsonIntermediate
Manageable SSAS Deployment StrategiesKerry TylerBeginner
Master Data Services Best PracticesSteve SimonIntermediate
Master Data Services Disaster RecoverySteve SimonIntermediate
Mastering Date-Time Based Analysis in DAXDan ClarkIntermediate
MDX Trek: First ContactMark VaillancourtIntermediate
Mind your language!! Cursors are a dirty wordSteve SimonIntermediate
Monitoring Server health via Reporting Services dashboardsSteve SimonIntermediate
Monitoring Server health via Reporting Services dashboardsSteve SimonIntermediate
Native File Streaming with SQL Server 2012Leonard LobelIntermediate
Optimizing Bulk Insert OperationsMark WojciechowiczIntermediate
Optimizing Protected IndexesChris BellIntermediate
Parsing T-SQL using the TransactSql.ScriptDom library (C#)Dominic FalsoAdvanced
Patch Management Strategies for SQL ServerAllan HirtIntermediate
Performance Tuning - Analyzing Execution PlansKonstantin MelamudIntermediate
Performance Tuning - Index OptimizationKonstantin MelamudBeginner
Performance Tuning - TSQLKonstantin MelamudIntermediate
Power View: A Peek Behind the CurtainStacia MisnerBeginner
Practical SQL Azure: Moving into the CoudTimothy CoreyBeginner
Programming T-SQL Enhancements in SQL Server 2012Leonard LobelIntermediate
Put Your Data on the MapMark HudsonBeginner
Query Optimization Crash CourseEdward PollackBeginner
Securing a Multi-Database ApplicationSebastian MeineIntermediate
SQL 2012 Table CompressionJason BrimhallAdvanced
SQL Server Backup and Recovery FundamentalsAyman El-GhazaliBeginner
SQL Server Cryptology PrimerSebastian MeineIntermediate
SQL Server Dos and Don'ts: Keys to DBA NirvanaAllan HirtBeginner
SQL Server Indexing FundamentalsAyman El-GhazaliBeginner
SQL Server Internals Party: Storage, Memory and the Query Life-cycleAyman El-GhazaliBeginner
SQL Server Reporting Services Best PracticesSteve SimonIntermediate
SQL Server Reporting Services, attendees chooseKevin GoffIntermediate
SSAS Tabular 2012 vs SSAS Multidimensional OLAPKevin GoffIntermediate
SSIS Templates Can Make Your Life EasierBrian DavisBeginner
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
Tabular versus Multidimensional: May the Best Model WinStacia MisnerBeginner
The Business Intelligence Assembly Line – When Speed to Delivery MattersJeff BurkeIntermediate
The Business Intelligence Management Data MartChris SchmidtAdvanced
The Data Whisperer: Detecting & Extracting Meaning From Changing DataJoshua LynnIntermediate
The Super Trace: Introduction to Extended Events Warner ChavesIntermediate
The Use Cases for In-Memory OLTPWarner ChavesIntermediate
Think like SSIS and Build a packageRavi KumarBeginner
Transnational Replication-10 steps for successful implementationKonstantin MelamudIntermediate
Treating Tables Like Legos, Partitioning BasicsBrandon LeachBeginner
T-SQL for Application Developers - Attendees choseKevin GoffIntermediate
Update Statistics is not a Silver BulletSlava MuryginAdvanced
Using Apache Solr with SQL for Text SearchingAshton HobbsIntermediate
Using Hive to Query and Process Big DataDan ClarkBeginner
Using SQL Server Security Features to Satisfy Custom Regulatory RequirementsJon TupitzaIntermediate
Using SQL Server Security Features to Satisfy Custom Regulatory RequirementsJon TupitzaIntermediate
Visual Analytics with HDInsight and Power ViewJosh FennessyBeginner
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate
Windows Azure SQL Database – SQL Server in the CloudLeonard LobelIntermediate
Your SQL Server Environment--Fair or Foul?Carlos ChaconBeginner


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