Programming Microsoft SQL Server 2008 (PRO-Developer) [Perfect Paperback]

Leonard Lobel (Author), Andrew J. Brust (Author), Stephen Forte (Author)

Book Description

ISBN-10: 0735625999 | ISBN-13: 978-0735625990 | Publication Date: October 29, 2008 | Edition: 1

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.

Editorial Reviews

About the Author

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.

Product Details

• Perfect Paperback: 976 pages
• Publisher: Microsoft Press; 1 edition (October 29, 2008)
• Language: English
• ISBN-10: 0735625999
• ISBN-13: 978-0735625990
• Product Dimensions: 8.9 x 7.3 x 1.7 inches
• Shipping Weight: 3.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #717,111 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

5.0 out of 5 stars MyReview - Programming MSSQL 2K8, June 27, 2009

By 

Donald L. Yatch "SebastianC" (San Antonio, Texas) - See all my reviews
(REAL NAME)   

This review is from: Programming Microsoft SQL Server 2008 (PRO-Developer) (Perfect Paperback)

Programming Microsoft SQL Server 2008 (PRO-Developer)

I've been working with 2008 for 2 years now and with 2005/2000/7.0/6.5 since '98. This book has really become my right hand man with quick, easy to understand reference on the new capabilities of Sql Server 2008. I find it a great, fast to access source of information for a broad range of MSSQL concepts including; CLR, Replication, BI, Linq, New Syntax, deprecation warnings.. the list goes on. The book gives enough insite to a programmer to get him started with all the above. It does not delve into great depth on any of these ideas giving the developer a chance to utilize his/her own intelligence and pursue their own path of specific interest. It does, however, provide a great launching pad on all these ideas. Personally, I would have liked to have seen more on Performance Tuning and using the Service Broker. Reality is though, this IS one book. These days there's enough going on inside Sql Server to fill a library!! This book is a fantastic single point of reference for getting one's self started in 'most' of the concepts involved in a package that's quickly becoming an SOA/Enterprise platform of choice.

14 of 17 people found the following review helpful:

2.0 out of 5 stars A mush mash of development, April 23, 2009

By 

Suresh Chanmugam (Ontario Canada) - See all my reviews
(REAL NAME)   

This review is from: Programming Microsoft SQL Server 2008 (PRO-Developer) (Perfect Paperback)

What would you like to do with SQL server, programming wise as the title suggests ? - Database development for applications or Business Intelligence (reporting, analytics)? This book covers both aspects and does not give sufficient depth to do any sort of reasonable programming in either environment. "Smart Business Intelligence Solutions" ISBN-10: 0735625808 is a good book on Reporting, Analytics and ETL using integration services. For application development, I have not found a single source yet. I recommend: Apress T-Sql recipes and MSPress SQL Server Internals; also MSpress T-SQL fundamentals for beginners.

4.0 out of 5 stars A great source for SQL 2008 information, October 23, 2011

By 

Sudheer K. Maharana - See all my reviews
(REAL NAME)   

This review is from: Programming Microsoft® SQL Server® 2008 (PRO-Developer) (Kindle Edition)

One of the great additions to my library. Authors have well laid out the chapters. I liked the chapters on FileStream and the datawarehousing chapters. The contents of the chapters are much advanced and helps guide a programmer to get upto speed on SQL Server 2008 new features such as FileStream, merge, and date functions. I recommend this book for all the medium to advanced level programmers to refer it to for a quick understanding of concepts with examples.
This also takes DBAs to understand the concept around occasionally connected systems and how SQL Server refreshes the data for the end applications such as Mobile applications. The chapter dedicated to Transactions could have been much improved. Again if one wants to write a chapter in transactions, leave a alone a single chapter, a sizable book will not be sufficient.