Category Archives: SQL Community

NSSUG – Session 1: Paul Randal on Wait Stats

Thanks to all those who made it to our first user group meeting tonight. Paul Randal gave a great session on the Waits and Queues Troubleshooting methodology and we had some really good discussion.

Paul’s code and slide deck are uploaded to the user group file store and there’s a discussion thread posted for any questions or comments on the session.

There’s also a thread in the forum for you to let us know what sessions you are interested to see in the future. We’ve had a lot of really good offers for speakers for future sessions, but want to make sure we are tailoring things to the content the group is after.

I’d also like to thank Gigatown Nelson who supplied the venue and were announced as finalists in the Chorus Gigatown competition today. It’s a great effort from the team and I’d like to urge everyone to get behind them as they try to win the top prize and bring fast internet to Nelson.

Finally a reminder that Paul is doing an internals course in Australia in December. These sessions go into great depth and are well worth the sticker price – especially if you take advantage of the discounts Paul offered last night..

Hope to see you all again next month!

Rob

Nelson SQL Server User Group

Wanted to take a moment to announce the great news that Nelson now has it’s own SQL Server User Group. You can join in at the Nelson SSUG page.

Even better news is we have Paul Randal lined up as our first presenter. The session is at 6pm on the 17th September at the #GIGATOWNNSN office in Halifax Street. Plenty of parking across the road, free Beer and Pizza and a top quality presenter. What excuse would you possibly have NOT to come?

Session Description: One of the first things you should check when investigating performance issues are wait statistics – as these can often point you in the direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem – what is often called ‘knee-jerk performance tuning’. In this session, you will learn what waits are, how to analyze them, and potential solutions to common problem patterns. Paul Randal will be presenting this remote session on SQL Server Wait Statistics, and how to make the best use of them.

SQL Saturday Christchurch – Are you high?

On 10th August we are running a community event called SQL Saturday. What is SQL Saturday? It’s an opportunity for you to get free training in various areas of SQL Server that is an extension of the work that we are doing with the SQL Server user group.

Amongst quite a good lineup of speakers I’ll be taking a session on High Availability and Disaster Recovery(Are you high? Can you recover?), running through the various options that you have natively available out of the box. I’ve been working with these alot recently – almost as if some major disaster has hit the city I live it and people are suddenly aware of the danger of keeping all your eggs in one basket.

Alongside Martin and myself we have a great cast of speakers lined up including David Curlewis(TradeMe), Brent McCracken(Kiwibank), and Microsoft MVP’s Dave Dustan and Argenis Fernandez. If SQL isn’t your bag, you can join the code camp guys and talk applications, but I’m assuming if you are reading this SQL IS your bag:)