Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Richard Douglas

Richard Douglas is a SQL Server Professional working in the UK where he recently worked as a DBA in women's clothing, not literally he hastens to add! He is certified in SQL Server 2008, runs the Maidenhead SQL Server User Group Pass Chapter and is on the organising committee for SQL Relay. In his spare time plays the trumpet in local symphony orchestras.

His online presence includes:

Webcasts this week – wc 20131118

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.

Comments

Leave a comment on the original post [sql.richarddouglas.co.uk, opens in a new window]

Loading comments...