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-SQLrelated features. SQL Server 2005 T-SQL Receipes: 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.
One of the best SQL books out there!August 12, 2008 Book worm(Australia) 1 out of 2 found this review helpful
This book packs a lot of information, from beginning to advanced topics. I learned a lot from this book esp. when I was pressed for time trying to fix things and do some scripts for the department I work for. I would definitely recommend this book to learn SQL scripting and other things related to database and table design.
Excellent learning aid for a SQL Server beginnerJuly 2, 2008 Dimitri Shvorob(London, UK) 1 out of 2 found this review helpful
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.
Excellent Practical ReferenceApril 28, 2008 Kent Harris 2 out of 3 found this review helpful
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.
Great T-SQL CookbookFebruary 10, 2008 Daniel C. Kline(West Bend, WI) 2 out of 3 found this review helpful
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.
Good reference but not enough detail to be truly comprehensiveDecember 13, 2007 Scott's on Vacation(San Francisco, CA USA) 3 out of 9 found this review helpful
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.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
