Maidenhead SQL Server User Group
Speakers to include Richard Douglas and Chris Testa-O'Neill.
Increasing Business and IT collaboration with SQL Server
SQL Server 2012 provides the ability to deliver solutions for BI users with all experience levels. See the ease of collaboration of business intelligence reporting between business users and IT departments and demonstrate a real world use case as used by a Coeo customer to present a business case for using SQL Server 2012 within your business.
Chris Testa-O'Neill is a SQL Server Microsoft Most Valuable Professional(MVP) and EMEA Senior SQL Server Professional with Insight (http://uk.insight.com/). He is also a technical author, working on courses for SQL Server 2008 R2 with Microsoft Learning and advising on the SQL Server 2012 curriculum. Chris runs the Manchester SQL Server User Group and is an organiser for SQLBits. Chris has spoken at a range of events including user groups in the UK and Adelaide, Australia, SQLBits and SQLPASS
Understanding SQL Server's query execution plans
Understanding query execution plans is something many IT professionals either don't know about or don't fully understand. SQL Server's programming language, T-SQL, is different from most other programming languages. In most languages, you tell the language what you want it to do, but in T-SQL, you tell it what you want. This means you are at the mercy of the query optimizer, which will take the logical instruction and convert it into a physical plan. The query execution plan is a map of what the optimiser thinks will be a good way of returning the data you have asked for. Being able to understand query plans and what they show is critical for both DBAs and developers in uncovering query performance problems.
In this session, SQL Server expert Richard Douglas will explain:
- Where to find a query plan
- How to read a query plan
- How to find common performance problems without looking at the code
- Where the query optimiser and other features of SQL Server can cause sub-optimal plans.
Location: Maidenhead, Berkshire