Six of the Best: Clustered Columnstore Special

Here’s a roundup of 6 links and updates from the past month I recommend as good reading. I decided that I needed to post a list of Blogs posts, technology info and other random-but-related stuff. So I decided to limit myself to a monthly post of sharing no more than 6 articles across the web.

I’m massively busy getting to grips with Clustered Columnstore indexes, as well as day to day tasks, raising a family, studying for exams etc. And like I don;t have enough on, we’re moving house.

But at any rate, all the links below relate directly to columnstore indexes. Even if you’re not planning on using them, these links will help you understand them.

Teched 2013 video on Columnstore

Columnstore Indexes at 2013

Microsoft Research/SIGMOD paper of Columnstore

Columnstore Gotchas (please read the comments on this one because the gotchas have gotchas

What is the Tuple Mover doing?

A 27 part special on Clustered Columnstores

Six of the Best: January 2014

Here’s a roundup of 6 links and updates from the past month I recommend as good reading. I decided that I needed to post a list of Blogs posts, technology info and other random-but-related stuff. So I decided to limit myself to a monthly post of sharing no more than 6 articles across the web.

Script CREATE and DROP indexes for all indexes in tables.

BIDS Helper 1.6.5 was released on 7th January with new features and bug fixes.

SQL Server Cheat Sheet from SQL Authority.

Glenn Berry advices us on one Intel Processor Family to Avoid For SQL Server 2012/2014.

Upgrading the ZTE Open to different versions of Firefox OS.

Shill Time… MSBuildSsis2012 is up and available on CodePlex.

Six of the Best: November 2013

Here’s a roundup of 6 links and updates from the past month I recommend as good reading. I decided that I needed to post a list of Blogs posts, technology info and other random-but-related stuff. So I decided to limit myself to a monthly post of sharing no more than 6 articles across the web. Continue reading “Six of the Best: November 2013”

Six of the Best: October 2013

Here’s a roundup of 6 links and updates from the past month I recommend as good reading. I decided that I needed to post a list of Blogs posts, technology info and other random-but-related stuff. So I decided to limit myself to a monthly post of sharing no more than 6 articles across the web.

Comodo Ice Dragon is a web browser that integrates with Comodo’s SecureDNS, and is very good indeed.

SQL Server 2014 CTP2 is available to download here.

SSAS Activity Viewer 2012 is a work in progress application from yours truly to help view the activity on a SSAS instance.

Selecting an Appropriate Intel Xeon E5-2600 v2 Family Processor for SQL Server 2012 Glenn Berry saves you a lot of trouble and gives you the skinny on the best processors to buy from the Xeon E5-2600 v2 Family.

More from Glenn as he provides a SQL Server Database Server Hardware Upgrade Case Study to put the previous post into context for you.

Never has the phrase “The Devil Makes Work for Idle Hands” been so pertinent as these guys make a MineCraft tribute to a “Nightmare Before Christmas”.

Six of the Best: September 2013

Here’s a roundup of 6 links and updates from the past month I recommend as good reading. I decided that I needed to post a list of Blogs posts, technology info and other random-but-related stuff. So I decided to limit myself to a monthly post of sharing no more than 6 articles across the web.

The Full Story of Nokia and Microsoft – How we got here, and why Microsoft will fail with Nokia handsets

Collateral-Damage: My $.02 on the MCM debacle

Microsoft Do Something for Free, But Still Get Called Evil

Extract Dacpacs using PowerShell

Find Last Backup Time For All Databases

Brawny Cores Beat Wimpy Cores… Most of The Time

Six of the Best: August 2013

Here’s a roundup of 6 links and updates from the past month I recommend as good reading. I decided that I needed to post a list of Blogs posts, technology info and other random-but-related stuff. So I decided to limit myself to a monthly post of sharing no more than 6 articles across the web.

Determine if a computer is virtual with powershell

SSD RAID Load Testing Results from a Dell PowerEdge R720

Subselects And Formula Engine Caching In SSAS 2012

SQL SERVER – Finding Last Backup Time for All Databases

Bug: DBCC CHECKDB data purity checks are skipped for master and model

Ridiculously good acapella versions of video game songs

Six of the Best: July 2013

Here’s a roundup of 6 links and updates from the past month I recommend as good reading. I decided that I needed to post a list of Blogs posts, technology info and other random-but-related stuff. So I decided to limit myself to a monthly post of sharing no more than 6 articles across the web.

Enabling OpenSource Software using Windows Server 2012 R2

Architectural overview of SQL Server 2014 In Memory OLTP

The 1 Skill You Need to Succeed in IT

Like it or not, Self-Service BI and Cloud BI are Here

Light Completely Stopped for One Minute

Features Supported by the Editions of SQL Server 2014