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: Room ATrack 2 - Room: Room BTrack 3 - Room: Room CTrack 4 - Room: Room DTrack 5 - Room: Room ETrack 6 - Room: Room FTrack 7 - Room: Room GTrack 8 - Room: Room H
08:30 AMSQLSaturday 235

Kickoff / Keynote

Level: Non-Technical
SQLSaturday 235

Kickoff / Keynote

Level: Non-Technical
      
09:00 AMThomas LaRock

Database Design: Size DOES Matter

Level: Intermediate
Jeffrey Garbus

Indexing for performance

Level: Intermediate
David Klee

Database Health and Performance

Level: Intermediate

download
Michael Corey

Virtualizing SQL 2012: Doing It Right

Level: Intermediate
Ted Krueger

Upgrading to SQL Server 2012 with limited downtime

Level: Beginner
David Dye

Dealing With Errors in SSIS 2012

Level: Advanced
Carl Berglund

How to Create a Self-Managed SQL Server Utility without SQL Server Enterprise Edition

Level: Intermediate
Timothy McAliley

A Walk Around the SQL Server 2012 Audit Feature

Level: Intermediate

download
10:15 AMKevin Kline

SQL Server Internals and Architecture

Level: Intermediate

download
Ben DeBow

Surviving Your Peak Database Load

Level: Intermediate
Robert Pearl

HealthySQL

Level: Beginner
Stacia Misner

Using Power View & Hadoop to Unlock Hidden Markets

Level: Beginner

download
Allan Hirt

Patch Management Strategies for SQL Server

Level: Beginner
Paul Rizza

ETL not ELT! Common mistakes and misconceptions about SSIS

Level: Advanced
Virginia Mushkatblat

Data Flow Architectures in Software Development Life-Cycle

Level: Intermediate
Kevin Feit

SQL Server Sudoku Solver using Transact-SQL

Level: Beginner

download
11:30 AMSQLSaturday 235

Lunch / Vendor Presentations: SIOS, Bridgewater, Pragmatic Works

Level: Non-Technical
SQLSaturday 235

Lunch / Vendor Presentations: SIOS, Bridgewater, Pragmatic Works

Level: Non-Technical
Melissa Demsak / Kathi Kellenberger

WIT Panel / Lunch

Level: Non-Technical
     
12:30 PMSteve Simon

Alright,WHY is the server REALLY running so slow!

Level: Intermediate

download
Alex Grinberg

Advanced T-SQL Development with latest features.

Level: Intermediate

download
George Walters

SQL Server 2012 AlwaysOn Availability Groups

Level: Beginner

download
Wayne Sheffield

Minimally Invasive - Tools to Doctor Up Your Code

Level: Intermediate

download
Edwin Sarmiento

The Transaction Log and How It Affects HA/DR

Level: Advanced

download
Martin Schoombee

The 10 Commandments of ETL

Level: Beginner

download
John Morehouse

SQL Server Databaseology 201

Level: Intermediate

download
John Miner

How to audit and prevent unwanted user actions.

Level: Intermediate

download
01:45 PMAndrew Brust

Big Data-BI Fusion: Microsoft HDInsight & MS BI

Level: Intermediate

download
Joseph D'Antoni

Into the Blue: Extending AlwaysOn Availability Groups

Level: Intermediate
Troy Gallant

Indexing your Data Warehouse

Level: Intermediate
Ashish Sharma

SQL Server 2014 - Staying Ahead of the curve

Level: Intermediate
Karen Lopez

Windows Azure SQL Database Design: Silver Lining and Dark Side

Level: Intermediate
Steve Hughes

Building BI Solutions with Excel 2013

Level: Beginner

download
John Abrams

How to Build a Centralized Database Monitoring Solution – Never Miss a Backup

Level: Beginner

download
SB Chatterjee

New version: Get-PowerShell | Get-SQLServer

Level: Beginner

download
03:00 PMKevin Goff

SSAS Tabular 2012 vs SSAS Multidimensional OLAP

Level: Intermediate

download
Simon Facer

Ask the Microsoft PFE

Level: Lightning Talk
Kathi Kellenberger

Indexes: The Basics

Level: Beginner

download
Matt Velic

Automating in the Cloud

Level: Intermediate
Thomas Grohser

SQL Server Storage Engine under the hood

Level: Intermediate

download
Daniel Bowlin

SSIS templates, configurations and variables, oh my

Level: Intermediate

download
Mike Hillwig

Recovery and Backup for Beginners

Level: Beginner

download
Don Gabor

Networking and Building Connections for IT Professionals

Level: Non-Technical
04:15 PMEdward Pollack

Query Optimization Crash Course

Level: Beginner

download
Kevin Boles

Common TSQL Mistakes

Level: Intermediate

download
David Bermingham

Deploying Highly Available SQL Servers in the Amazon EC2 Cloud

Level: Intermediate

download
Melissa Demsak

Data Career Paths and Decision Making Strategies

Level: Non-Technical
Leonard Lobel

Database Development with SQL Server Data Tools

Level: Intermediate

download
Samuel Vanga

Biml for Fun and Profit with SSIS

Level: Intermediate

download
Chris Bell

“Indexing” Encrypted Data

Level: Intermediate

download
Hilary Cotter

Merge Replicaton Internals

Level: Advanced
05:30 PMSQLSaturday 235

Closing / Prizes

Level: Non-Technical
SQLSaturday 235

