Pro SQL Server 2012 Practices by Bradley Ball, TJay Belt, Glenn Berry, Jes Borland |, Paperback | Barnes & Noble
Pro SQL Server 2012 Practices
  • Alternative view 1 of Pro SQL Server 2012 Practices
  • Alternative view 2 of Pro SQL Server 2012 Practices
  • Alternative view 3 of Pro SQL Server 2012 Practices
  • Alternative view 4 of Pro SQL Server 2012 Practices
<Previous >Next

Pro SQL Server 2012 Practices

by Bradley Ball, TJay Belt, Glenn Berry, Jes Borland
     
 

Pro SQL Server 2012 Practices is 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 into release management, auditing, and other issues—the book helps

Overview

Pro SQL Server 2012 Practices is 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 into release 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


Product Details

ISBN-13:
9781430247708
Publisher:
Apress
Publication date:
10/30/2012
Edition description:
2012
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 http://chrisshaw.wordpress.com. He can also be reached on twitter at @SQLShaw or by email at Chris@sqlshaw.com.

pstrongGrant Fritchey/strong 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. /p pGrant 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 emDissecting SQL Server Execution Plans/em. He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG)./p pOutside 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./p

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 SQLServerCentral.com and Simple-Talk.com, and blogs on all things relating to database performance on her blog at http://sqlinthewild.co.za. 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 http://weblogs.sqlteam.com/mladenp. In his free time he develops a popular add-in for SQL Server Management Studio called the SSMS Tools Pack (http://www.ssmstoolspack.com/).

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 a Consulting Member of Oracle’s Strategic Customer Program Team who is focused on Enterprise Manager. She offers expertise and support to customers on implementation of special projects involving Enterprise Manager and Ops Center products. She also provides valued direction within Oracle Corporation on the future development of Enterprise Manager. Kellyn is a talented and accomplished database administrator. She is a member of the Oak Table Network, an Oracle ACE Director, serves on the board of the Rocky Mountain Oracle User Group (RMOUG), was Director of RMOUG Training Days 2014, leads the database track for the Oracle Developer Tools User Group’s KSCOPE 2014 event, and speaks widely at industry events on topics relevant to database administration and Oracle technologies.

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 www.bluesyntax.net.

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 jonathanagardner.com

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 http://www.sqlballs.com.

Jes Borland is a Consultant with Brent Ozar Unlimited and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree, is a Microsoft Certified Professional in SQL Server 2012, and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is user group president, Tech on Tap founder, and a LessThanDot.com blogger. She frequently presents at user groups, SQL Saturdays, and other community events. She is also an avid runner and 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 http://www.sqlha.com.

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 (Compass.net) 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

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >