Reed Me

Development schtuff, SQL Server & other random geekness. Now with more [fill in the blank]!

Browse by Tags

Tagged Content List
  • Blog Post: Degenerate dimensions in VSTS DB edition GDR R2 (a.k.a. TSD03136)

    This is a common pattern in many BI projects that I’ve been involved with in the past four or five years for deriving degenerate dimensions without expending the effort to build and maintain star schema or snowflake tables in a data mart or data warehouse. (I’m not passing judgment, just making an observation...
  • Blog Post: erR? TSD03006. Doh!

    I’m often skeptical when I read things like this that make absolute statements: To resolve this problem, upgrade to Microsoft Visual Studio Team System 2008 Database Edition GDR R2. FIX: When you access a table source in a referenced project by using an alias in VSTS 2008 Database Edition GDR, if you...
  • Blog Post: Developers MERGE thyselves?

    I was reading this CIO.com article a while back and wondering if “database developers” and “regular developers” agree. As Microsoft sees it, the roles of the database-centric developer and "regular" developer are less distinct than they once were, so the company is merging its VSTS database...
  • Blog Post: Testing the SQL Database

    Being a big fan of test-driven development of any kind, database or otherwise, I was honored to sit on a panel with some other much smarter people than I at TechEd*2008 entitled "Testing the SQL Database." Not only did I get to opine a bit, but I also got to learn some, too, which happens whenever you...
  • Blog Post: DataDude Annoyance #13: Project variables omitted from output script.

    If you're using any software product for a non-trivial purpose, you'll find that it has flaws that will (upon occasion) drive you up a wall. It doesn't make any difference what it is or who produced it. I've even heard Mac users, upon occasion, complain about bugs in their toys. But sometimes these little...
Page 1 of 1 (5 items)