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.
Customer Reviews
Average Rating:
Rating: - 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. He gives you just what you need and nothing else. I wish they were all like this.
By providing actual performance testing Adam Machanic doesn't just make expert claims for his methods. In fact, my favorite quote from the book: "The hallmark of a truly great developer, and what allows these qualities to shine through, is a ... Read More
Rating: - 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. Where many books follow a very rigid path through a subject, quite often in a very feature driven manner (Here is this command, and you can do this. Next, this command) or process driven manner (First we do this, then we do this...).
This book is very different from that. The title includes the word "Expert" for good reason. This is a book that doesn't assume you know ... Read More
Rating: - Great Book
This is really a great book. It covers specific topics really extensively and it is very easy to read. I was impressed because I was able to find great information about topics such as Encryption or Hierarchies that cannot be found very easily in other books. The examples are very descriptive but the most important thing is that the author will show you all possible solutions and will prove why the one he selected is the best. It is not a beginner's book but it is a fantastic book for advanced ... Read More
Rating: - 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. Encryption, access control, testing, basic software engineering and exception handling are never touched in SQL programming books -- including my own! The spatial chapters were new to me. The little asides were also worth looking up. Good clean style, great job.
Rating: - 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. The amount of detail presented is just right - detailed enough to understand the topics yet simple enough not to feel overwhelmed by the amount of information presented.
In the first chapter, the author reviews coupling, cohesion, encapsulation and database role in the application development cycle.
Chapter 2 is extremely useful for testing ... Read More
