Real World SQL Server Administration with Perl

Real World SQL Server Administration with Perl

4.11 - 1251 ratings - Source

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.... a reference.aquot;; my $server = Win32::OLEa€”agt;new(a#39;SQLDMO.SQLServera#39;) or die aquot;* **Err: Could not create SQLDMO object. ... get the referenced columns (FKa#39;s only) for(my $i = 1; $i alt;= $keya€”agt;ReferencedColumns()a€”agt;Count(); $i++) { pushanbsp;...

Title:Real World SQL Server Administration with Perl
Author:Linchi Shea
Publisher:Apress - 2003-07-24


You Must CONTINUE and create a free account to access unlimited downloads & streaming