posted on Wednesday, September 29, 2004 7:55 AM
by
RickH
PASS - Wednesday Keynote Thoughts
Bill Baker delivered the keynote address this morning at PASS. The BI Tools were highlighted during his speech as many improvements are coming in SQL Server 2005.
There were 2 Demos. One featured a new Report Generation Tools that will be available in SQL Server 2005 that is more “User Friendly” than the Reporting Services project in .NET today. When you create a basic aggregate type of report, the system will also automatically create drill-down reports that you can click on inside the report you write. It will most likely be available in Beta 3.
The second Demo was on Integration Services (formerly known as DTS). The demo featured a new “wizard” to help you define slowly changing dimensions. It took about 5 minutes to create it with the wizard! Cool!
I am currently sitting in a session called “Operational OLAP”. It has some neat discussion on if a data warehouse structure is needed.
I hope to blog more later today!