By Don Jones
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.
- 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
- Before you begin
- Server evaluate and configuration
- T-SQL crash course
- Managing databases
- Backup and recovery
- Authentication: who're you?
- Authorization: what are you allowed to do?
- Accounting: what did you do?
- Analyzing indexes
- Maintaining indexes
- Tuning index designs
- Reading question execution plans
- Block and impasse analysis
- Automating administration with SQL Server Agent
- Multiserver management
- Windows PowerShell and SQL Server
- Using prolonged Events
- Monitoring and examining performance
- Options for prime availability
- Virtualizing SQL Server
- Moving, migrating, and upgrading databases
- SQL Server functionality checklist
- Never the end