Common data scenarios require developers to write and maintain logic to determine whether to insert, update or delete information (sometimes called upsert) such as: 1: IF FOUND 2: THEN UPDATE 3: ELSE 4: INSERT SQL Server 2008 provides the new MERGE statement within the SQL language to enable developers to provide this functionality with a [...]
At Magenic, Dan English and I are working on creating SQL Server 2008 screencasts highlighting the new features. He's already published a couple on his blog regarding Intellisense and Data Profiler task in SSIS. His explanation of what we're doing is so perfect, I'm just going to borrow it. "A new thing we are trying [...]