Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference Review

Average Reviews:

(More customer reviews)Are you looking to buy Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference? Here is the right place to find the great deals. we can offer discounts of up to 90% on Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference ReviewI bought this book on the basis of the glowing recommendations here. As I have a number of servers to tune which execute some extremely complex SQL, and I need to be able to look inside with Perfmon and the profiler, I thought this book would be very useful. I particularly wanted help with sysmon.
This book gave me virtually nothing. Its coverage of tuning was shallow, information was repeated unnecessarily, text was copied almost verbatim from BOL, and it provided little or nothing that couldn't be found elsewhere and easily.
It tries to cover everything at the cost of giving real value. For example it provides 15 pages on data warehousing of which 12 are a description of data warehousing so cursory that if you don't know the subject you'll only be confused, and 3 pages on actual tuning which basically say that you should find out whether the bottleneck is CPU/disk/memory then add more CPU/disk/memory respectively.
Sizing and capacity planning are introduced with seven equations without justification. Okay, but completions C is given as the number of transactions that were completed during the observation period, but on the facing page C = 96 seconds [sic]. Did anyone proof-read this? With these and numerous other oddities (trunc. log on chkpt on SQL2000?) I don't know what I can trust.
The mathematics for this section is done and finished in 6 pages.
I was particularly looking for a comprehensive description of sysmon counters. Other than a quick rundown of the obvious ones there's a long list in the appendix of others, including such gems as "lock blocks allocated: the total number of allocated lock blocks". The whole point of buying this book was to find out how to use them, or indeed what they mean (Skipped Ghosted Records/Sec - means what?); merely giving me a list of them is redundant. This was the biggest letdown for me - I need this info!
There are other important omissions. I have spent literally weeks identifying and working round failures in the query plan optimiser. This serious issue is not properly addressed except for a chapter introducing query hints. A taxonomy of optimiser failures and ways of tackling each type might save others from the headaches I've had. Optimiser hints do not always suffice.
The book is rated on the back for user levels IT Implementer and Corporate Developer. That is far too generous.Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference Overview
Performance tuning a relational database can be engaging yet frustrating, and this guide gives you the practical information you need to configure and tune a Microsoft® SQL Server™ 2000 database for better, faster, more scalable solutions. The authors start with the basics and build upon them to teach the mechanics of performance tuning and how they affect the whole system. This book also shows how to optimize for the underlying operating system and hardware. It's the only book of its kind coauthored by engineers who have worked in the SQL Server performance group.

Expert instruction helps you understand these topics:

THE BASICS:

Architectural fundamentals that affect tuning
I/O tuning and RAID storage considerations
How to tune hardware, database layout, and configuration parameters
Feature enhancements for better ease-of-use, performance, manageability, and reliability.

SERVER TUNING:

How to use the Microsoft Windows® 2000 System Monitor and the SQL Server Profiler to shorten transaction response times.

SIZING AND CAPACITY PLANNING:

How to model software and hardware usage to predict resource consumption and conduct preconfiguration planning, and how to perform what-if scenarios about workload growth to avoid slow response times.

CONFIGURING AND TUNING:

How to tune online transaction processing (OLTP) systems, data warehouses, and replicated systems.
How to set up your system for high-performance backup and recovery.

TUNING SQL STATEMENTS:

How to get optimal performance by using Query Analyzer and Profiler to tune SQL statements and stored procedures.
How to take advantage of indexes and hints.


Want to learn more information about Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Expert Oracle PL/SQL (Osborne ORACLE Press Series) Review

Average Reviews:

(More customer reviews)Are you looking to buy Expert Oracle PL/SQL (Osborne ORACLE Press Series)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Expert Oracle PL/SQL (Osborne ORACLE Press Series). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Expert Oracle PL/SQL (Osborne ORACLE Press Series) ReviewNote the word Expert in the title of this book. This is not where you would turn to learn how to write a simple SELECT statement. This book presumes that you have a basic fundamental knowledge of how Oracle and SQL work together. The emphasis here is on the lessor used features, the newest additions to 10g Release 2, in short the information beyond what the basic programmer knowledge that helps to define the expert.
In addition to the standard programming tips, this book goes beyond the basics to look at what the database itself is doing. With more knowledge here, you can better understand what the database itself is doing when it is working on your SQL statements.
Although virtually all databases now use SQL as their basic programming language, each of the big database programs has additions or differences that make that particular version of SQL just a bit different from others. In this book, the authors concentrate on those special features as implemented by Oracle.Expert Oracle PL/SQL (Osborne ORACLE Press Series) OverviewExperienced PL/SQL programmers and Oracle developers will learn to master Oracle's procedural extension to industry-standard SQL. Using this authoritative resource, readers will become experts at developing robust, high-performance enterprise applications with PL/SQL. Detailed examples describe the practical aspect of each feature, and provide ideas to the reader of how they can best exploit the functionality.

Want to learn more information about Expert Oracle PL/SQL (Osborne ORACLE Press Series)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice) Review

Average Reviews:

