Real World SQL Server Administration with Perl

Linchi Shea

800 pages, parution le 14/08/2003

Ajouter à une liste

Indisponible

Résumé

Real World SQL Server Administration with Perl significantly empowers SQL Server database administrators and developers with Perl scripting techniques and takes SQL Server administration to the next level. This is the first book entirely devoted to solving practical SQL Server administrative problems with Perl.

Real World SQL Server Administration with Perl consists of a series of scenarios covering a wide range of SQL Server administrative topics. These are real-world scenarios that you see DBAs discussing on the SQL Server forums and newsgroups—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 they 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 it 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.

Introducing Perl Basics
Working with Commonly Used Perl Modules
Working with Commonly Used Perl Routines
Migrating Data
Comparing and Sorting Database Objects
Analyzing Databases
Analyzing SQL Code
Generating SQL Code
Analyzing Log Files
Managing SQL Server Security
Monitoring SQL Servers
Managing SQL Servers in the Enterprise
Appendix A: Perl Resources
Appendix B: Getting Started with Perl

L'auteur - Linchi Shea

works at a major Wall Street firm as the SQL Server technical lead. He is a Microsoft MVP and is active with many SQL Server communities via SSWUG.org. He has a bachelors degree in Electrical Engineering and Computer Science and a masters in Information Systems from the University of British Columbia. When not automating and solving DBA problems with Perl, Linchi is an avid tennis player and a regular reader of newspaper bridge columns.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Apress
Auteur(s)	Linchi Shea
Parution	14/08/2003
Nb. de pages	800
Format	18 x 23,5
Couverture	Broché
Poids	1300g
Intérieur	Noir et Blanc
EAN13	9781590590973
ISBN13	978-1-59059-097-3