Skip Main Navigation
Page Content
This event has ended

MagicPASS January 2015 Meeting

MagicPASS

Wednesday, January 21, 2015 from 5:00 PM to 9:00 PM (EST)

MagicPASS January 2015 Meeting

Registration Information

Type Remaining End Quantity
MagicPASS January 2015 Meeting 13 Registrations Ended Free  

Share MagicPASS January 2015 Meeting

Event Details

Free SQL Server Training!

Join us for the January 2015 meeting of MagicPASS, South Orlando's SQL Server User Group. Food and beverages will be served, plus we've got swag to give away!

This month we welcome SQL Server MVP Jes Borland via video conference to present Execution Plans: The Secret to Query Tuning Success.

After the meeting we'll head to the Celebration Town Tavern for more socializing. (You are responsible for your own drinks)

Make a difference in someone's career: Invite them to attend the meeting with you! (Heck, invite them to attend even if you can't make it)

Featured Presentation

Execution Plans: The Secret to Query Tuning Success

Speaker: Jes Borland (Remote Presentation)

Summary: SQL Server will tell you exactly what steps it took to return the results of your query. By being able to read this "map", you can tell where you can improve it! This session will show you how to read execution plans, what common problems can be uncovered, and what the execution plan doesn't tell you. You'll leave this session able to go to work, open a plan, and identify where to start fine-tuning the query.

About Jes: Jes Schultz Borland is a consultant with Brent Ozar Unlimited and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is an active member of PASS, President of FoxPASS in northeast Wisconsin, founder of Tech on Tap, and a LessThanDot.com blogger. Jes frequently presents at user groups, SQLSaturdays, and other community events. She is also an avid runner and chef.

Pre-Meeting Presentation

Query Tuning Mastery: Manhandling Parallelism, 2014 Edition (Video Replay From the 2014 PASS Summit)

Speaker: Adam Machanic

Summary: When it comes to driving ultimate performance for your biggest queries, parallelism is the name of the game. Don't let SQL Server decide when and where to apply its parallel magic; be your own query optimizer and take control!

The 2012 edition of this talk--one of the most popular sessions at PASS Summit--discussed problems with parallel costing, intricacies of plan selection and execution, and the extremely effective Parallel CROSS APPLY pattern. But these things were just the beginning. Two more years of research have yielded new insights, new techniques, and new performance gains.

In this session, you'll get a quick review of the 2012 content before diving into brand-new costing hacks, tricks for leveraging parallel scans, and a set of SQLCLR functions that will give you more control over intraquery parallelism than you ever thought possible. Get ready: it's time to Manhandle Parallelism all over again.

Have questions about MagicPASS January 2015 Meeting? Contact MagicPASS

When & Where


Disney Vacation Club
1390 Celebration Blvd
Celebration, FL 34747

Wednesday, January 21, 2015 from 5:00 PM to 9:00 PM (EST)


  Add to my calendar

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.