Send a Visa virtual eGift card.
Add Prime to get Fast, Free delivery
Amazon prime logo
Buy new:
-28% $35.86
FREE delivery Tuesday, November 26
Ships from: Amazon.com
Sold by: Amazon.com
$35.86 with 28 percent savings
List Price: $49.99
FREE Returns
FREE delivery Tuesday, November 26
Or Prime members get FREE delivery Saturday, November 23. Order within 7 hrs 21 mins.
In Stock
$$35.86 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$35.86
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon.com
Ships from
Amazon.com
Sold by
Amazon.com
Sold by
Amazon.com
Returns
Returnable until Jan 31, 2025
Returnable until Jan 31, 2025
For the 2024 holiday season, eligible items purchased between November 1 and December 31, 2024 can be returned until January 31, 2025.
Read full return policy
Returns
Returnable until Jan 31, 2025
For the 2024 holiday season, eligible items purchased between November 1 and December 31, 2024 can be returned until January 31, 2025.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$21.00
Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! See less
$3.99 delivery November 30 - December 3. Details
Only 1 left in stock - order soon.
$$35.86 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$35.86
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Ships from and sold by HPB-Ruby.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Adam Machanic
Follow
Hugo Kornelis
Follow
Something went wrong. Please try your request again later.

Expert SQL Server 2005 Development 1st ed. Edition

by Adam Machanic (Author), Lara Rubbelke (Author), Hugo Kornelis (Author)
4.1 4.1 out of 5 stars 13 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$35.86","priceAmount":35.86,"currencySymbol":"$","integerValue":"35","decimalSeparator":".","fractionalValue":"86","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"Qs%2B9W2cRI28uZukWWKBPgjuFFoL4%2BMYK8lSNOvtv5B3ddMdb8EKx8KKB8VBWMSmSSzeTe0IaTpuZ7PQfWNqz0BCmMo0SkXHA80KEPc3mw8T%2FMrB7wq7ZQQ2f5aooZIu2G1tWwIah7gI%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$21.00","priceAmount":21.00,"currencySymbol":"$","integerValue":"21","decimalSeparator":".","fractionalValue":"00","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"Qs%2B9W2cRI28uZukWWKBPgjuFFoL4%2BMYKKiN32Ge2HXrOwxatjIYQkAj%2B2f62Wx0NWFnc3yMfjizWuzEScfGou0cTXbaVV27uAH6mxeev103Fp7yrmMaGISretcpxlAKfGu3Uqnwj2BhFb0WKlmyR8bZgegnQvfBlFwstocAGqPttLLSTw1mbu%2FRNjwjB9%2BDe","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

While building on the skills you already have, Expert SQL Server 2005 Development will help you become an even better developer by focusing on best practices and demonstrating how to design high–performance, maintainable database applications.

This book starts by reintroducing the database as a integral part of the software development ecosystem. You'll learn how to think about SQL Server development as you would any other software development. For example, there's no reason you can't architect and test database routines just as you would architect and test application code. And nothing should stop you from implementing the types of exception handling and security rules that are considered so important in other tiers, even if they are usually ignored in the database.

You'll learn how to apply development methodologies like these to produce high–quality encryption and SQLCLR solutions. Furthermore, you'll discover how to exploit a variety of tools that SQL Server offers in order to properly use dynamic SQL and to improve concurrency in your applications. Finally, you'll become well versed in implementing spatial and temporal database designs, as well as approaching graph and hierarchy problems.

Previous slide of product details
  1. ISBN-10
    159059729X
  2. ISBN-13
    978-1590597293
  3. Edition
    1st ed.
  4. Publisher
    Apress
  5. Publication date
    May 16, 2007
  6. Language
    English
  7. Dimensions
    7.5 x 1.07 x 9.25 inches
  8. Print length
    472 pages
  9. See all details
Next slide of product details
Amazon First Reads | Editors' picks at exclusive prices

Editorial Reviews

About the Author

