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 TimeBeginner - Room: J Building Room 100BI Track - Room: 4th Floor Room 4105BI/Big Data/Misc - Room: 4th Floor Room 4104Cloud/Security - Room: 3rd Floor Room 3206DBA Admin 2 Track - Room: 4th Floor Room 4106DBA Admin Track - Room: 4th Floor Room 4208DBA Performance Track - Room: 4th Floor Room 4103Prof Dev/Security - Room: 3rd Floor Room 3207SSIS/Virtualization Track - Room: 3rd Floor Room 3205T-SQL/SQL 2014 Track - Room: 4th Floor Room 4205
08:30 AMAndy Warren

From Student to IT Professional - Part 1

Level: Beginner
SQLSaturday 318

Registrations

Level: Non-Technical
SQLSaturday 318

Registrations

Level: Non-Technical
SQLSaturday 318

Registrations

Level: Non-Technical
SQLSaturday 318

Registrations

Level: Non-Technical
SQLSaturday 318

Registrations

Level: Non-Technical
SQLSaturday 318

Registrations

Level: Non-Technical
SQLSaturday 318

Registrations

Level: Non-Technical
SQLSaturday 318

Registrations

Level: Non-Technical
SQLSaturday 318

Registrations

Level: Non-Technical
09:00 AMRodney Landrum

First Day DBA - Installation to Fascination without Frustration

Level: Beginner
Devin Knight

Getting Started with Power Query

Level: Beginner
Pam Shaw

Tips & Tricks for dynamic SSRS Reports

Level: Beginner
Sebastian Meine

Permission Management: 12 Pitfalls & Misconceptions

Level: Intermediate
Dmitri Korotkevitch

How To Kill SQL Server in 60 Minutes

Level: Intermediate
Jonathon Moorman

Database Projects

Level: Beginner
Ed Watson

Performance Tuning for Mere Mortals Part I

Level: Beginner
Andy Warren

Turbocharge Your Career With a Learning Plan

Level: Beginner

download
Michael Corey

Virtualizing SQL Server: Doing IT Right - The SeQueL

Level: Intermediate
Brian Davis

Getting Started with Hekaton (In-Memory OLTP)

Level: Beginner
10:00 AMSQLSaturday 318

Coffee with our Sponsors

Level: Non-Technical
SQLSaturday 318

Coffee with our Sponsors

Level: Non-Technical
SQLSaturday 318

Coffee with our Sponsors

Level: Non-Technical
SQLSaturday 318

Coffee with our Sponsors

Level: Non-Technical
SQLSaturday 318

Coffee with our Sponsors

Level: Non-Technical
SQLSaturday 318

Coffee with our Sponsors

Level: Non-Technical
SQLSaturday 318

Coffee with our Sponsors

Level: Non-Technical
SQLSaturday 318

Coffee with our Sponsors

Level: Non-Technical
SQLSaturday 318

Coffee with our Sponsors

Level: Non-Technical
SQLSaturday 318

Coffee with our Sponsors

Level: Non-Technical
10:30 AMAndy Warren

From Student to IT Professional - Part 3

Level: Beginner
Alexander Nykolaiszyn

How to Give Your Boss a Headache - Introduction to Dashboard & Report Design

Level: Non-Technical
Arvin Meyer

Access As A Front-end to SQL-Server

Level: Intermediate
Geoff Hiten

Cloudy with a Chance of Data

Level: Intermediate
Diana Betancourt

A DiBA guide to Database Standards

Level: Intermediate
Mike Nelson

Test Automation - Where to Start

Level: Beginner
Richie Rump

Database Design Disasters: Common Mistakes Found in the Wild

Level: Intermediate
Jason Carter

Encryption 101: A look at SQL Encryption Options

Level: Beginner
Bradley Schacht

Introduction to ETL Using SSIS

Level: Beginner
Greg Larsen

T-SQL Best Practices

Level: Beginner
11:45 AM Gene Webb

Building an MDM Center of Excellence with MDS and Maestro

Level: Beginner

download
Jack Corbett

Tired of the CRUD? Automate it!

Level: Intermediate
Guillermo Caicedo

SQL Server 2014 Hybrid Cloud Features

Level: Intermediate
Elijah Baker

How to Partition Anything!

Level: Intermediate
Jason Hall

TempDB Parasites!

Level: Intermediate
Mike Lawell

Performance Tuning for Mere Mortals Part II

Level: Intermediate
Jeffrey Garbus

How to be a GREAT DBA

Level: Beginner
Brett Tomson

