Expert SQL Server 2005 Development and over 360,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

 

or
Sign in to turn on 1-Click ordering.
 
 
Express Checkout with PayPhrase
What's this? | Create PayPhrase
Sorry!
More Buying Choices
37 used & new from $18.99

Have one to sell? Sell yours here
 
   
Expert SQL Server 2005 Development
 
 
Start reading Expert SQL Server 2005 Development on your Kindle in under a minute.

Don’t have a Kindle? Get your Kindle here.
 
  

Expert SQL Server 2005 Development (Paperback)

~ (Author), (Author), Lara Rubbelke (Author)
Key Phrases: employee temp, parameter query, adjacency list hierarchies, Service Broker, Total Exceptions, Number of Threads Actual Seconds (more...)
4.9 out of 5 stars  See all reviews (11 customer reviews)

List Price: $49.99
Price: $40.45 & this item ships for FREE with Super Saver Shipping. Details
You Save: $9.54 (19%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Wednesday, November 11? Choose One-Day Shipping at checkout. Details
26 new from $26.59 11 used from $18.99

Formats

Amazon Price New from Used from
  Kindle Edition $32.36 -- --
  Paperback $40.45 $26.59 $18.99

Frequently Bought Together

Expert SQL Server 2005 Development + Pro SQL Server 2005 Database Design and Optimization + Pro T-SQL 2005 Programmer's Guide (Expert's Voice)
Price For All Three: $125.93

Show availability and shipping details

  • This item: Expert SQL Server 2005 Development by Adam Machanic

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Pro SQL Server 2005 Database Design and Optimization by Louis Davidson

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Pro T-SQL 2005 Programmer's Guide (Expert's Voice) by Michael Coles

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

Pro T-SQL 2005 Programmer's Guide (Expert's Voice)

Pro T-SQL 2005 Programmer's Guide (Expert's Voice)

by Michael Coles
4.8 out of 5 stars (6)  $31.49
Microsoft SQL Server 2005 Unleashed

Microsoft SQL Server 2005 Unleashed

by Ray Rankins
4.4 out of 5 stars (20)  $40.94
Beginning SQL Server 2005 Programming (Programmer to Programmer)

Beginning SQL Server 2005 Programming (Programmer to Programmer)

by Robert Vieira
4.2 out of 5 stars (24)  $26.39
Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer)

Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer)

by Itzik Ben-gan
4.7 out of 5 stars (12)  $31.49
Expert SQL Server 2005 Integration Services (Programmer to Programmer)

Expert SQL Server 2005 Integration Services (Programmer to Programmer)

by Brian Knight
4.3 out of 5 stars (14)  $31.49
Explore similar items

Editorial Reviews

Product Description

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.



About the Author

ADAM MACHANIC is an independent database software consultant, writer, and speaker based in Boston, Massachusetts. He has implemented SQL Server solutions for a variety of high-availability OLTP 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.



HUGO KORNELIS has a strong interest in information analysis and process analysis. He is convinced that many errors in the process of producing software can be avoided by using better procedures during the analysis phase, and deploying code generators to avoid errors in the process of translating the analysis results to databases and programs. Hugo is cofounder of the Dutch software company perFact BV, where he is responsible for improving analysis methods and writing a code generator to generate complete working SQL Server code from the analysis results.

When not working, Hugo enjoys spending time with his wife, two children, and four cats. He also enjoys helping out people in SQL Server&emdash;related newsgroups, speaking at conferences, or playing the occasional game. In recognition of his efforts in the SQL Server community, Hugo was given the Most Valuable Professional (MVP) award by Microsoft in January 2006 and January 2007. He is also a Microsoft Certified Professional.



LARA RUBBELKE is a service line leader with Digineer in Minneapolis, Minnesota, where she consults on architecting, implementing, and improving SQL Server solutions. Her expertise involves both OLTP and OLAP systems, ETL, and the Business Intelligence lifecycle. She is an active leader of the local PASS chapter and brings her passion for SQL Server to the community through technical presentations at local, regional, and national conferences and user groups. Lara's two beautiful and active boys, Jack and Tom, and incredibly understanding husband, Bill, are a constant source of joy and inspiration.


Product Details

  • Paperback: 472 pages
  • Publisher: Apress; 1 edition (May 21, 2007)
  • Language: English
  • ISBN-10: 159059729X
  • ISBN-13: 978-1590597293
  • Product Dimensions: 9.1 x 6.9 x 1 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.9 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon.com Sales Rank: #330,999 in Books (See Bestsellers in Books)

