posted on Wednesday, July 02, 2008 8:50 AM
by
joe.sack
SQL Server 2008 Transact-SQL Recipes
** Cross-posted on www.joesack.com **
My new book, "SQL Server 2008 Transact-SQL Recipes" is coming out in a few weeks (estimated publication at the end of July). As of July 1st, Amazon.com is selling it for $37.70. They don’t have a picture of the cover up yet, but it will have the standard bumble-bee color scheme Apress cover, so expect no surprises there. J
Although this was an update of my last book, it still took 9 months to write (plenty of weeknights and weekends holed up in my office). I updated existing content, and added content for both SQL Server 2008 and SQL Server 2005 SP2 additions.
Like my last book, I focus specifically on the Transact-SQL language. Even with the focus on T-SQL and not the GUI, the book wound up being greater than 800 pages. Also like the last book, I use a problem/solution format. The overall theme and mission statement for this book was:
"Look up what you need to do. Learn how to do it. Do it."
I'll have a downloadable detailed index link available after the publication date. That link will include the specific recipes for each chapter. In the meantime, here is a high level list of the chapters:
CHAPTER 1 SELECT
CHAPTER 2 Perform, Capture, and Track Data Modifications
CHAPTER 3 Transactions, Locking, Blocking, and Deadlocking
CHAPTER 4 Tables
CHAPTER 5 Indexes
CHAPTER 6 Full-Text Search
CHAPTER 7 Views
CHAPTER 8 SQL Server Functions
CHAPTER 9 Conditional Processing, Control-of-Flow, and Cursors
CHAPTER 10 Stored Procedures
CHAPTER 11 User-Defined Functions and Types
CHAPTER 12 Triggers
CHAPTER 13 CLR Integration
CHAPTER 14 XML, Hierarchies, and Spatial Data
CHAPTER 15 Hints
CHAPTER 16 Error Handling
CHAPTER 17 Principals
CHAPTER 18 Securables, Permissions, and Auditing
CHAPTER 19 Encryption
CHAPTER 20 Service Broker
CHAPTER 21 Configuring and Viewing SQL Server Options
CHAPTER 22 Creating and Configuring Databases
CHAPTER 23 Database Integrity and Optimization
CHAPTER 24 Maintaining Database Objects and Object Dependencies
CHAPTER 25 Database Mirroring
CHAPTER 26 Database Snapshots
CHAPTER 27 Linked Servers and Distributed Queries
CHAPTER 28 Query Performance Tuning
CHAPTER 29 Backup and Recovery
I enjoyed writing this book; but most importantly I hope you find it to be a useful, practical reference.