SQL Server Meeting in Orange County  

Fundamentals of Query Optimization & Performance Tuning

Presentation Abstract:

We will begin with examining the fundamentals of key concepts in SQL Server Performance Tuning such as Indexing, Statistics, Primary and Foreign Keys, and Referential Integrity, and 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.

New Horizons 1900 S. State College Boulevard Suite 100 Anaheim, CA 92806 Time: 6:30pm - 9:00pm Meetings are on the 2nd Thursday of each month, unless noted with the meeting event.

http://www.ocdotnet.org/SIGs/SQLServerUserGroupSIG/tabid/174/Default.aspx

• SQL Server 2005 Analysis Services Step by Step - Reed Jacobson
• Foundations of SQL Server 2005 Business Intelligence - Lynn Langit
• Practical Business Intelligence with SQL Server 2005 - John C. Hancock and Roger Toren
• A Decision Maker's Overview of Business Intelligence in SQL Server 2005 – Ben Aminnia Click here  

SQL Server Meeting in Orange County  

SQL Server Clustering 101

In this session we will cover the basics and delve into the advanced techniques which can be used to cluster Windows servers using the Windows Cluster Service, what sort of protection this provides you, and how to properly set up your clusters for a rock solid environment which will last you for many years to come. We will start with planning our cluster configuration, selecting our software, and walk through the process of clustering two servers together into an active passive cluster. We will cover the differences between a standalone machine and clusters with regard to licensing and multiple instance configurations.

Presenter Bio:

Denny Cherry has over a decade of experience managing SQL Server, including MySpace.com's more than 175-million-user installation, one of the largest in the world. Denny's areas of expertise include system architecture, performance tuning, replication and troubleshooting. He uses these skills in his role as a senior database administrator and architect at Awareness Technologies. 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.

Service Dispatcher: SQL Server Service Broker at MySpace

SQL Server Meeting in Orange County August 14, 2008 - 6:30-9:30 p.m. - Microsoft Irvine, 3 Park Plaza, Suite 1600, Irvine, CA 92614 Presentation: Lynn Langit -  Business Intelligence with SQL Server 2008

Business Intelligence with SQL Server 2008 and PerformancePoint Server 2007

Presented by: Deborah Ford, Microsoft

To retrieve a copy of this meeting's PowerPoint presentation, please click on the following links:

• Introduction (2.08 MB)
• Part 1 (3.48 MB)
• Part 2 (1.54 MB)
• Part 3 (3.76 MB)

To learn more about PerformancePoint Server, please follow this link.