January 2008 - Posts
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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,
Read More...