(More customer reviews)Are you looking to buy Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice) ReviewI've been looking around for a book that covers the full & released version of SQL Server 2005 and this is the only one I've found so far. All of the other books appear to be based on beta versions. Something to keep in mind.
The author tackles the subject of the book in a detailed yet concise manner and this makes for an interesting read. I would definitely recommend this to people migrating to SQL Server, people new to the system, and people upgrading to the latest version.
As with any book, there are the odd few flaws in the book and some of the code can be hard to understand, but these are only small issues and certainly wouldn't devalue the book in my opinion.Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice) OverviewSQL Server 2005 is the next generation of the SQL Server database. It is the number one relational database for the Windows platform and represents a great leap forward for SQL server developers in terms of programming options, productivity, database management, and analysis. So if you have some basic knowledge of relational databases, and are looking to start a development career using SQL Server, then this book is the ideal first step.Assuming no prior knowledge of SQL Server, it teaches a database novice the core jobs and roles involved in developing for a SQL Server database for the SQL Server 2000 and 2005. It comes with a free CD containing an evaluation edition of SQL Server 2005 that you can install and then use to work through all of the tutorials, which cover:- SQL for querying, inserting, updating, and deleting data- How to build a complete databases, from fundamentals of relational database design, to creating tables, relationships, indexes, and so on- Coverage of how to back up and restore databases to get you started with basic database administration in SQL Server- How to program in T-SQL, SQL Server's implementation (and extension) of the SQL programming language- Effective programming techniques using stored procedures and triggersThis book also provides practical advice, answers typical questions that you'll encounter from managers and DBAs, and offers practical steps to overcome issues with which beginners traditionally struggle. At every stage, it establishes a range of tried-and-tested practices and techniques that mark you out as a competent developer from the very start.

Want to learn more information about Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

TOAD Handbook Review

Average Reviews:

(More customer reviews)Are you looking to buy TOAD Handbook? Here is the right place to find the great deals. we can offer discounts of up to 90% on TOAD Handbook. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

TOAD Handbook ReviewFor most TOAD users, a decent general purpose reference for understanding TOAD's plethora of features - especially the DBA module's more advanced screens, wizards and utilities.TOAD Handbook Overview
TOAD Handbook is a guide for developing Oracle applications and administering Oracle databases with TOAD. Starting with installation and configuration, the book covers the TOAD SQL editors in depth, including dozens of helpful, undocumented features. Later chapters discuss reporting and exporting data and using several add-on tools designed to enhance TOAD development. Along the way, the authors provide critical insights into the workings of TOAD and how developers can use it to make the most of their applications. Includes a foreword by Jim McDaniel, the inventor of TOAD.


Want to learn more information about TOAD Handbook?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Professional Linux Programming (Programmer to Programmer) Review

Average Reviews:

(More customer reviews)Are you looking to buy Professional Linux Programming (Programmer to Programmer)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Professional Linux Programming (Programmer to Programmer). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Professional Linux Programming (Programmer to Programmer) ReviewI bought this book hoping to familiarize myself with some of the more common methods of programming for the Linux system. The book does a fairly good job of explaining the Linux kernel, as well as introducing the basics of OpenGL and SDL for graphics. I felt that the networking section of the book was rather lax in it's discussion of forking servers and handling TCP protocols. While the book discusses the basics of programming for the Linux system, it lacks nearly any mention of bash scripting or use of the standard Linux command line tools.
While this is a good book for learning the basics, if you don't already know some programming, then some of the examples can really mess you up; the editor missed quite a few things in this book. Some of the mistakes are in the example code, some are in the author's explanations of the examples, and there are several when the author is simply describing anything new.
Overall, i would recommend this book for learning basic programming for Linux. It was very helpful for me, even with all of the grammatical and programming syntax errors.
Professional Linux Programming (Programmer to Programmer) Overview
This book is broken into four primary sections addressing key topics that Linux programmers need to master: Linux nuts and bolts, the Linux kernel, the Linux desktop, and Linux for the Web
Effective examples help get readers up to speed with building software on a Linux-based system while using the tools and utilities that contribute to streamlining the software development process
Discusses using emulation and virtualization technologies for kernel development and application testing
Includes useful insights aimed at helping readers understand how their applications code fits in with the rest of the software stack
Examines cross-compilation, dynamic device insertion and removal, key Linux projects (such as Project Utopia), and the internationalization capabilities present in the GNOME desktop


Want to learn more information about Professional Linux Programming (Programmer to Programmer)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

MySQL Admin Cookbook Review

Average Reviews:

(More customer reviews)Are you looking to buy MySQL Admin Cookbook? Here is the right place to find the great deals. we can offer discounts of up to 90% on MySQL Admin Cookbook. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

MySQL Admin Cookbook ReviewThis book is a great first attempt at a book that has been needed for a long time. It covers the everyday practical parts of managing a MySQL server.
I have been hungry for this book for a long time. Most books about MySQL focus on the SQL language and give you long chapters on how to form complex queries. Or, they dive deep into MySQL commands command and the use of my.cnf. I have a bookshelf full of these books. None have given me help making backups on-the-fly without interrupting customer services or preventing mysqldump from failing with error 2013. This book, "MySQL Admin Cookbook", covers everyday issues database administrators (DBA) face.
I'm calling it a "first attempt" because you'll get a taste of the practical side but the authors don't give you all the tools. It covers transferring connections settings between different machines with a network share. Good. It doesn't talk enough about the tools every MySQL DBA know, like MaatKit, openarkkit, mycheckpoint, mysqltuner and so many more.
Another example, Chapter 5 covers the common details for loading large data sets using the LOAD DATA INFILE command. Common. But it doesn't talk about how you can replace a CSV or MyIsam files directly with tools like mysql-replace-tables-live.
If you are NOT a DBA and MySQL is something you're using, I FULLY recommend this book. If you are a DBA, unless your new, you will find most of this book covers things you have already learned on your own.
This book starts like a very good HOWTO with replication in chapter one without mentioning
the monitoring tool mk-heartbeat. By chapter six it get cooking with good tips on analyzing, monitoring and configuring your MySQL and then simmers to an ending with managing users and schemas.
I look forward to Rev2 of this book when it really gets cooking.
99 GREAT recipes? No. Everyday foods is more what it is.
MySQL Admin Cookbook OverviewThis book uses the approach of a cookbook, presenting solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy.Administrators of all skill-levels will find step-by-step instructions for practical approaches to MySQL configuration, maintenance, and optimization topics. Each recipe uses a concrete example for easy understanding. This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will profit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to widen their MySQL horizon.It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general.

