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: NTS: Always install the TFS Power Tools

    Or you’ll wind up with: TF10139: The following check-in policies have not been satisfied. Internal error in Changeset Comments Policy Well, you will whenever somebody else installs them on the TFS server and enables the Changeset Comments Policy... See also: TF10139 Error when checking in files: Check...
  • Blog Post: Two links I want to save for l8r: WM6.5 DTK and Windows API Code Pack for .NET 3.5

    From the MSDN Flash dated 20090623: Download the Free Windows API Code Pack for Microsoft .NET Framework The Code Pack is a source-code library that provides access to the new Windows 7 features (and some related Windows Vista features) from managed code. These features are not available to developers...
  • Blog Post: Whoops. Got to uninstall all the .NET 4.x bits or Server Manager breaks...

    Fiddling around with TFS 2010 (x64) got me into a little trouble: "MMC could not create the snap-in. The snap-in might not have been installed correctly. CLSID: FX:{18ea3f92-d6aa-41d9-a205-2023400c8fbb}" Doh. Fortunately, there were just two more .NET 4.x Beta 1 items in PAF (on 2008, formerly...
  • 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: 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...
  • Blog Post: Need to Renumber All Your Packages?

    If you do quasi-template driven development for Integration Services packages, you might find yourself in a situation where you suspect that your problems stem from concurrently executing packages that share the same GUID value for package ID. When that's the case, you'll probably want an automated means...
  • Blog Post: If you have to look it up more than once, blog it.

    The corollary of "if you have to do it more than once, automate it" is "if you have to look it up more than once, blog it." So I'm blogging the Data Dude links (so I don't have to look 'em up again later). Visual Studio 2005 Team Edition for Database Professionals Add-on for Visual...
Page 1 of 1 (9 items)