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.

PowerShell can change the way you work with SQL Server forever. This webcast is the first of a series designed to take DBAs with no knowledge of PowerShell and give them what they need to use this new scripting language. In this first one-hour session, Sean McCown provides a general introduction to the PowerShell language and environment, exploring both the “why” and “how” of this powerful tool. Whether you want to finally get started with PowerShell or you just want a refresher, this is an excellent place to get started. …

The provider model pattern was designed to provide a configurable component for data access which is defined from the web.config. The Provider interfaces between the Business logic and Data Access.

Ted demonstrates how his private MacBook uses Grails to connect to a MS SQL server using the new JDBC 4 driver for MS SQL. We thought we give this some extra footage. Ted demonstrates the Northwind database and scaffolded UI for these tables based on newly created domain classes.