This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly Changing Dimensions Fact tables and measures Intro to columnstore indexes Columnstore indexes and partitioning […]
I’m sure you’ve heard the story by Stephen Covey about the professor that fills a jar with rocks, pebbles, and sand as a metaphor for time management and prioritization. I’d relate it here, but I think this video is much more fun. Obviously this metaphor applies to all aspects of our lives, but we can […]
I’m off to Portland, Oregon for a few days for some much-needed R&R. I’m *so* looking forward to some of this A little of this And, yes, a bit of this Oh! and I have to try one of these! ‘Til next week, folks…
So I was poking around on SQLServerCentral today and I wandered into the QotD section. At random, I picked a TSQL question that introduced me to a new functionality in SQL Server 2008: table value constructors (TVC). Let me state for the record that I am not a developer (in case you hadn’t already noticed). […]
