Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Learn SQL Server Administration in a Month of Lunches: Covers Microsoft SQL Server 2005-2014

Buy

Summary

Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server operations, including maintenance, backup and recovery, high availability, and performance monitoring. In about an hour a day over a month, you'll learn exactly what you can do, and what you shouldn't touch. Most importantly, you'll learn the day-to-day tasks and techniques you need to keep SQL Server humming along smoothly.

Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

About the Book

Microsoft SQL Server is used by millions of businesses, ranging in size from Fortune 500s to small shops worldwide. Whether you're just getting started as a DBA, supporting a SQL Server-driven application, or you've been drafted by your office as the SQL Server admin, you do not need a thousand-page book to get up and running.

Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server. This concise, easy-to-read book skips academic introductions and teaches you day-to-day techniques for maintenance, backup and recovery, performance monitoring, and more. Each of the 21 short lessons gives you practical takeaways you'll use over and over.

What's Inside

  • Master the basics—indexes, logins, backup, recovery ... and more
  • Learn what you can and cannot do when supporting a third-party application
  • Monitor and improve performance
  • Written by expert trainer and bestselling author Don Jones
  • Accessible to readers of any level of experience, the book covers techniques for all versions of SQLServer 2005-2014.

About the Author

Don Jones is a Microsoft MVP, speaker, and trainer. He is the creator of the Month of Lunches series and author of over 50 books on PowerShell, IIS, Active Directory, SCCM, SQL Server, and more.

Table of Contents

  1. Before you begin
  2. Server assessment and configuration
  3. T-SQL crash course
  4. Managing databases
  5. Backup and recovery
  6. Authentication: who are you?
  7. Authorization: what are you allowed to do?
  8. Accounting: what did you do?
  9. Analyzing indexes
  10. Maintaining indexes
  11. Tuning index designs
  12. Reading query execution plans
  13. Block and deadlock analysis
  14. Automating management with SQL Server Agent
  15. Multiserver management
  16. Windows PowerShell and SQL Server
  17. Using Extended Events
  18. Monitoring and analyzing performance
  19. Options for high availability
  20. Virtualizing SQL Server
  21. Moving, migrating, and upgrading databases
  22. SQL Server performance checklist
  23. Never the end
(HTML tags aren't allowed.)

Upgrading to Lotus Notes And Domino 7
Upgrading to Lotus Notes And Domino 7
If you're reading this book, you're probably already familiar with Lotus Notes/Domino. You know about all the powerful productivity features offered by this product (actually multiple products, although most of us in the Notes/Domino universe still think of it as one). You know how much your company relies on it to communicate, collaborate, and...
Advances in Signal Processing and Intelligent Recognition Systems: 4th International Symposium SIRS 2018, Bangalore, India, September 19–22, 2018, ... in Computer and Information Science (968))
Advances in Signal Processing and Intelligent Recognition Systems: 4th International Symposium SIRS 2018, Bangalore, India, September 19–22, 2018, ... in Computer and Information Science (968))
This book constitutes the refereed proceedings of the 4th International Symposium on Advances in Signal Processing and Intelligent Recognition Systems, SIRS 2018, held in Bangalore, India, in September 2018.

The 28 revised full papers and 11 revised short papers presented were carefully reviewed and selected from 92...

The Extreme Searcher's Internet Handbook: A Guide for the Serious Searcher, Second Edition
The Extreme Searcher's Internet Handbook: A Guide for the Serious Searcher, Second Edition
"A phenomenal resource for both extreme and not-so-extreme researchers. Great tips, clear explanations, and years of expertise distilled into 250 pages of clear, engaging text. This book should be on every searcher's desk."  —Mary Ellen Bates, coauthor, Researching Online for Dummies

The
...

Management of Acute Pulmonary Embolism (Contemporary Cardiology)
Management of Acute Pulmonary Embolism (Contemporary Cardiology)

This practical volume highlights traditional, novel, and evolving aspects of the diagnosis and treatment of pulmonary embolism (PE). The contributors comprise an international team of experts. Important aspects of diagnosis, risk stratification, and differential treatment of patients with PE are presented in a concise, yet comprehensive...

Microsoft Office Excel 2007: Top 100 Simplified Tips & Tricks
Microsoft Office Excel 2007: Top 100 Simplified Tips & Tricks
You already know Excel 2007. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great...
WLAN Positioning Systems: Principles and Applications in Location-Based Services
WLAN Positioning Systems: Principles and Applications in Location-Based Services

Describing the relevant detection and estimation theory, this detailed guide provides the background knowledge needed to tackle the design of practical WLAN positioning systems. It sets out key system-level challenges and design considerations in increasing positioning accuracy and reducing computational complexity, and it also examines...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy