Learn SQL Server Administration
In a Month of Lunches
Book Description:
SummaryLearn 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 BookMicrosoft 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 InsideMaster the basics-indexes, logins, backup, recovery ... and moreLearn what you can and cannot do when supporting a third-party applicationMonitor and improve performanceWritten by expert trainer and bestselling author Don JonesAccessible to readers of any level of experience, the book covers techniques for all versions of SQLServer 2005-2014. About the AuthorDon 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 ContentsBefore you beginServer assessment and configurationT-SQL crash courseManaging databasesBackup and recoveryAuthentication: who are you? Authorization: what are you allowed to do? Accounting: what did you do?Analyzing indexesMaintaining indexesTuning index designsReading query execution plansBlock and deadlock analysisAutomating management with SQL Server AgentMultiserver managementWindows PowerShell and SQL ServerUsing Extended EventsMonitoring and analyzing performanceOptions for high availabilityVirtualizing SQL ServerMoving, migrating, and upgrading databasesSQL Server performance checklistNever the end
Download Link:
Related Books:
Microsoft SQL Server 2008 Administration
With Windows PowerShell
The definitive guide to automating SQL Server admnistration with Powershell scriptsIf you're a SQL Server database administrator, this book will make your life easier. Windows PowerShell is an administrative scripting tool that allows you to automate many tasks you're probably currently doing by hand. This nuts-and-bolts guide shows you how to create Windows PowerShell scripts to administer almost every aspect of SQL Server.You'll get a thorough introduction to PowerShell basics and all the PowerShell components that have been integrated into SQL Server 2008, as well as actual administration tasks. The book provides complete scripts that have been tested and proven, saving you hours of effort.The new release of Microsoft SQL Server 2008 now includes ...
Getting Started with SQL Server 2014 Administration
Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014 with this book and ebook. Overview Design your SQL Server 2014 infrastructure by combining both onpremise and WindowsAzurebased technology Implement the new InMemory OLTP database engine feature to enhance the performance of your transaction databases This is a handson tutorial that explores the new features of SQL Server 2014 along with giving real world examples In Detail The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud...
Microsoft SQL Server 2008 R2 Administration Cookbook
This book offers practical, task-based, and immediately usable recipes covering a wide range of advanced techniques for administering a high-performance SQL Server 2008 R2 system. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, its explanations go into great detail, which makes it good learning material for everyone who has experience in SQL Server and wants to improve. The book is designed in such a way that you can either read it chapter by chapter or refer to recipes that you want in no particular order. Although the book is focused on specific Microsoft SQL Server 2008 R2, most of the concepts and explanations are also applicable to SQL Server 2008. If you are an experienced database ad...
2007 - 2021 © eBooks-IT.org