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: 30th StreetBI II - Room: WynewoodDBA I - Room: MRP IIDBA II - Room: MRP IIIMisc - Room: EBCProfessional Development - Room: BerwynSQL 2014 - Room: MRP I
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

download
Brandon Leach

Treating Tables Like Legos, Partitioning Basics

Level: Beginner
Ayman El-Ghazali

SQL Server Backup and Recovery Fundamentals

Level: Beginner

download
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 AMTamera Clark

Designing & Formatting Reports

Level: Beginner

download
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

download
Konstantin Melamud

Performance Tuning - Index Optimization

Level: Beginner
Karen Lopez

Database Design Contentious Issues

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

download
12:00 PM    Panel Discussion

Beyond Stereotypes: Equality, Gender Neutrality, and Valuing Team Diversity

Level: Beginner
  
12:30 PM  Allan Hirt and SIOS Technology

Clusters Your Way - #SANLess clusters for physical, virtual and cloud environments

Level: Non-Technical
Saska Cvetkovic

ApexSQL Tools

Level: Beginner
  James Davis

Advanced Performance Tuning Tips with Database Performance Analyzer

Level: Beginner
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

download
Sebastian Meine

Securing a Multi-Database Application

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 Cloud

Level: Beginner

download
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

download
Steve Simon

SQL Server Reporting Services Best Practices

Level: Intermediate

download
Jeff Burke

Analysis Services Relational Querying – Why Bother?

Level: Intermediate

download
Jason Brimhall

SQL 2012 Table Compression

Level: Advanced

download
Timothy McAliley

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

Level: Intermediate

download
04:00 PMMark Wojciechowicz

Optimizing Bulk Insert Operations

Level: Intermediate

download
Mark Hudson

Put Your Data on the Map

Level: Beginner
Warner Chaves

The Super Trace: Introduction to Extended Events

Level: Intermediate

download
Slava Murygin

Extended Properties and how to automate DB Documenting process.

Level: Beginner

download
Justin Dearing

An Introduction to SQLCLR

Level: Intermediate
Kerry Tyler

45 Minutes to Your First SSAS Tabular Model

Level: Beginner

download
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 Performance Tuning Tips with Database Performance Analyzer James DavisBeginner
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
ApexSQL ToolsSaska CvetkovicBeginner
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
Beyond Stereotypes: Equality, Gender Neutrality, and Valuing Team DiversityPanel DiscussionBeginner
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
Clusters Your Way - #SANLess clusters for physical, virtual and cloud environmentsAllan Hirt and SIOS TechnologyNon-Technical
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
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 CloudTimothy 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
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