| 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:15 |
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 |
SQL Server Analysis Services 2005 – How to migrate cubes created using Analysis Services 2000 to Analysis Services 2005, and also how to take advantage of new enhancements in Analysis Services 2005 when building cubes |
| Andrew Sadler, Principal Consultant, ProClarity UK |
|
This session is aimed at organisations that use Analysis Services within SQL Server and are considering moving to SQL Server 2005. Andrew will demonstrate how to migrate an Analysis Services cube created in SQL Server 2000 to Analysis Services 2005, and then move onto creating a SQL Server 2005 cube from scratch, highlighting important new functionality. The resulting cube will then form the basis of the following presentation. |
| 19:15 |
Analysing data in SQL Server Analysis Services 2005 cubes using ProClarity 6.1. |
| Andrew Sadler, Principal Consultant, ProClarity UK |
| As organisations consider moving to SQL Server 2005, how can they best take advantage of the new features in Analysis Services 2005? |
| 19:45 |
|
| Break |
|
| 20:00 |
SQL Server Integration Services A few simple packages |
| Simon Sabin (Blog: sqljunkies.com\weblog\simons) |
Will look at the basics of SSIS and how packages are build, investigate extending packages with script components.
Comparing with other file processors i.e. Log Parser.
Those attending what is your exposure to SSIS and DTS? (Nil, used DTS, used SSIS) - please email Tony Rogerson tonyrogerson@torver.net. |
| 21:00 |
Evening Ends |
|