Windows Server 2008

Database Mail is useful for sending e-mail to administrators and end users. Database mail can contain data from queries or from files or other resources on your network. In this video Scott Golightly shows how to configure Database Mail in SQL Server 2008. After setting up Database Mail we see how to test the mail and view the mail log.

Data quality is important to every business. Using the SQL Server 2008 Data Profiling task computes statistics about the data in a database to spot incorrect values. The Data Profiling viewer allows you to view the generated statistics. In this video Scott Golightly shows how to create the data profile and how to review the results.

Managing hierarchies in Information Systems has long been a challenge to most information systems professionals. The issues are simple, but the implementation of hierarchies within databases is complex and often onerous. The HierarchyID datatype introduced in SQL Server 2008 provides a new way to deal with these types of issues. In this video, Max Adams will introduce this new HierarchyID Datatype and examine how to: - Create tables that implement this datatype - Populate the table with data using CTE - Query the table using some of the inherent functions available for the HierarchyID Datatype.

Not all virtualisation deployments run on huge farms of clustered servers. In this video, Mark Wilson shows how to create a failover cluster for high availability with both nodes running virtualised on Hyper-V.