Category Archives : Uncategorized

Exam Prep 70-463: Master Data Services Models

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 […]

Explicit Hierarchy (courtesy of MSDN)

If you fill the jar with pebbles first, you'll never have room for the big rocks.

Pitching Pebbles – Using Certificates to Grant Privileges

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 […]

The Rose City

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…

TVC example output

Table Value Constructors

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). […]