Want to learn more information about MySQL Admin Cookbook?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Oracle JDeveloper 10g Handbook Review

Average Reviews:

(More customer reviews)Are you looking to buy Oracle JDeveloper 10g Handbook? Here is the right place to find the great deals. we can offer discounts of up to 90% on Oracle JDeveloper 10g Handbook. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Oracle JDeveloper 10g Handbook ReviewThe authors told us in the introduction part of this book that it is for "both Oracle developers who want to make the transition to the J2EE environment and also Java developers who want to leverage the productivity tools and frameworks available in JDeveloper". The authors have done an good job to satisfy this scope, though I feel time by time that this is book is actually written for Oracle developers who have already exposed to Java/J2EE technology and also J2EE developers who possess basic knowledge about Oracle database technology. Otherwise, I do not recommend you to start your journey from this book. It could be too difficult. Further more, if you want to learn how to use JDeveloper 10g as your Java development tool, this book is not designed for you.
This book gives a good overview of the introductory information about JDeveloper 10g and many related J2EE technologies developed by Oracle. Such overview coverage is further enhanced by about 25 well-designed step-by-step hands-on practices, which are very helpful.
It is true that you may find a lot of learning material from Oracle Technology Network. However, I feel this book offers the unique value by covering this quite extensive and diversified subject in an organized way. By reading this book, you will certainly improve your productivity since JDeveloper 10g is a great tool and since otherwise you may feel overwhelmed by the vast amount of information you may find online.
This book is based on Oracle JDeveloper 10g production release of version 9.0.5.1. The current Oracle JDeveloper 10g production release is of version 10.1.2. I found some of the step-by-step instructions may need slight modification due to the difference of the two versions, though I do not think it posses much difficult to any experienced readers.
Chapter 5, Java Language Concepts for JDeveloper Work, gives a very brief overview of Java concepts. Well, if you need to read this chapter, you are not ready to read this book yet. The good news is that this chapter is only about 30 pages long, less than 5% of this thick book. The development of the rest of the story is in a quite logic and readable order.
The authors explain to us that "this book is a `handbook' not in the sense of a complete guide to all areas of the tool, but, .., a guide for creating J2EE applications using JDeveloper". It is interesting why they still insist to call it a handbook. This book covers only many of the basic features of JDeveloper. If you are advanced, and if you need quickly find a good coverage on an important but advanced features, most likely this is not the book that will give you an answer. Many of the books by Oracle Press are already written in somewhat quite a technical manner. Calling it a handbook may actually scare away those who are new to 10g. You do not start studying a subject by reading a handbook, do you?Oracle JDeveloper 10g Handbook OverviewCreate web and database applications with Oracle JDeveloper 10g--the complete, integrated Java development environment--with help from this comprehensive, real-world resource. Many chapters contain hands-on practices and source code examples reinforcing vital concepts. It's all here--from the nuts-and-bolts of J2EE applications, servlets, and JavaServer Pages technology to advanced development using the Oracle Application Development Framework. From the exclusive publishers of Oracle Press books, Oracle JDeveloper 10g Handbook will have you developing Java-based applications in no time.

Want to learn more information about Oracle JDeveloper 10g Handbook?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Mastering Microsoft SQL Server 2005 Express Edition Review

Average Reviews:

(More customer reviews)Are you looking to buy Mastering Microsoft SQL Server 2005 Express Edition? Here is the right place to find the great deals. we can offer discounts of up to 90% on Mastering Microsoft SQL Server 2005 Express Edition. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Mastering Microsoft SQL Server 2005 Express Edition ReviewBefore I had got this book I had been reading tutorials on the internet. I wanted a single source of information so I started looking for a book. I'm just starting to get into SQL Server and I'm going to convert an Access DB into SQL Server 2005 Express.
My experience with Access was learn as you go because I needed to get the app finished asap. By the time I was done I wanted to redo the whole app again using the knowledge I'd gained through the whole process. Now I do not have time constraints and like I said I'm going to redo the Access DB in SQL Server 2005 Express, but I didn't want to make the mistake of jumping in right away and learning as I go. So I decided to read up as much as I could before starting.
After reading this book I feel I have a solid understanding of most the aspects of SQL Server 2005 Express. What I wanted most was to learn about backups and security which this book does a good job of covering. I think the strongest attribute of the book is it reads easy and fast, but has good information. The chapters are kept short so it is easy to finish each in one sitting.
I gave it four stars because to me it is a comprehensive book, but after reading it I don't believe I have "mastered" SQL Server 2005 Express. I don't think anyone could with one book. I think it gives the reader a good base knowledge on most aspects but to master them you'd have to research further.Mastering Microsoft SQL Server 2005 Express Edition OverviewA Comprehensive Guide to Microsoft's New Express Edition of its Bestselling Database ServerMicrosoft's SQL Server 2005 Express Edition is the perfect fit if you're a small business owner, trainer, or student who doesn't need all the bells and whistles of the full version of SQL Server 2005. In this comprehensive guide written by two SQL Server experts, you'll find step-by-step explanations and simplified management tools forusing SQL Server Express in smaller-scale but still mission-critical situations. With a focus on practical tasks, the book thoroughlycovers both database administration and development, smoothly moving you from beginner to advanced subjects.Coverage Includes* Understanding basic database concepts* Getting to know database types: file server, client server, relational and more* Learning Structured Query Language (SQL) and SQL Server's Transact-SQL* Creating efficient and useful databases* Writing queries and stored procedures to explore your data* Automating the administration of your databases* Developing database applications with Visual Basic(r) Express* Using SQL Server Management Studio Express* Sharing data between multiple servers* Monitoring and optimizing SQL Server ExpressFeatured on CDCD includes Microsoft(r) SQL Server Express and Visual Basic(r) Express!Leverage the Experience of Experts through Real-World ExamplesIncrease Your Own Productivity with an Entire Chapter on TroubleshootngDiscover Practical Solutions to a Database Administrator's NeedsReduce Complexity and Build Simple Data-Driven Applications

