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 Time - Room: 111 - Room: 112 - Room: 115 - Room: 118 - Room: 120 - Room: 123 - Room: 124
09:00 AMWarren Sifre

Introduction to FileTables in SQL 2012

Level: Intermediate

download
Dmitri Korotkevitch

Eternal story on temporal objects

Level: Intermediate

download
Jonathan Kehayias

SQL Server Amnesia: Diagnosing Memory Problems

Level: Advanced

download
Jorge Segarra

What is a BI DBA?

Level: Intermediate
Jon Bloom

Introduction to SSRS for DBAs

Level: Beginner

download
Jose Chinchilla

Designing and Optimizing SSAS Hierarchies

Level: Beginner
Jorge Novo

Dynamic File Loading Using SSIS Programming

Level: Advanced
10:15 AMChris Skorlinski

Check Engine Lights

Level: Intermediate
Janis Griffin

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

Level: Intermediate

download
David Klee

Squeezing Top Performance from Your Virtualized SQL Server

Level: Beginner

download
Wayne Sheffield

Windowing Functions in SQL Server 2012

Level: Intermediate
Eric Wisdahl

Free tools from the SQL Server Community

Level: Beginner

download
Mike Davis

Complex DAX Functions

Level: Beginner
Rafael Salas

ETL: Avoiding Costly Mistakes

Level: Intermediate
11:30 AMThomas LaRock

Database Design: Size DOES Matter

Level: Intermediate
Jeffrey Garbus

How to be a GREAT DBA

Level: Beginner
Grant Fritchey

Statistics and Query Optimization

Level: Intermediate
Tim Radney

You Inherited a Database, Now What?

Level: Beginner

download
Allen White

Manage SQLServer Efficiently w/PowerShell Remoting

Level: Intermediate

download
Brian Mitchell

The Modern Data Warehouse

Level: Beginner
Robert Biddle

Loading a Data Warehouse with SSIS

Level: Advanced
01:30 PMmiguel cebollero

Database Development Comes out of the Dark Ages

Level: Intermediate

download
Chad Churchwell

Introduction to SQL Server Replication

Level: Beginner
Shawn Meyers

Translate SQL server performance issues into business costs

Level: Intermediate
Frank Quintana

An introduction to Business Intelligence and Big Data

Level: Intermediate
Tim Radney

Getting involved and Getting ahead

Level: Beginner

download
Jen Underwood

Combining SQL Server, SSRS and SSAS with Tableau Dashboards

Level: Intermediate
Chris Skorlinski

Your Best Interview Ever

Level: Beginner

download
02:45 PMRob Volk

Harvesting Web Data Using Data Explorer and XML

Level: Beginner

download
Jason Carter

Maintenance and Backups: How Ola makes your life

Level: Beginner

download
Brandon Leach

Treating Tables Like Legos, Partitioning Basics

Level: Beginner
Philip Pees

Big Data - HdInsight and Parallel Data Warehousing (PDW)

Level: Intermediate

download
 Michael Antonovich

Introducing Cube World To Users From Flat Table Land

Level: Intermediate

download
John Welch

Unit Testing SSIS Packages

Level: Intermediate
04:00 PMKendal Van Dyke

Discover, Document, & Diagnose Your Servers on Your Coffee Break

Level: Beginner
Andy Warren

PCI For The SQLDBA

Level: Beginner
Bradley Ball

Trimming Indexes Getting Your Database In Shape

Level: Intermediate
Ronald Dameron

SQL Server Security Easy Button

Level: Intermediate

download
Susan Rickman

Can't we all just get along?

Level: Beginner
Julie Smith

BIML--Step by Step

