Programming Books C Java PHP Python Learn more Browse Programming Books
Buy New
  • List Price: $49.99
  • Save: $12.30 (25%)
In Stock.
Ships from and sold by
Gift-wrap available.
Add to Cart
Want it Thursday, April 17? Order within and choose One-Day Shipping at checkout. Details
Trade in your item
Get a $17.00
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Pro SQL Server 2012 Practices Paperback

ISBN-13: 978-1430247708 ISBN-10: 1430247703 Edition: 1st

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from Collectible from
"Please retry"
"Please retry"
$34.67 $37.66


Frequently Bought Together

Pro SQL Server 2012 Practices + Professional SQL Server 2012 Internals and Troubleshooting + SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server)
Price for all three: $134.42

Buy the selected items together


Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 504 pages
  • Publisher: Apress; 1 edition (October 31, 2012)
  • Language: English
  • ISBN-10: 1430247703
  • ISBN-13: 978-1430247708
  • Product Dimensions: 9.2 x 7.5 x 1 inches
  • Shipping Weight: 1.8 pounds (View shipping rates and policies)
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Best Sellers Rank: #919,513 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Chris Shaw started his database career in 1993. He began by working with Lotus during his time in the Marine Corps. Following his time with the Marines, Chris continued working with databases for companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. He later consulted with insurance companies, including Anthem Blue Shield and Admini Quest. Chris has been writing and speaking about SQL Server for over 15 years at events such as SQL Connections, PASS, and SSWUG Ultimate conferences. Chris was the Conference Director for SSWUG in 2008. Chris received the Microsoft MVP award in 2009, 2010, and 2011, and he just received his fourth MVP award in April 2012. He is the founding member of the Colorado Springs SQL Server User Group and presently is the Co-President. Chris has many featured articles on the SSWUG website, and he was a contributing author for SQL Server 2005 Bible (Wiley, 2006) and SQL Server MVP Deep Dives, Volume 2 (Manning Publications, 2011). Blogs, information, questions, quizzes, and interviews can be found at Chris� blog site at He can also be reached on twitter at @SQLShaw or by email at

Grant Fritchey works as a development database administrator for FM Global, an industry-leading engineering and insurance company. In his previous time as a�database administrator�and developer, he has worked at three failed dot-coms, a major consulting company, and a global bank. He has developed large-scale applications in languages such as VB, C#, and Java and has lived with SQL Server from the hoary days of 6.0, right through to 2008. His nickname at work is "The Scary DBA." He even has an official name plate, and he displays it proudly.

Grant volunteers for the Professional Association of SQL Server Users (PASS) and has written and published articles on various topics relating to SQL Server at Simple-Talk, SQL Server Central, SQL Server Performance, the PASS web site, SQL Standard, and the SQL Server Worldwide Users Group. He is the author of the book Dissecting SQL Server Execution Plans. He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG).

Outside work, Grant kayaks, learns and teaches self-defense, brews his own beer, chops wood to heat his house, raises his kids, and helps lead a pack of Cub Scouts.

Carlos Bossy (MCTS SQL Server 2008 BI, CBIP, Data Mining Certified) is a Business Intelligence Consultant with 25 years of experience in software and database development. Carlos is Principal Consultant for his own company Quanta Intelligence. He focuses on developing BI solutions including data warehouses, predictive models, data integration, and reporting.� He has worked with SQL Server for more than 12 years, is a frequent speaker at regional and national events, and is very enthusiastic about SQL Server and the future of Business Intelligence. Carlos has developed warehouses and BI solutions for a variety of industries and state agencies. He�s worked in the domains of consumer goods, human services, solar energy, telecommunications, and health insurance.

Jeremy Lowell is the founder of Data Realized and has been helping DBA�s and clients with SQL Server for over a decade. �Jeremy has a track record of solving complex issues for small and large enterprises at any point in the lifecycle of a business.� From start-ups to Fortune 100 enterprises, Jeremy has been a leader in implementing best practices, and helping business leaders realize their data.

Gail Shaw is a senior consultant with Xpertease and is based in Johannesburg, South Africa. She specializes in database performance tuning and database recovery, with a particular focus on topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail is a Microsoft Certified Master for SQL Server 2008 and a SQL Server MVP. She is a frequent poster on the SQL Server Central forum, writes articles for both and, and blogs on all things relating to database performance on her blog at She has spoken at TechEd Africa, the 24 Hours of PASS web event and, on multiple occasions, at the PASS Community summit.

Jesper Johansen is a SQL Server DBA with two decade�s experience. He is well-known in Danish circles, and is a member of the Danish consulting company Miracle A/S. At Miracle A/S he has worked to developed efficient techniques for consolidating SQL Server installations, thus saving customers time, money, and energy. Jesper also enjoys the challenge of backup and recovery, and especially relishes being able to help a client recover data presumed to have been lost forever. Jesper is a board member of the Danish SQL Server User Group.

