Tony Rogerson's ramblings on SQL Server

Last chance to register for this evening event organised by the SQL Server User Group in partnership with Chris Webb.

To register (essential) please visit http://sqlserverfaq.com?eid=83 to register.

Registration is at 5.30, evening will commence at 6pm and finish 9pm.

6pm - 6.15pm
Introduction, news and gossip.

6.15pm - 7pm
Visualising Information with Microsoft Visio 2007
David Parker (http://www.bvisual.net/)
Visio is a unique data visualization application, and the 2007 edition adds three new important data features that provide brand new data links, data graphics and pivot diagrams.  These capabilities, along with the existing and often under-exploited tools, firmly position Visio as the foremost practical, easy to use visual information system that can be applied to a multitude of business scenarios. Microsoft Visio has been able to link ODBC data sources for many years via the Database Wizard, but this has limitations such as only a single data link per shape, and no support for stored procedures.  Microsoft Visio 2007 overcomes both of these with the new Link Data programmable API, making it simple for end users and developers to create data rich diagrams that can be refreshed simply. In addition, the new Data Graphic features enable you to enhance linked shapes with icons, data bars, text callouts and color by value. The new Pivot Diagrams can be linked to data sources, including SQL Server Analysis Services, to provide interactive drill-downs of data diagrams, allowing the user to visualise, analyse, and present aggregate information in a new appealing manner. I'll demonstrate the new features...and show how these data links can be made.

7pm - 7.45pm
Using Microsoft BI Technology with SAP
Sanjay Nayyar (IMGroup)
This session covers the various approaches to using Microsoft BI technology to provide reporting capabilities in a SAP environment.  Ranging from using Reporting Services in conjunction with SAP BW to loading data into SSAS from SAP ERP systems.

7.45 - 8pm
Break

8pm - 9pm
MOPPS 2007 – what’s it all about?
Andrew Sadler - Proclarity/Microsoft
Come to find out from Microsoft Technical Solutions Professional, Andrew Sadler, about the past, present and future of the end to end Microsoft BI story.  Featuring such highlights along the way as ProClarity, BSM, Biz#, PerformancePoint, etc…