Skip to content
  • About

Brett W. Green's On the Contrary

This is my blog. There are many like it but this one is mine.

Month: May 2013

The Power and Simplicity of the Data Warehouse

Originally posted on Fortigent:
“In many ways, dimensional modeling amounts to holding the fort against assaults on simplicity” – Ralph Kimball, The Data Warehouse Toolkit Although there are many reasons that an organization may consider building a “data warehouse”, most of the time the overwhelming reason is performance related… a report or web page is…

May 23, 2013 Brett W GreenLeave a comment

The coolest SQL Server function you never heard of

Ever heard of the SQL_VARIANT_PROPERTY function? I didn’t think so. SQL Server developers very often make the mistake of making their NUMERIC fields too large. When faced with a choice of how to size the column, they’ll often think “make it way larger than I need to be safe”. This works OK as long as… Read More The coolest SQL Server function you never heard of

May 8, 2013 Brett W Green3 Comments

Links

  • My 500px photos
  • Stack Overflow Profile

My tweets

My Tweets

Top Posts & Pages

  • Management by PowerPoint
  • Build a testing database with SSDT and NuGet

Archives

  • March 2020
  • February 2017
  • September 2016
  • June 2016
  • February 2015
  • May 2013
  • March 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • July 2012
Blog at WordPress.com.
  • Follow Following
    • Brett W. Green's On the Contrary
    • Already have a WordPress.com account? Log in now.
    • Brett W. Green's On the Contrary
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar