Using the MERGE Statement in SSIS Via a Stored Procedure By Nicholas C. Smith

Using the MERGE Statement in SSIS Via a Stored Procedure

By Nicholas C. Smith, 2012/01/23

http://www.sqlservercentral.com/articles/EDW/77100/

Grant Fritchey's SQL Server Howlers

http://www.simple-talk.com/sql/database-administration/grant-fritcheys-sql-server-howlers/

Stairway to SQL Server Agent

SQL Server Agent is at the heart of any live database system. The Agent has a number of uses which aren't always obvious, and so a knowledge of the system is always useful, to developers as well as DBAs. Richard Waymire provides a simple explanation of its many uses.

http://www.sqlservercentral.com/stairway/72403/

Should we use Singular or Plural Database Table Names

by JoshuaKissoon

http://www.codeproject.com/Articles/309304/Should-we-use-Singular-or-Plural-Database-Table-Na

Convert numbers to words in English and Asian format

by Musa Biralo

http://www.codeproject.com/KB/vb/NumbersToWords.aspx

Configure Database Mail, Operator and Notifications in SQL Server

by Keshav Singh

http://www.codeproject.com/KB/database/Configure-Mail-SQL-Server.aspx

Dynamically Generating Html/Excel/Word Document Files with SQL Server data using SSIS 2005

by Venkat Chaitanya Kanumukula

http://www.codeproject.com/KB/database/Dynamic_Html.aspx