Kategoria BISAC: Computers >> Database Administration & Management

-Explains how to model databases with Microsoft(R)...

Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis.This book provides a concise reference to the enormous store of information an...

This concise book contains detailed information about Oracle internals -- information that's not readily available to Oracle customers. It lays a foundation for advanced performance tuning of the Oracle database. Based on Oracle8i release 8.1, the book describes many of the secrets of Oracle's internal services: data structures, algorithms, and undocumented Oracle system statistics. Main topics include:

Waits - how Oracle processes communicate via semaphores, and how to use the Oracle wait statistics to identify the source of performance problems.Latches - how they keep...

This unique cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Authors Ales Spetic and Jonathan Gennick, two authorities with extensive database and SQL programming experience, include a discussion with each recipe to explain the logic and concepts underlying the solution.SQL (Structured Query Language) is the closest thing to a standard query language that currently exists, and Transact-SQL...

SQLLoader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQLLoader is to load data from flat files into an Oracle database. It's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format.Almost every Oracle user has to use SQLLoader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite...

* Describes the IBM WebSphere versions 4.0 and 5.0 architecture from a nuts and bolts level, giving visibility to the technology and underlying WebSphere platform design

* Describes how to proactively manage the performance of an IBM WebSphere v4 or v5 platform

* Thorough descriptions of tuning WebSphere with performance and robustness in mind

* Teaches the reader how to develop custom IBM WebSphere performance monitoring and management tools

* Presents an innovative, philosophical approach to Oracle database administration, and shows how to think about the whole complex problem of performance tuning, how to break it down, how to root out the cause of performance bottlenecks.

*Covers all practical aspects of Oracle performance tuning.

* Filled with hands-on lessons and accounts.

* Teaches an innovative and effective "Physician to Magician" approach, showing how to understand the problem, uncover the root cause, and choose and implement the most effective solution.

Do you need more from a PL/SQL book than just the correct keywords and some pretty syntax diagrams? Have you been searching in vain for real-world examples and genuine strategies for maximizing the benefits of PL/SQL within your organization? You'll find them here in Mastering Oracle PL/SQL: Practical Solutions, the inaugural title of the pioneering OakTable Press series from Apress.

This isn't a tutorial on how to code PL/SQL. It's designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and wont break in high-load, multiuser...

SQL Server is the dominant relational database in the Windows market and data security is a huge and growing concern for all businesses. Securing SQL Server is one of the most important responsibilities of the SQL Server professional.

SQL Server Distilled, Second Edition is a very carefully researched, clearly explained book on securing SQL Server, by an author who knows SQL Server inside and out. If you follow the practical guidelines that are clearly set out in this book, then you stand a very good chance of making sure that the data stored in your database is secure and...

Beginning Visual Basic 6 Database Programming introduces you to databases and takes you all the way through to the latest ADO technologies in Visual Basic 6. Step by step, this book will help you to build working database components and applications in Visual Basic. Whether you want to work with databases on your desktop, get access to legacy data, or program database access across the Internet, this is the book that will get you started.

This book provides you with all the practical knowledge and skills you need to build a solid foundation in Microsoft Access and Visual Basic...

Although less publicized than other open source database management systems, Firebird continues to gain a dedicated following of professional users. Figures have already reached hundreds of thousands worldwide, in Firebird's shorthistory in open source. And until now, no other book has been available.

This is the first, official book on Firebird--the free, independent, open source relational database server that emerged in 2000. Based on the actual Firebird Project, this book will provide all you need to know about Firebird database development, like installation, multi-platform...