ETL in a Nutshell with SSIS

Level: Beginner
Eric Wisdahl

SQL 2014 In Memory OLTP and Natively Compiled Stored Procedures

Level: Beginner
12:45 PM SQLSaturday 318

Lunch Break

Level: Non-Technical
SQLSaturday 318

Lunch Break

Level: Non-Technical
SQLSaturday 318

Lunch Break

Level: Non-Technical
SQLSaturday 318

Lunch Break

Level: Non-Technical
SQLSaturday 318

Lunch Break

Level: Non-Technical
SQLSaturday 318

Lunch Break

Level: Non-Technical
SQLSaturday 318

Lunch Break

Level: Non-Technical
SQLSaturday 318

Lunch Break

Level: Non-Technical
SQLSaturday 318

Lunch Break

Level: Non-Technical
1:15 PM Gene Webb of The Profisee Group

Learn How To Build A Golden Record for Any Subject Over Lunch!

Level: Beginner
Todd Phillippe of Dell Software

Object Level Recovery Made Easy

Level: Beginner
 Carl Berglund of DH2i

Get Your Nights & Weekends Back from SQL Server Planned Downtime

Level: Intermediate
SIOS Technology Corp. and Rodney Landrum

SIOS Lunch Session: Clusters Your Way: #SANLess clusters for physical, virtual & cloud environments

Level: Lightning Talk
Janis Griffin of SolarWinds

Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite)

Level: Non-Technical
  Steve Leroy of Violin Memory

Flash 101- An Introduction to Flash Storage for MS SQL Server and Data Centers

Level: Beginner
02:00 PM James McAuliffe

Report With Power: New Data Tools, New Insights

Level: Beginner
Josh Luedeman

Show me whatcha workin' with: Big Data Edition

Level: Intermediate
Allen White

Manage Both On-Prem and Azure Databases with PowerShell

Level: Intermediate
miguel cebollero

Database Development Comes out of the Dark Ages

Level: Intermediate
John Pertell

An Introduction to FileTables

Level: Intermediate
Janis Griffin

Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Level: Intermediate
Matthew Brimer

SQL Security Best Practices & Shrinking Your Attack Surface

Level: Intermediate
Jorge Segarra

Azure Virtual Machines: A Walk in the Cloud

Level: Beginner
Louis Davidson

How In-Memory Database Objects Affect Database Design

Level: Intermediate
03:15 PM Wes Springob

Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Level: Intermediate
Mark Kromer

Big Data Analytics with SQL Server, Hadoop and MongoDB

Level: Intermediate
Maximo Trinidad

Powershell Working with Windows Azure SQL Database Server

Level: Beginner
Prakash Heda

Re-Indexing - The quest of ultimate automation

Level: Intermediate
Santos Martinez and Elias Mereb

SQL Server for System Center Administrators

Level: Intermediate
Jason Horner

Tricks from the DBA Inbox: Real World Performance Tuning

Level: Beginner
Leigh Freijo

Why I won't hire you and what you can do about it!

Level: Beginner
Robert Biddle

Loading a Data Warehouse with SSIS

Level: Advanced
Jose L. Rivera

Mastering T-SQL Window Functions

Level: Intermediate
04:30 PM Jason Thomas

DataViz You Thought You Couldn't Do with SSRS

Level: Advanced
Rowland Gosling

Hadoop + SQL Server: The Emerging Patterns in Big Data

Level: Beginner
Scott Klein

SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Level: Advanced
David Klee

Easy SQL Server Benchmarking

Level: Beginner
Randy Knight

Understanding the SQL Server Transaction Log

Level: Intermediate
Argenis Fernandez

Making DBCC CHECKDB Go Faster

Level: Intermediate
Ronald Dameron

SQL Server Security Easy Button

Level: Intermediate
Jorge Novo

Dynamic File Loading Using SSIS Programming

Level: Advanced
Rob Volk

Revenge: The SQL! - Director's Cut

Level: Intermediate
05:45 PM SQLSaturday 318

Raffle

Level: Non-Technical
SQLSaturday 318

Raffle

Level: Non-Technical
SQLSaturday 318

Raffle

Level: Non-Technical
SQLSaturday 318

Raffle

Level: Non-Technical
SQLSaturday 318

Raffle

Level: Non-Technical
SQLSaturday 318

Raffle

Level: Non-Technical
SQLSaturday 318

Raffle

Level: Non-Technical
SQLSaturday 318

Raffle

