Join us for another UK SQL Server User Group meeting.
5.30pm – 6:00 Registration and networking + Tea/Coffee with biscuits.
Meet and greet.
6:00pm – 6:30pm Round Table discussion and Nuggets - ALL
Take stock and get the latest news in the SQL Server field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.
It's also a great opportunity to share your knowledge and gain exposure in the industry by giving a short 1 - 6 minute "nugget" demo/tip.
6.30pm – 7:30
T-SQL Hints and Tips, Tony Rogerson, SQL Server MVP
T-SQL: Hints and Tips session covering, Sub-Queries, Case Expression, Partitioning using Views (poor man's partitioning), Common Table Expressions (including Recursion), good practice and reading TSQL, perhaps a bit on database design and de-normalisation and normalisation.
7:30pm – 7:50 BREAK: Light refreshments
More time to network and ask questions...
7:50pm – 8.50pm
"How are my servers Today?", Colin Leversuchs-Roberts
One of the worst things that can happen to a Production DBA is for the users to tell him or her when there is a problem with their SQL Server.
It's very easy to create real time performance dashboards and alerts for your servers and applications using SQL Server and SSRS.
Here's a walkthrough of a working solution with illustrations on how to display "difficult data", how to collect data and how to work with what you collect.
Spot potential problems before they become critical, diagnose issues in real time, view historical data to predict trends.
The monitoring works for sql 2000 onwards although SSRS 2005 is required for some of the dashboards.