I’ve been a bit lapse in posting what I am up to recently. For example, I completely missed blogging about speaking at both the PASS SQL Rally events earlier this month! I’ll try and write up a review of the events next week to make up for it though and also tidy up my presentations page. I also missed the Twitterchat with Brent Ozar too.
This fortnight is pretty busy with two webcasts this week and two presentations next week, I’ll separate out the presentations for next week into a separate post. The first session I will be presenting this week is “Understanding Indices” for Dell Software on Tuesday 19th at 10:30 GMT – register here.
The abstract is as follows:
When it comes to boosting SQL Server performance, few things can have as much impact as indexing. Join domain expert Richard Douglas as he provides unique insight into the value of indexing and sheds light on SQL Server’s index architectures
By the end of this session, you’ll know how to:
- Find missing and unused indexes
- Resolve fragmentation issues
- Make the right indexing choices
The second webcast is hosted by MSSQLTips.com and is entitled “Understanding SQL Server Query Execution Plans”. You can register for this webcast here – https://www2.gotomeeting.com/register/124285746
The abstract for this session is:
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, 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.
Hope to (virtually) see you at one of the sessions.