Level: Non-Technical
SQLSaturday 318

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
A DiBA guide to Database StandardsDiana BetancourtIntermediate
A Matter of Time... In SSASAlexander NykolaiszynIntermediate
Access As A Front-end to SQL-ServerArvin MeyerIntermediate
Achieving Peak Performance from your Virtualized SQL ServersDavid KleeIntermediate
Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite) Janis Griffin of SolarWindsNon-Technical
Advanced Spatial Analysis: Beyond Bubble ChartsJason HornerAdvanced
An Introduction to FileTablesJohn PertellIntermediate
Automate Your ETL Infrastructure with SSIS and PowerShellAllen WhiteIntermediate
Azure Virtual Machines: A Walk in the CloudJorge SegarraBeginner
Bad SQLGeoff HitenIntermediate
Bad, less Bad, not Bad; rewriting bad SQL CodeJeffrey GarbusBeginner
Big Data Analytics with SQL Server, Hadoop and MongoDBMark KromerIntermediate
Building an MDM Center of Excellence with MDS and Maestro Gene WebbBeginner
Business Rules, Data Governance, and Workflow with MDS and Maestro Gene WebbBeginner
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Cloudy with a Chance of DataGeoff HitenIntermediate
Coffee with our SponsorsSQLSaturday 318Non-Technical
Database Design Disasters: Common Mistakes Found in the WildRichie RumpIntermediate
Database Development Comes out of the Dark Agesmiguel cebolleroIntermediate
Database ProjectsJonathon MoormanBeginner
DataViz You Thought You Couldn't Do with SSRSJason ThomasAdvanced
Detect Worst Performing SQL Queries During Peak HourPrakash HedaAdvanced
Detecting Changes in SQL ServerRobert BiddleBeginner
Dynamic File Loading Using SSIS Programming Jorge NovoAdvanced
Easy SQL Server BenchmarkingDavid KleeBeginner
Encryption 101: A look at SQL Encryption OptionsJason CarterBeginner
Entity Framework: Or How I Learned to Stop Worrying and Learned to Love DevelopersRichie RumpIntermediate
ETL Frameworks Using SSIS Jorge NovoAdvanced
ETL in a Nutshell with SSISBrett TomsonBeginner
First Day DBA - Installation to Fascination without FrustrationRodney LandrumBeginner
Flash 101- An Introduction to Flash Storage for MS SQL Server and Data CentersSteve Leroy of Violin MemoryBeginner
Free tools from the SQL Server CommunityEric WisdahlBeginner
From Student to IT Professional - Part 1Andy WarrenBeginner
From Student to IT Professional - Part 2Andy WarrenBeginner
From Student to IT Professional - Part 3Andy WarrenBeginner
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issuesJanis GriffinIntermediate
Get Near Realtime ETL with Service BrokerAllen WhiteIntermediate
Get Your Nights & Weekends Back from SQL Server Planned DowntimeCarl Berglund of DH2iIntermediate
Getting Started with Hekaton (In-Memory OLTP)Brian DavisBeginner
Getting Started with Power QueryDevin KnightBeginner
Goodbye Next Next Next, Hello Automated InstallsBrian DavisIntermediate
Hadoop + SQL Server: The Emerging Patterns in Big DataRowland GoslingBeginner
How In-Memory Database Objects Affect Database DesignLouis DavidsonIntermediate
How to Argue with Your Infrastructure Admins – and WinDavid KleeBeginner
How to be a GREAT DBAJeffrey GarbusBeginner
How to Give Your Boss a Headache - Introduction to Dashboard & Report DesignAlexander NykolaiszynNon-Technical
How To Kill SQL Server in 60 MinutesDmitri KorotkevitchIntermediate
How to Partition Anything!Elijah BakerIntermediate
How to Write a DML TriggerLouis DavidsonIntermediate
Indexing for Join OptimizationJeffrey GarbusAdvanced
Indexing for performanceJeffrey GarbusIntermediate
Indexing Internals for DevelopersBradley BallAdvanced
Inroduction to TriggersJack CorbettBeginner
Inside the SQL Server 2014 Query OptimizerBradley BallAdvanced
Interactive Reporting with Power ViewBradley SchachtBeginner
Introduction to ETL Using SSISBradley SchachtBeginner
Introduction to Power BIDevin KnightBeginner
Introduction to SSASBradley SchachtBeginner
Isn't that SpatialJason HornerBeginner
Learn How To Build A Golden Record for Any Subject Over Lunch!Gene Webb of The Profisee GroupBeginner
Loading a Data Warehouse with SSISRobert BiddleAdvanced
Locks, Blocks, and Deadlocks Oh My!Randy KnightIntermediate
Lunch BreakSQLSaturday 318Non-Technical
Maintenance and Backups: Intro to Ola HallengrenJason CarterBeginner
Making DBCC CHECKDB Go FasterArgenis FernandezIntermediate
Manage Both On-Prem and Azure Databases with PowerShellAllen WhiteIntermediate
Manage SQLServer Efficiently w/PowerShell RemotingAllen WhiteIntermediate
Mastering T-SQL Window FunctionsJose L. RiveraIntermediate
Object Level Recovery Made EasyTodd Phillippe of Dell SoftwareBeginner
Performance Tuning for Mere Mortals Part IEd WatsonBeginner
Performance Tuning for Mere Mortals Part IIMike LawellIntermediate
Permission Management: 12 Pitfalls & MisconceptionsSebastian MeineIntermediate
Power This, Power That...Making Sense of Power BIBrett TomsonBeginner
Powershell Working with Windows Azure SQL Database ServerMaximo TrinidadBeginner
Querying Active Directory From SSRS To Secure Reports And Enhance The User ExperienceWes SpringobIntermediate
RaffleSQLSaturday 318Non-Technical
Recipe for a happy DBAJason HallBeginner
RegistrationsSQLSaturday 318Non-Technical
Re-Indexing - The quest of ultimate automationPrakash HedaIntermediate
Report With Power: New Data Tools, New InsightsJames McAuliffeBeginner
Revenge: The SQL! - Director's CutRob VolkIntermediate
Secure Your SQL Server Instance Without Changing Any CodeArgenis FernandezIntermediate
Securing Semantic Models: Real World ScenariosBrett TomsonIntermediate
Show me whatcha workin' with: Big Data EditionJosh LuedemanIntermediate
SIOS Lunch Session: Clusters Your Way: #SANLess clusters for physical, virtual & cloud environmentsSIOS Technology Corp. and Rodney LandrumLightning Talk
Smart Rats Leave FirstGeoff HitenNon-Technical
SQL 2014 In Memory OLTP and Natively Compiled Stored ProceduresEric WisdahlBeginner
SQL Limbo - How Low Can Your Server Go?Rodney LandrumIntermediate
SQL Security Best Practices & Shrinking Your Attack SurfaceMatthew BrimerIntermediate
SQL Server 2014 Hybrid Cloud FeaturesGuillermo CaicedoIntermediate
SQL Server 2014 OLTP (Hekaton) Deep DiveScott KleinIntermediate
SQL Server 2014 Top 5 - Hybrid FeaturesScott KleinIntermediate
SQL Server 2014: A First Look at What’s New!Bradley BallIntermediate
SQL Server for System Center AdministratorsSantos Martinez and Elias MerebIntermediate
SQL Server HA and DR in a Windows Azure Virtual Machine – Deep DiveScott KleinAdvanced
SQL Server Security Easy ButtonRonald DameronIntermediate
SQL Server: Ground Zero BasicsJorge SegarraBeginner
SSIS - Integrating PowerShell in a ScriptTask compMaximo TrinidadIntermediate
SSIS Programming Using .NET FrameworkJorge NovoBeginner
SSIS Templates Can Make Your Life EasierBrian DavisBeginner
SSIS Tips & TricksGuillermo CaicedoIntermediate
Standardize SQL Server Implementations (Dev to Prod)Prakash HedaIntermediate
Storage Design and SQL Server Performance Rowland GoslingBeginner
Taking the Scary out of Monster ReportsPam ShawBeginner
TempDB Parasites!Jason HallIntermediate
Test Automation - Where to StartMike NelsonBeginner
Tips & Tricks for dynamic SSRS ReportsPam ShawBeginner
Tired of the CRUD? Automate it!Jack CorbettIntermediate
Tricks from the DBA Inbox: Real World Performance TuningJason HornerBeginner
T-SQL Best PracticesGreg LarsenBeginner
Turbocharge Your Career With a Learning PlanAndy WarrenBeginner
Understanding SQL Server XML Features Randy KnightIntermediate
Understanding the SQL Server Transaction LogRandy KnightIntermediate
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Using Power BI Q&A to Bring your Data to Everyone in your OrganizationDevin KnightBeginner
Virtualizing SQL Server: Doing IT Right - The SeQueLMichael CoreyIntermediate
We Don't Need Roads: A Look Into SQL Server IndexesRichie RumpIntermediate
What is a BI DBA?Jorge SegarraIntermediate
Why I won't hire you and what you can do about it!Leigh FreijoBeginner


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