Adam Machanic is an independent database software consultant, writer, and speaker based in Boston. He has implemented SQL Server solutions for a variety of high-availability online transaction processing and large-scale data warehouse applications, and also specializes in .NET data access layer performance optimization. Adam has written for SQL Server Professional and TechNet magazines, serves as the SQL Server 2005 Expert for SearchSQLServer.com, and has contributed to several books on SQL Server, including Pro SQL Server 2005 (Apress, 2005). He regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP). When not sitting at the keyboard pounding out code or code-related prose, Adam tries to spend a bit of time with his wife, Kate, and daughter, Aura, both of whom seem to believe that there is more to life than SQL. Adam blogs at http://www.sqlblog.com, and can be contacted directly at amachanic@datamanipulation.net.

Product details

  • Publisher ‏ : ‎ Apress; 1st ed. edition (May 16, 2007)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 472 pages
  • ISBN-10 ‏ : ‎ 159059729X
  • ISBN-13 ‏ : ‎ 978-1590597293
  • Item Weight ‏ : ‎ 1.64 pounds
  • Dimensions ‏ : ‎ 7.5 x 1.07 x 9.25 inches
  • Customer Reviews:
    4.1 4.1 out of 5 stars 13 ratings

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Adam Machanic

    Adam Machanic

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read book recommendations and more.

    See more on the author's page
  2. Hugo Kornelis

    Hugo Kornelis

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read book recommendations and more.

    See more on the author's page
Next page

Customer reviews

4.1 out of 5 stars
13 global ratings

Top reviews from the United States

Jaewoo Kim
4.0 out of 5 stars Provides golden nuggets to T-SQL development
Reviewed in the United States on January 26, 2009
Verified Purchase
This is not a comprehensive book on T-SQL development. Rather it provides some high level golden nuggets of T-SQL information that even many experienced T-SQL developers do not have a full mastery.

Here are the main topics the book covers:

1)Errors and Exceptions: open transactions and how it can be resolved using XACT_ABORT and error handling. How to use Try/Catch.

2)Encryption: Symmetric and asymmetric encryption and good explanation of which one to use in which circumstances.

3)SQLCLR: How to use .NET with within SQL instance. This feature, as the author correctly states, is rarely used and has been overhyped by Microsoft.

3)Dynamic SQL and SQL injection: how to and why use SP_ExecuteSQL instead of "exec" when using dynamic SQL.

I highly recommend this book to SQL developers and Database Architects. It is not as helpful to the DBAs since it covers areas not typically handled by the DBAs. But this book nonetheless helps everyone to better understand the intricacies of T-SQL.
One person found this helpful
Helpful
 Report
Denis G
5.0 out of 5 stars Review of Expert SQL Server 2005 Development
Reviewed in the United States on June 14, 2007
If you are an advanced or intermediate SQL Server developer then this is the book for you. Adam understands real world scenarios and understands that databases are part of a bigger group in the business world. The database is usually the most important asset in an organization. All your data is in the database, you need to secure it, this is where encryption, privilege and authorization comes in. The ratio of web servers to database servers is usually many to one, it is easy to scale out with web servers however with database servers this is not so easy. This is a reason why your code needs to be optimized and designed for application concurrency.

I recommend this book to any intermediate or advanced SQL Server developer. This book is not a book that is like the other book you have but 2 chapters are different. NO, this book contains a lot of good info which is not available in other books. I learned a lot from reading this book and you will too. Here is the breakdown of what is covered in the chapters.

Chapter 1 Software Development Methodologies for the Database World
Adam explains what Cohesion, Coupling and Encapsulation is, where the business logic should live and the balance between maintainability, performance, security and more.

Chapter 2 Testing Database Routines
This chapter is worth the price of the book by itself. You will learn how to unit test your procedures, evaluate performance counters and this chapter introduces the SQLQueryStress Performance Tool (see picture below) which will be used in other chapters. This is a very useful tool if you have to tune a query. How many times do you set statistics time and statistics IO on and off to see the reads and CPU time? This tool does it all for you, paste in your query or proc call, specify how many times you want to run it that is it. This tool will save you many stressful (pun intended) hours

