Refactoring SQL Applications

What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. Refactoring SQL Applications provides a set of tested options for making code modifications to dramatically improve the way your database applications function. Backed by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems.

Moving and Accessing SAS 9.2 Files

Explains the steps for moving SAS files across operating environments. Strategies include the Cross-Environment Data Access feature of directory-based operating environments, the CPORT and CIMPORT procedures, the XPORT engine with the DATA step or COPY procedure, and the XML engine with the DATA step or the COPY procedure.

Oracle PL/SQL by Example, 4th Edition

This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example, Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers.

One step at a time, you’ll walk through every key task, discovering the most important PL/SQL programming techniques on your own. Building on your hands-on learning, the authors share solutions that offer deeper insights and proven best practices. End-of-chapter projects bring together all the techniques you’ve learned, strengthening your understanding through real-world practice.

SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach

SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.
Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
Current: Newly updated for SQL Server 2008.
Comprehensive: Covers 30 different Transact–SQL problem domains.

MySQL

В книге описана одна из самых популярных реляционных систем управления базами данных MySQL Вместо простого обзора возможностей MySQL, автор показывает, как можно максимально эффективно использовать эту СУБД. На примере двух тестовых баз данных он приводит рецепты решения проблем, с которыми вы обязательно столкнетесь при практическом использовании MySQL. Вы научитесь интегрировать MySQL с программными средствами, разработанными сторонними компаниями, такими как компиляторы языков РНР и Perl, которые позволяют с помощью запросов к базе данных создавать динамические Web-страницы. Кроме того, здесь приведен обширный справочник по типам столбцов, операторам, функциям, синтаксическим конструкциям языка SQL
интерфейсам С API, Perl DBI и РНР API.

В книге предоставлена уникальная информация, которую вряд ли можно получить где-нибудь еще. Книга рассчитана на пользователей и разработчиков систем клиент/сервер на основе MySQL.
Эта книга содержит:

Общую информацию по MySQL и языку запросов SQL;
Описание типов данных MySQL и их применение;
Советы по оптимизации запросов;
Полный курс обучения процедуре создания клиентских программ на языке программирования С;
Руководство по использованию интерфейсов Perl DBI и РНР APIдля создания приложений, работающих из командной строки и Web-приложений;
Советы по вопросам администрирования (ведение учетных записей пользователей, резервное копирование, восстановление после сбоев и безопасность) ;
Помощь в выборе провайдерадоступа к MySQL;
Полная справка по типам данных MySQL, операторам, функциям и утилитам;
Полные справочники по программным интерфейсам MySQL С API, Perl DBI API и РНР;

Ajax in Oracle JDeveloper

Asynchronous JavaScript and XML (Ajax) is a web technique used to transfer data between a browser and server asynchronously without posting the web page to the server. "Asynchronously" implies that the processing of the web page continues while the Ajax request is sent to the server and a response is received from the server. The web page, or section(s) of the web page, is refreshed with the Ajax response without reposting the web page. Ajax has the following advantages over non-Ajax web applications.
- Reduced response time and reduced server load, as the complete web page is not reposted.
- Reduced bandwidth of web applications as only data is transferred and the HTML format is applied in the browser.
- Separation of data, format and style.

Oracle Database 11g: New Features for DBAs and Developers

Oracle Database 11g: New Features is a comprehensive, example-laden review of the most significant new features and improvements offered by the latest release of Oracle Corporation’s flagship database product.
Learn what’s new in Oracle that really counts.
See actual examples and test run output.
Make sound decisions on new feature adoption.

Oracle Database 10g Performance Tuning Tips & Techniques

“Offers hundreds of hints, tips, and tricks of the trade that can be useful to any DBA wanting to achieve maximum performance of Oracle applications. No Oracle library would be complete without this book.” –Ken (Dr. DBA) Jacobs, Vice President of Product Strategy for Server Technologies, Oracle Corporation

“Rich is the first and last stop for Oracle Database technology and performance tuning. His knowledge is a vital tool that you need to successfully negotiate the waters of Oracle database development.” –Mike Frey, Principal Architect, Navteq

SQL Server 2005 Management and Administration

Microsoft SQL Server 2005 Management and Administration, based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, and monitoring. With coverage of the new features and functionality of SQL Server 2005 Service Pack 2, this book is designed to be comprehensive, resulting in something for all database administrators—from simple tips to tactical solutions. Microsoft SQL Server 2005 Management and Administration goes far beyond the basic installation and setup information found in many other resources. The book looks at day-to-day administration, best practices, tips, and step-by-step configurations based on real-world examples found in the industry. Unlike others, this book includes not only administration and management details on the Database Engine, but also coverage of other SQL Server 2005 components often overlooked, including Analysis Services, Reporting Services, and more.

Oracle Magazine - March/April 2008

Operating and maintaining legacy systems consumes up to four-fifths of every IT budget. This fiscal necessity puts IT managers in a bind: They need to take advantage of open systems, serviceoriented architecture, and other modern technologies, but they can’t afford to discard the content of their legacy business systems. See how Oracle helps companies modernize their applications, middleware, and databases while preserving the business-specific information they need.