IT programming books related reviews

---

Not a complete reference, but a comprehensive overview

This is a great book. Information is organized and flows very well. With an MCP in Data Warehousing, this book provided me a really good view of "SQL Server Land". Others have been critical about the depth of content, but the author makes it very clear that some topics are too big for this type of book, with over 900 pages- it's provides plenty. In addition, the author interjects humor that makes reading more pleasurable. This is the best SQL Server book I have read yet! Great resource when working SQL Srvr and/or Perl on Windows

Real World SQL Server Administration with Perl focuses on how Perl can be applied to perform administration tasks involving SQL Server. Shea has provided a great detail of material in nearly all major areas of SQL Server administration. Subtopics include migrating data, comparing and sorting database objects, analyzing log files, analyzing and generating SQL code, monitoring SQL Servers, and managing SQL Servers in an enterprise environment. In every subtopic, Shea succeeds in demonstrating how Perl can be used to build tools to perform a particular administrative task. A common theme found throughout the book is to use Perl to bridge the gap between standard and third-party SQL Server administration management tools with Perl scripts.

The first three chapters of the book along with Appendix B review the basics of Perl as well as Perl modules. Much focus is given to Windows specific modules included in ActivePerl, the leading freeware Perl runtime environment from ActiveState. Over the course of chapters 2 and 3, Shea details how to use Perl to connect both with ADO and ODBC (as part of this, he touches upon using COM from Perl). Also introduced in these chapters are utility routines that Shea has developed to support the tools that he provides in later chapters.

Starting in chapter 4, Shea launches into the gist of the book, SQL Server administration. The first topic covered is data migration focusing on the bulk copy program (BCP). As examples, he demonstrates the importing of both the SQL Server error log as well as the Windows PerfMon log. Changing gears in chapter 5, the comparison of table columns, column indexes, contraints, stored procedures is introduced. In each case, at least one script is shown as an example. Later in chapter 5, Linchi provides a comprehensive script that compares several database objects in one script execution pass. His intent in this chapter is to address a common DBA task, comparing database schemas for change management whether it be for application trouble-shooting or upgrading deployments. He then concludes chapter 5 with scripts for generating stored procedure call trees and procedure dependency lists.

Chapter 5 is jammed packet with several cool Perl scripts including the following:

1. Table columns - compareColumns.pl
2. Table indexes - compareIndexes.pl
3. Constraints - compareConstraints.pl
4. Store Procedures - compareSPs.pl
5. Schemas - The first comparison rolled into script, compareDBs.pl
6. Stored Procedure Call Tree (callTree.pl)
7. Stored Procedure (Package) Dependency Lister (sortSPs.pl) - this Perl script will scan a group of stored procedures and identify the dependencies of other stored procedures.
8. Producting a Reference Tree for a Table (tableTree.pl) - this Perl script will generate a table dependency graph of other tables that are referred to by their foreign keys.

In chapter 6, Shea switches to a different track, analysis of the internals of a SQL Server database. Here he dives into more advanced facilities such as the trace flag 1200 - useful for debugging the locking behavior of a particular row - and the DBCC PAGE command, as well as details that help identify potential database problems. Once again, scripts are provided to help analyze the information that can be gleaned from SQL Server.

Chapters 7 and 8 deal with analysis and generation of SQL code. In starting off on these series of topics, Shea introduces filerQueryPlans.pl, a script that analyzes the output generated by the SQL Profiler tool. He also provides scripts for identify queries with excessive joins and dynamic SQL (reviewSP.pl). indexSummary.pl is another script that is quite useful, this script scans the a query plan and analyze how a given SQL query utilizes indexes. This script thus helps you to determine which indexes are used, not used, as well as how often a script is used. SQL code generation is also covered with examples that generate T-SQL code from a configuration file, database schema, from data in a table, existing T-SQL script files, and other SQL-DMO object instances. Perl script code to split files containing multiple stored procedures into a single file for each procedure is also provided here.

