The emerging field of "Location Intelligence" brings the worlds of Geographic Information Systems (GIS) and Business Intelligence (BI) together. These capabilities are now available with SQL Server in a no-coding, user-driven environment provided by the Integeo (www.integeo.com) Map Intelligence product. SQL Server 2008 also introduces a number of spatial features to support the development and extension of spatial applications. In this session, you will see how SQL Server Reporting Services can be used to extend your corporate data to provide interactive, spatial analysis through dashboards, reports and .NET applications.
About the Speaker
Brad Culbert is the Lead Technology Strategist and Solution Architect at Bistech (www.bistech.com.au), the Performance Management experts. Brad has a wealth of experience deploying Performance Management solutions to a number of QLD?s largest corporations and is a leading expert in the field of Location Intelligence.
WHEN Thursday, 26th of November | 5:30PM for a 6:00PM start (finishing at approximately 7:30PM)
The QSSUG website can be found at www.qssug.org and contains a repository of materials from past meetings as well as details of upcoming meetings. Other Australian SQL Server related material can be found at www.sqlserver.org.au.
Richard will show the insides (and outsides) of an OLAP cube created to assist
in monitoring and managing a 6 node Oracle RAC database that sustains 600
transactions per second from 30,000 online users. Richard will go through the
early prototypes, development cycle and design considerations for the cube,
which has 12 measure groups, dozens of measures, and dozens of hierarchies. The
demonstration will also look into the transformation package that incrementally
loads the cube, Excel access and the RS reports available to the masses. This
cube is an effective demonstration of the value in having complex data in a
cube. All the data in the cube is available to guru DBAs from base tables. But
without the cube, getting this information is time consuming and error prone.
Richard Lees is a well known Microsoft expert in the large database and
business intelligence fields. He is the author of ThinSlicer, the first publicly
available thin client cube browser, which is used by companies around the world.
SQL Server Users Group (Sydney) Meeting
Monday 6th Nov 2006
Mechanics' School of Arts
Level 1, 280 Pitt St Sydney
Start: 6.00pm untill 8.00pm
Itzik Ben-Gan the T-SQL set based solution guru from
Solid Quality Learning will be appearing at the Sydney SQL Server Users group on
Tuesday 10th Oct 2006.
Itzik will be discussing Internals and Externals of Table Scans and the
access methods SQL Server uses to perform these and other scans.
The Sydney SQL Server Users Group meets at:
Mechanics' School of Arts
Level 1, 280 Pitt St
Sydney
from 6pm Tuesday 10 October 2006. Drinks and food are provided from 5:30pm.
Don has been the Program Manager for the SQL Server Storage Engine for the past five years, and is also in town for TechEd 2006. Don will be presenting the second session for the night, so I'd expect these two sessions to run overtime.
The SQL Server User Group is meeting is free. The group meets regularly and is for all levels of developer / administrators for Microsoft SQL Server. Meetings usually include two presentations from experienced SQL Server developers / dbas / MVPs. Travelling members of the SQL Server Development Team in Redmond and other "celebrities" present when in town.
SQL Server Users Group (Sydney) Meeting
Friday 25 Aug 2006
Mechanics' School of Arts
Level 1, 280 Pitt St Sydney
Start: 6.00pm untill 8.30pm (or later)
Siva Harinath (Microsoft SQL Server Test Lead) will be appearing at the Sydney SQL Server Users group on Friday 25th Aug 2006. He'll be showing off the new data mining add-in for Excel, as well as coming features of SQL Server 2005. If you're a user of Analysis Server 2005 or thinking of implementing it in your organisation this is an excellent opportunity to learn from one of the masters.
Siva will be appearing for the SQL Server Users Group at Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney from 6pm Friday, 25 August 2006. Please register for the event. Drinks and food are provided from 5:30pm.
Note: Siva's name was incorrectly spelt "Siva
Haranth" and "Siva Haranath" in the SSUG newsletter.