Free 240 page eBook “SQL Server Tacklebox: Essential Tools and Scripts for the day-to-day DBA” by Rodney Landrum. Scripts, tools and techniques to tackle SQL Server issues. Troubleshoot performance issues. Receive notifications of impending issues. Fight off data corruption. Document and report on your servers. Automate and standardize SQL Server installation. Migrate data and manage data growth. Secure access to your servers.
Book Description
The success of your career as a DBA depends largely on how well-prepared you are to deal with such situations. Without verified backups, sound server documentation, and a ready supply of tried-and tested troubleshooting tools, there is no safe place to hide when the monster rears up. All you can do is buy some time, patch things up as best you can and then duck away into your cubicle, which, if you lost any data in the process, may soon be empty.
However, with the tools and techniques provided in the SQL Server Tacklebox, you will be fully-equipped to fight back. Inside, you’ll find scripts that will allow you to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending danger, secure access to your servers and fight off data corruption.
Table of Contents
- Eating SQL Server installations for breakfast
- The SQL Server landscape
- The migratory data
- Managing data growth
- DBA as detective
- Monitoring and notifications
- Securing access to SQL Server
- Finding data corruption