Real World SQL Server Administration with Perl

Author:   Dave Shea ,  Linchi Shea
Publisher:   APress
Edition:   Softcover reprint of the original 1st ed.
ISBN:  

9781590590973


Pages:   832
Publication Date:   25 July 2003
Format:   Paperback
Availability:   In Print   Availability explained
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Our Price $158.37 Quantity:  
Add to Cart

Share |

Real World SQL Server Administration with Perl


Add your own review!

Overview

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.

Full Product Details

Author:   Dave Shea ,  Linchi Shea
Publisher:   APress
Imprint:   APress
Edition:   Softcover reprint of the original 1st ed.
Dimensions:   Width: 17.80cm , Height: 4.30cm , Length: 23.50cm
Weight:   1.431kg
ISBN:  

9781590590973


ISBN 10:   159059097
Pages:   832
Publication Date:   25 July 2003
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print   Availability explained
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of 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

Reviews

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)


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)


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)


Author Information

"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."

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

MRG2025CC

 

Shopping Cart
Your cart is empty
Shopping cart
Mailing List