SQL Server Tacklebox - Essential tools and scripts for the day-to-day DBA

For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data corruption. When the worst happens, and SQL Server is down, or performance is suffering, customers ar...

Mô tả đầy đủ

Đã lưu trong:
Chi tiết về thư mục
Tác giả chính: Landrum, Rodney
Định dạng: Sách
Ngôn ngữ:English
Được phát hành: Simple Talk Publishing 2011
Những chủ đề:
Truy cập trực tuyến:http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/25870
Các nhãn: Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
Thư viện lưu trữ: Thư viện Trường Đại học Đà Lạt
id oai:scholar.dlu.edu.vn:DLU123456789-25870
record_format dspace
spelling oai:scholar.dlu.edu.vn:DLU123456789-258702012-03-05T04:20:21Z SQL Server Tacklebox - Essential tools and scripts for the day-to-day DBA Landrum, Rodney Tin học Database For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data corruption. When the worst happens, and SQL Server is down, or performance is suffering, customers are quick to complain. During such difficult periods, you, the DBA, are the centre of attention. Suddenly, three or four people crowd your desk, laser beam focused on your every action, fully expecting you to solve the problem quickly. 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. In short, you'll be able to respond quickly and professionally to the many issues that blight the waking, and often sleeping, hours of the DBA. Then, one day, who knows? That cubicle may turn into an executive office with wall-to-wall tinted windows revealing a flowing brook outside, where no monsters live. 2011-09-19T03:04:00Z 2011-09-19T03:04:00Z 2009 Book 978-1-906434-24-3 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/25870 en application/zip Simple Talk Publishing
institution Thư viện Trường Đại học Đà Lạt
collection Thư viện số
language English
topic Tin học
Database
spellingShingle Tin học
Database
Landrum, Rodney
SQL Server Tacklebox - Essential tools and scripts for the day-to-day DBA
description For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data corruption. When the worst happens, and SQL Server is down, or performance is suffering, customers are quick to complain. During such difficult periods, you, the DBA, are the centre of attention. Suddenly, three or four people crowd your desk, laser beam focused on your every action, fully expecting you to solve the problem quickly. 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. In short, you'll be able to respond quickly and professionally to the many issues that blight the waking, and often sleeping, hours of the DBA. Then, one day, who knows? That cubicle may turn into an executive office with wall-to-wall tinted windows revealing a flowing brook outside, where no monsters live.
format Book
author Landrum, Rodney
author_facet Landrum, Rodney
author_sort Landrum, Rodney
title SQL Server Tacklebox - Essential tools and scripts for the day-to-day DBA
title_short SQL Server Tacklebox - Essential tools and scripts for the day-to-day DBA
title_full SQL Server Tacklebox - Essential tools and scripts for the day-to-day DBA
title_fullStr SQL Server Tacklebox - Essential tools and scripts for the day-to-day DBA
title_full_unstemmed SQL Server Tacklebox - Essential tools and scripts for the day-to-day DBA
title_sort sql server tacklebox - essential tools and scripts for the day-to-day dba
publisher Simple Talk Publishing
publishDate 2011
url http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/25870
_version_ 1757662557758291968