Mladen Prajdi? is a SQL Server MVP from Slovenia and a developer for over 10 years. Optimizing SQL statements and finding unconventional solutions gives him great joy. He blogs at In his free time he develops a popular add-in for SQL Server Management Studio called the SSMS Tools Pack (

Wendy Pastrick is a SQL Server database administrator, and member of the Professional Association of SQL Server. She is a graduate of Central Missouri State University.

Kellyn Pot'Vin is an Oracle ACE Director and Sr. Technical Consultant at Enkitec, managing Oracle and SQL Server. She specializes in environment optimization tuning and creating systems that are robust and enterprise level. Kellyn works mostly on multi-TB size databases, including Exadata and databases with driven performance involving solid state disk solutions. Kellyn is deeply involved in the Oracle User Group Community,speaking at conferences around the world and is the director for the Rocky Mountain Training Days Conference, (RMOUG) one of the largest regional conferences. Kellyn blogs at https://dbakevlar.comand is engrossed in social media. She can be found on Twitter under the handle, @DBAKevlar, Linked in and Facebook,where she often discusses her daily technical adventures since she works from home and doesn't have any co-workers to tell them to. She also heads up local and global WIT, (Women in Technology) groups, mentoring fellow women in technical fields. Kellyn resides in Westminster, CO with her partner, Tim Gorman and her three children, Sam, Cait and Josh.

Jason Strate is a database architect and administrator with more than 15 years of experience. He has been a recipient of Microsoft's "Most Valuable Professional" designation for SQL Server since July 2009. His experience includes design and implementation of both OLTP and OLAP solutions, as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008.

Jason is actively involved with his local PASS chapter (SQL Server User Group) and serves as its director of program development. Jason worked with the board to organize the PASSMN SQL Summit 2009 for the local community. Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, Jason has presented at the SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and at PASSMN user group meetings.

Jason is a contributing author for the Microsoft whitepaper �Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition.� Jason is an active blogger with a focus on SQL Server and related technologies.

Herve Roggero, Windows Azure MVP, is founder of Blue Syntax Consulting, a company specialized in cloud computing products and services. Herve's experience includes software development, architecture, database administration, and senior management with both global corporations and startup companies. Herve holds multiple certifications, including an MCDBA, MCSE, and MCSD. He also holds a Master's degree in Business Administration from Indiana University. Herve is co-author of the Apress books PRO SQL Server 2012 Practices and Pro SQL Database for Windows Azure. For more information, visit

TJay Belt is a Professional Database Administrator and has been developing his expertise over the past 8 years. He has been working in IT for over 18 years. He enjoys delivering technical presentations, and has presented for Microsoft, Professional Association for SQL Server, SQL Server Worldwide User Group, PASS SQL Saturday events, and local SQL Server User groups. TJay has published technical articles for SQL Server Central, Simple Talk, and SQL-Server-Performance. He is the founder and was the leader of the PASS chapter SQL Server user group in Utah County. TJay has volunteered as a chapter leader for PASS, Regional Mentor for PASS chapters, PASS Chapter Committee. He was also the founder of the Auditing & Compliance Special Interest Group with PASS. TJay currently volunteers as a Regional Mentor for PASS chapters.�

Jonathan Gardner is a Senior Systems Architect, PMP, and MCITP working with Geocent, L.L.C. in New Orleans, LA. He has over 10 years of experience with a wide range of IT solutions including Database Administration, Virtualization, SAN Administration, and Windows Server environments.� He writes from his website

Glenn Berry is a Principal Consultant with SQLskills. He has worked as a SQL Server professional for many years in a variety of roles, most recently as Database Architect for Avalara in Parker, CO. Glenn has been a SQL Server MVP since 2007. He has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which all prove that he likes to take tests. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College.

Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for the two books SQL Server MVP Deep Dives and SQL Server MVP Deep Dives, Volume 2

Bradley Ball is a MCITP SQL 2005 & MCTS 2008 DBA with over 10 years of IT experience.  Bradley spent eight years working as a defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States.  He is currently a Sr. Consultant with Pragmatic Works specializing in DBA and BI solutions.  He has presented at many SQL Saturdays, for the MAGICPASS & OPASS SSUG�s, for SQL Rally 2011 & 2012, for DevConnections 2012, and at the PASS Summit in 2012 & 2011. Bradley can be found blogging on

Jes Borland is a Consultant with Brent Ozar PLF, and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree, and loves SQL Server Reporting Services and day-to-day administration. She is an active member of PASS, a user group founder, a Tech on Tap brewmaster, and a blogger. She's a frequent presenter at user groups, SQL Saturdays, and other community events. She is also an avid runner and novice chef.�

Ben DeBow is a consultant who works with customers of all sizes on their mission critical applications and SQL Server deployments. His versatility allows him to assist with everything from virtualization and consolidation to schema design. He is involved in performance tuning, disk architectures, and everything in between. He has tuned and deployed some of the largest and most complex SQL Server solutions in the world. An active member of the SQL Server community, Ben is also an MCDBA, MCSE, and MCITP. He is also the co-founder of SQLHA with Allan Hirt, and can be reached at

Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor�s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics.�Louis is the data architect for Compass Technology ( in Chesapeake, Virginia, leading database development on their suite of nonprofit�oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.

Customer Reviews

5.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Most Helpful Customer Reviews

3 of 3 people found the following review helpful By Mr. Ian W. Stirk on April 3, 2013
Format: Paperback

I have written a chapter-by-chapter review of this book on [...]. the first part of this review follows:

It is practically impossible to write a book that covers everything in SQL Server 2012. However, if you ask a group of SQL Server experts to write on topics that interest them, you'll end up with a book full of enthusiasm and detail - this is such a book...

I expected the book to be mostly innovative, but it is probably 60% new material and 40% rehash of material available elsewhere.

The chapters fall into three categories, either innovative, an overview of a given area, or a very detailed investigation of a small topic. Often the book is not specifically about 2012 features, but practices that can be applied to many versions of SQL Server. Many of the authors suggest ways of working, without mandating it, however they do provide persuasive arguments to back up their approaches.

Owing to the disparate nature of the contents, I'll discuss each chapter in turn. I've given each chapter a rating since it is really like having several types of books within a book. All the chapters are worth reading, but I suspect some of the ratings may reflect my personal interests/bias.

In many ways, this book is a bit like Manning Press's SQL Server MVP Deep Dive books (see side panel and Kay Ewbank's review), which is no bad thing since SQL Server has so many diverse areas of interest.

More infor here[...]
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Product Images from Customers