Register Log in

SQL Server eBook Download – SQL Server Tacklebox

Comments 0

Share to social media

Essential Tools and Scripts for the day-to-day DBA

774-SQL_SERVER_TACKLEBOX_135px.gif

“Inside the SQL Server Tacklebox, you’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.” — Rodney Landrum, Author

SQL Server Tacklebox (7.8MB Download)

Scripts

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 (SQL_Server_Tacklebox_Code.zip)

Table of Contents

Chapter 1: Eating SQL Server installations for breakfast

  • Specification, installation, configuration
  • Specifying the physical server
  • Ready to install – almost
  • Installation done, now to configure

Chapter 2: The SQL Server landscape

  • What information is required?
  • Automating information retrieval

Chapter 3: The migratory data

  • Mapping out the data migration solution
  • The data source
  • Bulk data transfer tools
  • SSIS
  • Data comparison tools
  • “High Availability” tools

Chapter 4: Managing data growth

  • Common causes of space issues
  • Being a model DBA
  • Indexes and large row counts
  • TempDB
  • A query to determine current space utilization

Chapter 5: DBA as detective

  • System tables versus DMVs
  • Tracking down database performance issues
  • Automating discovery of problems

Chapter 6: Monitoring and notifications

  • Types of monitoring and notifications
  • Enabling notifications
  • Backup failure notification
  • Performance issues
  • Stopped services and disk space shortage

Chapter 7: Securing access to SQL Server

  • Overview of security challenges
  • Finding SQL logins, Windows users and groups
  • Find Windows Active Directory group membership
  • Find SQL users at the database level
  • Loading up the DBA repository with security data
  • Finding service accounts with WMIC
  • Surveillance

Chapter 8: Finding data corruption

  • Causes of corruption
  • Consequences of corruption
  • Fighting corruption
  • Seeking out corruption

Load comments

Recommended for you

About the author

Rodney Landrum

See Profile

Rodney Landrum went to school to be a poet and a writer. And then he graduated so that dream was crushed. He followed another path, which was to become a professional in the fun filled world of Information Technology. He has worked as a systems engineer, UNIX and network admin, data analyst, client services director and finally as a database administrator. The old hankering to put words on paper, while paper still existed, got the best of him and in 2000 he began writing technical articles, some creative and humorous, some quite the opposite. In 2010 he wrote SQL Server Tacklebox, a title his editor disdained, but a book closest to the true creative potential he sought; he still yearns to do a full book without a single screen shot, which he accomplished in 2019 with his first novel, Chronicles of Shameus He currently works from his castle office in Pensacola, FL as a senior DBA consultant for Ntirety, a division of Hostway/Hosting.

Rodney's contributions
Rodney's latest contributions: