www.sqlpass.org    Professional Association for SQL Server

Welcome to the SQL South West

 Welcome

If you are using SQL in any way and are interested in meeting other SQL professionals in the South West then please contact us.

We are a group of DBAs and developers from Cornwall, Devon and Somerset who get together in Exeter once a month to talk about anything related to SQL. If you live or work in the South West of the UK or are in the area on business or holiday then we'd be happy to see you.

The group is for anyone working with SQL Server or anyone interested in starting to work with it. You may be a full time DBA or developer or someone looking to understand SQL Server things more clearly or maybe you are the guy that didnt run fast enough when the last DBA left.

We meet on the third Thursday of each month at the offices of First Data Bank, in Exeter.

In general the meeting format is:

17:00 - 17:30 - Gather together, get drinks and get organised
17:30 - 20:00 - Presentations (with 30 min break for refreshments).

 Next Meeting

Next meeting - August 18th

Alex Whittles - (Blog|Twitter) will be talking about PowerPivot and QlikView 101 (level 200)

How to get started with PowerPivot and QlikView. This session will cover how to combine data sources, common pitfalls, adding some calculation logic and building a basic dashboard. We’ll walk through the same example on both systems and compare the results, pros and cons of each.

Meet from 17:00 for 17:30 start.

Please contact me for more details of next meeting or directions -jonathan@sqlsouthwest.co.uk

 

 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.
 Sponsors

PASSChapterLogo100.jpg