Pro SQL Server 2012 Practices


Pro SQL Server 2012 Practicesis an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. With an emphasis upon performance—but also branching intorelease management,auditing,and other issues—the book helps you deliver the most value for your company’s investment in Microsoft’s flagship database system

  • Goes ...
See more details below
$38.60 price
(Save 22%)$49.99 List Price
Other sellers (Paperback)
  • All (14) from $40.32   
  • New (11) from $40.32   
  • Used (3) from $41.71   
Sending request ...


Pro SQL Server 2012 Practicesis an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. With an emphasis upon performance—but also branching intorelease management,auditing,and other issues—the book helps you deliver the most value for your company’s investment in Microsoft’s flagship database system

  • Goes beyond the manual to cover good techniques and best practices
  • Delivers knowledge usually gained only by hard experience
  • Focuses upon performance, scalability, reliability
  • Helps achieve the predictability needed to be in control at all times

What you’ll learn

  • Migrate to the new Extended Events framework for troubleshooting performance problems
  • Automate the tracking of key performance indicators such as available disk space, cpu utilization, index fragmentation, and more
  • Design performance into your database and its applications from the very beginning
  • Manage staged releases from development to test through to production
  • Diagnose resource and performance problems via dynamic management views
  • Analyze I/O patterns and plan reliably to obtain the performance you need

Who this book is for

Pro SQL Server 2012 Practices is aimed at SQL Server professionals who want to further their careers through expert-level practices in performance management, scalability, predictability, and security.

Table of Contents

  1. Jesper Johansen. Be Your Developer’s Best Friend
  2. Louis Davidson. Getting It Right: Designing for Database Performance
  3. Gail Shaw. Hidden Performance Gotchas
  4. Kellyn Pot’vin. Dynamic Management Views
  5. Mladen Prajdic. From SQL Trace to Extended Events
  6. Chris Shaw. The Utility Database
  7. Jason Strate. Indexing Outside the Bubble
  8. TJay Belt. Release Management
  9. Jonathan Gardner. Compliance and Auditing
  10. Jes Borland. Automating Administration
  11. Wendy Pastrick. The Fluid Dynamics of SQL Server Data Movement
  12. Herve Roggero. Windows Azure Features for DBAs
  13. Jeremy Lowell. I/O: The Untold Story
  14. Bradley Ball. Page and Row Compression
  15. Glenn Berry. Selecting and Sizing the Server
  16. Grant Fritchey. Backups and Restores Using Availability Groups
  17. Carlos Bossy. Big Data for the SQL Server DBA
  18. Ben DeBow. Tuning for Peak Load
Read More Show Less

Product Details

  • ISBN-13: 9781430247708
  • Publisher: Apress
  • Publication date: 10/31/2012
  • Edition number: 1
  • Pages: 504
  • Product dimensions: 7.60 (w) x 9.40 (h) x 1.30 (d)

Meet 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.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)