Kategoria BISAC: Computers >> Database Administration & Management

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...

Stored procedures are compiled T-SQL statements that reside on the database. They are the cornerstones of successful data manipulation, and data-handling operations of every complexity make use of them. This book is an in-depth guide to a key area of database development.

This book tackles real-world problems faced by developers when working with stored procedures, showing you how to solve these problems, avoid the common pitfalls, and produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you.

Database design is one of the most contentious issues in computer science. There is always a delicate balance to be struck between the strict academic rules that govern the design of relational databases and the real-world techniques that programmers apply to get the job done in a certain time frame. This book's goal is to coverfrom a "real-world" point of viewall of the essential elements in designing, modeling, and building efficient relational databases, while avoiding a dry, theoretical approach.

Author Louis Davidson explains the process of implementing a...

Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically achieved using a database. If you're building or maintaining any significant application and are using MySQL, this book is for you. For open source and other types of projects, the MySQL database is a very popular choice: it's free, fast, robust, and scalable, and it runs on all of the major platforms, allowing maximum use of available hardware resources. But it's easy to disregard MySQL's speed and other advantages if your database design is...

JDBC is the most commonly used API in Java to access and manipulate data in a database. Oracle is one of the most popular and scalable databases in the world. This book is a must-have for any developer building an application that employs JDBC on Oracle database. Unlike other JDBC books, this book has been written to complement not rehash the contents of Oracle JDBC documentation and the JDBC specification.

The book teaches you not just how to write JDBC code, but how to write effective JDBC code in a step-by-step fashion. This book does not assume any prior knowledge of JDBC,...

Many SQL Server-based applications perform far below expectation costing money and time. And until now, there has been very little practical information available that explains how to identify and cure performance problems in SQL Server. But this book offers essential content to fill in the gap.

SQL Server Query Performance Tuning Distilled, Second Edition includes updated material plus one new chapter, and explains how to design and tune SQL Server applications to cope with ever-increasing workloads. With proven strategy, this book teaches you how to use SQL Server tools to...

* One of the very few resources that is specific to the Oracle database, rather than being database generic.

* Written by a recognized expert, who has based the book on his extensive experience administering and performance-tuning PeopleSoft systems.

*Explains Oracle programming using both C# and VB.NET languages; provides a one-stop reference for VS.NET developers working with Oracle.

*Excellent resource for J2EE programmers in environments considering moving to a .NET environment (and retaining the Oracle database).

PostgreSQL is arguably the most powerful open-source relational database system. It has grown from academic research beginnings into a functionally-rich, standards-compliant, and enterprise-ready database used by organizations all over the world. And it's completely free to use.

Beginning Databases with PostgreSQL offers readers a thorough overview of database basics, starting with an explanation of why you might need to use a database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets. You'll also learn...

Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world's most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or youre a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you.

The first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. The...

Real Application Clusters (RAC) and the Grid architecture are Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many other topics.

The RAC-specific technologies described include configuration of the...

Pro SQL Server 2005 Database Design and Optimization will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.

The authors also describe how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization, and strategies for increased scalability to support large numbers of concurrent users. They provide in-depth advice on optimal code distribution in SQL...