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: C112BI2 - Room: C114DBA - Room: E303Dev - Room: A201Mixed - Room: Auditorium (1st Floor)Professional Development / Misc - Room: C200
08:45 AMJessica Moss

Getting Reports on Your Schedule

Level: Beginner
Kevin Hazzard

Creating an Extensible Data Quality Foundation

Level: Intermediate

download
Tim Chapman

SQL Server Index Internals

Level: Advanced
Jason Hall

5 Common SQL Server Performance Issues

Level: Intermediate

download
Kevin Kline

Top 10 Admininistrator Mistakes on SQL Server

Level: Beginner

download
Matt Velic

Build your own Virtual Lab

Level: Intermediate
10:00 AMMelissa Coates

Dashboards...How To Choose Which MSBI Tool

Level: Beginner
Andy Leonard

“I See a Control Flow Tab. Now What?” (Level 100)

Level: Beginner
Joseph D'Antoni

SQL 2012 -- All About HA and DR

Level: Intermediate
Kevin Boles

Windowing Functions: THE Reason to Upgrade to 2012

Level: Intermediate

download
Karen Lopez

Database Design Contentious Issues

Level: Intermediate

download
Rob Volk

Revenge: The SQL Part 2: The Sequel!

Level: Intermediate

download
11:15 AMPaul Rizza

Upgrading to SSIS 2012

Level: Beginner
John Welch

Unit Testing SSIS Packages

Level: Intermediate
Geoff Johnson

Intro to Common Table Expressions

Level: Beginner

download
Tim Chapman

Writing faster queries

Level: Advanced
Steve Jones

Branding Yourself for a Dream Job

Level: Beginner

download
SHANNON LOWDER

OnPremise to Azure

Level: Intermediate

download
12:30 PM   CapTech Consulting

Implementing CapTech's Data Management Framework

Level: Beginner
Panel Discussion

Women in Technology: Breaking the Glass Ceiling

Level: Beginner
Nimble Storage

How Flash-Optimized Storage Accelerate Performance and Simplify Storage For Virtualized Environments

Level: Beginner
01:45 PMPhilip Noakes

Realizing the Power of Microsoft Reporting

Level: Beginner

download
A.J. Mee

SQL Server 2012's Net-New BI Capabilities

Level: Intermediate
Brandon Leach

A DBAs Guide to HIPAA

Level: Beginner
Paul Oster

SQL Server and XML Imports and Exports

Level: Intermediate
Kevin Kline

Team Leadership Fundamentals

Level: Beginner

download
Grant Fritchey

Query Tuning in the Clouds

Level: Intermediate
03:00 PMStacia Misner

(Way Too Much) Fun with Reporting Services

Level: Beginner

download
Melissa Coates

So You Want To Be A Rockstar Report Developer?

Level: Intermediate
Mike Hillwig

How Not to Be a Cranky DBA

Level: Beginner
Steve Jones

The Encryption Primer

Level: Beginner

download
Thomas LaRock

Choose Your Own Adventure: Performance Tuning

Level: Advanced
Michael Corey

Virtualizing SQL Server 2012: Doing IT Right

Level: Intermediate
04:15 PMRafael Salas

Waiter, There's a Fly In My Data

Level: Intermediate
John Welch

Moving Big Data - SSIS, Pig, and Sqoop

Level: Beginner
Grant Fritchey

Database Backups for the Accidental DBA

Level: Beginner
Kevin Boles

Common TSQL Mistakes

Level: Intermediate

download
Andy Leonard

Using BIML as an SSIS Design Patterns Engine

Level: Advanced
Jason Hall

Recipe for a happy DBA

Level: Beginner

