How we did it:
For any feedback, any questions, any notes or just for chat - feel free to follow us on social networks
Sajal Dam, Grant Fritchey
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter’s domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day–to–day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area. Emphasizes the practical. Does not bury readers in theory. Gives readers practical techniques to immediately apply in their daily work. Dedicates a chapter to each of the most common, performance–related problem areas. What you’ll learn Identify and fix poorly performing queries that are hurting your business. Read query execution plans and identify bottlenecks in performance. Record system performance metrics for trend analysis. Learn to design databases and write Transact–SQL code to avoid common problems. Understand what an index is, what it does, and how to build one. Use industry accepted best practices and understand how to develop your own to arrive at optimal database performance. Who this book is for SQL Server Query Performance Tuning Distilled is aimed at anyone writing business–critical Transact–SQL queries, and also at those responsible for the continued good performance of those queries. Developers, database administrators, business intelligence analysts, and any others who develop Transact–SQL queries will find this book an indispensable resource for getting the most out of what SQL Server 2008 has to offer.
Kenn Scribner, Scott Seely
The first complete, cutting-edge guide to building REST-based services with Microsoft's .NET Framework • • Shows .NET developers why REST is so exciting, how it works, and how both client and server-based code can access data using REST services. • Covers leading-edge technologies and approaches, including Astoria, REST on WCF, Silverlight 2.0, and ASP.NET MVC • 100% practical: focused on building REST capability into real applications, and leveraging REST's benefits quickly and painlessly. Developers are discovering REST's immense potential to simplify the development of sophisticated web services and applications that incorporate externally-sourced data. There is little information on using REST with the .NET platform. In Effective REST Services via .NET, .NET experts Kenn Scribner and Scott Seely show exactly how to use the .NET Framework's core building blocks to consume and serve RESTful services. Scribner and Seely first explain why REST services offer so much value to the developers of today's web services and Web 2.0 applications. Next, using realistic examples, they demonstrate how REST services work, and how REST services can best be used in both desktop-based and Web-based applications. Scribner and Seely conclude by introducing Microsoft's revolutionary cloud computing initiative, and showing how to access data from the computational cloud via Microsoft's new 'Service Bus.' This book covers cutting-edge technology, but from start to finish it's 100% practical - focused on solving real problems with working tools.
John Shaw, Gary Evans
Pro ADO.NET Data Services: Working with RESTful Data is aimed at developers interested in taking advantage of the REST–style data services that ADO.NET Data Services (formerly code–named Astoria) provides. The book shows how to incorporate ADO.NET Data Services into a wide range of common environments, including BizTalk, Ajax and Silverlight client applications. The material is intended for professional developers who are comfortable with the .NET 3.5 Framework but are coming to ADO.NET Data Services for the first time and want to understand how to integrate it into their own applications and enterprise solutions. The book is packed full with extensive real–world solutions and exercises, ensuring you walk away with a deep understanding of how to use ADO.NET Data Services to your best advantage.