Featured Presentation

Introduction to PowerPivot for Excel

Speaker: Mike Antonovich

Summary: This presentation focuses on the basics of how to use PowerPivot with Excel to create simple pivot tables (cubes) and pivot charts using both data already in Excel as well as how to connect to SQL tables as your data source. It will also cover how add slicers, how to add calculated columns and how to define hierarchies in your pivot tables.

About Mike: Mike Antonovich is the Assistant Director of Web Services for Orange County Public Schools in Orlando, FL where he manages the SharePoint portal team implementing the Internet, intranet, collaboration, project, team, and school sites. They are also responsible for multiple .Net custom applications around the district. In June of 2010, he published his 7th book: Office and SharePoint 2010 User's Guide. Mike has been using SQL Server since 1998 and SharePoint since 2007.

 

Pre-Meeting Presentation

Basics of Performance Tuning - Part 3

Speaker: Andy Warren

Summary: As we wrap up our three part look at performance tuning you’ll learn how to read a query plan as we walk through some common query types, and we’ll then bring the lessons you learned about Profiler and indexing into play as we tune a few queries so you can see the impact. You’ll learn how to read the tool tips, what areas of a plan to focus on, and see first hand just how much difference an index can make - and why!

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

cage-aids
cage-aids
cage-aids
cage-aids