SQL Server 2005 T SQL Recipes A Problem Solution Approach A Problem Solution Approach
Posted by aspnetnerd on 21 Nov 2008 at 08:14 am | Tagged as: Book
SQL Server 2005 T SQL Recipes A Problem Solution Approach A Problem Solution Approach
If you are looking for a succinct, easy to use, and up-to-date reference guide for SQL Server 2005 and T-SQL, I highly recommend SQL Server 2005 T-SQL Recipes.
— David Hayden, .NET Developer
Each chapter is completely autonomous, so you can just look up the syntax you need at the time without having to rely on knowledge from previous chapters. Its really an excellent reference that deserves a place on your desk.
— Sean McCown, ITBookworm
Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQL�related features. SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach is an ideal book, whatever your level as a DBA or developer.
This �no-fluff� desk reference offers direct access to the information you need to get the job done. It covers basic T-SQL data manipulation, the use of stored procedures, triggers and UDFs, and advanced T-SQL techniques for database security and maintenance. It also provides hundreds of practical recipes that describe the utilities of features and functions, with a minimim of background theory.
Additionally, this book provides �how-to� answers to common SQL Server T-SQL questions, conceptual overviews, and highlights of new features introduced in SQL Server 2005. It also features concise T-SQL syntax examples, and you can use the book to prepare for a SQL Server-related job interview or certification test.
User Ratings and Reviews
5 Stars Extremely Useful How To Book on SQL Server 2005
This is the book that I consult most often, when there is something I want to accomplish quickly and easily. There is a lot of SQL Server 2005 specific content here, and most major aspects of SQL Server are covered at a decent depth. Very highly recommended.
3 Stars Good reference but not enough detail to be truly comprehensive
I think this book is a good addition to your bookshelf but I was hoping for a little more. The price is right and the breadth of topic coverage is fine. I just want more “recipes”; that is more examples showcasing each topic with variations on how to use different commands and techniques in my SQL code plus best practices for developing a SQL Server databases across an enterprise software system.
5 Stars Excellent learning aid for a SQL Server beginner
Great, convenient reference: I usually check it before turning to Google and MSDN, and so far have found it to be a sufficient, and far-easier-to-navigate, resource.
4 Stars Great T-SQL Cookbook
This is a great book to keep at arms length. It has many great examples of the T-SQL commands and syntax. I use it most oftern when I find myself asking the question, “How do you use that command?”. Subject matter is complete and includes the XML extensions to T-SQL.
5 Stars Excellent Practical Reference
Background: Professional developer with 20 years experience of application programming and embedded development who is recently learning SQL / SQL Server.
I was looking for a solution to a problem and found it in the online text included in this book. The solution saved me about 2 hours of research, so I went ahead and bought the book since it had already paid for itself.
It has since paid for itself many times over.
