Real World SQL Server Administration with Perl

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.

1 Introducing Perl Basics.- 2 Working with Commonly Used Perl Modules.- 3 Working with Commonly Used Perl Routines.- 4 Migrating Data.- 5 Comparing and Sorting Database Objects.- 6 Analyzing Databases.- 7 Analyzing SQL Code.- 8 Generating SQL Code.- 9 Analyzing Log Files.- 10 Managing SQL Server Security.- 11 Monitoring SQL Servers.- 12 Managing SQL Servers in the Enterprise.- Appendix A Perl Resources.- Perl Online Documentation.- Perl Books.- Perl Web Sites, Mailing Lists, and Newsgroups.- Perl Modules.- Appendix B Getting Started with Perl.- Installing Perl.- Running Perl Scripts.- Getting to Know the Perl Bare Essentials.- Introducing Values, Data Types, and Variables.- Understanding Scalars, Arrays, and Hashes.- Understanding Scalar Context and List Context.- Determining True or False.- Grouping Statements into Code Blocks.- Creating Compound Statements.- Declaring Variables.- Comparing Values.- Interpolating Variables.- Using Functions or Routines.- Quoting Strings.- Understanding References.- Introducing Perl Regular Expressions.- Using Regular Expressions.- Writing Simple Regular Expressions.- Composing Complex Regular Expressions.- Using More Advanced Features.- Summary.

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.