Programming Microsoft SQL Server 2008

Written by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples.

Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you ll learn the essential tools and techniques for developing robust applications. Discover how to:
-Program views, stored applications, triggers, and functions using T-SQL
-Work with the new data types, LINQ, and the ADO.NET Entity Framework
-Automate common administration and maintenance tasks
-Debug databases, reports, and objects using Microsoft Visual Studio® 2008
-Write transactional code and implement local and distributed transactions
-Use business intelligence tools, such as SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services

Many of the book s examples, exercises, and code samples are available for download from the companion Web site.

Leonard Lobel is a senior consultant with twentysix New York, a Microsoft Gold Certified Partner. Programming since 1979, his experience spans a variety of business domains, including the publishing and retail industries, and roles from senior developer to chief architect. A contributing editor to VISUAL STUDIO MAGAZINE, Leonard has also served as lead developer for six of Microsoft's Starter Kits and Sample Applications for SQL Server Express Edition.
Andrew J. Brust is Chief, New Technology, at twentysix New York, a Microsoft Gold Certified Partner specializing in business intelligence and custom database applications built with Microsoft .NET, SQL Server, and other Microsoft technologies. Andrew has more than 20 years experience programming and consulting in the financial, public, small business, and not-for-profit sectors.
Stephen Forte has several years experience as a developer, entrepreneur, consultant, and executive. He speaks regularly at industry conferences such as Tech Ed, CTTM, Advisor DevCon, and other worldwide conferences. Stephen is also the Microsoft Regional Director for the New York Metro region. He has written several books on database development and is technical editor and monthly columnist for ACCESS VB SQL ADVISOR MAGAZINE.