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 TimeA - Room: Golisano 1435B - Room: Golisano 1445C - Room: Golisano 1455D - Room: Golisano 1610E - Room: Golisano 1620F - Room: Golisano Auditorium
08:45 AMTim Costello

Dimensional Design primer: What you need to know

Level: Intermediate
David Eichner

SRS Report Builder for Business Intelligence

Level: Beginner

download
JEFFERY HICKS

Getting Started with Background Jobs in PowerShell

Level: Beginner

download
Randy Knight

But it worked great in Dev! Perfomance for Devs

Level: Beginner

download
Grant Fritchey

What to Look for in Execution Plans

Level: Intermediate
Andy Roberts

New High Availability options with SQL Server 2012

Level: Beginner

download
10:15 AMTim Costello

Pro Tips: Performance Tuning SSIS

Level: Intermediate
William E. Pearson III

Overcoming Barriers and Avoiding Mistakes with BI

Level: Intermediate
JEFFERY HICKS

Jobs and Tasks in PowerShell 3.0

Level: Intermediate

download
Jason Thomas

Fast Track to Spatial Reporting

Level: Intermediate
Grant Fritchey

Top Tips for Writing Better T-SQL Queries

Level: Intermediate
Andy Roberts

The biggest and baddest SQL Installs in the World

Level: Beginner

download
12:45 PMTim Costello

ELT: Old school data loading with tsql

Level: Intermediate
William E. Pearson III

Getting Started with MDX

Level: Beginner
JEFFERY HICKS

PowerShell v3 WorkFlows

Level: Intermediate

download
Janis Griffin

Looney Tuner? No, there IS a method to my madness

Level: Intermediate

download
Robert Schoedel

Discover the power of Visual Studio db projects

Level: Intermediate

download
David Benoit

Replication- A fresh look & peek behind the scenes

Level: Intermediate
02:15 PMTim Costello

Data Visualization primer: What you need to know

Level: Intermediate
David Eichner

An Overview of PowerPivot

Level: Beginner
Randy Knight

Understanding Transaction Isolation Levels

Level: Intermediate

download
Janis Griffin

Don't Panic, DBAs! Databases on VMware made easy.

Level: Intermediate

download
Robert Schoedel

SQL 2012 Master Data Services (MDS)

Level: Beginner

download
Grant Fritchey

Deadlocks and what to do about them

Level: Intermediate
03:45 PMChristopher Crane

Introducing Query Optimization

Level: Intermediate

download
William E. Pearson III

Becoming DAX: An Introduction ...

Level: Intermediate
Randy Knight

Understanding SQL Server XML Features

Level: Intermediate

download
Janis Griffin

Extend Your Knowledge with Extended Events!

Level: Beginner

download
Andy Roberts

SQL Server 2012 T-SQL Enhancements

Level: Beginner

download
Grant Fritchey

Common Backup Problems and How to Deal With Them

Level: Beginner
05:00 PMSQL Saturday Rochester, NY

Final Raffle Drawings

Level: Beginner
SQL Saturday Rochester, NY

Final Raffle Drawings

Level: Beginner
SQL Saturday Rochester, NY

Final Raffle Drawings

Level: Beginner
SQL Saturday Rochester, NY

Final Raffle Drawings

Level: Beginner
SQL Saturday Rochester, NY

Final Raffle Drawings

Level: Beginner
SQL Saturday Rochester, NY

Final Raffle Drawings

Level: Beginner


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
An Overview of PowerPivotDavid EichnerBeginner
As a DBA, Where Do I Start?Mike WalshBeginner
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIBeginner
Aviation Disasters - And IT Lessons From ThemMike WalshBeginner
Become Bilingual! Oracle for the SQL Server DBARandy KnightIntermediate
Becoming DAX: An Introduction ... William E. Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Bridging the Chasm: BI Theory vs. Practice William E. Pearson IIIIntermediate
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Common Backup Problems and How to Deal With ThemGrant FritcheyBeginner
Data Visualization primer: What you need to knowTim CostelloIntermediate
Deadlocks and what to do about themGrant FritcheyIntermediate
Design and Implement BI Like Edison!William E. Pearson IIIBeginner
Dimensional Design primer: What you need to knowTim CostelloIntermediate
Discover the power of Visual Studio db projectsRobert SchoedelIntermediate
Don't Panic, DBAs! Databases on VMware made easy.Janis GriffinIntermediate
ELT: Old school data loading with tsqlTim CostelloIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Extend Your Knowledge with Extended Events!Janis GriffinBeginner
Fast Track to Spatial ReportingJason ThomasIntermediate
Final Raffle DrawingsSQL Saturday Rochester, NYBeginner
Getting Started with Background Jobs in PowerShellJEFFERY HICKSBeginner
Getting Started with MDXWilliam E. Pearson IIIBeginner
Introducing Query OptimizationChristopher CraneIntermediate
Jobs and Tasks in PowerShell 3.0JEFFERY HICKSIntermediate
Looney Tuner? No, there IS a method to my madnessJanis GriffinIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
New High Availability options with SQL Server 2012Andy RobertsBeginner
Overcoming Barriers and Avoiding Mistakes with BIWilliam E. Pearson IIIIntermediate
PowerPivot for ExcelWilliam E. Pearson IIIBeginner
PowerShell v3 WorkFlowsJEFFERY HICKSIntermediate
Pro Tips: Performance Tuning SSISTim CostelloIntermediate
Pro Tips: Troubleshooting SSISTim CostelloIntermediate
Reciprocal Symmetry: Doing MDX in PowerPivotWilliam E. Pearson IIIIntermediate
Replication- A fresh look & peek behind the scenesDavid BenoitIntermediate
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
SQL 2012 Master Data Services (MDS)Robert SchoedelBeginner
SQL Server 2012 Is Here - Why Should You Care?Mike WalshBeginner
SQL Server 2012 T-SQL EnhancementsAndy RobertsBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
The biggest and baddest SQL Installs in the WorldAndy RobertsBeginner
Top Tips for Writing Better T-SQL QueriesGrant FritcheyIntermediate
Understanding SQL Server XML Features Randy KnightIntermediate
Understanding Transaction Isolation LevelsRandy KnightIntermediate
What to Look for in Execution PlansGrant FritcheyIntermediate


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