SQL Live! Sessions
What’s So Good About SQL Server 2005 OLAP?
Andrew Brust, Twentysix New York
SQL Server 2005 Analysis Services, with its Unified Dimensional Model, has turbo-charged its OLAP capabilities. OLAP solutions in SQL 2005 are incredibly useful to business because they’re more powerful than their SQL 2000 counterparts, easier to develop, and can be based on real-time or near-real time data. This session will show you how to use new Visual Studio designers to create OLAP cubes, and then acquaint you with powerful new features like .NET CLR stored procedures, Key Performance Indicators, Perspectives, Translations and pro-active caching. You’ll leave understanding the business imperative for OLAP as well as its implementation.
OLAP Application Development with ADO MD.NET: An API Smörgåsbord
Andrew Brust, Twentysix New York
Microsoft offers an array of OLAP APIs for everything from developing top-notch dedicated OLAP applications to just adding OLAP functionality to your existing apps. In this session we’ll study ADO MD.NET for OLAP data access, AMO for OLAP database management, and XMLA for a SOAP-based combination of the two. We’ll also look at AdomdServer, which makes possible true .NET CLR stored procedures and functions for your OLAP cubes. You’ll leave ready to write applications and queries that take full advantage of the SQL Server release that will truly deliver on the promise of BI.
Reporting Innovations in SQL Server and Visual Studio 2005
Bill Wolff
This talk highlights the new features added to the reporting tools implemented in SQL Server and Visual Studio 2005. We discuss how to configure your report server for best performance and safest operation as well as how third-party tools can add new and powerful graphics to your reports, plus how to access new features from your reports including multiple-select pick lists, and converting existing RDL reports created for SQL Server 2000. You’ll also find out how to export reports to the new Visual Studio 2005 ReportViewer.
SQL Server Integration Services: Patterns and Practices for the Real World
Trey Johnson, Encore Development
Integration Services fulfills the core needs of ETL within the Enterprise. It’s not you're old DTS; but you can learn the techniques that will make it successful for you today. Curious now and want to know just how the technology is being applied to this paradigm as well as alternatives? Join us for this in-depth hour of exploring querying of federated data sources, learning integration of Data Mining in the pipeline and coming to know the blend of out-of-the-box and custom extensions to making Integration Services work well in your organization. We'll explore this through a multitude of demonstrations that can be applied in your own business.
Report Builder: The Unified Approach to Consuming Cubes and Relational Data
Trey Johnson, Encore Development
Through Reporting Services' Report Builder technology users have the ability to consume both Multi-Dimensional (OLAP) and Relational data. Come explore the means for building rich report models that allow for exploration throughout the enterprise. Confused as to whether OLAP or Relational data is most optimal? We'll explain the differences and examine the best opportunities with this platform. Through this session you’ll gain a clear picture of the enterprise implications of the Report Builder technologies. And whether you're brand new to Reporting Services or looking to overcome the usual reporting backlog, this is one hour you can’t miss!
