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 TimeBaratheon - Room: Room 215Drogo - Room: Room 209Lannister - Room: Room 105Snow - Room: Room 208/210Stark - Room: Room 108/110Targaryen - Room: Room 111
7:30 AMSQLSaturday 304

Registrations

Level: Non-Technical
SQLSaturday 304

Registrations

Level: Non-Technical
SQLSaturday 304

Registrations

Level: Non-Technical
SQLSaturday 304

Registrations

Level: Non-Technical
SQLSaturday 304

Registrations

Level: Non-Technical
SQLSaturday 304

Registrations

Level: Non-Technical
08:00 AMBrian Beswick

Database Unit Testing

Level: Beginner
Brian Davis

Getting Started with Hekaton (In-Memory OLTP)

Level: Beginner

download
Allen White

Manage SQLServer Efficiently w/PowerShell Remoting

Level: Intermediate

download
Joey D'Antoni

Building Perfect SQL Servers, Every Time

Level: Beginner
Aaron Crouch

Better Decision Making with Power BI

Level: Beginner
Aaron Cutshall

The Lost Science of Set Theory

Level: Beginner

download
09:15 AMSteve Jones

Branding Yourself for a Dream Job

Level: Beginner

download
Andy Tabisz

Creating Access 2013 web apps on SharePoint using SQL Azure

Level: Beginner

download
David Ortiz

Self Service Pitfalls

Level: Beginner
David Maxwell

DBA 911 - Database Corruption

Level: Beginner

download
Andy Yun

Every Byte Counts: Why Your Datatype Choices Matter

Level: Intermediate

download
Kathi Kellenberger

Writing Better T-SQL Queries with Window Functions

Level: Intermediate

download
10:30 AMAlan Dykes

How to start with XML

Level: Beginner

download
Joseph D'Antoni

Power BI in the Fast Lane--Visualizing Formula 1

Level: Intermediate
Kevin Boles

SQL Injection

Level: Intermediate

download
Warren Sifre

DBA Monitoring and Maintenance Fundamentals

Level: Beginner

download
Eddie Wuerch

The Guts of Data Manipulation

Level: Advanced
Erin Stellato

Making the Leap from Profiler to Extended Events

Level: Beginner
11:45 AMSQLSaturday 304

Lunch Break

Level: Non-Technical
SQLSaturday 304

Lunch Break

Level: Non-Technical
SQLSaturday 304

Lunch Break

Level: Non-Technical
Kathi Kellenberger

Women in Tech Panel

Level: Beginner
Carlos Parra

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

Level: Beginner
SQLSaturday 304

Lunch Break

Level: Non-Technical
1:00 PMScott Nei

A Better Introduction to Tabular Mode in SSAS

Level: Beginner
Dave Bland

Change Data Capture - What is it and Why I should use it

Level: Intermediate

download
Anthony Mattas

Addressing Trends In Big Data with APS

Level: Intermediate
Frank Gill

Interrogating the Transaction Log

Level: Intermediate
Scott Fallen

Getting Started With Execution Plans

Level: Beginner

download
Frank Murphy

DIY Geocoding

Level: Intermediate
2:15 PMJeff Foushee

Transforming Data using the T-SQL PIVOT / UNPIVOT operators

Level: Intermediate

download
Patrick Brewer

Why Re-Invent the Wheel? Build One Solution to Import/ Export Data

Level: Intermediate
Bradley Nielsen

The User Experience of Data Systems

Level: Beginner
Kathi Kellenberger

T-SQL Window Function Performance

Level: Advanced

download
Kerry Tyler

45 Minutes to Your First SSAS Tabular Model

Level: Beginner
Aaron Cutshall

T-SQL Tips & Tricks Part 2

Level: Intermediate

download
3:30 PMJoe Mack

Azure Development - Soup to Nuts

Level: Intermediate

download
Arie Jones

Everything Columnstore!

Level: Intermediate
JD Wade

What SQL DBAs need to know about SharePoint

Level: Intermediate
Kevin Boles

SQL Server Defaults SUCK!!

Level: Intermediate

download
Rob Volk

