Healthy SQL

A Comprehensive Guide to Healthy SQL Server Performance



Bookstore > Books > Healthy SQL

Price$42.95 - $45.48
Rating
AuthorRobert Pearl
PublisherApress
Published2015
Pages408
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101430267739
ISBN-139781430267737
EBook Hardcover Paperback

Healthy SQL is about ensuring the ongoing performance health of a SQL Server database. An unhealthy database is not just an inconvenience; it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct reflection on you. It's in everyone's best interest to have a healthy SQL implementation. Healthy SQL is built around the concept of a medical checkup, giving you the tools you need to assess the current health of your database and take action to improve upon that health and maintain good performance to your business.

Healthy SQL aids in developing a rigorous routine so that you know how healthy your SQL Server machines are, and how you can keep those same servers healthy and fit for duty. The book is filled with practical advice and a time-tested strategy, helping you put together a regimen that will ensure your servers are healthy, your implementation is fully optimized, your services are redundant and highly available, and you have a plan for business continuity in the event of a disaster. If your current environment doesn't match up with these criteria, then pick up a copy of Healthy SQL today and start your journey on the road to a fit and tight SQL Server deployment.




5 5 4

Similar Books


SQL Queries for Mere Mortals, 4th Edition

SQL Queries for Mere Mortals, 4th Edition

by John L. Viescas

SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques.Step by step, Viescas guides you through creating re...

Price:  $18.13  |  Publisher:  Addison-Wesley  |  Release:  2018

SQL Server 2019 Administration Inside Out

SQL Server 2019 Administration Inside Out

by Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni

Dive into SQL Server 2019 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts th...

Price:  $48.15  |  Publisher:  Microsoft Press  |  Release:  2020

A Developer's Guide to Data Modeling for SQL Server

A Developer's Guide to Data Modeling for SQL Server

by Eric Johnson, Joshua Jones

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL...

Price:  $6.15  |  Publisher:  Addison-Wesley  |  Release:  2008

Beginning Microsoft SQL Server 2008 Administration

Beginning Microsoft SQL Server 2008 Administration

by Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger

SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation a...

Price:  $5.17  |  Publisher:  Wrox  |  Release:  2009

Professional SQL Server 2008 Internals and Troubleshooting

Professional SQL Server 2008 Internals and Troubleshooting

by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort

When faced with a variety of SQL Server issues, you need to be able to troubleshoot SQL Server as well as its underlying operating system. To that end, this author group of SQL Server experts presents you with invaluable advice that brings together - and simplifies - practical internal information concerning SQL Server along with troubles...

Price:  $5.49  |  Publisher:  Wrox  |  Release:  2010

SQL All-in-One For Dummies, 2nd Edition

SQL All-in-One For Dummies, 2nd Edition

by Allen G. Taylor

SQL, or structured query language, is the international standard language for creating and maintaining relational databases. It is the basis of all major databases in use today and is essential for the storage and retrieval of database information. This fun and friendly guide takes SQL and all its related topics and breaks it down into ea...

Price:  $7.49  |  Publisher:  Wiley  |  Release:  2011

Oracle SQL Tuning Pocket Reference

Oracle SQL Tuning Pocket Reference

by Mark Gurry

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the r...

Price:  $6.76  |  Publisher:  O'Reilly Media  |  Release:  2002

Oracle PL/SQL Language Pocket Reference, 4th Edition

Oracle PL/SQL Language Pocket Reference, 4th Edition

by Steven Feuerstein, Bill Pribyl, Chip Dawes

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. A companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming, this concise guide boils down the most vital PL/SQL inf...

Price:  $5.98  |  Publisher:  O'Reilly Media  |  Release:  2007