Tuesday, November 08 2005

1:30pm - 3:00pm

4.5 stars

This session covers the trio of Integration Services, Analysis Services, and Reporting Services.

After a funny intro video (including some snide back and forth between an "IT Pro" and a "Developer". Not sure what an IT Pro was supposed to be, but it sounds like it's the new Microsoft lingo for administrative type roles. The video included comments like the developer calling the IT Pro a "glorified DJ", and the IT Pro saying about development "A monkey could do that". Quite funny), the session got underway. This was a full house, and covered topics like integration services (formerly DTS - which has seen some huge improvements), including a demonstration of its performance improvements (processing and importing 2 million rows in seconds), data cleansing and "AI" abilities, among other advances.

The discussion then moved on to Analysis services, XML/A and unified dimensional model, data mining (such as the demonstrated associative model), key performance indicators, and the dashboard. Very informative.

It then moved to reporting services, demonstrating how developers could create and deploy reports, and how even relatively untrained users could do the same.

[]

   

Reader Comments

Add Comment

Name *:

Email Address:

(your email address is not displayed)
Website:

Comment *:



About the Author
Dennis Forbes Dennis Forbes is a Toronto-based software architect. While focused primarily on the .NET and SQL Server worlds, Dennis frequently ventures outside of this comfort zone into game development and image processing. He has been published in several industry magazines, has been quoted in the Wall Street Journal and has been interviewed by NPR.

He is a vice president and lead software architect at an innovative New York City hedge fund back-office services firm.

Dennis has been working on solutions for the financial, telecommunications, and power generation markets for over 15 years.





 

Dennis Forbes