Speaker: Brad McGehee
Add To Outlook: Add To Calendar
Date and Time:
2/25/2010 11:30:00 AM CST
BIO: Brad M. McGehee (www.bradmcgehee.com) is a MCSE+I, MCSD, and MCT (former) with a Bachelors’ degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 15 years’ SQL Server experience, over 6 years’ training experience, and has been involved in the industry since 1982.
Brad is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars, where he shares his 15 years’ cumulative knowledge.
In 2009, Brad made 33 public presentations to a total of 1,853 attendees, in six different countries.
A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 15 technical books and over 100 published articles. His most recent books include “How to Become an Exceptional DBA (2nd Edition)”, “Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs”, “Mastering SQL Server Profiler”, and “Brad’s Sure Guide to Database Maintenance Plans”. These eBooks are available free in PDF format at: http://www.sqlservercentral.com/Books/.
Topic: #11-Introduction to Graphical Execution Plans
One of the black arts of being a DBA is learning how to read and interpret graphical execution plans. This is an important skill, as knowing how to read and interpret graphical execution plans can help the DBA tune queries for optimal performance. Without this crucial knowledge, the DBA won’t be able identify potential query problems, nor understand how to fix them.
In this short, introductory level session, which is designed for DBAs with little or no knowledge of query execution plans, you will learn why execution plans are important, how they are created, learn about the different execution plan formats, discover different ways to produce them, find out about the difference between estimated and actual execution plans, and learn the basics of how to read them. Because this is an introductory session, after attending, I highly recommend you download this free eBook to learn more about execution plans: “SQL Server Execution Plans” by Grant Fritchey. http://www.sqlservercentral.com/articles/books/65831/
This session assumes attendees have a basic foundation of DBA knowledge. After attending the session, attendees will be able to immediately put what they have learned into practice.
|
Speaker: Max Trinidad
Add To Outlook: Add To Calendar
Date and Time:
3/9/2010 11:30:00 AM CST
BIO: Max Trinidad is a native of Puerto Rico and has been working with computers since 1979. He has worked with Dbase III/IV, Clipper, RPG, OS/400, OCL/JCL/CL, HTLM and most current MS development technologies. Work for many years as a Senior IT/Developer has provided support for Windows Servers 2003/2008, SQL Servers Applications, Microsoft Virtualization Technologies, and IBM iSeries building Visual Studio solutions. In 2009 and 2010 got his Microsoft MVP award in Powershell.
Topic: #12-Intro SQL Server and Power Shell
Brief tour on SQLServer 2008 (r2) PowerShell. You will how easy is to manipulate database information with PowerShell. Check the difference between PowerShell (v1/v2)vs SQLPS.exe (SQL PowerShell mini-shell). Create to PowerShell SQL Agent Job and how to interact with .NET technologies. All in 30 minutes.
|
Speaker: Mike Davis
Add To Outlook: Add To Calendar
Date and Time:
3/15/2010 11:30:00 AM CST
BIO: Mike Davis is a Senior BI consultant and Trainer at Pragmatic Works. He was an author on the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups across the US, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.
Topic: #13-Advanced Parameters in SSRS 2008
In this session Mike shows parameters in many different ways including stored procedure, cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures and using parameters with custom code. Key takeaways: Learn how to use advanced parameter techniques in SSRS 2008 including stored procedure parameters cascading parameters and multi value parameters.
|