Chapters 9 and 11 are companion chapters. Chapter 9 introduces log file analysis of the SQL Server error logs, Windows event logs (grepEventLog.pl), DBCC output files, log files from scheduled jobs, SQL Server agent files, replication error log files, and agent output files. Other types of log files include Windows cluster log files, application server log files, as well as third-party log files. In this chapter the author discusses and develops scripts for alerting based on evaluations of the SQL Server error log, local drive space, database server availability and cluster. Then as a follow-up in chapter 11, Linchi develops scripts for monitoring of these areas with the ability to notify via SMTP e-mail.

Chapter 12, Managing SQL Servers in the Enterprise, is the last chapter. This chapter provides material and scripts for managing many SQL server instances in an enterprise environment. As the reader has come to expect, this chapter is also packed with useful scripts for managing SQL server instances as well as system and user accounts.

ListSysadmin.pl - Lists Sysadmin accounts and logins
scanForSQLServer.pl - Scan for SQL Server machines on a network
scanNullSAPasswords.pl - Scanning for sa accounts with null passwords
trackSQLAccounts.pl - Tracking SQL Server Service accounts
findOpenShares.pl - identify file shares on your SQL Server systems that are wide-open

In conclusion, the book Real SQL Server Administration with Perl is a wonderfully useful book for DBAs managing SQL Server databases. I have come across no other book targeted at a particular community within the world of Microsoft and Windows that demonstrates the power and usefulness of Perl. In addition to packing the book with incredibly useful Perl scripts for SQL Server administration, I also find myself using the first few chapters as well as the appendix as a general reference to programming Perl in the Windows environment. Latest in a great series

If you like the previous two "Inside" Books, or even if you just have them on your bookshelf for reference, then get this one too. Don't expect it to hand-hold you through the product, give real-world examples of product usage, tell you how to code your queries etc. That's not what the book is about - there are plenty of other books that cover these and other subjects well. This book covers the internals of SQL 2000, how it works, how the optimiser does it's job, how the database pages are laid out - all the stuff you won't find documented anywhere else. This is the only book the SQL Server development team have put their first hand knowledge into, so if you're really interested in how the product works and is architected then buy this book (or get a job on the SQL Server development team). Returning mine

I've been attempting off an on again for over a year to get a grasp on creating and using stored procedures. I've searched the Internet for information, bought another book published by SAMS, read the white papers from Microsoft, just about everything I could think of. Nothing would sink in...Then after sitting back and giving up for a few months, I tried another search of the Amazon books online and found "SQL Server 2000 Stored Procedure Programming". I can't believe the ease of learning this book gave me with its simple step by step, hands on instructions. It finally started to click by the time I was in Chapter 3, I finally had a grasp of how to create and use stored procedures with Microsoft's SQL Server.I've been programming since 1976 and never had such a problem getting over a learning curve but this book's easy to follow, detailed and illustrated instructions made it a snap. My thanks go to Dejan Sunderic and Tom Woodhead for creating a top notch book that I'm having a hard time putting down as I'm having such a good time with it. excellent book

As a Visual Basic developer, I have been faced several times with the requirement to write database access components using only stored procedures. All the books on VB and SQL Server that I looked at seemed to focus on how to connect to SQL Server using ADO, RDO or ODBC, but I could never find a really comprehensive guide to using stored procedures. This is the first book I've seen that is dedicated to programming with stored procedures. Now I'm starting to understand what my DBA was talking about. Overxplanation of DW basics instead of PHP creation

