MagicPASS February 2011 Meeting

Kendal Van Dyke, 2011-02-15

Feb 2011 Graphic

Register for MagicPASS February 2011 Meeting in Celebration, FL  on Eventbrite

If you’re in the central Florida area you’re invited to the February 2011 meeting of MagicPASS, South Orlando’s SQL Server User Group. We’ll have food & drinks, networking, presentations from Andy Warren and Bradley Ball, and swag to give away.

This month’s meeting is sponsored by Red Gate Software and Signature Consultants and will also include a brief demonstration of Red Gate’s SQL Monitor.

We’re changing the meeting format and times to include a bonus “pre-meeting” presentation for those that want to absorb more SQL Server learning. The pre-meeting begins at 5:00 PM and the main meeting begins at 6:30 PM. Pre-meeting attendance is optional – if you can’t make it we’d still love to have you come for the main meeting!

Join us afterwards at the Celebration Town Tavern for more socializing and shop talk. (You are responsible for your own drinks)


Pre-Meeting Presentation

Basics of Performance Tuning – Part 1

Speaker: Andy Warren

Abstract: In part one of our three part class on performance tuning you’ll learn how to use Profiler, the tool that ships with SQL Server that is used to monitor SQL statements sent to the server. We’ll show you how to start a Profiler session, set up the most common events, columns, and filters, and how to create a template so you can easily use the same settings each time. We’ll explain how to assess the cost of a query by looking at reads, writes, cpu time, and duration. We’ll finish up by showing you how to set up a server side trace – think of it as Profiler without the UI. Knowing how to use Profiler is critical for a DBA, and incredibly useful for a developer.

About Andy: Andy Warren is a SQL trainer focusing on basic administration and performance tuning, he runs the free training site, is currently a SQL Server MVP, blogs daily at, started the SQLSaturday franchise, serves as a member of the Board of Directors of PASS, and was a founding partner in In his remaining free time he’s working on a book for first time managers

Main Meeting Presentation

Page And Row Compression How, When, and Why

Speaker: Bradley Ball

Abstract: Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page & Row with SQL 2008 RTM, and Page & Row with Unicode Compression with SQL 2008 R2. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan patterns affect the compression types you should consider. And what you should you take into consideration for additional overhead.

About Bradley: Bradley Ball is a MCITP SQL 2005 & MCTS 2008 Database Administrator with over 10 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office Of the President of the United States. He is currently a Sr. SQL Database Administrator for Publix Supermarkets. Bradley can be found blogging on





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads