How the SQL Server Query Optimizer Works   The Query Optimizer is the component of SQL Server that attempts to determine the most efficient way to execute a query by finding the best execution plan. This session will show you how a better understanding on how the Query Optimizer works and what information it needs to generate better execution plans can help you to improve the performance of your databases. Learn about the high level structures of the Query Optimizer and some important factors that are considered during the optimization phase of query processing. See how you can provide SQL Server with appropriate statistics and indexes so it can perform better cardinality estimation and produce an efficient execution plan. Since SQL Server Query Optimizer is a cost based optimizer, this information will help to better estimate the execution plan cost. Finally, although the Query Optimizer almost always selects the best possible execution plan for a query, it may not create the fastest execution plans for all the possible scenarios. See how you can troubleshoot these issues and how you can use other alternatives like query hints or plan guides to force the query optimizer to produce a better execution plan.   About the Speaker Ben Nevarez has more than 15 years of experience with relational databases and has worked with SQL Server since version 6.5. He has been the technical editor of the two latest Kalen Delaney’s books including 'SQL Server 2008 Internals'. Ben holds a Master’s Degree in Computer Science and has been a speaker at several technology conferences, including the PASS Community Summit. Ben is currently a Senior Database Administrator with the American International Group (AIG).   Ben blogs at http://sqlblog.com/blogs/ben_nevarez/ and can be reached by e-mail at BNevarez at SQLServerInternals dot com.

 SQL Server Reporting Services

 

SQL Server Indexing for the Client Developer Presented by: Denny Cherry Presentation Abstract: In this session we will go over the way SQL Server indexes work and how to create them for maximum benefit. We will also go over some of the tips and tricks that DBAs use to improve index performance. Presenter Bio: Denny Cherry has over a decade of experience managing SQL Server, including MySpace.com’s over 175 million user installation, one of the largest in the world. Denny’s areas of technical expertise include system architecture, performance tuning, replication and troubleshooting. Denny uses these skills on a regular basis in his current role as a Sr. Database Administrator and Architect at Awareness Technologies. Denny currently holds several Microsoft Certifications related to SQL Server as well as being a Microsoft MVP.  Denny is a longtime member of PASS and Quest Software’s Association of SQL Server Experts and has written numerous technical articles on SQL Server management.

SQL Server Meeting in Orange County

SQL Server Analysis Services - From Planning to Implementation   

Presentation Abstract: In this presentation Ben will go through a practical and real-life journey of an SSAS project, from planning to design, development and implementation. Some of the challenges for converting the project from SQL Server 2005 to 2008 will also be discussed. Presenter Bio: Ben Aminnia has been the president and webmaster of Los Angeles SQL Server Professionals Group (www.sql.la) and also a board member of Los Angeles .NET Developers Group (www.ladotnet.org) for the past few years. He has worn many different hats in the SQL Server and .NET realms, including DBA Manager, Developer and Architect. He also has 20+ years of consulting experience with Pointer Corporation (www.pointercorp.com). Ben can be reached at: ben@pointercorp.com

Location   New Horizons 1900 S. State College Boulevard Suite 100 Anaheim, CA 92806

Fundamentals of Query Optimization & Performance Tuning Presented by: Allen Berezovsky Presentation Abstract: We will begin with examining the fundamentals of key concepts in SQL Server Performance Tuning such as Indexing and Statistics, and then finish off with live examples of how we can improve performance of our queries and make our customers happy. We will examine the power of reading and understanding execution plans, and will learn how to use SQL Server 2005 Database Tuning Advisor to quickly optimize your queries and stored rocedures. Presenter Bio: Allen Berezovsky is a senior DBA and developer with HarborObjects with over 12 years of experience. He is Microsoft certified and has a keen eye for solving real life SQL Server problems. His experience in implementing large scale web applications has helped him gain in depth knowledge about performance tuning and optimization of SQL Server.