London SQL Server User Group with Neil Hambly on XQuery fundementals and Dave Ballantyne on re-engineering for faster performance
Nearest Tube : St. Paul’s
Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers.
Remember to tell your friends and the people you work with; make sure you register as soon as you can.
5.30 – 6:00pm Registration and networking
Meet and greet.
6:30 – 7:20pm Neil Hambly – “XQuery fundamentals”
Discover the world of XQuery – find out how we use XQuery to find and resolve performance issues
We will look @ practical examples like What Query Plans have used a specific index, find missing indexes, extract key metrics for further analysis
7.20 – 7:30pm Break
7.30 – 8:20pm Avanade - Highlights from Avanade SQL deliveries
“Coping with Oracle as a SQL developer” or “StreamInsight – Temporal analysis”
8:20 – 8:40pm Break: Light refreshments
More time to network, ask questions and eat pizza...
8.40 – 9:30pm Dave Ballantyne "Just make it go faster”
That’s a standard command that gets filtered down through the management on an all too frequent basis.
How can that best be achieved? Sure you could throw hardware at the problem, but how do you know that that will solve the problem and at what financial cost. Alternatively you could partition tables, use created clustered views or any manor of tweaks.
But are you just papering over the cracks? Without addressing the underlying problems then you are not going to achieve real performance, scalability and create a system that performs in a predictable fashion.
By re-engineering some cursor ridden code, we'll see how that can be achieved.