{"id":641,"date":"2008-08-05T00:00:00","date_gmt":"2009-08-05T00:00:00","guid":{"rendered":"https:\/\/test.simple-talk.com\/uncategorized\/sql-server-ebook-download-sql-server-tacklebox\/"},"modified":"2021-08-24T13:40:39","modified_gmt":"2021-08-24T13:40:39","slug":"sql-server-ebook-download-sql-server-tacklebox","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/database-administration-sql-server\/sql-server-ebook-download-sql-server-tacklebox\/","title":{"rendered":"SQL Server eBook Download &#8211; SQL Server Tacklebox"},"content":{"rendered":"<p><\/p>\n<div id=\"pretty\">\n<h3>Essential Tools and Scripts for the day-to-day DBA<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/imported\/774-SQL_SERVER_TACKLEBOX_135px.gif\" class=\"float-left\" alt=\"774-SQL_SERVER_TACKLEBOX_135px.gif\" \/><\/p>\n<p>&#8220;Inside the SQL Server Tacklebox, you&#8217;ll find a collection of the day-to-day tools and techniques that I use to automate and standardize SQL Server installation, document and report on my servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access to my servers and fight off the data corruption monster.&#8221; &#8212; <em>Rodney Landrum, Author<\/em><\/p>\n<h2><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/imported\/774-SQLServerTacklebox.pdf\">SQL Server Tacklebox (7.8MB Download)<\/a> <\/h2>\n<p><strong>Scripts<\/strong><\/p>\n<p>The scripts contained in this book are contained in a ZIP file and can be downloaded from the link in the box to the right of the author photo (<strong>SQL_Server_Tacklebox_Code.zip<\/strong>)<\/p>\n<p><strong>Table of Contents<\/strong><\/p>\n<p>Chapter 1: Eating SQL Server installations for breakfast<\/p>\n<ul>\n<li>Specification, installation, configuration  <\/li>\n<li>Specifying the physical server  <\/li>\n<li>Ready to install &#8211; almost  <\/li>\n<li>Installation done, now to configure <\/li>\n<\/ul>\n<p>Chapter 2: The SQL Server landscape<\/p>\n<ul>\n<li>What information is required?  <\/li>\n<li>Automating information retrieval <\/li>\n<\/ul>\n<p>Chapter 3: The migratory data<\/p>\n<ul>\n<li>Mapping out the data migration solution  <\/li>\n<li>The data source  <\/li>\n<li>Bulk data transfer tools  <\/li>\n<li>SSIS  <\/li>\n<li>Data comparison tools  <\/li>\n<li>&#8220;High Availability&#8221; tools <\/li>\n<\/ul>\n<p>Chapter 4: Managing data growth<\/p>\n<ul>\n<li>Common causes of space issues  <\/li>\n<li>Being a model DBA  <\/li>\n<li>Indexes and large row counts  <\/li>\n<li>TempDB  <\/li>\n<li>A query to determine current space utilization <\/li>\n<\/ul>\n<p>Chapter 5: DBA as detective<\/p>\n<ul>\n<li>System tables versus DMVs  <\/li>\n<li>Tracking down database performance issues  <\/li>\n<li>Automating discovery of problems <\/li>\n<\/ul>\n<p>Chapter 6: Monitoring and notifications<\/p>\n<ul>\n<li>Types of monitoring and notifications  <\/li>\n<li>Enabling notifications  <\/li>\n<li>Backup failure notification  <\/li>\n<li>Performance issues  <\/li>\n<li>Stopped services and disk space shortage <\/li>\n<\/ul>\n<p>Chapter 7: Securing access to SQL Server<\/p>\n<ul>\n<li>Overview of security challenges  <\/li>\n<li>Finding SQL logins, Windows users and groups  <\/li>\n<li>Find Windows Active Directory group membership  <\/li>\n<li>Find SQL users at the database level  <\/li>\n<li>Loading up the DBA repository with security data  <\/li>\n<li>Finding service accounts with WMIC  <\/li>\n<li>Surveillance <\/li>\n<\/ul>\n<p>Chapter 8: Finding data corruption<\/p>\n<ul>\n<li>Causes of corruption  <\/li>\n<li>Consequences of corruption  <\/li>\n<li>Fighting corruption  <\/li>\n<li>Seeking out corruption <\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The SQL Server Tacklebox contains a collection of practical tools and techniques to automate and standardize SQL Server installation, document and report on servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access servers and fight off the data corruption.&hellip;<\/p>\n","protected":false},"author":221800,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143527],"tags":[5005,4170,5007,4150,4151],"coauthors":[],"class_list":["post-641","post","type-post","status-publish","format-standard","hentry","category-database-administration-sql-server","tag-data-corruption","tag-database-administration","tag-free-sql-server-ebook","tag-sql","tag-sql-server"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/221800"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=641"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/641\/revisions"}],"predecessor-version":[{"id":92280,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/641\/revisions\/92280"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=641"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}