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

Learning PowerShell
Learning PowerShell

Learning PowerShell is a custom-built, handcrafted, painstakingly curated book designed to get you from total PowerShell newbie to confident PowerShell user in as little as four weeks. This book assumes no prior knowledge, perfect for non-developers and Gui addicts who recognize that PowerShell is the future but need a good bit of handholding...

Relational Database Programming: A Set-Oriented Approach
Relational Database Programming: A Set-Oriented Approach
I want to share some thoughts from my experiences doing project-based work as an IT contractor. Working as an IT contractor means taking on a mix of short- and long-term projects. In a short-term project, you need to work on a specific task with a team of developers, you need to solve a problem quickly, and then you are done with the...
TensorFlow for Deep Learning: From Linear Regression to Reinforcement Learning
TensorFlow for Deep Learning: From Linear Regression to Reinforcement Learning

Learn how to solve challenging machine learning problems with TensorFlow, Google’s revolutionary new software library for deep learning. If you have some background in basic linear algebra and calculus, this practical book introduces machine-learning fundamentals by showing you how to design systems capable of detecting objects...


Computer Security Fundamentals (Pearson IT Cybersecurity Curriculum (ITCC))
Computer Security Fundamentals (Pearson IT Cybersecurity Curriculum (ITCC))

ONE-VOLUME INTRODUCTION TO COMPUTER SECURITY

 

Clearly explains core concepts, terminology, challenges, technologies, and skills

 

Covers today’s latest attacks and...

Mastering PowerShell
Mastering PowerShell

Master the art of automating and managing your Windows environment using PowerShell

About This Book

  • Construct scripts by following proven best practices to automate redundant tasks
  • Delve into real-world examples to understand how to simplify the management of your Windows environment
  • ...
Starting an Online Business All-in-One For Dummies (For Dummies (Business & Personal Finance))
Starting an Online Business All-in-One For Dummies (For Dummies (Business & Personal Finance))

Start a successful online business—and be your own boss!

Being an online entrepreneur means more than just building a website—and this book breaks down everything you need to know to be successful. Inside, you'll get plain-English explanations and easy-to-follow instruction on online business basics, legal...

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