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 TimeHawthorne - Room: 4th Floor--4038Longfellow - Room: 4th Floor--4028Thoreau - Room: 4th Floor--4018Bunker Hill - Room: 2nd Floor--2006Concord - Room: 2nd Floor--2018Constitution - Room: 2nd Floor--2033Lexington - Room: 2nd Floor--2035
08:30 AMSQLSaturday 262

Registrations

Level: Non-Technical
SQLSaturday 262

Registrations

Level: Non-Technical
SQLSaturday 262

Registrations

Level: Non-Technical
    
09:00 AMSQLSaturday 262

Kickoff and Speed Networking

Level: Non-Technical
SQLSaturday 262

Kickoff and Speed Networking

Level: Non-Technical
SQLSaturday 262

Kickoff and Speed Networking

Level: Non-Technical
    
9:45 AMKevin Kline

SQL Server Internals and Architecture

Level: Intermediate

download
Mohammad Yusuf

An Introduction to Database Design And Management

Level: Beginner
Chris Bell

Optimizing Protected Indexes

Level: Intermediate

download
Bradley Ball

Trimming Indexes Getting Your Database In Shape

Level: Intermediate
David Bermingham

High Availability with Windows Server 2012 R2 and SQL Server 2014

Level: Intermediate
Bryan Cafferky

So you think you know SSIS? What about Scripting?

Level: Advanced
Brandon Leach

Treating Tables Like Legos, Partitioning Basics

Level: Beginner
11:00 AMAaron Bertrand

T-SQL : Bad Habits & Best Practices

Level: Intermediate

download
Andy Leonard

Designing an SSIS Framework

Level: Advanced
Mike Walsh

What I Wish I Knew Before Becoming a DBA

Level: Beginner
Steve Simon

Mind your language!! Cursors are a dirty word

Level: Intermediate

download
Bryan Cafferky

Dimensional Modeling: The Heart of the Data Warehouse

Level: Intermediate
Ayad Shammout

Building BI Semantic Model Tabular in 60 minutes

Level: Beginner
John Flannery

What the Hekaton

Level: Intermediate

download
12:00 PMSQLSaturday 262

Lunch Break

Level: Non-Technical
SQLSaturday 262

Lunch Break

Level: Non-Technical
SQLSaturday 262

Lunch Break

Level: Non-Technical
SQLSaturday 262

Lunch Break

Level: Non-Technical
SQLSaturday 262

Lunch Break

Level: Non-Technical
SQLSaturday 262

Lunch Break

Level: Non-Technical
SQLSaturday 262

Lunch Break

Level: Non-Technical
12:30 PMSQLSaturday 262

Keynote - Electra Govoni

Level: Non-Technical
SQLSaturday 262

Keynote - Electra Govoni

Level: Non-Technical
SQLSaturday 262

Keynote - Electra Govoni

Level: Non-Technical
David Bermingham

Sponsor Spotlight: Clusters Your Way, #SANLess clusters for physical, virtual and cloud environments

Level: Non-Technical
Sponsor Microsoft

Sponsor Spotlight: Microsoft SQL Server 2014 Launch

Level: Beginner
Sponsor Cisco

Sponsor Spotlight: Cisco

Level: Non-Technical
 
01:30 PMGrant Fritchey

Statistics and Query Optimization

Level: Intermediate
Bob Pusateri

Whatcha Doin'? Passive Security for Hostile Environments

Level: Intermediate

download
Allan Hirt

Patch Management Strategies for SQL Server

Level: Intermediate
Sunil Kadimdiwan

Develop Impressive Dashboards using SSRS 2012

Level: Intermediate

download
Jack Corbett

Inroduction to Triggers

Level: Beginner

download
Brandon Leach

Implementing a HIPAA Compliance Strategy with SQL Server

Level: Beginner
John Miner

Effective use of temporary tables

Level: Intermediate
02:45 PMParesh Motiwala

Database Forensics - Part 1

Level: Advanced
Adam Machanic

Query Tuning Mastery: Clash of the Row Goals

Level: Advanced
Edward Pollack

Diving Into Query Execution Plans

Level: Intermediate

download
Tim Radney

Know Backups and Know Recovery

Level: Intermediate

download
Joseph D'Antoni

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

Level: Intermediate
Timothy McAliley

Floating on a Hybrid Cloud: SQL Server 2014 & Windows Azure

Level: Intermediate
Brian McCaig

