Introduction to SQL Server Statistics
September 7th 12:00 PM EDT (GMT -4)
Presenter: Andy Warren
This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you’re a DBA or trying to get by without one, this session will give you the information you need to know.
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, is co-President of the Orlando SQL Server Users Group, 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.
Designing High Performance I/O for SQL Server
September 8th 12:00 PM EDT (GMT -6)
Presenter: Jimmy May
This session attempts to describe the “full story” of SQL Server I/O. We will start at the hardware level working our way up the stack through Windows and into the SQL Server storage engine. I aim to provide in depth information about all aspects related to the fundamentals of high performance storage design for SQL Server and best practices on this complex subject.
Jimmy is a Sr. Program Manager for the SQL Server Customer Advisory Team. He is the manager of the SQL Server Customer Lab where customers from around the world bring the biggest, fastest, & most interesting SQL Server apps for tuning. He is a founder of both the Indiana Windows User Group (http://www.iwug.net) and Indianapolis Professional Association for SQL Server (http://www.indypass.org). Jimmy recently moved to Redmond from Indianapolis, Indiana with his lovely bride, Phyllis, and Fannie May the Wonder Dog. Subscribe to and read his SQL Server performance and personal productivity blog at http://blogs.msdn.com/jimmymay. Contact him at email@example.com or firstname.lastname@example.org. Jimmy is also part of the rich & robust SQL Server community on Twitter: www.twitter.com/aspiringgeek.
Live Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=S29G25&role=attend
Data Mining with PowerPivot 2010
September 8th 12:00 PM EDT (GMT -4)
Presenter: Mark Tabladillo
Excel provides a compelling and ubiquitous interface for Microsoft Data Mining. With new features available through PowerPivot, business users can apply the technology through a well-designed infrastructure of Microsoft technologies. This presentation will welcome any newcomers to data mining, and provide interactive demos which highlight data mining through these technologies.
Mark provides consulting and training for data mining with Solid Quality Mentors. He has taught statistics at Georgia Tech and for the graduate business school of the University of Phoenix. In addition to his Microsoft certifications (MCAD .NET and MCT), Mark has years of deep experience with the SAS System, and has presented at many local, regional, and national technical conferences. Mark produces a data mining resource and blog at http://www.marktab.net