Browse by Tags

New and old blend of data-types in SQL Server 2008

Published 9 July 7 9:8 AM | SSQA.net

By now you might have seen on blogs and documentation that there are new datatypes introduced in SQL Server 2008, they are: DATE - ANSI-compliant date data type TIME - ANSI-compliant time data type with variable precision DATETIMEOFFSET - timezone aware...

Filed under: sql server, database, 2008, new, data capture, datatype

SQL Server 2008 - Change Data Capture: new feature

Published 20 June 7 4:34 PM | SSQA.net

Let us talk briefly about the new feature that is introduced within SQL Server 2008 aka Katmai. Change Data Capture (CDC) is (similar to triggers: INSERTED & DELETED tables) the 'new boy in SQL Server town' that records the DML activities...

Filed under: sql server, katmai, features, 2008, new, cdc, data capture