Chapter 3 Errors and Exceptions
This chapter explains the different type of exceptions and how to do error handling. You will also find out what a `doomed transaction' is, this is the one where you get this user friendly message: "The current transaction cannot be commited and cannot support operations that write to the log file. Roll back the transaction."

Chapter 4 Privilege and Authorization
This chapter explains what impersonation and ownership chaining is. Also covered is how to use EXECUTE AS and how to sign procedures.

Chapter 5 Encryption
This chapter will explain encryption to you in a clear and concise matter. You will learn how to improve performance by using Message Authentication Code. The difference between symmetric and asymmetric key encryption is covered as well as all the terminology that is needed to really understand encryption.

Chapter 6 SQLCLR: Architecture and Design Considerations
What this chapter covers is SQLCLR security, why to use SQLCLR and how to enhance Service Broker Scale-Out with SQLCLR

Chapter 7 Dynamic T-SQL
You want to protect your data? Then this is something you have to read. You will learn how to deal with sql injection, why sp_executesql is much better than exec and the performance implications of parameterization and caching.

Chapter 8 Designing Systems for Application Concurrency
If you are running an OLTP system and you are suffering from blocking/locking then this is the chapter for you. Isolation levels and how they affect concurrency is explained. This chapter uses the SQLQueryStress Performance Tool to show you the difference it makes in performance when you slightly change your proc.

Chapter 9 Working with Spatial Data
Spatial data, this is what a lot of people are storing these dates, unfortunately calculating the distance between 2 points is not as easy as it seems (the earth is not flat you know ;-( ) This chapter covers a couple of ways to represent Geospatial Data.

Chapter 10 Working with Temporal Data
Dates are everywhere in the database but unfortunately a lot of people do not know how dates are stored internally and how to write efficient queries which will cause an index seek instead of a scan. Calendar tables, time zones and intervals are all covered in this chapter

Chapter 11 Trees, Hierarchies, and Graphs
The difference between Nested Set Model, Persisting Materialized Paths and Adjacency list Hierarchies are explained. There is code included that shows you how to traverse up or down the hierarchy, insert new nodes and much more.
18 people found this helpful
Helpful
 Report
fredeye
3.0 out of 5 stars Three Stars
Reviewed in the United States on April 3, 2018
Verified Purchase
Not a very good reference.
Helpful
 Report
Hilary Cotter
5.0 out of 5 stars A truly remarkable book
Reviewed in the United States on July 18, 2007
There is an old story about three men imprisoned in a dark dungeon. Each day they were given a bowl of food and a spoon to eat with. The darkness eventually drove one of the men mad, and he was no longer able to eat his meal. In the darkness, he had forgotten how to eat with his spoon. Every day, one of the two remaining men patiently taught the madman how to use his spoon to eat his meal. The madman, however, would forget what he'd learned on a daily basis, and would have to be taught anew each day by this fellow prisoner. One day, the prisoner became frustrated with the third man for his complete lack of assistance, and began to lash out at him asking, "Why don't you ever help me?" The third man replied, with an aire of conviction, "I am busy trying to bring light into the dungeon so that we can all see."

Too many books in the technical field just teach us the basics; they help us with our daily lives. In this unique book, Adam (one of the brightest lights in the SQL Server world) teaches us to see the light, to understand SQL Server programming, and revolutionize the way we do our work. In this exceptionally well written book, he consistently explains difficult topics with original explanations and great clarity. At first, I felt that some of his examples (like the ones on concurrency) were incorrect, but over time, I have grown in understanding of just how fitting, appropriate, and accurate they actually are. I find I can no longer speak about concurrency without using Adam's examples. He also presents the definitive arguments on some of the more hotly debated topics in the SQL Server world today: stored procedure use over ad hoc SQL, for example.

Each topic is presented with clear code samples that illustrate his points perfectly.

I truly admire Adam's rhetorical style. Somewhat akin to peeling back layers of an onion, he will present a topic and then, just when you have digested it and added it to your toolbox, he will show you its shortcomings and offer an alternative, more powerful technique. Once you have grasped this new technique, he will present to you a third.

Although this volume is somewhat slim, it is a book that should be read and digested slowly, and continually pondered. My understanding of SQL Server 2005 has been transformed from having read this book; read it and let it transform yours as well!
10 people found this helpful
Helpful
 Report