Want to learn more information about Mastering Microsoft SQL Server 2005 Express Edition?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Applied Oracle Security: Developing Secure Database and Middleware Environments Review

Average Reviews:

(More customer reviews)Are you looking to buy Applied Oracle Security: Developing Secure Database and Middleware Environments? Here is the right place to find the great deals. we can offer discounts of up to 90% on Applied Oracle Security: Developing Secure Database and Middleware Environments. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Applied Oracle Security: Developing Secure Database and Middleware Environments ReviewThis is an excellent part 2 book for anyone looking to understand the overall Oracle security architecture. The book is easy to read and understand. Has plenty of examples that improved my understanding of the concept being discussed. I was happy that it didn't repeat the content of Knox's first book (Effective Security by Design) and was intentionally written to take the reader onto the next level of learning Oracle security. Would recommend this to any DBA and application server administrator.Applied Oracle Security: Developing Secure Database and Middleware Environments Overview
Cutting-edge techniques from leading Oracle security experts

This Oracle Press guide demonstrates practical applications of the most compelling methods for developing secure Oracle database and middleware environments. You will find full coverage of the latest and most popular Oracle products, including Oracle Database and Audit Vaults, Oracle Application Express, and secure Business Intelligence applications.
Applied Oracle Security demonstrateshow to build and assemble the various Oracle technologies required to create the sophisticated applications demanded in today's IT world. Most technical references only discuss a single product or product suite. As such, there is no roadmap to explain how to get one product, product-family, or suite to work with another. This book fills that void with respect to Oracle Middleware and Database products and the area of security.

