18:30 – 18:45 Worst ever mistakes (I know a friend who...)
This evening's session will kick off with your (or one of your friend's) worst ever SQL Server related mistake. From deleting a production database to bringing down the entire exchange mail server, we’ll welcome you with open arms! We'll take a few minutes to go round the room to share these stories, so please make a note of these in advance and bring them along.
18:45 – 19:00 Redgate SQL Monitor (Adam Morton on behalf of Redgate)
RedGate would like some constructive feedback on their new product SQL Monitor, so where better place to start then at a SQL Server User Group.
SQL Monitor is a web-based performance monitoring and alerting tool for SQL Server. Accessible from any computer or internet-enabled mobile device, SQL Monitor gives you the freedom to keep watch on your servers beyond the limits of your desktop.
In return for your participation they’re providing plenty of swag to dish out and a free license.
SQLMonitor Demo Website
19:00 – 19:45 Using SSRS, DMVs & spatial data to visualise SSAS cube structures (Alex Whittles Purple Frog Systems)
Link to blog post and code download
Link to presentation slides
Most developers’ attitude to documentation is well known! So why not make it interesting and automate it using some of the new features available in SQL Server?
This session will show how to use DMVs (dynamic management views) to query the OLAP cube structure, and then use SSRS to create a set of interactive reports including the BUS matrix, and using spatial data to generate automated star schemas.
After you’ve done this once it will provide live structure documentation, automatically updating itself every time the cube structure is updated.
19:45 – 20:00 Break & Pizza
20:00 – 21:00 Chalk and Talk on HA/DR/Scaling Tony Rogerson, SQL Server MVP
Tony will chat through considerations and options for developing and implementing a Disaster Recovery plan for SQL Server. He will talk about and demonstrate Mirroring, Log Shipping and general backup/restore options and talk about other HA options. He will also look at scaling considerations
Tony Rogerson has been working as a developer/database professional since 1986 working mainly with DB2, since 1993 he has worked mainly with Microsoft SQL Server. He went freelance in 1997.