Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach (Books for Professionals by Professionals) Paperback – July 25, 2008
Customers who bought this item also bought
About the Author
Joseph Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail, and the real estate industry. Prior to joining SQLskills, he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting, and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development, and high-availability. In 2006 Joe earned the Microsoft Certified Master: SQL Server 2005 certification; and in 2008, he earned the Microsoft Certified Master: SQL Server 2008 certification. In 2009 he took over responsibility for the SQL Server Microsoft Certified Master program and held that post until 2011. He is the author of a few books and white papers, including most recently, SQL Server 2008 Transact-SQL Recipes (Apress, 2008). Joe's blog is at www.SQLskills.com/blogs/joe, and he can be reached at joe@SQLskills.com.
Top customer reviews
If I had to ask for more, I would have asked for more detail on the system functions (he names many, perhaps all, but only gives detail and "recipes" on the most commonly used), I occasionally have to turn to Google to find how to actually use the function he suggests.
If you don't know anything about SQL, then this is not the book for you. This is not a tutorial. This is not the kind of book you sit down and read, as much as you would learn from doing so. Instead, this is a reference...and a really good one at that.
The chapters break down into broad concepts like Select or Indexes or Linked Servers. These concepts are then broken down into the component parts so that, for example, in the Backup chapter, you get broad sub-topics on Creating a Backup and Recovery Plan, Making Backups and Restoring a Database. These are then broken down even further into specifics such as Viewing Database Space Usage. These specific topics then show the syntax, similar to Books Online, but laid out a little differently with immediate explanation of the parameters followed by the true strength of the book, examples. He finally sums up the section with a "How It Works" description.
This is not a "learn how to use SQL Server" book. It is exactly what it says, a set of recipes that will help you work with T-SQL. Actually, when you look at all the examples in the book, that's where you're getting your money's worth and then some. These are good examples, original and well thought out. It shows how to use the code, and, more importantly, how to use it right.
I'd recommend this to DBA's for sure, but I think it's a must for developers too. Here's a handy resource to help you get better T-SQL code the first time.
The book deals with topics that are evenly dispersed over the whole T-SQL area giving even a novice a simple and clear explanation of every major functionality.
This is not a book for an expert to learn SQL Server 2008 specifics because experts usually work with the whole database which includes Integration, Reporting and Analysis Services which this book knows nothing about but where also substantial changes occurred with SQL Server 2008.
The book is written very well and is easily readable and so even if you are an expert SQL Server user and have a long flight to take, this book will give you a good reading experience as you will certainly find several chapters that refresh your memory and enhance it by SQL Server 2008 flavor.
Another good think I like about this book is the Chapter 14 which explains how to use XML in Database like Creating, Validating and Indexing XML data. the explanation is so simple and clear. In later chapters, the details on Error handling and service brokers are good but not very detailed. But there is good enough information to understand what they are and how they work.
At the end there are some good information for a DB developer might need to know such as Linked servers, Mirroring, little performance tuning and snapshot and full backup and recovery. Overall, I really enjoyed reading this book. not just enjoyed, I learned a lot from this book. Thanks to the author. I would recommend this book to all my friends and DB learners. 5 star...