Full Description
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.
Contents
Chapter 1: Introducing Perl Basics Chapter 2: Working with Commonly Used Perl Modules Chapter 3: Working with Commonly Used Perl Routines Chapter 4: Migrating Data Chapter 5: Comparing and Sorting Database Objects Chapter 6: Analyzing Databases Chapter 7: Analyzing SQL Code Chapter 8: Generating SQL Code Chapter 9: Analyzing Log Files Chapter 10: Managing SQL Server Security Chapter 11: Monitoring SQL Servers Chapter 12: Managing SQL Servers in the Enterprise Appendix A: Perl Resources Appendix B: Getting Started with Perl
