Anyway, I get this fantastic database newsletter each Monday, and I always plow through it and find interesting links that I click but don't exactly have time to read. I'm sure plenty of great links get lost in the whatever of time and the ether and all that. So, for the record, here's what looked interesting to me this week:
Book Review: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook
I'm dying to build a cube using Microsoft SQL Server Analysis Services (SSAS), and MDX is sort of the language of the Microsoft cube, as far as I understand. This book would be beyond what I need to read now, but who knows, my curiosity may get the best of me and it may end up on my bookshelf before long.
SQL Server table columns under the hood
Good FYI info on understanding what a table is made of. I usually just highlight the table name in an SSMS query window and hit Alt+F1 to get the details on a table. This post acknowledges that my method is a common one, and then asks this:
"But ... ‘What are the physical columns of this table?’. Huh? Is there any difference? Lets see."Hmmm, there's another way. Good to know. May come in handy some day.
Week before last was the annual PASS Summit, a big geek fest for SQL Server enthusiasts. Don't misread me -- I totally wish I'd been there. I follow a bunch of SQL pros on Twitter, and after the PASS Summit a little Tweet thread materialized about what should happen when a presenter at a PASS event (the Summit, SQL Saturday, or SQL Rally) cancels before the event. I was surprised how many people supported a zero-tolerance attitude on speaker cancellations that Steve (Twitter | Blog) writes about in his editorial. I've never been involved with organizing one of these events, so I've never felt the pain of trying to fill a gap in the session schedule. It's just that this SQL Server community is full of compassionate, helpful professionals, always eager to share tips and reply to help requests from novices (me!). Adopting this "If You Cancel, You're Banned" stance seems very out of character for this crowd.