Sunday, April 24, 2005

Analysis Services 2005

AS 2005 is an intensely compelling product.  If I may borrow a concept from OLAP, the Analysis Services product improves on its predecessor in a number of “dimensions,” including ease of use, feature richness, sophistication of client tools, and programmability.  This release truly feels like a serious tool for developers, statisticians, and scientists. It makes AS 2000 look like a bare-bones, proof-of-concept product by comparison.

In preparation for some upcoming presentations (including one at Tech*Ed in a month and a half), I’ve been working especially hard over the last week studying Analysis Services Data Mining and, on the OLAP side, ADO MD.NET programming for both the server and the client.  My general impression while examining all of this technology is that it is rich, elegantly extensible, and much easier to use than its predecessors.  Some highlights follow:

 

  • ADO MD.NET will be familiar to ADO MD and ADO.NET programmers alike.  Do you prefer thinking in terms of axes and cellsets?  It’s all covered.  More comfortable using DataReaders and DataSets?  That’s accommodated too.  Jealous of the CLR programmability on the relational side of SQL Server 2005?  Don’t be: you can now use the objects in the Microsoft.AnalysisServices.AdomdServer namespace in a .NET assembly to create MDX-callable functions that can accept and return sets, tuples, and scalar values, all with the same security model as on the relational SQLCLR side.
  • The number of Data Mining Algorithms has been extended significantly and the ability for you to create your own plug-in algorithms is carefully documented, rather than merely being implemented.
  • Tools for browsing models have been extended significantly and are available from both Analysis Services Projects in Visual Studio (a.k.a. Business Intelligence Development Studio) and directly from SQL Server Management Studio.  Tools for visual development of prediction queries are also readily available in both tools and are easy to use (in AS 2000, the Prediction Query Wizard is buried in DTS, and viewing prediction query results is rather inconvenient).
  • Mining Structures, a new entity in AS 2005 databases, contain a common data source/input column set/predictable column set configuration that can be used by multiple models within the structure.  Each constituent model can be built using a different algorithm, the same algorithm with different parameters, or a combination of both.  Better yet, new “lift” charts allow you to graph the relative accuracy of all your models, both for predictable columns in general and specific values of those columns.  As with other tools, lift charts are available from both Analysis Services projects in Visual Studio and from within SQL Server Management Studio.  Here’s a screenshot of the latter (forgive the large size, but I want you to be able to read all the text within):

Management Studio Does Data Mining!

 

I continue to believe that the real story to SQL Server 2005 is its business intelligence feature set, and I don’t just mean Reporting Services and ReportBuilder.  OLAP and Data Mining technologies from Microsoft are powerful and eminently useful analysis tools.  Their potential for adding value to the entire Microsoft stack, from Office to SharePoint, BizTalk to Commerce Server and every member of the Microsoft Business Solutions family, is tremendous.  Continue to ignore these technologies at your own peril. 

#    |
 Saturday, April 16, 2005

Jazz Legends and Odd Intersections

 

Seventh Avenue South (the extension of Seventh Avenue below Eleventh Street) is a funny, crooked street.  It was actually created specifically to provide a “cut and cover” connecting corridor for the West Side IRT subway (today’s 1, 2, 3, and 9 lines) between the southern end of Seventh Avenue and the northern end of Varick Street.  (Some excellent background info is available here.)

 

When the street was built in 1917, buildings in its way were demolished, or cut right through.  If you look at all carefully, you can see evidence of Seventh Avenue South’s disruption to the buildings around it.  To this day, many buildings that face the street are of odd triangular shapes, and some of them are even “shaved” at their corners.  Since the street proceeds on a diagonal, it intersects with streets that run perpendicular to each other, creating awkward intersections all along its route.  Most businesses that open on Seventh Avenue South don’t stay open for very long, and I attribute this to the street’s challenge to simple navigation by pedestrians.

 

