Programming Books C Java PHP Python Learn more Browse Programming Books
Programming Microsoft SQL Server 2012 (Developer Reference) and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $59.99
  • Save: $22.71 (38%)
Only 18 left in stock (more on the way).
Ships from and sold by
Gift-wrap available.
Add to Cart
FREE Shipping on orders over $35.
Used: Like New | Details
Sold by bacobooks
Condition: Used: Like New
Comment: *****FREE 2-DAY SHIPPING with Amazon Prime. Great Buy*****
Access codes and supplements are not guaranteed with used items.
Add to Cart
Trade in your item
Get a $6.62
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Programming Microsoft SQL Server 2012 (Developer Reference) Paperback – July 25, 2012

ISBN-13: 978-0735658226 ISBN-10: 0735658226 Edition: 1st

Buy New
Price: $37.28
32 New from $29.48 25 Used from $23.27
Amazon Price New from Used from
"Please retry"
"Please retry"
$29.48 $23.27


Frequently Bought Together

Programming Microsoft SQL Server 2012 (Developer Reference) + Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) + Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference)
Price for all three: $94.02

Buy the selected items together


Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now

Product Details

  • Series: Developer Reference
  • Paperback: 816 pages
  • Publisher: Microsoft Press; 1 edition (July 25, 2012)
  • Language: English
  • ISBN-10: 0735658226
  • ISBN-13: 978-0735658226
  • Product Dimensions: 9 x 7.4 x 1.5 inches
  • Shipping Weight: 2.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (7 customer reviews)
  • Amazon Best Sellers Rank: #297,126 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Leonard Lobel is a principal consultant at Tallan, a Microsoft Gold Certified Partner.

More About the Authors

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

Customer Reviews

4.3 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 7 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

7 of 8 people found the following review helpful By zave on September 8, 2012
Format: Paperback
If you're looking for a book that gives you plenty of starting points for programming against the various data access APIs available to MS SQL Server using .NET while learning something about some of the new tools and features available to MS SQL Server 2012, including SQL Server Data Tools, then this book is a good place to start. My only complaint: when this review went to press, the companion website and accompanying code samples were non-existent, yet they're referenced on several occasions; a little frustrating.

Part One of the book, "Core SQL Server Development", kicks off with a description of the new SQL Server Data Tools and its declarative, model based development approach, which utilizes an "in-memory representation of what the database looks like". This permits a developer to work against something beside the database, all from inside the project explorer in Visual Studio, then deploy to the real thing.

Chapter two of the book illustrates the latest T-SQL additions, which include improved "windowing" using the OVER clause, new functions, improvements to THROW, "server-side result set paging with OFFSET and FETCH NEXT", "sequential number generation with the SEQUENCE object", and "metadata discovery". Even in the absence of the downloadable code samples, there are plenty of samples in the pages of the book to keep you off the streets.

Chapter Three does a good job showing the reader the degree to which Visual Studio and SQL Server are integrated and how a developer can host SQL Server Database Projects in Visual Studio, and the next chapter goes on to give a thorough explanation of Transactions and a review of the ACID properties for added context.
Read more ›
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Neeraj Agrawal on November 25, 2012
Format: Paperback
First off, this book is for all those db developers who have good working knowledge of SQL Server along with a keen interest in using other microsoft technologies to play around with the database. The book is nicely dissected into 3 parts. The first 2 parts are geared towards core SQL development. The 3rd part covers new tools of integration and new technologies that are enriching the SQL landscape.

Chapter 1 is a full-blown coverage of the new SSDT introduced in SQL Server 2012. This chapter is for core developers who often find themselves juggling between tools for SQL as well as .net development. As SSDT is hosted within the visual studio, there is now a single development environment to work from.

Chapter 2 covers new T-SQL features and enhancements brought in by SQL Server 2012. Each feature is nicely treated with some good examples.

Chapter 3 goes deep into discussing SQL CLR. This highly underutilized feature within SQL Server was touted to be the next big thing. Hopefully after reading the chapter, you will feel the same and be encouraged to take advantage of it.
Chapters 4 & 5 cover transactions and SQL security. Both have been highly misunderstood areas and the chapters do complete justice to them.

Chapters 6, 7, 8 & 9 covers all the non-relational features that are making SQL an enterprise level product. Features like XML integration, Hierarchical data manipulation, file streaming and
geospatial support equip SQL Server with tomorrow's technology. These features are powerful and very intuitive to use.

Chapters 10, 11, 12, 13, 14 & 15 cover different aspects of SQL programming. Mobile and cloud computing have becomes buzzwords and SQL is enabling developers to tap into those areas. .
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Davis M. DeBard on October 6, 2012
Format: Paperback
"Programming Microsoft SQL Server 2012" by Lobel and Brust wastes no time in going over what is new and different in SQL Server 2012 from SQL Server 2008. Put out by Microsoft Press, the book is a straightforward treatment of what professional developers need to know about new (and deprecated) features in SQL Server's latest release. Even though the book is 771 pages long, it is still not an exhaustive treatment of the subject, and reads as explanation, not encyclopedia. This release of SQL Server introduces SSDT (SQL Server Data Tools), a fully functional way of working with SQL Server objects and data in a Visual Studio object model environment. Debugging by setting breakpoints in stored procedures, etc. is also now supported. Hierarchical data structures (essentially using lists instead of joins) are introduced. This release comes with greater support for data mining, Azure and other cloud technologies, Windows Phone and other mobile technologies, XML, and distributed transactions, to name several. If you are new to SQL Server, this is not the book for you, but if you are an experienced software developer using Microsoft storage technologies, this book is very worthwhile.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
The problem of selecting a database reference book is that most of the material will not be related to your area of interest. Practically no one is trying to get a fifth reference on normalizing a database and writing a SQL query. What we want is a book that has some depth and gives you a decent look into the proper use of new features and a new perspective or two with new code examples.

I can say that this book is one of Microsoft's better renditions of a user manual for it's latest database. This is a very good thing, because the 2008 R2 database had some peculiar gotchas and jams when runnning slightly advanced queries and special applications. Along with many other programmers, who didn't want to make a career out of database design, we wanted better reliability of operation and much better documentation for the new 2012 database. This book goes a long way in the desired direction.

Especially welcome sections were: Table Valued Parameters(TVPs), modern date-time convenient storage formats, data encryption and security, spacial data enhancements, and stored parameter design and testing. Microsoft databases have lagged behind PostgreSQL databases and others for years because they didn't have anything similar to an array column type. TVPs may finally alleviate this issue and a good discussion about this solution is gratefully accepted. The date-time conversion operations make handling this vital area of database interaction much clearer. The use of proper security of databases has long been a poorly documented issue and the more thorough presentation of it in Chapter 5 is well worth reading. Chapter 9 answers some long awaited questions on the use of spacial data.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images