Tuesday, August 25, 2009

Sending HTML formatted email from SSIS

Send Mail Task which is quite simple to use and can be used in a scenario where you need to send plain text email with less development efforts. But you can use, Script Task to overcome the limitations imposed by the Send Mail Task. Click here to see what code you need to write to send HTML formatted mails from SSIS package.

Sending email from SSIS Package

Sending email from SSIS Package
SSIS provides a built-in "Send Mail Task" to send email. The Send Mail Task is quite simple and straight forward in its configuration and use. Click here to learn how to configure and use Send Mail Task in your SSIS Package.

Resource Governor in SQL Server 2008

Resource Governor in SQL Server 2008
Resource Governor is a new technology in SQL Server 2008 that enables you to manage SQL Server workloads and resources by specifying limits on resource consumption by incoming requests. In an environment where multiple distinct workloads are present on the same server, Resource Governor enables us to differentiate these workloads and allocate shared resources as they are requested, based on the limits that you specify. These resources are CPU and memory. Click here for more details on Resource Governor.