UK SQL Relay 2014 Plus Travel Info for London and Southampton

Throughout October, SQL Relay 2014 is taking place in the UK. If you’re unfamiliar with SQL Relay, it is a series of 1 day events that are run throughout the UK. Each event is a single track (or more in the case of London) conference, with between 50 and 200 attendees and 6-8 hour long talks by SQL Server professionals, MVPs, authors, technical experts etc.

Continue reading “UK SQL Relay 2014 Plus Travel Info for London and Southampton”

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

SQL Supper Notes

Yesterday evening there was a very special SQL Supper hosted at the Microsoft offices in London Victoria. It was an open session with some of the Microsoft Data Platform group, Mark Souza, Nigel Ellis, Conor Cunningham, Hatay Tuna and Ewan Fairweather. So I made my way by foot from the offices here in Covent Garden to London Victoria. Although February in London is rather chilly, with a brisk walk you can make it in half an hour, plus you pass several landmarks such as the piazza at Covent Garden, Trafalgar Square (and it’s controversial 4th plinth sculpture, the Blue Hahn Cock) the Mall, Buckingham Palace and finally, Westminster Cathedral.

536px-Hahn-Cock

Continue reading “SQL Supper Notes”

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”

UK SQL Relay 2013 R2 Plus Travel Info for London and Southampton

Throughout November, SQL Relay R2 2013 is taking place in the UK. This is the 2nd series of events this year. SQL Relay is a series of 1 day events that are run throughout the UK. Each event is a single track (or more in the case of London) conference, with between 50 and 200 attendees and 6-8 hour long talks by SQL Server professionals, MVPs, authors, technical experts etc.

Continue reading “UK SQL Relay 2013 R2 Plus Travel Info for London and Southampton”