In this session, we will explore the Script Task and Script Component tools within SQL Server Integration Services. Learn how to break out of the traditional flat-file ETL mold and, using VB.NET or C#, create custom scripts to address unconventional transformations and related tasks. We’ll also discuss other possible uses of script in SSIS, with several practical examples.

Video producer: Oklahoma City SQL Developers Group

SQL Azure provides a fully relational database service that is based on Microsoft SQL Server and familiar concepts such as T-SQL, schema-based tables, and stored procedures. Learn patterns and best practices for developing resilient applications that allow you to take full advantage of the scale and elasticity of SQL Azure Database Service.

Amit Goyal and Michael Lisin discuss SQL Server 2008 R2 with Ted Neward.

SQL Server expert Eric Johnson teaches “Accidental DBAs” the basic building blocks of SQL Server maintenance in a no-nonsense, approachable way. Topics include installation, database overview, backing up and restoring databases and more.

Amit Goyal interviews author Michael Lisin about his new book, Microsoft SQL Server 2008 Reporting Services, the comprehensive guide to SQL Server 2008 Reporting Services.