Closing / Prizes

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
“Silly DBA, Maintenance Plans are for Kids!” John MinerIntermediate
HealthySQLRobert PearlBeginner
$#*! Your Database Says About MeKaren LopezBeginner
(a Few of) My Favorite DMVsEdward PollackBeginner
“Indexing” Encrypted DataChris BellIntermediate
10 Things That Every DBA Should Know!John MorehouseBeginner
14 New T-SQL FunctionsSam NasrIntermediate
A dive into Data Quality ServicesSteve SimonIntermediate
A Walk Around the SQL Server 2012 Audit FeatureTimothy McAlileyIntermediate
A Window into Your Data: Using SQL Window FunctionSteve HughesBeginner
Advanced T-SQL Development with latest features.Alex GrinbergIntermediate
Alright,WHY is the server REALLY running so slow!Steve SimonIntermediate
Ask the Microsoft PFESimon FacerLightning Talk
Automate SSIS Development for Loading a Data WarehouseSamuel VangaIntermediate
Automating in the CloudMatt VelicIntermediate
Bad, less Bad, not Bad; rewriting bad SQL CodeJeffrey GarbusBeginner
Be Your Own SQL SWAT TeamBen DeBowIntermediate
Big Data-BI Fusion: Microsoft HDInsight & MS BIAndrew BrustIntermediate
Biml for Fun and Profit with SSISSamuel VangaIntermediate
Building BI Solutions with Excel 2013Steve HughesBeginner
Business Continuity: The Real Reason for HA and DRAllan HirtBeginner
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Column Level EncryptionDavid DyeBeginner
Common TSQL MistakesKevin BolesIntermediate
Cooking the ReportsSteve SimonIntermediate
Dashboard Do's and Don'tsStacia MisnerBeginner
Data Career Paths and Decision Making StrategiesMelissa DemsakNon-Technical
Data Flow Architectures in Software Development Life-CycleVirginia MushkatblatIntermediate
Data Profiling, Cleansing, Enrichment & Matching with SSISChristopher PriceBeginner
Data Profiling, Cleansing, Enrichment & Matching with SSISChristopher PriceBeginner
Database design for mere developersSteve SimonIntermediate
Database Design: Size DOES MatterThomas LaRockIntermediate
Database Development with SQL Server Data ToolsLeonard LobelIntermediate
Database Health and PerformanceDavid KleeIntermediate
Database Recovery Techniques To Keep HandyEdwin SarmientoAdvanced
DAX and the tabular modelSteve SimonBeginner
DBA's Rules for Dummies... And DevelopersMike HillwigBeginner
Dealing With Errors in SSIS 2012David DyeAdvanced
Dealing With Errors in SSIS 2012David DyeAdvanced
Demystifying Clustering for the DBAAllan HirtIntermediate
Deploying Highly Available SQL Servers in the Amazon EC2 CloudDavid BerminghamIntermediate
Effective Data Warehouse Storage PatternsJohn MinerAdvanced
Establishing a SLAThomas GrohserIntermediate
ETL Automation Using SSISJorge NovoIntermediate
ETL not ELT! Common mistakes and misconceptions about SSISPaul RizzaAdvanced
Full Text Indexing BasicsJohn MinerIntermediate
Full-Text Search in SQL 2012 with Custom ProximitySam NasrIntermediate
Geospatial Data Types in SQL Server 2012Leonard LobelIntermediate
Get your Mining Model Predictions out to allSteve SimonIntermediate
Getting to Know the BI Semantic Model Andrew BrustIntermediate
Grab your pick and shovel, let's mine our dataSteve SimonIntermediate
How to audit and prevent unwanted user actions.John MinerIntermediate
How to be a GREAT DBAJeffrey GarbusBeginner
How to Build a Centralized Database Monitoring Solution – Never Miss a BackupJohn AbramsBeginner
How to Create a Self-Managed SQL Server Utility without SQL Server Enterprise EditionCarl BerglundIntermediate
I 'wanna' learn SQL ServerSteve SimonBeginner
Implementing a HIPAA Compliance Strategy with SQL ServerBrandon LeachBeginner
Implementing and Maintaining a SQL Azure projectEmanuele ZanchettinIntermediate
Implementing Auditing in SQL Server 2012David DyeBeginner
Implementing Auditing in SQL Server 2012David DyeBeginner
Index Tuning for the DBABen DeBowIntermediate
Indexes: The BasicsKathi KellenbergerBeginner
Indexing for Join OptimizationJeffrey GarbusAdvanced
Indexing for performanceJeffrey GarbusIntermediate
Indexing your Data WarehouseTroy GallantIntermediate
Integrating Reporting Services with SharePointKevin GoffIntermediate
Into the Blue: Extending AlwaysOn Availability GroupsJoseph D'AntoniIntermediate
Into the Wild,Taming Unstructured DataChristopher PriceIntermediate
Into the Wild,Taming Unstructured DataChristopher PriceIntermediate
Introduction to SSIS 2012Sam NasrIntermediate
Keeping an eagle eye on your SQL ServerSteve SimonIntermediate
Locks, Blocks, and Deadlocks Oh My!Randy KnightIntermediate
Managing your reporting services environmentDaniel BowlinIntermediate
Master Data Services Best PracticesSteve SimonBeginner
Master Data Services decodedSteve SimonIntermediate
MDS in Practice: An Integrated ApproachChristopher PriceBeginner
Merge Replication for Offline Data MobilityTed KruegerIntermediate
Merge Replicaton InternalsHilary CotterAdvanced
Minimally Invasive - Tools to Doctor Up Your CodeWayne SheffieldIntermediate
N/A - No Session/ActivitySQLSaturday 235Non-Technical
Native File Streaming with SQL Server 2012Leonard LobelIntermediate
Networking and Building Connections for IT ProfessionalsDon GaborNon-Technical
New version: Get-PowerShell | Get-SQLServerSB ChatterjeeBeginner
NoSQL: An AnalysisAndrew BrustIntermediate
Patch Management Strategies for SQL ServerAllan HirtBeginner
Programming T-SQL Enhancements in SQL Server 2012Leonard LobelIntermediate
Query Optimization Crash CourseEdward PollackBeginner
Recovery and Backup for BeginnersMike HillwigBeginner
Scaling with SQL Server Service BrokerHilary CotterAdvanced
Security and High Availability and DRThomas GrohserIntermediate
Server Application Virtualization - Picking Up Where Server Virtualization Leaves OffDon Boxley JrNon-Technical
SharePoint 2010/2013 DatabasesSB ChatterjeeIntermediate
Social Networking Is Alive!John MorehouseNon-Technical
SQL 2012 -- All About HA and DRJoseph D'AntoniIntermediate
SQL Azure for beginnersSalomon HenriquezBeginner
SQL InjectionKevin BolesIntermediate
SQL Server 2012 AlwaysOn Availability GroupsGeorge WaltersBeginner
SQL Server 2012 AlwaysOn Step-by-StepDavid BerminghamIntermediate
SQL Server 2012 Failover ClusteringGeorge WaltersIntermediate
SQL Server 2012 Performance TuningGeorge WaltersIntermediate
SQL Server 2014 - Staying Ahead of the curveAshish SharmaIntermediate
SQL Server 2014 New FeaturesGeorge WaltersIntermediate
SQL Server Databaseology 201John MorehouseIntermediate
SQL Server Integration Services RecipesSamuel VangaBeginner
SQL Server Internals and ArchitectureKevin KlineIntermediate
SQL Server Reporting Services, attendees chooseKevin GoffIntermediate
SQL Server Storage Engine under the hood Thomas GrohserIntermediate
SQL Server Sudoku Solver using Transact-SQLKevin FeitBeginner
SQLServer2012 as semantic search engine into file using filetable and MS semanticdbEmanuele ZanchettinIntermediate
Squeezing Performance from VMware-Based SQL ServerDavid KleeAdvanced
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSAS Tabular 2012 vs SSAS Multidimensional OLAPKevin GoffIntermediate
SSIS 2012 : Keeping ahead of the curveSteve SimonIntermediate
SSIS Programming using .netJorge NovoAdvanced
SSIS templates, configurations and variables, oh myDaniel BowlinIntermediate
SSIS: The DBA MultiplierTed KruegerIntermediate
Stress testing SQL ServerHilary CotterAdvanced
Surviving Your Peak Database LoadBen DeBowIntermediate
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
Taking BI to the Next Level: CollaborationStacia MisnerIntermediate
Tech 4 KidzRobert PearlBeginner
The 10 Commandments of ETLMartin SchoombeeBeginner
The Role of Active Directory and DNS in SQL Server HA/DREdwin SarmientoIntermediate
The Transaction Log and How It Affects HA/DREdwin SarmientoAdvanced
Traffic Directions for Database JOINsMike HillwigBeginner
Troubleshoot SQL Server Performance Issues using Wait StatisticsEdwin SarmientoIntermediate
Troubleshooting MDX Query PerformanceStacia MisnerAdvanced
T-SQL 2012 Analytic FunctionsKathi KellenbergerIntermediate
TSQL Road Less Traveled: MERGEKevin BolesIntermediate
Understanding the SQL Server Transaction LogRandy KnightBeginner
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Upgrading to SQL Server 2012 with limited downtimeTed KruegerBeginner
Using Compression to Improve Database PerformanceJoseph D'AntoniIntermediate
Using FiletablesSam NasrIntermediate
Using Power View & Hadoop to Unlock Hidden MarketsStacia MisnerBeginner
Using PowerPivot to Drive Quality into ETL ProcessesSteve HughesIntermediate
Using Statistical Semantic SearchSam NasrAdvanced
Virtualizing SQL 2012: Doing It RightMichael CoreyIntermediate
What the VLF? Mike HillwigAdvanced
What’s new in SQL Server Integration Services 2012Kevin GoffIntermediate
What's new in SSIS 2012Kevin FeitIntermediate
Whats New in T-SQL With SQL Server 2012David DyeBeginner
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesIntermediate
Windows Azure SQL Database Design: Silver Lining and Dark SideKaren LopezIntermediate
WIT Panel / LunchMelissa Demsak / Kathi KellenbergerNon-Technical
Wrangling performance with Resource GovernorBrandon LeachBeginner


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