January, 2008

  • SQL 2008 Table Value Parameters and Merge

    Table Value Parameters + MERGE statement In many customer scenarios, it is necessary to pass a set of table structured values (rows) to a stored procedure/function on the server. These values may be used for populating/updating a table directly or for...
  • SQL 2008 New Date/Time Data Types

      New Date/Time Data Types SQL Server 2008 introduces new date and time data types: · DATE – a date only type · TIME – a time only type · DATETIMEOFFSET – a time zone aware datetime type · DATETIME2 – a...
  • SQL 2008 Hierarchy ID

      HierarchyID SQL Server 2008 enables database applications to model tree structures in a more efficient way than currently possible. HierarchyId is a new system type that can store values that represent nodes in a hierarchy tree. This new type features...
  • Darth Vader Directs Imperial March

    Ok, so I Love multimedia. I am especially fond of new online media channels and the effect they may have on popular culture as well as day to day life.  You Tube is of particular interest to me.  I think it is the direct result of the desire...
  • SQL 2008 Building Occasionally Connected Systems

    Building Occasionally Connected Systems With mobile devices and workers on-the-go, occasionally connected has become a way of life. SQL Server 2008 delivers a unified synchronization platform that enables consistent synchronization across applications...