One notable exception to the perennial business failures on the street is the Village Vanguard, one of Jazz’s most important landmarks, which first opened at its present location in 1935, 18 years after Seventh Avenue South was created.  The basement location and odd triangular shape forced on it by Seventh Avenue South have, for whatever reason, created an atmosphere that seems to nurture Jazz music and the audience’s appreciation of hearing and seeing it performed live.

 

My wife Lauren took me there for my birthday last week to hear Bill Charlap, a superlative Jazz pianist, and his trio colleagues, Peter and Kenny Washington, on bass and drums respectively (no relation).  The music was great, but hearing it at the Vanguard made it even better.  Looking at photos of Jazz greats adorning the walls (including a great one of Charlap playing mid-note with his ear to the piano) while the music’s playing, and knowing that they all played there, is just a great experience.

 

The Internet is actually a wonderful way to discover the prominence and continuity that is the Village Vanguard.  Try doing a Google search on “Live at the Village Vanguard” and you’ll see how many Jazz artists have performed and recorded there.  (By the way, Joe Lovano’s “Quartets Live at the Village Vanguard” album is terrific.)  If you click through the search results, you might come across this album cover of “John Coltrane Live at the Village Vanguard Again!” which was recorded in 1966 (the year I was born):

 

 

The clothes may be dated, but I can tell you that the outside of the club looks exactly the same today as it does in that photo.  There’s nothing more exciting than visiting places that persist in this way, as ongoing businesses.  I think it provides the closest possible thing there is to time travel.

 

If you’ve never been to the Vanguard, you should go (even if you don’t live in New York).  It may have been there for 70 years, but I worry that New York’s real estate market hyperdrive could one day spell the venue’s demise.  Make sure you experience its history before it becomes history, or else hope for a crash in the real estate market.

#    |
 Tuesday, April 05, 2005

Hosted Hands-On-Labs / VPC Images

Ever promised yourself that one "weekend" you'd go through all those MSDN Universal disks, install stuff on Virtual PC images and start learning some new technology?  Then Saturday rolls around and the idea of doing all that install work just to start digging into stuff becomes wildly unappealing?

If that describes you, you're a lazy, me-generation sloth!  But then again so am I.  Luckily Microsoft has a solution.  Check out this URL:
http://msdn.demoservers.com/login.aspx

This site provides hosted (Terminal Services-based) access to actual Hands On Labs for a number of MS technologies, including shipping technology like VB .NET, C#, ASP.NET, VS .NET 2003, Smart Client development, and Beta technology like Visual Studio 2005 and SQL Server 2005 (just added).

Go to the site now, and you'll be up and running with a Lab manual and a functional VPC in 3 minutes or less.  The only drawback I can find is that the labs are time-limited, so make sure you can block out some uninterrupted time to avoid being kicked out and having to start from scratch.

Feedback on this content is welcome...I'll work to push it back to Redmond as appropriate.

#    |
 Monday, April 04, 2005

Oracle and Whidbey

More details to come (including code), but here's a first glimpse of what worked and what didn't when I combined Whidbey with Oracle:

        ·         Even though ODP.NET was installed on the same machine as VS 2005, none of the VS dialogs or wizards recognized it.

·         Using Microsoft’s Oracle provider in the Server Explorer window, I could enumerate, but not view the PL/SQL code for, stored procedures within Oracle packages.

·         Using Microsoft’s Oracle provider in the TableAdapter Configuration Wizard, stored procedures in packages were not enumerated and could not be selected.  Therefore, typed DataSets against Oracle package-based stored procs were no go.

·         I couldn’t use the ASP.NET SqlDataSource control with ODP.NET.  The latter isn’t available from any drop-downs, and manually typing “Oracle.DataAccess.Client” into the Provider property created errors when I tried to run the page.

·         The winning combination was the ObjectDataSource control combined with “hand-written” classes that use ODP.NET to implement CRUD operations on package-based stored procedures.

·         Most of my research was in ASP.NET 2.0, and not Windows Forms.  But similar results came up there as well.

 
#    |