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 TimeBI - Room: Franklin LabBI/Dev - Room: EBCDBA I - Room: MRP II DBA II - Room: MRP IDev - Room: WynnewoodDev/Misc - Room: TBDPerformance - Room: 30th StreetProf Dev/Misc - Room: BerwynSponsor Session - Room: Bryn Mawr
08:30 AMKevin Bucher

Business Analytics

Level: Beginner

download
Donald Scott

Enterprise Information Management Using SQL Server 2012

Level: Intermediate
Matt Velic

Automating in the Cloud

Level: Intermediate
Christopher Bell

“Indexing” Encrypted Data

Level: Intermediate

download
Bill Wolff

Using SQL Server for the Model in MVC

Level: Advanced
Mark Scott

Building Datamarts with SQL Server 2012

Level: Advanced

download
Janis Griffin

Extend Your Knowledge with Extended Events!

Level: Beginner

download
Andy Warren

Building Your Professional Development Plan

Level: Beginner

download
 
9:45 AMMark Hudson

Making Predictions with Microsoft Data Mining Tools

Level: Intermediate

download
Akesh Gupta

Self Service BI using Office 2013 and SQL 2012

Level: Intermediate
Michael Corey

Virtualizing SQL 2012: Doing IT Right

Level: Intermediate
Joseph D'Antoni

Using Compression to Improve Database Performance

Level: Intermediate
Wayne Sheffield

Windowing Functions in SQL Server 2012

Level: Intermediate

download
Darryll Petrancuri

Loading a Partitioned Fact Table using SSIS 2012.

Level: Advanced

download
Eddie Wuerch

Page Latches for Mere Mortals

Level: Advanced

download
Brian Moran

Awesome coaching questions every geek, analyst, leader, and consultant must know.

Level: Intermediate

download
 
11:00 AMVince Napoli

SSIS Performance Tuning Considerations

Level: Intermediate
Mike Hillwig

Recovery and Backup for Beginners

Level: Beginner

download
Steve Jones

Searching Binary Data in SQL Server 2012

Level: Intermediate

download
Bill Emmert

AlwaysOn - Finally, A usable 'mirror'!

Level: Beginner

download
Kevin Goff

T-SQL for Application Developers - Attendees chose

Level: Intermediate
Darryll Petrancuri

Loading a Partitioned Fact Table using SSIS 2012 (Continuation)

Level: Advanced
Hope Foley

My SQL Server is Not Slow for Pete's Sake! - Server Side Performance Analysis

Level: Beginner

download
Melissa Demsak

Data Career Paths and Decision Making Strategies

Level: Non-Technical
Eric Schwartz

Accelerating Microsoft SQL Databases & Critical Applications with Fusion-io

Level: Beginner
12:00 PMDave Bermingham and Eric Schwartz

High Performance SANLess Clustering

Level: Beginner
WIT Panel

Recruiting, Retaining & Advancing Women in Technology: Why does it matter?

Level: Non-Technical
Janis Griffin

Advanced Performance Tuning Tips with Ignite

Level: Beginner
Akira Lewis

Is the Job of a DBA, just a DBA?

Level: Beginner
  Peter Wellauer

Run your Applications @ the Speed of Memory

Level: Intermediate
  
01:30 PMJessica Moss

Exploring your Data with Power View

Level: Beginner
Ravi Gudlavalleti

Building a Reusable ETL Framework using SSIS 2012

Level: Intermediate

download
Robert Pearl

HealthySQL

Level: Beginner
Mike Hillwig

What the VLF?

Level: Advanced

download
Samuel Vanga

Automate SSIS Development for Loading a Data Warehouse

Level: Intermediate

download
John Abrams

Can you Restore Back to Yesterday? Always Answer YES!

Level: Intermediate
Eddie Wuerch

Partitioning for Perf and Mgmt of Large Tables

Level: Intermediate

download
Mark Kromer

Big Data & Microsoft SQL Server in the Real World

Level: Intermediate
 
02:45 PMA.J. Mee

Analysis Services - Multidimensional vs. PowerPivot vs. Tabular/BISM

Level: Intermediate

download
Paul Rizza

Upgrading to SSIS 2012

Level: Beginner
Charles Rivel

Move Your On Premise Database to a Windows Azure SQL Database and Setup Data Sync

Level: Intermediate

download
Gethyn Ellis

An Introduction to SQL Server Virtualisation

Level: Beginner
Kevin Boles

Common TSQL Mistakes

Level: Intermediate

download
Wayne Sheffield

Table Vars & Temp Tables - What you NEED to Know!

Level: Intermediate

download
Sebastian Meine

