Real World SQL Server Administration with Perl

Dave Shea (Autor)

Buch | Softcover

832 Seiten

2003 | Softcover reprint of the original 1st ed.
Apress (Verlag)
978-1-59059-097-3 (ISBN)

Artikel merken

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.

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.

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.

Erscheint lt. Verlag	25.7.2003
Zusatzinfo	LXII, 832 p. In 2 volumes, not available separately.
Verlagsort	Berkley
Sprache	englisch
Maße	178 x 235 mm
Themenwelt	Informatik ► Datenbanken ► SQL Server
	Informatik ► Programmiersprachen / -werkzeuge ► Perl
	Mathematik / Informatik ► Informatik ► Software Entwicklung
ISBN-10	1-59059-097-X / 159059097X
ISBN-13	978-1-59059-097-3 / 9781590590973
Zustand	Neuware