More About the Authors

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

Inside This Book (learn more)

What Do Customers Ultimately Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(3)

Your tags: Add your first tag
 

 

Customer Reviews

11 Reviews
5 star:
 (10)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.9 out of 5 stars (11 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
17 of 18 people found the following review helpful:
5.0 out of 5 stars Off the beaten path - getting serious about SQL Server architecture and design solutions, June 8, 2007
By Joseph I. Sack (Minneapolis, MN USA) - See all my reviews
(REAL NAME)   
Although this book has "expert" in the title, I think readers of all skill levels will benefit from it. It earns the title by talking about the art and science of database design and architecture and by covering the intricacies of various topics. The first few chapters are worth the price of admission alone. Most SQL Server professionals have varying degrees of application design experience, and Adam does an excellent job describing concepts like coupling, cohesion, encapsulation, object-oriented systems, unit testing, and functional testing. Adam espouses the virtue of treating the database as software - which of course it is. Too often is SQL Server treated like a toy or side effect in the development cycle, but then is expected to perform under enterprise class conditions.

By chapter 3, we start moving into SQL Server functional areas. SQL Server books usually fall into two areas - references and narratives. Adam mixes both narrative and reference quite well, detailing real life methods for handling errors and exceptions, understanding proxies, ownership chaining, and encryption methodologies. In the Encryption chapter, be sure to check out the "Securing Data from the DBA" and "Searching Encrypted Data" sections - both very timely topics given the data breach issues with retail companies lately.

This book doesn't tread down the beaten path. Other advanced topics detail SQL CLR architecture and design considerations, SQL CLR security and reliability, dynamic T-SQL versus Ad Hoc, SQL injection, application concurrency considerations, geospatial data by latitude and longitude, working with time zones, and querying hierarchies. The later chapters have the quality of stand-alone white papers. Recommended for SQL Server professionals and architects alike.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
15 of 17 people found the following review helpful:
5.0 out of 5 stars Review of Expert SQL Server 2005 Development , June 14, 2007
By Denis Gobo "SQL Menace" (Princeton, NJ USA) - See all my reviews
(REAL NAME)   
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
11 of 13 people found the following review helpful:
5.0 out of 5 stars A truly remarkable book, July 18, 2007
By Hilary Cotter (Englishtown, NJ, USA) - See all my reviews
(REAL NAME)   
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!
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Hard to find a book like this
Typically I have come to expect that technical books for Microsoft topics will inevitably revert to at least partial regurgitations of the material already available on Books... Read more
Published 6 months ago by Stephen P. Hood

4.0 out of 5 stars Provides golden nuggets to T-SQL development
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... Read more
Published 9 months ago by Jaewoo Kim

5.0 out of 5 stars Did you ever think you wouldn't really learn anything new from yet another SQL Server book?
The author imparts a wealth of knowledge on the reader in a mere 445 pages. His style is direct, clear and doesn't waste any pages on trying to get you up to speed. Read more
Published 22 months ago by T. Schroeder

5.0 out of 5 stars Definitely different...great different...but different
I have read (well, ok, read through or I would post more reviews) quite a few technical books about SQL Server. Read more
Published on October 16, 2007 by Louis B. Davidson

5.0 out of 5 stars Great Book
This is really a great book. It covers specific topics really extensively and it is very easy to read. Read more
Published on August 23, 2007 by SPYRIDON PRANTALOS

5.0 out of 5 stars Stuff I did not know
Frankly, I was expecting a very SQL Server 2005 specific book. Instead, what we have is a good general RDBMS book that happens to be using SQL Server 2005. Read more
Published on August 20, 2007 by Joe Celko

5.0 out of 5 stars Well written and practical book on SQL Server 2005.
The book presents real-life SQL Server problems and shows you how to solve them. It is written in a friendly and story-like fashion. Read more
Published on August 12, 2007 by AT

5.0 out of 5 stars Required Reading
Adam Mechanic has the rare ability to convey a vast store of knowledge in an organized and easily understood manner. Read more
Published on July 29, 2007 by Jesse Liberty

Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
Hello from the author! 0 May 2007
See all discussions...  
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Discussion Replies Latest Post
Textbooks for Kindle DX? 61 1 day ago
textbook scam 66 6 days ago
Amazon is a great place to buy textbooks! 35 18 days ago
Search Customer Discussions
   




Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Look for Similar Items by Subject

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.