By Don Jones

Summary

Learn SQL Server management in a Month of Lunches is the correct option to start with SQL Server operations, together with upkeep, backup and restoration, excessive availability, and function tracking. In approximately an hour an afternoon over a month, you are going to research precisely what you are able to do, and what you should not contact. most significantly, you are going to research the day by day initiatives and methods you must hold SQL Server buzzing alongside smoothly.

Purchase of the print e-book encompasses a unfastened e-book in PDF, Kindle, and ePub codecs from Manning Publications.

About the Book

Microsoft SQL Server is utilized by thousands of companies, ranging in measurement from Fortune 500s to small retailers world wide. even if you are simply getting begun as a DBA, helping a SQL Server-driven program, or you have been drafted by means of your place of work because the SQL Server admin, you don't want a thousand-page booklet to wake up and running.

Learn SQL Server management in a Month of Lunches is the correct strategy to start with SQL Server. This concise, easy-to-read e-book skips educational introductions and teaches you day by day concepts for upkeep, backup and restoration, functionality tracking, and extra. all the 21 brief classes grants useful takeaways you are going to use over and over.

What's Inside

  • Master the basics—indexes, logins, backup, restoration ... and more
  • Learn what you could and can't do whilst aiding a third-party application
  • Monitor and enhance performance
  • Written through professional coach and bestselling writer Don Jones
  • Accessible to readers of any point of expertise, the e-book covers recommendations for all models of SQLServer 2005-2014.

About the Author

Don Jones is a Microsoft MVP, speaker, and coach. he's the author of the Month of Lunches sequence and writer of over 50 books on PowerShell, IIS, energetic listing, SCCM, SQL Server, and more.

Table of Contents

  1. Before you begin
  2. Server evaluate and configuration
  3. T-SQL crash course
  4. Managing databases
  5. Backup and recovery
  6. Authentication: who're 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 question execution plans
  13. Block and impasse analysis
  14. Automating administration with SQL Server Agent
  15. Multiserver management
  16. Windows PowerShell and SQL Server
  17. Using prolonged Events
  18. Monitoring and examining performance
  19. Options for prime availability
  20. Virtualizing SQL Server
  21. Moving, migrating, and upgrading databases
  22. SQL Server functionality checklist
  23. Never the end

Show description

Read Online or Download Learn SQL Server Administration in a Month of Lunches: Covers Microsoft SQL Server 2005-2014 PDF

Similar Database Storage Design books

Oracle Database 11g The Complete Reference (Oracle Press)

The Definitive consultant to Oracle Database 11gGet complete information at the robust beneficial properties of Oracle Database 11g from this completely up-to-date Oracle Press consultant. Oracle Database 11g: the full Reference explains tips on how to use all of the new good points and instruments, execute robust SQL queries, build PL/SQL and SQL*Plus statements, and paintings with huge items and object-relational databases.

Oracle Database 10g: A Beginner's Guide (Osborne ORACLE Press Series)

Presents starting DBAs and builders with an exceptional origin within the database management and programming fundamentals had to embark on an Oracle profession. the point of interest is on Oracle Database 10g, yet you’ll get the basics appropriate to all Oracle database releases.

The Profit Impact of Business Intelligence

Company Intelligence (BI): It’s not only a expertise. It’s not only a strategy. It’s a robust new administration procedure that – whilst performed correct – can convey wisdom, potency, larger judgements, and revenue to just about any association that makes use of it. whilst BI first got here at the scene, it promised much yet usually did not convey.

Building the Agile Enterprise: With SOA, BPM and MBM (The MK/OMG Press)

Within the final ten years IT has introduced primary adjustments to the best way the area works. not just has it elevated the rate of operations and communications, however it has additionally undermined uncomplicated assumptions of conventional company versions and elevated the variety of variables. this day, the survival of significant businesses is challenged by way of a world-wide market, foreign operations, outsourcing, worldwide groups, a altering team, defense threats, company continuity, internet visibility, and shopper expectancies.

Additional resources for Learn SQL Server Administration in a Month of Lunches: Covers Microsoft SQL Server 2005-2014

Show sample text content

Rated 4.12 of 5 – based on 45 votes