Yukon: Database redefined

Stunning — I was at Microsoft’s SQL Days in Paris today, and I wouldn’t bet anything credible will survive the rampage. SQL Server 2005 is like… database redefined.

The performance boost aside, some of the stuff that I found sexy:

  • Easy management features will let you set up mirrored clusters in a dozen clicks
  • Integrated run-time will let you create your own types and aggregation functions with .Net
  • You can use SQL and XQuery indifferently, at the same time in the same query if you want
  • The entire thing is built with XML and web services in mind (even more than SQL Server 2000)
  • T-SQL’s new features make it a credible option to do recursive stuff such as exploring a graph
  • There’s a cool revamp of Analysis Services and Reporting Services
  • Did I mention Analysis Services? What about the data mining wizards?
  • And… and…

I remember Bill Gates mentioning his idea of the future of programming during last year’s Gartner conference (transcript). It was along the lines of a GraphSet-like language that managers could use to define and draw the workflow between components.

As a response, Linux and Apple Zealots hissed at Bill Gates’ record as a software architect because Longhorn was behind schedule — without noting that the market is behind schedule as well.

I personally thought to myself: “We’ve been dreaming about this for over ten years now, there’s not a chance in hell they’ll get this working in the next ten years. But then again, it’s Microsoft, and Bill Gates looks confident.”

Rightly so, too. Integration Services is simply jaw breaking. Picture the guy who did the presentation. He did not write a line of code. Drag, drop, click, wizard… He was drawing a workflow with a GraphSet-like language. This is optimal when it comes to designing software. He then clicked the compile button and it just worked…