Level: Intermediate
 


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
10 Ways To Abuse T-SQLTracy McKibbenBeginner
5 TSQL Commands I've been missingJason CarterBeginner
An introduction to Business Intelligence and Big DataFrank QuintanaIntermediate
An introduction to Business Intelligence and Big DataFrank QuintanaIntermediate
An Introductory Look at Execution PlansEric WisdahlBeginner
Automate Your ETL Infrastructure with SSIS and PowerShellAllen WhiteIntermediate
Azure Virtual Machines: A Walk in the CloudJorge SegarraBeginner
Azure Virtual Machines: A Walk in the CloudJorge SegarraBeginner
Azure: What Is It and How Do I Get Started With It?Grant FritcheyBeginner
Bad, less Bad, not Bad; rewriting bad SQL CodeJeffrey GarbusBeginner
Best Practices for Database DeploymentGrant FritcheyIntermediate
Big Data - HdInsight and Parallel Data Warehousing (PDW) Philip PeesIntermediate
BIML--Step by StepJulie SmithIntermediate
Building Your Own SQL Server Virtual PlaygroundKendal Van DykeIntermediate
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Can't we all just get along?Susan RickmanBeginner
Change Data Capture tool for BI,Auditing,DR & moreJose ChinchillaBeginner
Check Engine LightsChris SkorlinskiIntermediate
Column Level EncryptionDavid DyeBeginner
Combining SQL Server, SSRS and SSAS with Tableau Dashboards Jen UnderwoodIntermediate
Complex DAX FunctionsMike DavisBeginner
Crazy Things That Developers DoWayne SheffieldBeginner
Data Warehouse ETL LoadingJorge NovoIntermediate
Data Warehousing Guidelines for BI and BAM solutionsShehap El-NagarAdvanced
Data Warehousing Guidelines for BI and BAM solutionsShehap El-NagarAdvanced
Database Design: Size DOES MatterThomas LaRockIntermediate
Database Development Comes out of the Dark Agesmiguel cebolleroIntermediate
Database Objects: Things that matterDmitri KorotkevitchIntermediate
Database Projects - Get to Know ThemJonathon MoormanBeginner
Dealing With Errors in SSIS 2012David DyeAdvanced
Denali Ho! Exploring SQL ServerRob VolkIntermediate
Designing and Optimizing SSAS HierarchiesJose ChinchillaBeginner
Discover, Document, & Diagnose Your Servers on Your Coffee BreakKendal Van DykeBeginner
Dynamic File Loading Using SSIS Programming Jorge NovoAdvanced
Eternal story on temporal objectsDmitri KorotkevitchIntermediate
ETL Frameworks using SSIS ProgrammingJorge NovoAdvanced
ETL: Avoiding Costly MistakesRafael SalasIntermediate
Free tools from the SQL Server CommunityEric WisdahlBeginner
Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issuesJanis GriffinIntermediate
Getting involved and Getting aheadTim RadneyBeginner
Harvesting Web Data Using Data Explorer and XMLRob VolkBeginner
Hello, My Name Is DAXMichael AntonovichIntermediate
Help! I've Got XML In My Database!Kendal Van DykeIntermediate
Help! I've Got XML In My Database!Kendal Van DykeIntermediate
How to be a GREAT DBAJeffrey GarbusBeginner
Implementing Auditing in SQL Server 2012David DyeBeginner
Indexing for Join OptimizationJeffrey GarbusAdvanced
Indexing for performanceJeffrey GarbusIntermediate
Inside the Query OptimizerBradley BallAdvanced
Introducing Cube World To Users From Flat Table LandMichael AntonovichIntermediate
Introduction to FileTables in SQL 2012Warren SifreIntermediate
Introduction to Slow Changing Dimensions Jorge NovoBeginner
Introduction to SQL Server ReplicationChad ChurchwellBeginner
Introduction to SSRS for DBAs Jon BloomBeginner
It is TEMPDB, Why Should You Care?Tim RadneyIntermediate
Know Backups and Know RecoveryTim RadneyIntermediate
Loading a Data Warehouse with SSISRobert BiddleAdvanced
Location Location Location Preparing and Presenting Geographic DataDavid DyeBeginner
Locks, Blocks, and Deadlocks Oh My!Randy KnightIntermediate
Maintenance and Backups: How Ola makes your life Jason CarterBeginner
Manage SQLServer Efficiently w/PowerShell RemotingAllen WhiteIntermediate
Microsoft Launch presentationBrian MitchellNon-Technical
PCI For The SQLDBAAndy WarrenBeginner
Performance baseline your new SQL instance shawn meyersIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Periodic Table of DMVs: Part Two - The SQLTim FordAdvanced
Policy-Based Management in a NutshellJorge SegarraBeginner
Putting Quality Back Into Your Data AnalysisMichael AntonovichIntermediate
Real World Report Server Performance Solutions and StrategiesDavid PlessIntermediate
Report With Power: New Data Tools, New InsightsJames McAuliffeBeginner
Self-service BI Revolution with Excel 2013Jose ChinchillaBeginner
Solving Complex Problems with Extended EventsJonathan KehayiasIntermediate
SQL Server 2012 AlwaysOn for HA and DRChad ChurchwellIntermediate
SQL Server Amnesia: Diagnosing Memory ProblemsJonathan KehayiasAdvanced
SQL Server Archaeology: Dig into the Past with system_healthJonathan KehayiasIntermediate
SQL Server Security Easy ButtonRonald DameronIntermediate
SQL Server Virtualization 101David KleeBeginner
SQL Server: Ground Zero BasicsJorge SegarraBeginner
Squeezing Top Performance from Your Virtualized SQL ServerDavid KleeBeginner
SSIS Log Providers, Custom Logging, and Event HandlersDavid DyeBeginner
SSIS Programming Using .NETJorge NovoBeginner
Statistics and Query OptimizationGrant FritcheyIntermediate
Subqueries for SuperheroesTracy McKibbenBeginner
Supercharge Microsoft BI with Pyramid AnalyticsMark ScottIntermediate
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
The Modern Data WarehouseBrian MitchellBeginner
Translate SQL server performance issues into business costsShawn MeyersIntermediate
Treating Tables Like Legos, Partitioning BasicsBrandon LeachBeginner
Trimming Indexes Getting Your Database In ShapeBradley BallIntermediate
T-SQL Performance Guidelines for better DB stress powersShehap El-NagarAdvanced
T-SQL Performance Guidelines for better DB stress powersShehap El-NagarAdvanced
T-SQL Performance Guidelines for better DB stress powersShehap El-NagarAdvanced
Understanding the SQL Server Transaction LogRandy KnightBeginner
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Unit Testing SSIS PackagesJohn WelchIntermediate
Unleashing SQL Server Performance MonitoringDavid PlessAdvanced
Using Excel 2010 as Your Analysis Services ClientMichael AntonovichIntermediate
What is a BI DBA?Jorge SegarraIntermediate
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate
Wrangling performance with Resource GovernorBrandon LeachBeginner
You Inherited a Database, Now What?Tim RadneyBeginner
Your Best Interview EverChris SkorlinskiBeginner


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