SQL Server 2008 RC0 has been released to the public here. It was released to MSDN and TechNet subscribers late last week, but now everyone can enjoy it. Also looks like a new Certification has come out as well called the Microsoft Certified Master. This actually looks like a step in between the regular certs [...]
In SQL Server 2008, Microsoft has included an entire infrastructure devoted to collecting and reporting on data to improve decision making capabilities. The Data Collector is a system that can collect data from any TSQL query like DMVs, Windows Performance Counters, and the SQL Trace. It bundles any selection of these items into a Collection [...]
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 [...]