Previous Section Table of Contents Next Section


We'd like to take a moment to thank a few special individuals at O'Reilly Media. First, we owe a huge debt of gratitude to Jonathan Gennick, the editor of the second edition. Jonathan kept us on track and on task, even when the cares of this world threatened to derail the project. Jonathan's attention to detail and exceptional management skills, in addition to his talents as an editor, are the reason this book is here today. Thank you! And of course, thanks to Tim O'Reilly for having a direct hand in the birth of this book.

We also owe a debt to our fine technical reviewers. To Peter Gulutzan (SQL Standard), Thomas Lockhart (PostgreSQL), Alan Beaulieu (Oracle), Baya Pavliachvili (Microsoft SQL Server), Bobby Fielding (DB2), Doug Doole (DB2), Rick Swagerman (DB2), Josh Stellan (DB2), Brian Lalonde (Database Programming), John Haydu (Oracle, Phani Arega (Oracle), and Paul DuBois (MySQL): we owe you a hearty thanks! Your contributions have greatly improved the accuracy, readability, and value of this book. Without you, our sections on each of the language extensions would have been on shaky ground. In addition, we'd like to tip our hat to Peter Gulutzan and Trudy Pelzer for their book SQL-99 Complete, Really!, which assisted our understanding of the ANSI SQL2003 standards.

Brand Hunt's Acknowledgments

To my wife Michelle, without your continued support and love, I wouldn't be a part of this project. I'm appreciative for every moment we've shared and your forgiveness for my keeping you awake at night with the "tappity-tap-taps" emanating from the computer.

To my parents Rex and Jackie, the two biggest influences in everything I've ever done correctly - especially those things that frequently take multiple attempts (like writing!)

A huge thanks to my teammates Kevin, Daniel, and Jonathan for letting me participate in this project and exercising so much patience tutoring a first time O'Reilly author. Your professionalism, work ethic, and ability to make the most tedious tasks fun is so admirable I plan to steal it and adopt it as my own!

Mad props to my friends and colleagues at Rogue Wave Software, ProWorks, NewCode Technology, and Systems Research and Development, for providing the ultimate sand box for refining skills in SQL, databases, business, software development, writing, and friendship: Gus Waters, Greg Koerper, Marc Manley, Wendi Minne, Erin Foley, Elaine Cull, Randall Robinson, Dave Ritter, Edin Zulic, David Noor, Jim Shur, Chris Mosbrucker, Dan Robin, Mike Faux, Jason Prothero, Tim Romanowski, Andy Mosbrucker, Jeff Jonas, Jeff Butcher, Charlie Barbour, Steve Dunham, Brian Macy, and Ze'ev Mehler.

Daniel Kline's Acknowledgments

I'd like to thank my brother, Kevin, for his continued willingness to work with me, to my colleagues at the University of Alaska Anchorage for their suggestions, and to the readers and users of the first edition of SQL in a Nutshell for their honest feedback and useful critiques. I'd also like to thank the Japanese translators of the first edition-Ryoko Akaike, O'Reilly Japan editor; Ishii Tatsuo, open source manager of Software Research Associates, Inc. and author of PostgresSQL Perfect Guide; and Toru Miyahara, CEO of BigiNet Co., Ltd.-for their careful review and helpful suggestions.

Kevin E. Kline's Acknowledgments

Many people helped deliver the big, thick book you hold in your hands. This note expresses our appreciation to those who helped make this a book reality.

First of all, Dan and Brand get a big slap on the back for working so hard to create the content you are now reading. Brand had to spend a lot of nights working on this both before and after his wedding. Thank you, Michelle, for lending us Brand when you wanted him the most.

Next, Jonathan Gennick, our editor at O'Reilly Media, gets a warm handshake and squeeze on the shoulder. You travailed through many extra months of hard labor bringing this book out of the shadows and into the light. I think there's a special blessing in store for those who've carried themselves with as much patience, professionalism, and good humor as you.

We must also express deep thanks and appreciation to our technical reviewers who caught many errors, omissions, and plain ol' mistakes and diverted us from many embarrassments:

  • ANSI SQL - Peter Gulutzan, author of SQL-99 Complete, Really and SQL Performance Tuning

  • DB2 - Doug Doole, Bobby Fielding, and Richard Swagerman of IBM; Josh Steffan of Quest Software

  • MySQL - Paul DuBois, author of MySQL

  • Oracle - Phani Arega of Quest Software and the reviewers at Oracle

  • PostgreSQL - Thomas Lockhart, original author of the PostgreSQL open source documentation

  • SQL Server - Baya Pavliashvili of Healthstream, Inc.

  • Database Programming - Brian LaLonde

To all of my colleagues at Quest Software go a very big thanks for your support and encouragement. Rony Lerner, Deb Jenson, Eyal Aronoff, John Newsom, and Vinny Smith: thank you for investing your trust in me and making these last three years with Quest Software such a blast.

Thank you to all the guys on the SQL Server team for making our products the best on the market: John Theron, Patrick O'Keeffe, John Ortega, Mark Simon, Hasan Fahimi, Lee Grissom, Joe Motley, Adrian Tudor, Israel Kalush, Amit Kubovsky, and Ross Doering. I couldn't ask for a better team or a better set of friends.

Thanks to the SQL Server team at Microsoft for keeping me in the know: Euan Garden, Richard Waymire, Joe Yong, Don Peterson, Mark Sousa, Steven Dybing, Fernando Caro, Tom Rizzo, and Bill Baker. Your product rocks!

Finally, a word for my family. It's hard to work ridiculously long hours for months on end, between the day job and the book project, without making some sacrifices. And yet, somehow, we managed to spend so much good time together. Katie Jo, you've learned how to talk between the time I started and the time I finished. I still get choked up hearing you say "Yi yove you, daddy." Anna Lynn, your super powers rescued me plenty of times when I was down. I want to hear "Supergirl to da rescue!" the next time I need rescuing. Here's a secret: I keep that jar of fresh pistachios on my desk just because they're your favorite. Emily, thank you for letting me paint your nails. Some daughters don't let their dads that close. Dylan, you whipped me at so many games on the PS2 that I don't know why you still want me to play with you. But, one day, the ol' man is gonna take you down! Kelly, you are my tonic, my therapy, and my medicine. Just a touch or a glance or a smile from you and my night turns to day and my despair to hope. Thank you for loving me, supporting me, and seeing me through this project.

    Previous Section Table of Contents Next Section