download


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
(Way Too Much) Fun with Reporting Services Stacia MisnerBeginner
“ColumnStore” Indexes for Fast EDW Queryderek daiIntermediate
“I See a Control Flow Tab. Now What?” (Level 100)Andy LeonardBeginner
“Indexing” Encrypted Data with Hash GroupsChris BellIntermediate
5 Common SQL Server Performance IssuesJason HallIntermediate
A DBAs Guide to HIPAABrandon LeachBeginner
Big Data/Smaller Pieces with PartitioningMike FemenellaBeginner
Branding Yourself for a Dream JobSteve JonesBeginner
Brian Garraty's Series of Unfortunate EventsBrian GarratyIntermediate
Build your own Virtual LabMatt VelicIntermediate
Change Data Capture & Change Tracking Deep DiveKevin HazzardAdvanced
Choose Your Own Adventure: Performance TuningThomas LaRockAdvanced
Common TSQL MistakesKevin BolesIntermediate
Communicate for Great Good!Matt VelicNon-Technical
Creating an Extensible Data Quality FoundationKevin HazzardIntermediate
Dashboards...How To Choose Which MSBI ToolMelissa CoatesBeginner
Database Backups for the Accidental DBAGrant FritcheyBeginner
Database Design Contentious IssuesKaren LopezIntermediate
DAX Formulas: Evaluation ContextJavier GuillenIntermediate
Defy the Defaults!Mike HillwigBeginner
Disk IO Tuning on Microsoft SQL ServerKevin KlineBeginner
Dive into the Query Optimizer-Undocumented InsightBenjamin NevarezAdvanced
Exploring your Data with Power ViewJessica MossBeginner
Getting Reports on Your ScheduleJessica MossBeginner
How Flash-Optimized Storage Accelerate Performance and Simplify Storage For Virtualized EnvironmentsNimble StorageBeginner
How Not to Be a Cranky DBAMike HillwigBeginner
Implement Agile BI with SQL2012 Powerpivot/BISMderek daiIntermediate
Implementing CapTech's Data Management FrameworkCapTech ConsultingBeginner
Intro to Common Table ExpressionsGeoff JohnsonBeginner
Managed Self-Service BIMelissa CoatesIntermediate
Model-Driven Database DesignKaren LopezBeginner
Moving Big Data - SSIS, Pig, and SqoopJohn WelchBeginner
MS Access with SQL Server Strategies and TipsJuan SotoBeginner
OnPremise to AzureSHANNON LOWDERIntermediate
Query Performance Tuning: A 12 Step ProgramThomas LaRockIntermediate
Query Tuning in the CloudsGrant FritcheyIntermediate
Realizing the Power of Microsoft ReportingPhilip NoakesBeginner
Recipe for a happy DBAJason HallBeginner
Reporting Services for Mere DBAsJason BrimhallIntermediate
Revenge: The SQL Part 2: The Sequel!Rob VolkIntermediate
Revenge: The SQL!Rob VolkIntermediate
Searching Binary Data in SQL Server 2012Steve JonesIntermediate
Seven SQL Agent Jobs You Should be RunningMike HillwigBeginner
Shame-free Database Restores with PowerShell Brian GarratyIntermediate
Shortcuts to Building SSIS in .NetPaul RizzaBeginner
So You Want To Be A Rockstar Report Developer?Melissa CoatesIntermediate
SQL 2012 -- All About HA and DRJoseph D'AntoniIntermediate
SQL 2012 ColumnStore Indexing FundamentalsAshton HobbsBeginner
SQL 2012 Extended EventsJason BrimhallAdvanced
SQL 2012 Table CompressionJason BrimhallAdvanced
SQL Server 2012 TSQL Enhancements and AdditionsKevin BolesIntermediate
SQL Server 2012's Net-New BI Capabilities A.J. MeeIntermediate
SQL Server and XML Imports and ExportsPaul OsterIntermediate
SQL Server Index InternalsTim ChapmanAdvanced
SQL Server Transaction Log InternalsTim ChapmanAdvanced
SQL Server: The Undiscovered CountryRob VolkIntermediate
SSIS 2012: Project Deployment Model End To EndRafael SalasIntermediate
Taking BI to the Next Level: CollaborationStacia MisnerIntermediate
Tame Your Unruly Data...With Constraints!Rob VolkBeginner
Team Leadership FundamentalsKevin KlineBeginner
Temporary InsanityMichael FemenellaIntermediate
The Art of Selecting the Right TestDennis Lloyd JrIntermediate
The Encryption PrimerSteve JonesBeginner
Thwarting Database DefectsDennis Lloyd JrIntermediate
Top 10 Admininistrator Mistakes on SQL ServerKevin KlineBeginner
Top Query Optimizer Topics for Better PerformanceBenjamin NevarezIntermediate
Transaction Log Deep DiveKevin BolesAdvanced
Trends in Database Administration & How DBA ChangMichael CoreyNon-Technical
T-SQL SELECT Subqueries - In and Out of the BoxGeoff JohnsonBeginner
Tuning Analysis Services Processing PerformanceJohn WelchAdvanced
Understanding Parameter SniffingBenjamin NevarezIntermediate
Unit Testing SSIS PackagesJohn WelchIntermediate
Upgrading to SSIS 2012Paul RizzaBeginner
Using BIML as an SSIS Design Patterns Engine Andy LeonardAdvanced
Virtualization for SQL DBAsJoseph D'AntoniIntermediate
Virtualizing SQL Server 2012: Doing IT Right Michael CoreyIntermediate
Waiter, There's a Fly In My Data Rafael SalasIntermediate
What Counts for A DBA-ObservantLouis DavidsonBeginner
What Sequence objects are (and are not)Louis DavidsonIntermediate
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesIntermediate
Wish you could live the glamorous consulting life?Juan SotoBeginner
Women in Technology: Breaking the Glass CeilingPanel DiscussionBeginner
Writing faster queriesTim ChapmanAdvanced


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