Table-Valued Parameters in SQL Server 2008 let you pass many rows to a stored procedure without a temp table. I walk through the steps with a Department example.
SQLAuthority News – Microsoft SQL Server 2008 Report Builder 2.0
Download Report Builder 2.0 for SQL Server 2008 Reporting Services, with table, matrix and chart wizards, plus a note on SQL Server 2008 R2 Report Builder 3.0.
SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database
Configure Database Mail in SQL Server 2008 in three steps: create a profile and account, configure email, then send email. Video and screenshots included.
SQL SERVER – 2005 – Best Practices Analyzer (August 2008)
The August 2008 release of SQL Server 2005 Best Practices Analyzer (BPA) checks your Windows and SQL Server settings against Microsoft best practices.
SQLAuthority News – Microsoft SQL Server 2008 Books Online – BOL – English
Download SQL Server 2008 Books Online, the main documentation with setup steps, new features, tutorials and reference for tools and APIs.
SQL SERVER – Download and Install Sample Database AdventureWorks 2005 – Detail Tutorial
Installed SQL Server 2008 and found no samples? A quick tutorial to download and install the Sample Database AdventureWorks, and a note on WideWorldImporters.
SQL SERVER – Introduction to Log Viewer
The SQL Server 2005 Log Viewer shows SQL Server error logs, Agent logs, Database Mail and Windows event logs in one place, ready to filter and export.