SQL Server cell level and transparent data encryption a case study

Level: Intermediate
04:00 PMStacia Misner

(Way Too Much) Fun with Reporting Services

Level: Beginner
George Walters

SQL Server 2012 AlwaysOn Availability Groups

Level: Beginner

download
Michael Corey

Virtualizing SQL Server: Doing It Right – The SeQueL

Level: Intermediate
Tim Radney

You Inherited a Database, Now What?

Level: Beginner

download
Edward Pollack

Dynamic SQL: Writing Efficient Queries on the Fly

Level: Beginner

download
Varsham Papikian

Yes, you can do it in SSMS: tips and tricks.

Level: Intermediate
Mike Hillwig

Recovery and Backup for Beginners

Level: Beginner
5:00 PMSQLSaturday 262

Raffle

Level: Non-Technical
SQLSaturday 262

Raffle

Level: Non-Technical
SQLSaturday 262

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
Alerting for the accidental DBA.John MinerBeginner
(Way Too Much) Fun with Reporting Services Stacia MisnerBeginner
12 Steps to Workload TuningJohn SterrettIntermediate
A Walk Around the SQL Server 2014 Audit FeatureTimothy McAlileyIntermediate
An Introduction to Database Design And ManagementMohammad YusufBeginner
An Introduction to Extended EventsJack CorbettIntermediate
Automate your daily checklist with PBM and CMSJohn SterrettBeginner
Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window AzureTimothy McAlileyIntermediate
Beautiful things always recurSteve SimonIntermediate
Best Practices for Database DeploymentGrant FritcheyIntermediate
Branding Yourself for a Dream JobSteve JonesBeginner
Building BI Semantic Model Tabular in 60 minutesAyad ShammoutBeginner
Business Continuity: The Real Reason for HA and DRAllan HirtBeginner
Clean T-SQL: Writing Better, More Maintainable CodeRobert PadillaBeginner
Clusters Your Way - #SANLess clusters for physical virtual and cloud environments.David BerminghamNon-Technical
Coffee BreakSQLSatruday 262Non-Technical
Column Level EncryptionDavid DyeBeginner
Data Warehousing Guidelines for BI and BAM solutionsShehap El-NagarAdvanced
Database Forensics - Part 1Paresh MotiwalaAdvanced
Database Forensics - Part 2Paresh MotiwalaAdvanced
DBA to Project Manager in 75 minutes flatParesh MotiwalaAdvanced
Dealing With Errors in SSIS 2012David DyeAdvanced
Deploying Highly Available SQL Servers in the Amazon EC2 CloudDavid BerminghamIntermediate
Designing an SSIS Framework Andy LeonardAdvanced
Develop Impressive Dashboards using SSRS 2012Sunil KadimdiwanIntermediate
Development Lifecycle with SQL Server Data ToolsJohn FlanneryIntermediate
Dimensional Modeling: The Heart of the Data WarehouseBryan CafferkyIntermediate
Diving Into Query Execution PlansEdward PollackIntermediate
Dynamic SQL: Writing Efficient Queries on the FlyEdward PollackBeginner
Effective Data Warehouse Storage PatternsJohn MinerAdvanced
Effective use of temporary tablesJohn MinerIntermediate
Floating on a Hybrid Cloud: SQL Server 2014 & Windows Azure Timothy McAlileyIntermediate
Get-PowerShell-3 | Get-SQLServer-2012SB ChatterjeeBeginner
HDInsight and Microsoft BI Integration In ActionAyad ShammoutIntermediate
High Availability and Disaster Recovery in the Microsoft Azure CloudDavid BerminghamIntermediate
High Availability with Windows Server 2012 R2 and SQL Server 2014David BerminghamIntermediate
How isolated are your sessions?John MinerIntermediate
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 Auditing in SQL Server 2012David DyeBeginner
Implementing Data Warehouse Patterns with the Microsoft BI ToolsKevin GoffIntermediate
In-Memory Columnstore Indexes--Make Your Data Warehouse Fly Joseph D'AntoniIntermediate
Inroduction to TriggersJack CorbettBeginner
Introducing Power BIStacia MisnerBeginner
Keynote - Electra GovoniSQLSaturday 262Non-Technical
Kickoff and Speed NetworkingSQLSaturday 262Non-Technical
Know Backups and Know RecoveryTim RadneyIntermediate
Lunch BreakSQLSaturday 262Non-Technical
Mind your language!! Cursors are a dirty wordSteve SimonIntermediate
MS Access with SQL Server Strategies and TipsJuan SotoBeginner
Optimizing Protected IndexesChris BellIntermediate
Patch Management Strategies for SQL ServerAllan HirtIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Query Optimization Crash CourseEdward PollackBeginner
Query Tuning Mastery: Clash of the Row GoalsAdam MachanicAdvanced
RaffleSQLSaturday 262Non-Technical
Recovery and Backup for BeginnersMike HillwigBeginner
Reduce, Reuse, Recycle: Automating Your BI FrameworkStacia MisnerIntermediate
RegistrationsSQLSaturday 262Non-Technical
SharePoint 2010/2013 DatabasesSB ChatterjeeIntermediate
Sharepoint 2013 performance point Dashboard On SSAS Cubeatif yasinIntermediate
So you think you know SSIS? What about Scripting? Bryan CafferkyAdvanced
So You've installed SQL Server--Now What?Joseph D'AntoniBeginner
Sponsor Spotlight: CiscoSponsor CiscoNon-Technical
Sponsor Spotlight: Clusters Your Way, #SANLess clusters for physical, virtual and cloud environmentsDavid BerminghamNon-Technical
Sponsor Spotlight: Microsoft SQL Server 2014 LaunchSponsor MicrosoftBeginner
SQL Saturday KeynoteSQLSaturday 262Non-Technical
SQL Security: Five Backdoors You Rarely CheckTony SweetIntermediate
SQL Server 2012 AlwaysOn Availability GroupsGeorge WaltersBeginner
SQL Server 2012 Data Access Layers(not Visual Studio)Steve SimonIntermediate
SQL Server 2012 Failover ClusteringGeorge WaltersIntermediate
SQL Server 2012 Performance Tuning All UpGeorge WaltersIntermediate
SQL Server 2012/2014 Columnstore indexKevin GoffIntermediate
SQL Server 2014 New FeaturesGeorge WaltersIntermediate
SQL Server cell level and transparent data encryption a case studyBrian McCaigIntermediate
SQL Server Dos and Don'ts: Keys to DBA NirvanaAllan HirtBeginner
SQL Server Internals and ArchitectureKevin KlineIntermediate
SQL Server Reporting Services Best PracticesSteve SimonIntermediate
SQL Server Reporting Services, attendees chooseKevin GoffIntermediate
SSIS 2012 – The Project Deployment ModelJohn FlanneryBeginner
SSIS Log Providers, Custom Logging, and Event HandlersDavid DyeBeginner
Statistics and Query OptimizationGrant FritcheyIntermediate
Table Partitioning: the Secret Weapon for your Big Data Problems.John SterrettIntermediate
Team Leadership FundamentalsKevin KlineBeginner
The Encryption PrimerSteve JonesBeginner
The Skinny on Data CompressionBob PusateriIntermediate
Top 10 Admininistrator Mistakes on SQL ServerKevin KlineBeginner
Treating Tables Like Legos, Partitioning BasicsBrandon LeachBeginner
Trimming Indexes Getting Your Database In ShapeBradley BallIntermediate
T-SQL : Bad Habits & Best PracticesAaron BertrandIntermediate
T-SQL for Application Developers - Attendees choseKevin GoffIntermediate
T-SQL Performance Guidelines for better DB stress powersShehap El-NagarAdvanced
Unstructured Data in SQL ServerSteve JonesBeginner
Using BIML as an SSIS Design Patterns Engine Andy LeonardIntermediate
Virtualizing SQL Server: Doing It Right – The SeQueLMichael CoreyIntermediate
VLDBs: Lessons LearnedBob PusateriIntermediate
What I Wish I Knew Before Becoming a DBAMike WalshBeginner
What the HekatonJohn FlanneryIntermediate
Whatcha Doin'? Passive Security for Hostile EnvironmentsBob PusateriIntermediate
Why do we shun using tools for DBA job?Paresh MotiwalaAdvanced
Wish you could live the glamorous consulting life?Juan SotoBeginner
Wrangling performance with Resource GovernorBrandon LeachBeginner
Yes, you can do it in SSMS: tips and tricks.Varsham PapikianIntermediate
Yes, you can write triggers that don't suckAaron BertrandIntermediate
You Inherited a Database, Now What?Tim RadneyBeginner
Your First Week as a SQL Server DBASteve JonesBeginner


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