Want to learn more information about Applied Oracle Security: Developing Secure Database and Middleware Environments?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Beginning DB2: From Novice to Professional (Expert's Voice) Review

Average Reviews:

(More customer reviews)Are you looking to buy Beginning DB2: From Novice to Professional (Expert's Voice)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Beginning DB2: From Novice to Professional (Expert's Voice). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Beginning DB2: From Novice to Professional (Expert's Voice) ReviewGood starting point for getting up and running with DB2. Not an intensive SQL coding tome but it helps you learn how to get around using the tools that are available for developing and testing programsBeginning DB2: From Novice to Professional (Expert's Voice) OverviewBeginning DB2 with Express C Edition is about the free version of IBM's leading-edge, DB2 relational database management system. It is the only introductory DB2 book in the market to be aimed at developers who do not plan to make a career out of database administration. It is written in a friendly and easy-going style that is accessible to rank beginners.

Want to learn more information about Beginning DB2: From Novice to Professional (Expert's Voice)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Business Database Systems Review

Average Reviews:

(More customer reviews)Are you looking to buy Business Database Systems? Here is the right place to find the great deals. we can offer discounts of up to 90% on Business Database Systems. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Business Database Systems ReviewTechnology is not really easy for me to understand but this book makes the concept of databases easy to grasp. I definitely recommend to students who want to learn how to construct a database.Business Database Systems OverviewBusiness Database Systems arms you with the knowledge to analyse, design and implement effective, robust and successful databases. This book is ideal for students of Business/Management Information Systems, or Computer Science, who will be expected to take a course in database systems for their degree programme. It is also excellently suited to any practitioner who needs to learn, or refresh their knowledge of, the essentials of database management systems.

Want to learn more information about Business Database Systems?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

FileMaker Pro 9 Bible Review

Average Reviews:

(More customer reviews)Are you looking to buy FileMaker Pro 9 Bible? Here is the right place to find the great deals. we can offer discounts of up to 90% on FileMaker Pro 9 Bible. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

FileMaker Pro 9 Bible ReviewWhether you are a beginner or a well-seasoned professional FMP developer, the FileMaker Pro 9 Bible is a must-read book. Dr. Cologon covers an immense range of important information, and he will stretch your mind to the full range of possibilities with FileMaker Pro, all the while holding your hand and breaking it down with a remarkably effective teaching approach.
Topics range from the general (how databases fit into real life and your business needs; comparisons with other database development tools; a broad discussion of integration with existing systems and software) through the building-blocks of FileMaker solutions, and on up to state-of-the-art advice on concepts of optimization, modularization, innovative and sophisticated user-interface design, dynamic elements, logic, cutting-edge calculations, publishing your database to the Web, FileMaker's brand-new ability to integrate tightly with SQL databases via "ESS". The book also includes the special developer tools available in FileMaker Pro Advanced, and covers topics too oft skipped over in other books on the market -- backup how-to's and strategies, must-read information about good database husbandry and file recovery, etc.
In spite of handling this vast sea of facts, particulars, instructions and guidance, there is nothing about this book that is intimidating even to folks facing database development for the very first time. Cologon -- whose crystal-clear and engaging writing style is well-known to those who have read various discussion lists and forums over the years -- has organized and presented the information in a brilliant fashion that makes this book work both as a good read and as a reference tome. Information is presented in a sort of iterative fashion, covering certain areas of development (for example, creating layouts or scripts) several times over throughout the book, on increasing levels of refinement and complexity. Therefore, whatever level of experience you have under your belt, it is easy to figure out "where to jump in" when you have a question in mind, simply by scanning the table of contents. The TOC is organized the way I wish _all_ such books were designed -- its chapters and sections correlate with the kinds of tasks you need to accomplish and the series of questions that arise in your mind organically as you gain experience, rather than the menu-by-menu approach taken by so many technical books.
A word about the book's personnel:
Ray Cologon, to anyone who has looked at his demos, attended one of his Developer Conference sessions, or read the volumes of help he has offered on forums over the years, is indisputably one of the world's topmost FileMaker wizards. Among the other credits, tech editors Corn Walker and Jason DeLooze stand out similarly as geniuses in their field who, like Cologon, have contributed their patient and top-quality assistance to the broad population of FileMaker users and developers, from newbies on discussion lists to FileMaker Inc. itself. Having been so connected to the community over the years, these developers understand intimately what folks need to know and how best to present that information, and working in concert they comprise a FileMaker instruction dream-team. (I am not familiar with the other book personnel.)
Whether you are looking for your first FileMaker Pro 9 book or already have a shelf-full, whatever level of expertise you may have, I strongly recommend you click the Add To Cart button.
-- Ilyse KazarFileMaker Pro 9 Bible OverviewRefocused and completely rewritten with the needs of business users and FileMaker Pro developers in mind, FileMaker Pro 9 Bible shows you how to design an industrial-strength database, make it intuitive, and automate it with scripts and programming. From the fundamentals to data modeling to writing no-fail code, you'll find the clear, step-by-step procedures, solid techniques, and detailed explanations you need to master this powerful software and build the right solutions for your needs.

Want to learn more information about FileMaker Pro 9 Bible?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Pro ODP.NET for Oracle Database 11g (Expert's Voice in Oracle) Review

Average Reviews:

(More customer reviews)Are you looking to buy Pro ODP.NET for Oracle Database 11g (Expert's Voice in Oracle)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Pro ODP.NET for Oracle Database 11g (Expert's Voice in Oracle). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Pro ODP.NET for Oracle Database 11g (Expert's Voice in Oracle) ReviewOverall the book has some very good examples and explanations. The introduction is very good as well. However, there are a bit too many redundant examples that seem to make the book thicker unnessarily. That being said, sometimes the detailed examples were very helpful.Pro ODP.NET for Oracle Database 11g (Expert's Voice in Oracle) OverviewPro ODP.NET for Oracle Database 11g is the "go to" book for .NET programmers wanting to use the Oracle Database. The authors are well-known for their expertise in the Oracle Data Provider for .NET. A highlight of the book is the author's application of "Gang of Four" design patterns to ODP.NET programming.

Want to learn more information about Pro ODP.NET for Oracle Database 11g (Expert's Voice in Oracle)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

SQL Server 2008 Transact-SQL Recipes (Books for Professionals by Professionals) Review

Average Reviews:

(More customer reviews)Are you looking to buy SQL Server 2008 Transact-SQL Recipes (Books for Professionals by Professionals)? Here is the right place to find the great deals. we can offer discounts of up to 90% on SQL Server 2008 Transact-SQL Recipes (Books for Professionals by Professionals). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

SQL Server 2008 Transact-SQL Recipes (Books for Professionals by Professionals) ReviewThis book is among the finest works on SQL Server which I've ever read. Joseph Sack has a well-deserved reputation for quality writing, yet I'm frankly more impressed than I expected to be. I've read many of his articles & the previous edition of this book has long been one of my favorites.
This latest-&-greatest edition, SQL Server 2008 Transact-SQL Recipes, has lots of new material & is his best yet. Joe's writing style is clear, concise, & comprehensive. The approach is unique, the chapter sections flow logically from one to anothter, yet they are written in independent vignettes for byte-sized consumption. His examples allow us to play along at home. They are accompanied by lucid explanations. The book doesn't stoop to copying code, but instead relies on unique examples followed by my favorite feature of all: "How It Works" in which the concepts are characterized in plain English. You'll enjoy it, too.
If it can be done in Transact-SQL, Joe teaches us not merely how it's done, but how it's done right. Topics run the gamut from fundamental concepts such as interrogating tables, creating views, defining indexes, & writing stored procedures, triggers, & functions, to more complex topics such as error handling & principals to newer constructions such as XML, Service Broker, CLR, spatial data, encryption, & auditing--& much more.
I used the book as my primary resource to study successfully for 70-441 & 70-442 (MCITP: DB Dev). I recommend it to all my customers. If you're a SQL Server DBA or a developer, I recommend this book is for you as well.Jimmy May
Microsoft Sr. Performance Consultant: SQL Server
SQL Server Pros, Founder & Visionary-in-Chief
Indianapolis Professional Association for SQL Server, Founder & Executive CommitteeSQL Server 2008 Transact-SQL Recipes (Books for Professionals by Professionals) OverviewWithout Transact-SQL, there is nothing. Developers and database administrators using Microsoft SQL Server 2008 are highly-motivated to learn Transact-SQL, because that language enables them to store and retrieve data, to move business logic into the database, and to interface with advanced SQL Server features. The recipe format facilitates just-in-time learning, showing readers immediately how to perform their assigned tasks, and is sure to be a hit with today's busy professional.

Want to learn more information about SQL Server 2008 Transact-SQL Recipes (Books for Professionals by Professionals)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Accelerated SQL Server 2008 (Expert's Voice) Review

Average Reviews:

(More customer reviews)Are you looking to buy Accelerated SQL Server 2008 (Expert's Voice)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Accelerated SQL Server 2008 (Expert's Voice). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Accelerated SQL Server 2008 (Expert's Voice) ReviewIn support of a current project, I was searching for whatever books I could find to help me with SQL Server 2008. This is one of the first available "credible" books I found. Credible since I have a number of other APRESS technical books that I found useful, and credible since the authors list certainly fit the lead-in on the cover - "The Experts Voice in SQL Server".
I found this book to be exactly what the title says (Accelerated) and exactly what I needed for my project effort. Let me explain - I have a significant background in database administration, and had worked on literally hundreds of SQL Server 2000 related projects. But due to job focus on other responsibilities, my exposure to SQL Server 2005 was limited to a couple of projects. So when this high profile SQL 2008 project came along, I really needed something to quickly jumpstart my learning.
As I went through the installation and the configuration of the database engine, analysis services, reporting services, and integration services in my environments, I used all the associated chapters in this book. It gave me the pertinent information, the important differences and improvements, without bogging me down in the basic things I felt I already knew.
I felt that the first 13 chapters covering primarily the database engine and associated features - Installation, Policy, Availability, Performance, Security, Monitoring, Service Broker, Full Text Search, and TSQL enhancements were very complete and excellent resource for someone with experience looking for a jumpstart. I don't see myself buying another book to supplement this knowledge - forums and whitepapers will probably be all that I will need - in the short term at least.
I admit that I skimmed the chapter or two on .Net integration and programming assemblies - but I will be back to it in a couple of weeks to be sure.
Since this current project requires a good deal of XML based data integration between our existing world and this new application - the chapters on XML and XQuery were of particular interest to me. I found them a valuable and complete introduction. The next few months of the project will show how valuable this really was, but I came away feeling pretty good about what we might be able to do to leverage this.
Because my work for the past couple of years has been focused on BI, I went through those last three chapters covering Business Intelligence (analysis server, reporting services, integration services) multiple times. First to do the installation and configuration, second to see what I was that I missed, and a final time to understand what I thought the authors had missed. This section provides a good basic intro to the products, and gives you what you need to get them setup and functional. To exploit them however, you will need to look for further resources.
You can look at this book as a focused set of expert recommendations, advice, and key bullet points around its 3 major divisions - the Enterprise data platform (I rate it excellent in that coverage), development in SQL Server (I'd rate it good, but I know I need to read it again), and Business Intelligence (I'd rate it useful, but basic in the coverage).
What this book is not, is an in-depth and complete coverage of all the specifics of each of the SQL 2008 vertical product features. If your primary interest is in one of those features outside the database engine itself - Reporting Services or Analysis Services, you will need to follow this book up with one of the detailed and targeted books.
At the end of the day - this book gave me exactly what I needed, when I needed it. That makes it a good book in my view, a keeper for my top bookself, and one I can recommend to others in similar circumstances.
Accelerated SQL Server 2008 (Expert's Voice) OverviewAccelerated SQL Server 2008 is a fast introduction to SQL Server 2008 for experienced database professionals. The book appeals to readers who are smart, who learn fast, and who do not want to wade through a large amount of introductory material. The goal is to impart the essentials of using SQL Server 2008 as quickly as possible.

Want to learn more information about Accelerated SQL Server 2008 (Expert's Voice)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

HOWTO Secure and Audit Oracle 10g and 11g Review

Average Reviews:

(More customer reviews)Are you looking to buy HOWTO Secure and Audit Oracle 10g and 11g? Here is the right place to find the great deals. we can offer discounts of up to 90% on HOWTO Secure and Audit Oracle 10g and 11g. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

HOWTO Secure and Audit Oracle 10g and 11g ReviewI can really recommend this book to anybody who is interested in making Oracle database systems more secure and to get an overview of all the security features and possibilities of current Oracle database releases. It covers versions 10g and 11g and contains not only excellent explanations of the different features but also practical examples of how to implement them. A highlight of the book is the focus on consequences of different features on database performance. The reader can really profit from the authors expertise in this area of technology.HOWTO Secure and Audit Oracle 10g and 11g OverviewOracle is the number one database engine in use today. The fact that it is the choice of military organizations and agencies around the world is part of the company's legacy and is evident in the product. Oracle has more security-related functions, products, and tools than almost any other database engine. Unfortunately, the fact that these capabilities exist does not mean that they are used correctly or even used at all. In fact, most users are familiar with less thantwenty percent of the security mechanisms within Oracle. Written by Ron Ben Natan, one of the most respected and knowledgeable database security experts in the world, HOWTO Secure and Audit Oracle 10g and 11g shows readers how to navigate the options, select the right tools and avoid common pitfalls. The text is structured as HOWTOs addressing each security function in the context of Oracle 11g and Oracle 10g. Among a long list of HOWTOs, readers will learn to: choose configuration settings that make it harder to gain unauthorized access understand when and how to encrypt data-at-rest and data-in-transit and how to implement strong authenticationuse and manage audit trails, and advanced techniques for auditingassess risks that may exist and determine how to address them make use of advanced tools and options such as Advanced Security Options, Virtual Private Database, Audit Vault, and Database Vault.The text also provides an overview of cryptography, covering encryption and digital signatures and shows readers how Oracle Wallet Manager and orapki can be used to generate and manage certificates and other secrets. While the book'sseventeen chapters follow a logical order of implementation, each HOWTO can be referenced independently to meet a user's immediate needs. Providing authoritative and succinct instructions highlighted by examples, this ultimate guide to security best practices for Oracle bridges the gap between those who install and configure security features and those who secure and audit them.

Want to learn more information about HOWTO Secure and Audit Oracle 10g and 11g?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

PostgreSQL 9 Admin Cookbook Review

Average Reviews:

(More customer reviews)Are you looking to buy PostgreSQL 9 Admin Cookbook? Here is the right place to find the great deals. we can offer discounts of up to 90% on PostgreSQL 9 Admin Cookbook. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

PostgreSQL 9 Admin Cookbook ReviewAs the book title suggests, it's a cookbook, but a cookbook that combines a question and answer style with a discussion style of writing. The tasks are neatly categorized into 12 chapters and each task smoothly builds on previous tasks discussed. It is still categorized in such a way that you can jump to a particular task you are currently having problems with without having read the other parts of the book.
Although it is titled PostgreSQL 9 -- it covers earlier versions as well.
This is one of those books I wish I had when training some of our customers or had early on. A lot of the questions - we are commonly asked or have stumbled on - like how to troubleshoot bad queries, how to tell what are my biggest tables, how to deal with data corruption etc, are all succinctly covered in this book.
Just to get a taste of what this book offers:
1. Chapter 1: First steps This is mostly a newbie chapter, that introduces you to PostgreSQL, guides you thru connecting to the database using commandline and PgAdmin. Some other examples of commonly used GUIs. Configuring access control, troubleshooting failed connections. It provides tips both for the Linux as well as the Windows user.
2. Chapter 2: Exploring the database starts to get into what I would call intermediate territory. It covers tasks such as determining where your database files are, how to determine disk space utilization for both whole database and individual tables. Getting quick estimate of number of rows for large tables where doing a count would be really slow. Using psql and the various system tables to determine object dependency.
3. Chapter 3: Configuration A good chapter not just for PostgreSQL users but I would say any database designer. I think this chapter holds useful nuggets for all levels of users. It covers basic considerations when planning your database and based on the needs how to configure the key PostgreSQL configuration settings by server, user, and database. It had tricks like how to determine which parameters are at non-default settings. I am ashamed to admit, that I learned a lot from this chapter. Stuff I really should have known before. My only lame excuse is that PostgeSQL has always worked so well, that I never had a need to delve into these nuances.
4. Chapter 4: Server Control - A very intermediate chapter slowly getting into more nuances. It covers connection pooling, viciously and not so viciously kicking users off, gracefully shutting down, using schemas to partition data. Again a lot of stuff here I didn't know so will have to reread when I find myself in these situations.
5. Chapter 5: Tables & Data - This chapter covers general good practices for namings tables and other objects, setting up keys, finding duplicate data, deleting duplicate data, . My favorite pasttime, techniques to generate test data. It concludes with loading data from flat files and csv files. Fundamentals of using pgloader utility created by Dmitri Fountaine.
6. Chapter 6: Security Covers new GRANT management in PostgreSQL 9.0, setting up users, auditing DDL and data changes, integrating with LDAP, using SSL, ensuring secure passwords, and encrypting data with pgcrypto.
7. Chapter 7: Database Administration - starts getting a bit into creating functions using plpgsql, plproxy. Running SQL scripts in parallel. Fundamentals of PostgreSQL DDL such as creating schemas, tablespaces and setting new configuration options for those introduced in 9.0. Moving objects to different schemas and tablespaces.
8. Chapter 8: Monitoring and Diagnosis - covers how to catch blocking queries, query monitoring. Using pgFouine for log processing and alerting you of issues. The thing I most enjoyed about this chapter were the cut and paste queries utilizing various PostgreSQL system tables to track down issues.
9. Chapter 9: Regular Maintenance - this topic is normally a very dry one,at least for me. It covers fundamentals you should know, like backup,recovery testing, reclaiming space, transaction wrap around (less of an issue with newer versions of PostgreSQL), but that puts a narcoleptic like me into a comatose state. I awoke when reading the topic of Carefully removing unwanted indexes. It shows you how to turn indexes off without removing them so you can see if they are really useful. I've really got to try this one out.
10. Chapter 10: Performance & Concurrency - My favorite chapter. Can't get enough of this stuff. Just read it. You'll learn a lot regardless your walk of life.
11. Chapter 11: Backup & Recovery - Covers using PostgreSQL specific tools such as pg_dump and other tools such as rman and rsynch for doing differential backups.
12. Chapter 12: Replication and Upgrades - It covers replication terminology, the new 9.0 streaming replication, hot standby as well as longtime favorites like Londiste, Slony-2.0 and load balancing with pgpool, and using pg_upgrade.
PostgreSQL 9 Admin Cookbook OverviewWritten in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases on PostgreSQL. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order. This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases. This book is most suited to those who have some technical experience.

Want to learn more information about PostgreSQL 9 Admin Cookbook?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

The Guru's Guide to Transact-SQL Review

Average Reviews:

(More customer reviews)Are you looking to buy The Guru's Guide to Transact-SQL? Here is the right place to find the great deals. we can offer discounts of up to 90% on The Guru's Guide to Transact-SQL. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

The Guru's Guide to Transact-SQL ReviewAh, where to begin. This book is a masterpiece. It is over the top. It distills, in one volume, all that's worth knowing about advanced Transact-SQL. If you've read the Books Online, this book is a natural next step in your T-SQL education. It took me from a rank amateur to an advanced coder within days. It gave me insights into new ways of coding that I'd never have thought of on my own. It showed me how to work in harmony with T-SQL and SQL Server, rather than try to get them to do things they weren't designed to do.
The best chapters, are, IMHO, these:
- DML Insights
- DDL Insights
- The Mighty SELECT
- Statistical Functions
- Transactions
- Cursors
- Sets
- Arrays
- Stored Procedures and Triggers
- T-SQL Performance Tuning
- Administrative T-SQL
- OLE Automation
- Undocumented T-SQL
There's so much good info in this book, it's hard to pick a list of the "best chapters." To be sure, there's not a weak chapter in the book, and you should read every last one of them.
[...] This book is a must-read for anyone serious about coding in Transact-SQL.The Guru's Guide to Transact-SQL OverviewSince its introduction over a decade ago, the Microsoft SQL Server query language, Transact-SQL, has become increasingly popular and more powerful. The current version sports such advanced features as OLE Automation support, cross-platform querying facilities, and full-text search management. This book is the consummate guide to Microsoft Transact-SQL. From data type nuances to complex statistical computations to the bevy of undocumented features in the language, The Guru's Guide to Transact-SQL imparts the knowledge you need to become a virtuoso of the language as quickly as possible. In this book, you will find the information, explanations, and advice you need to master Transact-SQL and develop the best possible Transact-SQL code. Some 600 code examples not only illustrate important concepts and best practices, but also provide working Transact-SQL code that can be incorporated into your own real-world DBMS applications. Your journey begins with an introduction explaining language fundamentals such as database and table creation, inserting and updating data, queries, joins, data presentation, and managing transactions. Moving on to more advanced topics, the journey continues with in-depth coverage of: Transact-SQL performance tuning using tools such as Query Analyzer and Performance Monitor Nuances of the various T-SQL data types Complex statistical calculations such as medians, modes, and sliding aggregates Run, sequence, and series identification and interrogation Advanced Data Definition Language (DDL) and Data Management Language (DML) techniques Stored procedure and trigger best practices and coding methods Transaction management Optimal cursor use and caveats to look out for Full-text search Hierarchies and arrays Administrative Transact-SQL OLE Automation More than 100 undocumented commands and language features, including numerous unpublished DBCC command verbs, trace flags, stored procedures, and functions Comprehensive, written in understandable terms, and full of practical information and examples, The Guru's Guide to Transact-SQL is an indispensable reference for anyone working with this database development language. The accompanying CD-ROM includes the complete set of code examples found in the book as well as a SQL programming environment that will speed the development of your own top-notch Transact-SQL code.

Want to learn more information about The Guru's Guide to Transact-SQL?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Beginning SQL Server 2008 Express for Developers: From Novice to Professional Review

Average Reviews:

(More customer reviews)Are you looking to buy Beginning SQL Server 2008 Express for Developers: From Novice to Professional? Here is the right place to find the great deals. we can offer discounts of up to 90% on Beginning SQL Server 2008 Express for Developers: From Novice to Professional. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Beginning SQL Server 2008 Express for Developers: From Novice to Professional ReviewI realize this is a beginners' book and accept that technical depth wouldn't be appropriate; however, many examples of what to execute in the query window lack explanation as to what the lines mean. While at other points in the book, the author takes the time to do so. This doesn't aid in learning anything if you are simply entering what you see.
Additionally, there are numerous missed steps in the progression the author is taking you through. It's as if you skipped an entire paragraph because he makes sudden jumps as to where you should be.
Now, if this wasn't a beginners' book, it would be proper for an author to assume a certain level of knowledge but a beginners' book should not assume this. At first I accepted a few of these but I am now at the half-way point in the book and find it very irritating that gaps in how he arrived at where he is and the reasons he had me execute a particular SQL script is irritating. I bought the book to learn Why What and Where; not execute this and there you go, good luck.
Beginning SQL Server 2008 Express for Developers: From Novice to Professional OverviewExpress Edition is a free version of SQL Server 2008 that is an excellent choice for those with modest database needs. Robin Dewson's book on the 2005 edition-according to current sales velocities-is one of the top three best-selling titles on Express Edition. Apress is releasing the 2008 edition of Dewson's book very early in the SQL Server 2008 life-cycle, from where it should go on to capture significant market-share.

Want to learn more information about Beginning SQL Server 2008 Express for Developers: From Novice to Professional?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Beginning SQL Server 2008 for Developers: From Novice to Professional (Expert's Voice in SQL Server) Review

Average Reviews:

(More customer reviews)Are you looking to buy Beginning SQL Server 2008 for Developers: From Novice to Professional (Expert's Voice in SQL Server)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Beginning SQL Server 2008 for Developers: From Novice to Professional (Expert's Voice in SQL Server). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Beginning SQL Server 2008 for Developers: From Novice to Professional (Expert's Voice in SQL Server) ReviewThis book was a great introduction to MS SQL Server, but I honestly don't think it would be as helpful to new developers as it would be for new DBAs, for the following reasons:
1) No real relational database theory review
2) SQL not really introduced till over halfway through the book
3) Some terms randomly mentioned, then never explained (such
as "computed columns")
4) IIs and other pre-2008 server references
5) Cursors not mentioned... also wish there had been some text on
accessing the database via different languages.
Not all of the examples worked. I eventually figured out everything, but had a really difficult time understanding the descriptions of some of the concepts; some were too wordy and some too terse. The last chapter on Reporting Services was almost completely useless because he didn't show you how to deploy the reports... this would have been pretty easy (I found it in another book). Because of this, I can't recommend this for beginning developers either.
HOWEVER, having said all that, there are several reasons why you should get the book:
1) Covers quite a bit of material which I don't think the other texts
will, such as security, back-ups, recovery, system databases, etc.
2) Walks you through a complete installation and set-up of SQL Server.
3) Every chapter has relevant exercises, so if you have trouble getting
through the text, there is at least an example.
4) Filled with a lot of helpful "gotchas" that I could tell were
learned the hard way.
5) His writing style is friendly and unpretentious. This is a BIG plus;
I have plenty of dusty books written by 5 or more pompous people
that make no sense that are really just trying to impress you with
how smart they are instead of teaching you something.
I have finally come to the conclusion that you probably need several books on any given technical subject to overcome the shortcomings of the other. This particular book is a good one to start with, I think.Beginning SQL Server 2008 for Developers: From Novice to Professional (Expert's Voice in SQL Server) OverviewBeginning SQL Server 2008 for Developers is the starting-point in the Apress roadmap of titles for developers who wish to base their projects upon Microsoft's flagship database management system. The book takes developers from the point of installing SQL Server 2008, through the process of storing, retrieving, and securing data, to the point of being able to serve up business reports using SQL Server 2008 Reporting Services.

Want to learn more information about Beginning SQL Server 2008 for Developers: From Novice to Professional (Expert's Voice in SQL Server)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...