If you have even rudimentary knowledge of Dreamweaver and MySQL, you can skip right to chapter 6. The first 6 chapters laboriously discuss Dreamweaver, PHP and MySQL, without giving any practical usage...instead the book repeats the same concepts over and over and over.So, I was happy when I finally got to the part of actually using Dreamweaver to create a PHP application in Chapter 6. But I was disappointed to find that a lot of the steps simply tell you what to click on and what to enter, without giving you an explanation of what's going on behind the scenes and what it is you're actually doing. For instance, when you're developing the example application of a hotel booking system, when you create a Recordset the book sometimes says things like "Setup the Filter so it reads ID=Form Variable bookingID. This creates a record where the ID field matches the bookingID sent from a previous page." Well, OK. But there is absolutely no mention of what the other options are in the Recordset Filter dropdown menu, or what they do, or why the Form Variable works the way it does, or exactly how it pulls the information from the prvious page. Please tell me WHY this does what it does?It surprises me that they could be so meticulous in explaining every little miniscule detail of everyday Dreamweaver functions, yet casually throw around the idea of using Dreamweaver to create PHP as if we already know how to do that, but are trying to learn the very basics of Dreamweaver instead.I guess what I'm getting at is this: you could simply fly through the tutorial and build the example in no time, but when you're done you won't have a clue as to why half the things the book told you to do function the way they do, let alone take the knowledge to build YOUR OWN application. So, I'm taking the lessons VERY slow to try to soak it all in.Oh, and one other annoyance. This book seems to be written by authors who use English as second language...the obscene overuse of the word "whilst" (sometimes 6 times per page) will have you pulling your hair out by Chapter 2. Who uses the word WHILST in real life????I'm still laboring through the book...perhaps I'll write a follow-up when I finish. It's not terrible, but it could be better.Bottom line: an even so-so, not a thumbs-up or thumbs-down. A tour of Oracle technologies

