Tag Archives: Denali

Recap of SQL Saturday 79 South Florida

I decided on August 9, 2011 that I wanted to go to SQL Saturday 79 in South Florida, as I blogged on previously. And was I glad I went too. I enjoyed not only being a presenter but also an attendee and participant too. This blog post has the details.

Continue reading “Recap of SQL Saturday 79 South Florida” »

SQL Server Denali CTP3 and Data Mining

Today, Microsoft has released the CTP3 version of the next version of SQL Server, codenamed Denali. The acronym CTP stands for Community Technology Preview. The purpose of this preview is to encourage people outside Microsoft to use the software before Microsoft releases an official version.

I, along with some select others, have been participating in the early access program called “Technology Adoption Program” (abbreviated TAP). Participation in Microsoft TAP is by invitation only, and had included CTP1 and CTP2. (Now that Microsoft invited me into the Microsoft MVP program, I am likely to be invited to similar opportunities in the future.) However, today’s release is widely available for EVERYONE (that means you too).

The purpose of this blog post is to describe the location of the new download, and encourage you to try it out for SQL Server Data Mining.

Continue reading “SQL Server Denali CTP3 and Data Mining” »

Vertipaq, Analysis Services, and Data Mining

Rob Collie formerly worked for Microsoft, and now blogs at PowerPivotPro.com.  His blog is included in my Recommended Blogs for 2011.  Late last year, he posted his comments on Vertipaq and Analysis Services.  I would expect my regular reading audience to be used to models, so let’s start with Rob’s graphic from http://powerpivotpro.com/2010/11/12/five-observations-from-sql-pass/:

1 6 2011 2 29 42 PM Vertipaq, Analysis Services, and Data Mining

In the blog post, Rob tells the story which we are all knowing now:  

  • PowerPivot is an expression of the Vertipaq technology as an Excel add-in
  • Vertipaq will be moved into Analysis Services along with the DAX language
  • The rapid adoption of PowerPivot so far provides a confidence that improvements in this area will continue

Continue reading “Vertipaq, Analysis Services, and Data Mining” »

Project Crescent and Data Mining

Recently announced by the SQL Server Reporting Services team is codenamed Project Crescent.

First, check out the Amir Netz video (host is Bruno Aziza) posted to YouTube.

httpvh://www.youtube.com/watch?v=FfRpfCav9hg

Facts about Project Crescent:

  • Product of the SQL Server Reporting Services (SSRS) Team
  • Web-based visualization
  • Silverlight technology provides the coolness
  • Azure hosted the demo’s content (from the video’s soundtrack) — though I do not expect Azure to be a requirement for all Project Crescent uses

Continue reading “Project Crescent and Data Mining” »

SQL Server Data Mining and Apollo Columnstore Indexes

Note: This post was revised November 12, 2010 to clarify the brand names Apollo and VertiPaq (thanks Denny Lee of SQLCAT) — and I extended comments on Amir Netz’s C++ versus C# analogy which I believe clarifies the discussion between what I have termed managed and unmanaged aggregations.  

This week’s PASS Summit conference included several demonstrations and announcements of the next version of SQL Server, version 11, codenamed Denali. In this blog post I have the following goals:

  • Outline Apollo columnstore indexes as a competitive Microsoft technology
  • Respond to Microsoft claims about the comparative performance advantages of columnstore indexes specifically for aggregations
  • Respond to Chris Webb’s multiple blog posts (posted from Seattle, WA) about the future of SQL Server Analysis Services

These topics seem like a lot to take on in one blog post, but in context, Microsoft found a way to introduce columnstore indexes in an 8 page whitepaper. As regular blog readers know, I put on my scientific hat first when trying to distinguish science from science fiction…

Continue reading “SQL Server Data Mining and Apollo Columnstore Indexes” »