EBooks » Database

Offers example-based coverage for various high availability solutions.

  • High availability is becoming an increasingly important topic for database administrators, data architects and system architects.
  • Covers choosing, planning, implementing and administering a high availability solution along with the business justifications.
  • Paul Bertucci has over 20 years of database experience including consulting for numerous Fortune 500 companies


 

SQL Server Reporting Services 2005 is the latest version of the reporting technology from Microsoft, providing the means to design, author, render, and deploy business reports to users, customers, and employees, via the web or the company intranet. The reporting engine is built in to the SQL Server 2005 database (and provided as a free add-on with SQL Server 2000) and the report manager is integrated with Visual Studio 2003, providing an effective and familiar environment for all SQL Server and .NET developers.

The book was written in parallel with a migration project, moving some 200 professional healthcare reports from various reporting architectures to SQL Server Reporting Services, and so is steeped in the day-to-day challenges, discoveries, and successes involved in delivering a successful reporting solution with this technology. In this book, you will find step-by-step guides, best practices, and real code examples that cover all of the common Reporting Services tasks.

Oracle PL/SQL for DBAs

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.

Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examplesUsing Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM,
DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.

DBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource.

Written by the world's top SQL programmers, this eBook utilizes their substantial knowledge in SQL database programming. With combined experience of over a century, these experts share their secrets for programming with SQL. This is an advanced eBook that explores topics such as using advanced SQL constructs and writing programs that utilize complex SQL queries. Not for the beginner, this eBook explore complex time-based SQL queries, managing set operations in SQL, and relational algebra with SQL. This is an indispensable handbook for any developer who is challenged with writing complex SQL inside applications.
Take Full Advantage of The Database and Analysis Potential of SQL Server 2005

Get full details on all the innovative features and benefits available in the upcoming release of SQL Server 2005. This authoritative guide explains the new and improved enterprise data management capabilities, developer functions, and business intelligence tools. You’ll see how the new release offers enhanced scalability, availability, and security, as well as ease-of-use. Written by the Senior Technical Editor of SQL Server Magazine, this is an ideal resource for decision-makers, developers, and DBAs preparing for upgrades or migration.


About the Author: Michael Otey is Senior Technical Editor of SQL Server Magazine, Technical Director of Windows IT Pro Magazine, and co-author of SQL Server 2000 Developer’s Guide and SQL Server 7 Developer’s Guide, both from McGraw-Hill/Osborne. He is the president of TECA, Inc., a software development and consulting firm.

 
Username:
Password:
 
Sign Up | Lost Password
 
 

Execution time : 0.00911712646484