Scripting in SQL Server Integration Services
Published September 8th, 2010 Under Database | Leave a Comment
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
Development Best Practices and Patterns for Using Microsoft SQL Azure Databases
Published June 22nd, 2010 Under Database | Leave a Comment
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.
SQL Server 2008 R2
Published May 10th, 2010 Under Database | Leave a Comment
Amit Goyal and Michael Lisin discuss SQL Server 2008 R2 with Ted Neward.
SQL Server Fundamentals for the Accidental DBA
Published March 22nd, 2010 Under Database | Leave a Comment
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.
Microsoft SQL Server 2008 Reporting Services
Published February 1st, 2010 Under Database | Leave a Comment
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.
keep looking »