Real World SQL Server Administration with Perl
Buch in deiner Nähe kaufen
Beschreibung
Real World SQL Server Administration with Perl is written with the goal of super-charging your SQL Server administration skills with Perl scripting, taking you to the next level of SQL Server administration. Through a broad range of scenarios, this book shows you how to write Perl scripts (often in combination with T-SQL scripting) to solve a wide variety of SQL Server administration problems. This unique book will provide you with the techniques to conquer real-world problems that frequently trouble database administrators.
You will take away at least two things from reading this book: a database administration toolkit complete with over 150 Perl scripts, and problem-solving techniques perfect for attacking additional SQL Server administrative challenges. Many of the sample problems are described in SQL Server 7 or 2000 context, but in reality, the examples arent version specificall the Perl scripts are open and may be adapted to work with any version of SQL Server.
Has appeal for both Windows programmers and open source aficionados Practical, real-world tested scripts are taken from actual production environments Provides over 150 ready-to-use and easy-to-customize Perl scripts for administrating SQL Servers
* The only book of its kind, SQL Server Administration with Perl has appeal for both Windows programmers and open source aficionados. * Practical, real-world tested scripts are taken from actual production environments. * SQL Server Administration with Perl provides over 150 ready-to-use and easy-to-customize Perl scripts for administrating SQL Servers. * Scripts include tracking configurations and schema changes, monitoring servers, analyzing log files, auditing server environments for breach of best practice standards, validating data migration, performing impact analysis and creating transaction summaries, managing code releases, controlling SQL Server functional and
Autor*in
Dave Shea
Themen in »Real World SQL Server Administration with Perl«
Microsoft SQL Server SQL SQL Server 2000 Scala T-SQL Transact-SQL regular expressions
Stimmen zu »Real World SQL Server Administration with Perl«
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)
()