Real World SQL Server Administration with Perl

ISBN-13: 9781590590973 / Angielski / Miękka / 2003 / 832 str.

Linchi Shea

Opis

This book is about solving SQL Server administrative problems with Perl. Linchi has designed it to consist of a series of scenarios covering a wide range of SQL Server administrative topics. These are real world scenarios that you hear DBAs discussing on the SQL Server forums or newsgroups, and scenarios that DBAs run into in their day-to-day development or production environments. Readers will walk away from this book with two things: a DBA toolkit with well over 150 Perl scripts, and problem solving techniques you can apply to create even more tools for attacking other SQL Server administrative problems. Most of the sample problems are described and addressed in the context of SQL Server 7 or SQL Server 2000, but they are generally version independent. The next major release of SQL Server ("Yukon")may change some of the details, but will not invalidate the nature of the presented approaches or solutions. All the Perl scripts are completely open and can be easily adapted to work with any version of SQL Server.

Recenzje

From the reviews:

"This is aimed at the DBA who is already running an efficient SQL server, but who wants to be forearmed against any future problems. ... The aim of the book is to provide a toolkit of around 150 Perl scripts that can then be adapted and applied to a wide variety of SQL server problems ... . There are also appendices that list useful resources ... . The book as a whole could be quite useful ... ." (Linux Magazine, March, 2004)

"The book demonstrates the capabilities of Perl by presenting individual scenarios, each designed to highlight a particular useful feature and how it might be applied to common SQL Server administration tasks. ... Overall, this is a well-rounded book providing a good balance of SQL Server administration task specific information, backed up with some useful Perl-specific text." (Adrian Hibbert, Computer Bulletin, March, 2004)

Spis treści

A table of contents is not available for this title.

O autorze

Linchi Shea works at a major Wall Street firm as the SQL Server technical lead. He is a Microsoft "Most Valuable Professional" and is active with many SQL Server communities via SSWUG.org. He has a bachelor's degree in electrical engineering and computer science, and a master's degree in information systems from the University of British Columbia. When not automating and solving database administration problems with Perl, Linchi is an avid tennis player and a regular reader of newspaper bridge columns.