To produce this book, Wrox took twenty expert Oracle developers and had each of them write about their area of expertise. The result is that whether you are a manager, a developer, or a DBA, if you are working with Oracle 8i this book should be on your desk. This book covers virtually every topic that you need to understand about the Oracle 8i development platform. It does not cover each topic completely but it provides a thorough and in most cases sufficient introduction on each topic. For a particular topic of interest you may need an additional book but to get all the information found in this book you would need ten volumes at least. The book opens with an introduction to Oracle 8i and some of its components including Net8 (Oracle's network solution) and Designer 6i (Oracle's development environment). The next section covers PL/SQL and PSP (this is similar to JSP). This is followed by an extensive section covering Java. This section covers JDBC, SQLJ, EJB, and interMedia (Oracle's powerful search tool). The last section covers XML and includes information on DOM and SAX parsers, SOAP, XSL, XSQL, and more. Extensive case studies are scattered throughout the book. Examples show how to use Oracle tools such as BC4J to develop enterprise applications. The book even includes primers on Java and XML. As a tour of all the features of Oracle 8i, this book is without competition. Great resource for any level of experience

I have read majority of this text and I think it's a great resource for anyone who wants to use it for SQL 6.5. Hate to disagree, but I don't quite see the point two previous reviewers are trying to make. Preface clearly states that this book is mainly geared towards SQL 6.5 rather than 7.0. Still, it contains very useful (although probably not complete) chapter regarding the differences between the two. It'd be great to have one complete reference that would provide everything you'd ever need, but I don't believe this book was intended to be that type of a reference. These days many companies have to use developers with limited dba experience, mainly due to the lack of this type of professionals. I'm sure all of those DBAs could use some real world advise and especially code samples provided in Transact SQL by Kevin Kline et al. Riddled with errors

Definitely the worst I've seen in the Exam Cram series. It looks like it was rushed to meet a dateline and I cannot believe that there was any technical review. Don't take my word for it just go through 10-20 questions of any of the exams at your local bookstore and you probably agree with my assessment. Ironically though that process might help you learn. Personally I would NOT recommend this book as I don't want to encourage such sloppiness. Best Reference material on my desk!.........

The author has explained things neatly but the problem is you seem to be taken in for more theortical info than a Hands on approach. I wanted to master sql 2000 in short time since I new sql 7.0 but it has consumed more time than that . If you are serious to learn and get a grasp of it in short time then this is not the book.Guna

• Main page
• Forums
• All reviews

TopSellers at Amazon - Handheld PDA-s

Garmin Forerunner 301 Personal GPS with Heart Rate Monitor
PalmOne Zire 31 Handheld
PalmOne Tungsten E2 Handheld
PalmOne Tungsten E Handheld
PalmOne LifeDrive Mobile Manager
Fossil Abacus AU5005 Wrist PDA with Palm OS - Black
Franklin Speaking 11th Collegiate Dictionary
PalmOne Zire 72 Special Edition Handheld Silver
PalmOne P10952U 802.11 Wi-Fi SDIO Card for Tungsten T3 and Zire 72
HP iPAQ RX3115 Pocket PC

TopSellers at Amazon - Cables and Interconnectors

Belkin Pro Series USB 2.0 Device Cable (USB A/USB B, 10 Feet)
Belkin F3U133-06 USB Device Cable (6 FT)
Belkin F3N401-06-ICE IEEE 1394 4-Pin/6-Pin 400 Mbps FireWire Cable (6 Feet)
Belkin F3U133-16 USB 2.0 A/B Cable (16 Feet)
Belkin F3U134-10 USB A/A Extension Cable; 10ft
Sima CT-2 Video Signal Processor
Monster Cable iSplitter for iPod and PowerBook
Nikon UC-E6 Replacement USB Cable for Coolpix 2100, 2200, 3100, 3200, 4200, 5200, 8400 & 8800 Digital Cameras
Belkin IEEE 1394 FireWire Compatible 4pin/4pin Cable (3-foot)
Monster Cable iCable for iPod

TopSellers at Amazon - Office Phones

Motorola MD671 5.8GHz Cordless Speakerphone/Caller ID
Cardo Systems scala-500 Bluetooth Headset
Plantronics Audio 90 Multimedia Stereo PC Headset
VTech ip5850 5.8 GHz DSS Cordless Phone with Dual Handsets and Digital Answering System
Creative Labs WebCam Live!
Uniden TCX800 Accessory Handset for TRU8800 Expandable Phones (Silver/Black)
Panasonic KX-TG5433M 5.8 GHz DSS Cordless Phone with Answering System and Three Handsets
Logitech 980158-0403 Internet Chat Headset
Panasonic KX-TCA60 Headset
Panasonic Type-24 PP511A Cordless Telephone Rechargeable Battery Replacement

Top 10 yahoo news about mobile phone technology

Yemen short-lists six for GSM award (ITP.net)
Servinova begins seamless Wi-Fi-GSM/GPRS VoIP network testing with ASNAP (MobileMag)
Strategic Partnership with CPS Enables Simcom to Integrate; High Accuracy Location Technology into GSM/W-CDMA Devices (ZDNet India)
Photo Release -- Servinova, a Cisco Systems Registered Partner Company Has Started Network Testing on CISCO Aironet (PrimeZone via Yahoo! Finance)
2N Intros GSM VOIP Support (Unstrung.com)
Wireless: Making a living from cellphone innards (International Herald Tribune)
Photo Release -- Servinova, a Cisco Systems Registered Partner Company Has Started Network Testing on CISCO Aironet (RedNova)
Group Helps Fight AIDS in Zambia; Four From Vancouver Join Christian Program (RedNova)
Docomo seeking overseas suppliers (Electronic Engineering Times Asia)
Bharti to outsource call-centres business for Rs 1,100 crore (Financial Express)

Valid XHTML and CSS

Most popular searches about sql, php, apache and more

c band satellite programming
database object
sql editor
perl pdf
base database
perl gtk
php ide
on apache
sql example
shell programming if
version of apache
as400 programming
microsoft sql server
database connectivity
sql dts
sql certification
htm php asp
apache pass
perl convert
interbase sql
office programming
sql count
htm php asp
mysql perl
menu database
area code database
dsp programming
perl cpan
mysql database
php mac
perl certification
in sql
database from
perl sysread
programming norstar
maximum database size
a database
php manual
sql reports
stored procedure sql
linear programming
database management systems
from a perl
mysql php
hd programming
date php
sql for
php cookbook pdf free download
mysql for dummies ebook chm file torrent
apache book emule pdf free warez

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Programming Books