April 2009 Tips - Recap

Backup and Recovery

• Purging MSDB Backup and Restore History from SQL Server
• When was the last time your SQL Server database was restored

• Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4

• SQL Server Database Mail Cleanup Procedures

• Database Mail and SQL Agent Mail setup by using a script

• DOS Commands for the SQL Server DBA

• Collecting performance counters and using SQL Server to analyze the data
• Convert Implicit and the related performance issues with SQL Server
• Do SQL Server User Defined Datatypes (UDT) affect performance?
• Handling workloads on SQL Server 2008 with Resource Governor

• Auditing Failed Logins in SQL Server

• SQL Server 2008 Installation Process - Part 2

• Different ways to execute a SQL Agent job

• Accessing SharePoint Lists with SQL Server Integration Services SSIS 2005
• Getting the SSIS package store to work with a SQL Server named instance
• Sending email from SQL Server Integration Services (SSIS)

• Auto generate change scripts in SQL Server Management Studio (SSMS) for tables

• Swap column data due to inserting data into wrong columns for SQL Server table