15 aspects of SQL Server indexes that you might not know

Level: Intermediate
Muthu Ramanathan

All about NoSQL databases !!

Level: Intermediate
 
04:00 PMDominic Falso

Introduction to Spatial Data in SQL Server

Level: Intermediate

download
Steven Wake

ABCs of CDC with SSIS 2012

Level: Intermediate

download
Timothy McAliley

A Walk Around the SQL Server 2012 Audit Feature

Level: Intermediate

download
David Bermingham

SQL Server 2012 AlwaysOn Step-by-Step

Level: Intermediate
Joshua Lynn

Learn RegEx In TSQL & Kick as{2}|a[s][s]+

Level: Beginner

download
Kevin Boles

Transaction Log Deep Dive

Level: Advanced

download
Mark Wojciechowicz

Easy Database Refactoring with SQL Server Database

Level: Beginner

download
Brian Davis

Goodbye Next Next Next, Hello Automated Installs

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
“Indexing” Encrypted DataChristopher BellIntermediate
15 aspects of SQL Server indexes that you might not knowSebastian MeineIntermediate
5 Key Points for Effective T-SQL Unit TestingSebastian MeineIntermediate
A Walk Around the SQL Server 2012 Audit FeatureTimothy McAlileyIntermediate
ABCs of CDC with SSIS 2012Steven WakeIntermediate
Accelerating Microsoft SQL Databases & Critical Applications with Fusion-ioEric SchwartzBeginner
Advanced Performance Tuning Tips with IgniteJanis GriffinBeginner
All about NoSQL databases !!Muthu RamanathanIntermediate
AlwaysOn - Finally, A usable 'mirror'!Bill EmmertBeginner
An Introduction to SQL Server VirtualisationGethyn EllisBeginner
Analysis Services - Multidimensional vs. PowerPivot vs. Tabular/BISMA.J. MeeIntermediate
Ask the expertsDonald ScottIntermediate
Automate SSIS Development for Loading a Data WarehouseSamuel VangaIntermediate
Automating in the CloudMatt VelicIntermediate
Awesome coaching questions every geek, analyst, leader, and consultant must know.Brian MoranIntermediate
Beyond the cube - Introduction to Tabular SSASJosh FennessyBeginner
Beyond the cube - Introduction to Tabular SSASJosh FennessyBeginner
Big Data & Microsoft SQL Server in the Real WorldMark KromerIntermediate
Branding Yourself for a Dream JobSteve JonesBeginner
Build your own Virtual LabMatt VelicIntermediate
Building a Reusable ETL Framework using SSIS 2012Ravi GudlavalletiIntermediate
Building Datamarts with SQL Server 2012Mark ScottAdvanced
Building Your Own Monitors with the SQL AgentMike HillwigIntermediate
Building Your Professional Development PlanAndy WarrenBeginner
Bulk Insert - Friend or FoeJoshua LynnBeginner
Business AnalyticsKevin BucherBeginner
Business and Money Tips for Independent Consultants: 20 years in 75 minutesBrian MoranIntermediate
Can you Restore Back to Yesterday? Always Answer YES!John AbramsIntermediate
Change Data Capture in SQL Server 2008/2012Kevin GoffIntermediate
Common TSQL MistakesKevin BolesIntermediate
Communicate for Great Good!Matt VelicNon-Technical
Data Career Paths and Decision Making StrategiesMelissa DemsakNon-Technical
Data Quality Services Approach to Cleansing Charles GaddyIntermediate
Defy the Defaults!Mike HillwigBeginner
Dive into the Query Optimizer-Undocumented InsightBenjamin NevarezAdvanced
Don't Panic, DBAs! Databases on VMware made easy.Janis GriffinIntermediate
Easy Database Refactoring with SQL Server DatabaseMark WojciechowiczBeginner
Enterprise Information Management Using SQL Server 2012Donald ScottIntermediate
Enterprise-Ready ETL Solutions Using SSIS 2012Donald ScottIntermediate
Exploring your Data with Power ViewJessica MossBeginner
Extend Your Knowledge with Extended Events!Janis GriffinBeginner
Getting Reports on Your ScheduleJessica MossBeginner
Global Address Data: Storage and VerificationCharles GaddyIntermediate
Goodbye Next Next Next, Hello Automated InstallsBrian DavisIntermediate
HealthySQLRobert PearlBeginner
High Performance SANLess ClusteringDave Bermingham and Eric SchwartzBeginner
Integrating MDX code with OLAP applicationsKevin GoffIntermediate
Integrating Reporting Services with SharePointKevin GoffIntermediate
Introduction to Spatial Data in SQL ServerDominic FalsoIntermediate
Is the Job of a DBA, just a DBA?Akira LewisBeginner
Join Us! Getting Started as a Technical SpeakerEddie WuerchBeginner
KeynoteSQL Saturday 200Beginner
Learn RegEx In TSQL & Kick as{2}|a[s][s]+Joshua LynnBeginner
Loading a Partitioned Fact Table using SSIS 2012 (Continuation)Darryll PetrancuriAdvanced
Loading a Partitioned Fact Table using SSIS 2012.Darryll PetrancuriAdvanced
Looney Tuner? No, there IS a method to my madnessJanis GriffinIntermediate
M2M Relationships in SSAS Tabular and PowerPivotCraig CollierIntermediate
Making Predictions with Microsoft Data Mining ToolsMark HudsonIntermediate
Matching and Survivorship Charles GaddyIntermediate
Minimally Invasive - Tools to Doctor Up Your CodeWayne SheffieldIntermediate
Move Your On Premise Database to a Windows Azure SQL Database and Setup Data SyncCharles RivelIntermediate
Much Ado About Indexes - Tips, Tricks and TSQLRobert PearlBeginner
My SQL Server is Not Slow for Pete's Sake! - Server Side Performance Analysis Hope FoleyBeginner
Page Latches for Mere MortalsEddie WuerchAdvanced
Partitioning for Perf and Mgmt of Large TablesEddie WuerchIntermediate
Put Your Data on the MapMark HudsonBeginner
Recovery and Backup for BeginnersMike HillwigBeginner
Recruiting, Retaining & Advancing Women in Technology: Why does it matter?WIT PanelNon-Technical
Run your Applications @ the Speed of MemoryPeter WellauerIntermediate
Searching Binary Data in SQL Server 2012Steve JonesIntermediate
Self Service BI using Office 2013 and SQL 2012Akesh GuptaIntermediate
SharePoint COOP Using 2008R2 Log ShippingDonald ScottIntermediate
SharePoint COOP Using SQL Server 2012 Always-OnDonald ScottIntermediate
Shortcuts to Building SSIS in .NetPaul RizzaBeginner
Spatial Data: Cooler Than You'd Think!Hope FoleyBeginner
SQL 2012 Extended EventsJason BrimhallAdvanced
SQL 2012 Table CompressionJason BrimhallAdvanced
SQL InjectionKevin BolesIntermediate
SQL Server 2012 AlwaysOn DemystifiedDavid BerminghamBeginner
SQL Server 2012 AlwaysOn Step-by-StepDavid BerminghamIntermediate
SQL Server 2012 Columnstore indexKevin GoffIntermediate
SQL Server 2012 TSQL Enhancements and AdditionsKevin BolesIntermediate
SQL Server Backup and Recovery FundamentalsAyman El-GhazaliBeginner
SQL Server Columnstore Index – How it worksSebastian MeineAdvanced
SQL Server Reporting Services, attendees chooseKevin GoffIntermediate
SQL Server Security for DevelopersAndy WarrenBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSAS Tabular 2012 vs SSAS Multidimensional OLAPKevin GoffIntermediate
SSIS 2012: More Than Just a Pretty UISteven WakeBeginner
SSIS Performance Tuning ConsiderationsVince NapoliIntermediate
SSIS Templates Can Make Your Life EasierBrian DavisBeginner
Stress testing SQL ServerHilary CotterAdvanced
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
TestWesley ChangBeginner
The Data Whisperer: Detecting & Extracting Meaning From Changing DataJoshua LynnIntermediate
The Encryption PrimerSteve JonesBeginner
The new tabular model in Analysis Services 2012Kevin GoffIntermediate
Top Query Optimizer Topics for Better PerformanceBenjamin NevarezIntermediate
Transaction Log Deep DiveKevin BolesAdvanced
T-SQL for Application Developers - Attendees choseKevin GoffIntermediate
Understanding Parameter SniffingBenjamin NevarezIntermediate
Upgrading to SSIS 2012Paul RizzaBeginner
Using Compression to Improve Database PerformanceJoseph D'AntoniIntermediate
Using SQL Server for the Model in MVCBill WolffAdvanced
Virtualizing SQL 2012: Doing IT RightMichael CoreyIntermediate
Visualize Twitter Data, with Tools You Already Know!Samuel VangaBeginner
What Can DQS Do for You?Mark HudsonBeginner
What the VLF? Mike HillwigAdvanced
What’s new in SQL Server Integration Services 2012Kevin GoffIntermediate
Why OLAP? Building SSAS cubes and benefits of OLAPKevin GoffIntermediate
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate


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