Power Power Query Query! (With Julie Smith and Rob

Level: Beginner

download
Tamera Clark

45 min to build your first SSRS report

Level: Beginner
04:30 PMSQLSaturday 304

Raffle

Level: Non-Technical
SQLSaturday 304

Raffle

Level: Non-Technical
SQLSaturday 304

Raffle

Level: Non-Technical
SQLSaturday 304

Raffle

Level: Non-Technical
SQLSaturday 304

Raffle

Level: Non-Technical
SQLSaturday 304

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
45 min to build your first SSRS reportTamera ClarkBeginner
45 Minutes to Your First SSAS Tabular ModelKerry TylerBeginner
5 Execution Plan Patterns To Watch ForErin StellatoBeginner
A Better Introduction to Tabular Mode in SSASScott NeiBeginner
Addressing Trends In Big Data with APSAnthony MattasIntermediate
Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite) Carlos ParraBeginner
Advanced Topics on Developing in SSAS Tabular ModeScott NeiIntermediate
An Overview of SQL Server 2014Sarah BarelaBeginner
Automate Your ETL Infrastructure with SSIS and PowerShellAllen WhiteIntermediate
Azure Development - Soup to NutsJoe MackIntermediate
Better Decision Making with Power BIAaron CrouchBeginner
BizTalk: EDI Made SimpleAaron CrouchBeginner
Branding Yourself for a Dream JobSteve JonesBeginner
Building Perfect SQL Servers, Every TimeJoey D'AntoniBeginner
Change Data Capture - What is it and Why I should use itDave BlandIntermediate
Connected at the hip for MS BI: SharePoint and SQLJD WadeIntermediate
Continuous Integration for DatabasesSteve JonesIntermediate
Creating Access 2013 web apps on SharePoint using SQL AzureAndy TabiszBeginner
Data Warehousing Guidelines for BI and BAM solutionsShehap El-NagarAdvanced
Database Unit TestingBrian BeswickBeginner
DBA 911 - Database CorruptionDavid MaxwellBeginner
DBA Monitoring and Maintenance FundamentalsWarren SifreBeginner
Designing a Restore StrategyFrank GillIntermediate
DIY GeocodingFrank MurphyIntermediate
Dynamic Connections in SSISGill RowleyIntermediate
Every Byte Counts: Why Your Datatype Choices MatterAndy YunIntermediate
Everything Columnstore!Arie JonesIntermediate
Everything I Know About Agile I Learned in Beast BarracksJoe MackNon-Technical
Get Near Realtime ETL with Service BrokerAllen WhiteIntermediate
Getting Started With Execution PlansScott FallenBeginner
Getting Started with Hekaton (In-Memory OLTP)Brian DavisBeginner
Goodbye Next Next Next, Hello Automated InstallsBrian DavisIntermediate
How to start with XMLAlan DykesBeginner
Interrogating the Transaction Log Frank GillIntermediate
Judge, Jury, and Executioner--A First Look At Execution PlansCarlos ChaconBeginner
Lunch BreakSQLSaturday 304Non-Technical
Making the Leap from Profiler to Extended EventsErin StellatoBeginner
Manage SQLServer Efficiently w/PowerShell RemotingAllen WhiteIntermediate
Manageable SSAS Deployment StrategiesKerry TylerBeginner
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Power BI – Cloud Self-Service BIGinger GrantBeginner
Power BI in the Fast Lane--Visualizing Formula 1Joseph D'AntoniIntermediate
Power Power Query Query! (With Julie Smith and RobRob VolkBeginner
Query Tuning Superstardom for BeginnersTim FordBeginner
RaffleSQLSaturday 304Non-Technical
RegistrationsSQLSaturday 304Non-Technical
Revenge: The SQL! - Director's CutRob VolkIntermediate
Self Service Pitfalls David OrtizBeginner
SQL InjectionKevin BolesIntermediate
SQL Server 2014 Column Store Index vNEXTKevin BolesAdvanced
SQL Server 2014 New FeaturesKevin BolesIntermediate
SQL Server 2014 Transitioning to the CloudSarah BarelaBeginner
SQL Server Agent - The DBA's Best FriendDavid MaxwellBeginner
SQL Server Defaults SUCK!!Kevin BolesIntermediate
SSIS Templates Can Make Your Life EasierBrian DavisBeginner
Stream Those BLOBs! Using SQL Server FILESTREAM and FILETABLE Arie JonesIntermediate
The Encryption PrimerSteve JonesBeginner
The Encryption PrimerSteve JonesBeginner
The Guts of Data ManipulationEddie WuerchAdvanced
The Lost Science of Set TheoryAaron CutshallBeginner
The Most Important Dynamic Management Objects for New DBAsTim FordBeginner
The Sqoop on Big Data from it’s humble beginnings to rise to notorietyGinger GrantBeginner
The User Experience of Data SystemsBradley NielsenBeginner
Transforming Data using the T-SQL PIVOT / UNPIVOT operatorsJeff FousheeIntermediate
Transforming Data using the T-SQL PIVOT / UNPIVOT operatorsJeff FousheeIntermediate
T-SQL Tips & Tricks Part 2Aaron CutshallIntermediate
T-SQL Window Function PerformanceKathi KellenbergerAdvanced
Updating Statistics Affects Query Performance More Than You ThinkErin StellatoIntermediate
What SQL DBAs need to know about SharePointJD WadeIntermediate
Why Re-Invent the Wheel? Build One Solution to Import/ Export DataPatrick BrewerIntermediate
Women in Tech PanelKathi KellenbergerBeginner
Writing Better T-SQL Queries with Window FunctionsKathi KellenbergerIntermediate
Your First Week as a SQL Server DBASteve JonesBeginner
You're the DBA. Now What?Gill RowleyBeginner


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.

Suggested Session TitleSkill Level
Why Re-Invent the Wheel? SSIS - MVC Data Imp/ExpIntermediate

SQLSaturday Home
PASS