Category Archives: Columnstore Indexing

SQL Saturday #109 – Silicon Valley Coming Up

The next SQL Saturday, number 109, is coming up this weekend in Mountain View, CA.  I’ve spoken at and attended 15 of these events and I want to tell you why you should attend too.

Everything Changes

SQL Server is a broad and deep product.  It’s difficult to be an expert in every feature of the product, and it’s also going through a major release.  And everything else is changing.  I’ve been at the Strata conference this week and it’s very clear that SQL Server professionals will continue to be in a changing and evolving environment for the rest of their working lives.  The work there is to do in analytics, visualization, real-time data, automated processing, and new technologies is huge with no end in sight.  The constant studying, learning, and re-learning that we do in this business will only get bigger.

Attending a SQL Saturday event is one really good way to stay on top of things.  You’ll get targeted sessions on SQL Server from top speakers on Performance, Business Intelligence, Administration, and much more.  And it’s free!

My Session

If you decide to come to the event, find me and say hello.  I’m presenting the session Using Columnstore Indexes in SQL Server 2012 so it’s a good way to find out about an important new feature in SQL Server.  Colomnstore Indexes will be a key consideration for you when developing a data warehouse architecture and I’ll show some good demos that explain why.

See you Saturday!

SQL Rally Voting Deadline

Have you put in your vote for which sessions you’d like to see at SQL Rally?  If not then cast your vote here so you can get the most out of your time this May in Dallas.  All it takes is to be a member of PASS and a few minutes.

I have a session on the ballot that’s called Using Columnstore Indexes in SQL Server 2012 and below is the session abstract for you to review.  You might not be sure whether to vote for my session or you don’t know whether you need to attend session on columnstore indexes, so I’ll give you one really good reason.

The Reason for Learning about Columnstores

Columnstore Indexes are really important because in SQL Server 2012 they will have to be seriously considered by DBAs and BI Architects as a replacement for cubes (or as an alternative) and as the primary indexing scheme for star schemas, report subsytems, data warehouses and any other reporting and analysis scenario.  Making the right decision will require you to have in-depth knowledge of how these indexes work.  That’s what you’ll get if you attend my session.

Session Abstract: Using Columnstore Indexes in SQL Server 2012

Columnstore Indexes in SQL Server 2012 will allow you to significantly improve the processing time of common data warehousing queries without creating cubes, aggregated tables, or other techniques normally used to improve performance. This session will show how to implement this new type of index in SQL Server and demonstrate their advantages compared to traditional solutions. Carlos will also discuss the scenarios for which columnstore indexes should be implemented to provide powerful but flexible BI solutions.

More Columnstore

Go to this blog post I wrote several weeks ago for more info on columnstore indexes.

SQL Saturday #104 in Colorado Springs

I’ve uploaded my slide deck and scripts for my presentation Using Columnstore Indexes in SQL Server 2012 that I’ll be delivering at 11am in Colorado Springs tomorrow (January 7, 2011).  To download the presentation material click here.  If you’re undecided as to what sessions to attend this should give you a good idea as to what I’ll be talking about.  When SQL Server 2012 is released, Columnstore Indexes will provide BI Architects and DBAs with another alternative for fast query response, but they are not appropriate for every situation.  My session will give you a good understanding of when it’s right to use this feature and how to prepare your data models when the time comes.

Using Columnstore Indexes in SQL Server 2012

 
Columnstore Indexes in SQL Server 2012 will allow you to significantly improve the processing time of common data warehousing queries without creating cubes, aggregated tables, or other techniques normally used to improve performance. This session will show how to implement this new type of index in SQL Server and demonstrate their advantages compared to traditional solutions. Carlos will also discuss the scenarios for which columnstore indexes should be implemented to provide powerful but flexible BI solutions.

Click here for a blog I wrote last week with more details about my session. I’ll see you in the Springs!

Follow

Get every new post delivered to your Inbox.

Join 473 other followers