17:30 -
18:00 |
Network - Coffee |
| A chance to meet other SQL Server professionals on a social level, what better way of networking and finding out what other people are doing in the SQL Server space. |
| |
18:00 -
18:30 |
Problem Clinic and Security Update |
| Question and Answer discussion between all attendees.. |
| Feel free to bring your questions or post them on the user group board prior to the event. |
18:30 -
19:15 |
SQL Server 2005 Unified Dimensional Model (UDM) |
| Matthew Stephen, IT Pro Evangelist, Microsoft UK |
|
The next release of SQL Server Analysis Services (codenamed “Yukon”) will introduce a richer model for OLAP objects (cubes and dimensions).
The goal is to combine the best aspects of traditional OLAP-based analysis and relational-based reporting into a single model, providing a single dimensional model covering both sets of needs. A set of cubes and dimensions defined in Yukon is referred to as “Unified Dimensional Model (UDM)”, this presentation will provide an introduction to this new approach to OLAP. |
19:15 -
19:30 |
|
| Break |
| |
19:30 -
20:00 |
Using Profiler in SQL Server 2000 |
| Neil Andrew, Quest |
|
Profiler is one of the most under-used tools in an administrator's toolbox. Profiler is a free tool that ships with SQL Server can meet most of your performance and security monitoring needs. This session starts with an overview of using Profiler for performance monitoring. From there, it will move on to look at replayable Profiler traces for testing and capacity planning situations. Then it will discuss how automated scriptable traces can be used to monitor key performance and security events. And finally, it will cover more advanced performance monitoring options available in Profiler and alternative solutions.
Goals:
1. Profiler for performance monitoring
2. Profiler for security monitoring
3. Advanced Profiler scripting
4. Profiler alternatives |
20:00 -
20:45 |
10 ways (or more) to skin a cat in sql server 2005 |
| Simon Sabin |
The programmability of sql server is often considered poor and common problems often not easy to solve. With sql server 2005 due out this year! Simon will be looking at the ways to produce a running total in sql server 2000 and what new ways will be possible in sql server 2005. The performance, complexity and maintainability of all options will be considered.
If you have a way of solving this problem then let Simon (simon.sabin@pjbc.co.uk) know so he can add it to the list. |