Real World SQL Server Administration with Perl
Autor Dave Sheaen Limba Engleză Paperback – 25 iul 2003
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.
Preț: 293.38 lei
Preț vechi: 366.72 lei
-20% Nou
Puncte Express: 440
Preț estimativ în valută:
56.18€ • 58.93$ • 46.60£
56.18€ • 58.93$ • 46.60£
Carte tipărită la comandă
Livrare economică 27 ianuarie-10 februarie 25
Preluare comenzi: 021 569.72.76
Specificații
ISBN-13: 9781590590973
ISBN-10: 159059097X
Pagini: 832
Ilustrații: LXII, 832 p. In 2 volumes, not available separately.
Dimensiuni: 178 x 235 x 43 mm
Greutate: 1.42 kg
Ediția:Softcover reprint of the original 1st ed.
Editura: Apress
Colecția Apress
Locul publicării:Berkeley, CA, United States
ISBN-10: 159059097X
Pagini: 832
Ilustrații: LXII, 832 p. In 2 volumes, not available separately.
Dimensiuni: 178 x 235 x 43 mm
Greutate: 1.42 kg
Ediția:Softcover reprint of the original 1st ed.
Editura: Apress
Colecția Apress
Locul publicării:Berkeley, CA, United States
Public țintă
Professional/practitionerCuprins
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.
Recenzii
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)
"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)
Notă biografică
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.
Caracteristici
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