www.sqlpass.org    Professional Association for SQL Server
 Welcome

We have meetings on the second Thursday of every month.  Our group meets at the Johnson County Community College Regnier Center. Our normal room is room #236 but check the visual displays when you arrive to confirm.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:30 - General Q&A session & Announcements
6:30 - 7:30 - Presentation(s)
7:30 - ?? - Door prizes and Question & Answer session

***NOTICE***

12345 College Blvd
Overland Park, Kansas 66210-1299
913-469-8500
Once you arrive the Regnier center is the red brick building next to the large white building. Parking is available under the center as well as on three sides. Once inside please check the room displays as the college frequently changes our room assignment.

If you cannot find us please call Neil Watkins @ 913-515-1404

 Next Meeting

Topic:        

Integrated Database Development with Visual Studio 2005 for Database Professional

Date:

Thursday, January 10, 2008

 

 

Speaker:

 

 

 

 

Neil Watkins

Neil Watkins is the manager of database administration for Epiq Systems Inc. He has over 10 years experience working with SQL Server technologies and is the current president of the Kansas City SQL Server Users Group.

Location:

Johnson County Community College (JCCC) Regnier Center.

Overview:

 

 

 

 

Sponsor:

This presentation is designed to show you how you can leverage VS2005 DB Pro to take control of your database development. This includes: Developing without a database, data generation, source control integration, design time validation, static code analysis, and ERD integration.

 

Damien Bowersock from EqualLogic will talk on SAN technologies and issues related to using a SAN with SQL server. 

 Announcements

 Controlling and Reusing Query Plans with Kalen Delaney

Thanks for our friends at ClearData Kalen Delaney is presenting this full-day seminar on March 26th, 2008 and will cover techniques available for determining if, when and how you should override the optimizer's choice of query plans. It will also cover how to determine if your plans are being reused, how you can determine if reuse is desirable for your queries, and how you can control query caching behavior.

Although the demonstrations will be run on SQL Server 2005, much of the information presented will relevant to SQL Server 2000 and SQL Server 2008 as well.

This seminar will cover the following topics:

  • Tools for Analyzing Query Plans
  • Plan Caching and Plan Cache Metadata
  • Plan Reuse and Parameter Sniffing
  • Managing Plan Cache and Preventing Cache Bloating
  • Overriding the Optimizer
  • Plan Guides
  • Plan Management
  • Plan Management in SQL Server 2008

Click to Register<

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif