Skip to main content
SpringerLink
Log in
Book cover
  • Book
  • © 2012

Pro SQL Server 2012 Practices

Apress

Authors:

  1. Bradley Ball
    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. TJay Belt
    View author publications

    You can also search for this author in PubMed   Google Scholar

  3. Glenn Berry
    View author publications

    You can also search for this author in PubMed   Google Scholar

  4. Jes Borland
    View author publications

    You can also search for this author in PubMed   Google Scholar

  5. Carlos Bossy
    View author publications

    You can also search for this author in PubMed   Google Scholar

  6. Louis Davidson
    View author publications

    You can also search for this author in PubMed   Google Scholar

  7. Ben DeBow
    View author publications

    You can also search for this author in PubMed   Google Scholar

  8. Grant Fritchey
    View author publications

    You can also search for this author in PubMed   Google Scholar

  9. Jonathan Gardner
    View author publications

    You can also search for this author in PubMed   Google Scholar

  10. Jesper Johansen
    View author publications

    You can also search for this author in PubMed   Google Scholar

  11. Jeremy Lowell
    View author publications

    You can also search for this author in PubMed   Google Scholar

  12. Wendy Pastrick
    View author publications

    You can also search for this author in PubMed   Google Scholar

  13. Kellyn Pot’vin
    View author publications

    You can also search for this author in PubMed   Google Scholar

  14. Mladen Prajdić
    View author publications

    You can also search for this author in PubMed   Google Scholar

  15. Herve Roggero
    View author publications

    You can also search for this author in PubMed   Google Scholar

  16. Chris Shaw
    View author publications

    You can also search for this author in PubMed   Google Scholar

  17. Gail Shaw
    View author publications

    You can also search for this author in PubMed   Google Scholar

  18. Jason Strate
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Pro SQL Server 2012

  • Practices is an anthology of high-end wisdom from a group of accomplished database administrators and developers who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012.

  • 17k Accesses

Sections

Buy it now

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (18 chapters)

  1. Front Matter

    Pages i-xxiv
    PDF

  2. Be Your Developer’s Best Friend

    • Jesper Johansen
    Pages 1-15

  4. Hidden Performance Gotchas

    • Gail Shaw
    Pages 43-70

  5. Dynamic Management Views

    • Kellyn Pot’vin
    Pages 71-99

  6. From SQL Trace to Extended Events

    • Mladen Prajdić
    Pages 101-133

  7. The Utility Database

    • Chris Shaw
    Pages 135-160

  8. Indexing Outside the Bubble

    • Jason Strate
    Pages 161-195

  9. Release Management

    • TJay Belt
    Pages 197-219

  10. Compliance and Auditing

    • Jonathan Gardner
    Pages 221-234

  11. Automating Administration

    • Jes Borland
    Pages 235-270

  12. The Fluid Dynamics of SQL Server Data Movement

    • Wendy Pastrick
    Pages 271-292

  13. Windows Azure SQL Database for DBAs

    • Herve Roggero
    Pages 293-312

  14. I/O: The Untold Story

    • Jeremy Lowell
    Pages 313-334

  15. Page and Row Compression

    • Bradley Ball
    Pages 335-359

  16. Selecting and Sizing the Server

    • Glenn Berry
    Pages 361-373

  17. Backups and Restores Using Availability Groups

    • Grant Fritchey
    Pages 375-393

  18. Big Data for the SQL Server DBA

    • Carlos Bossy
    Pages 395-428

  19. Tuning for Peak Load

    • Ben DeBow
    Pages 429-463

  20. Back Matter

    Pages 465-477
    PDF
Back to top

About this book

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

Back to top

About the authors

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.
Back to top

Bibliographic Information

  • Book Title: Pro SQL Server 2012 Practices

  • Authors: Bradley Ball, TJay Belt, Glenn Berry, Jes Borland, Carlos Bossy, Louis Davidson, Ben DeBow, Grant Fritchey, Jonathan Gardner, Jesper Johansen, Jeremy Lowell, Wendy Pastrick, Kellyn Pot’vin, Mladen Prajdić, Herve Roggero, Chris Shaw, Gail Shaw, … Jason Strate

  • DOI: https://doi.org/10.1007/978-1-4302-4771-5

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books

  • Copyright Information: The Author(s) 2012

  • Softcover ISBN: 978-1-4302-4770-8Published: 30 October 2012

  • eBook ISBN: 978-1-4302-4771-5Published: 29 November 2012

  • Edition Number: 1

  • Number of Pages: XXIV, 504

  • Topics: Database Management

Back to top

Publish with us

Policies and ethics

Back to top
Access via your institution

Buy it now

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Search

Navigation