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

Illustrated C# 7: The C# Language Presented Clearly, Concisely, and Visually
Illustrated C# 7: The C# Language Presented Clearly, Concisely, and Visually

Get to work quickly with C# with a uniquely succinct and visual format used to present the C# 7.0 language. Whether you’re getting to grips with C# for the first time or working to deepen your understanding, you’ll find this book to be a clear and refreshing take on each aspect of the language.

Figures are of...

The Names of Plants
The Names of Plants
The Names of Plants is an invaluable reference for botanists and horticulturalists. The first section gives an historical account of the significant changes in the ways that plants have been known and named. It documents the problems associated with an ever-increasing number of common names of plants, and the resolution of these problems through...
Beginning iOS AR Game Development: Developing Augmented Reality Apps with Unity and C#
Beginning iOS AR Game Development: Developing Augmented Reality Apps with Unity and C#

Create a fully featured application that’s both sophisticated and engaging. This book provides a detailed guide in developing augmented reality games that can take advantage of the advanced capabilities of new iOS devices and code while also offering compatibility with still supported legacy devices. 

No...


Beginning Big Data with Power BI and Excel 2013: Big Data Processing and Analysis Using PowerBI in Excel 2013
Beginning Big Data with Power BI and Excel 2013: Big Data Processing and Analysis Using PowerBI in Excel 2013

In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsoft’s Excel and Power BI to import data from NoSQL and SQL databases and other sources, create relational data models, and analyze business problems through sophisticated dashboards and data-driven...

Learn Bitcoin and Blockchain: Understanding blockchain and Bitcoin architecture to build decentralized applications
Learn Bitcoin and Blockchain: Understanding blockchain and Bitcoin architecture to build decentralized applications

Get up and running with the fundamentals of Bitcoin and blockchain

Key Features

  • Learn quick, effective, and easy ways to master blockchain and Bitcoin
  • Understand the impact of decentralization and discover ways to tackle it
  • Explore the future of Bitcoin...
Hands-On Artificial Intelligence with Java for Beginners: Build intelligent apps using machine learning and deep learning with Deeplearning4j
Hands-On Artificial Intelligence with Java for Beginners: Build intelligent apps using machine learning and deep learning with Deeplearning4j

Build, train, and deploy intelligent applications using Java libraries

Key Features

  • Leverage the power of Java libraries to build smart applications
  • Build and train deep learning models for implementing artificial intelligence
  • Learn various algorithms to...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy