Guide to Oracle 11g and Database Migration
Oracle Database 11g includes more features for self-management and automation, which makes it easier for customers to cost-effectively manage their data. Download this Internet.com eBook for an overview of some of the new features in 11g and for an overview of the issues you need to consider as you prepare for a database migration.
»
Solaris 8 Migration Assistant Rapidly move your Solaris 8 application environments to new systems running Solaris 10 with the Solaris 8 Migration Assistant. Reduce migration risk while taking advantage of increased performance, reliability and security of the latest SPARC hardware platforms and Solaris 10 OS. »
eBook: Storage Networking 2, Configuration and Planning Sponsored by HP
Learn best practices and cover the general concepts you must know before configuring SAN-attached storage. The most critical part of setting up a SAN is configuring each individual disk array. This guide examines configurations for SAN-attached servers and disk arrays, and also includes a look at the future of IP storage. Learn more.
Intrinsic Member Properties: The MEMBER_CAPTION Property5/22 Architect Bill Pearson introduces the intrinsic MEMBER_CAPTION property. In hands-on
exercises, we gain exposure to the use of the property in generating simple
lists, as well as datasets to support report parameter picklists.
Table-valued parameters – SQL Server 20085/21 In previous versions of SQL Server, it has not been possible to pass a table variable, as a parameter, to a stored procedure. Microsoft introduces table-valued parameters, along with other features, in SQL Server 2008. This article illustrates the function and usage of table-valued parameters.
On Seeing Double in V$SQL5/22 Our technologist looks at SQL repetition in V$SQL and differences in cardinality.
SQL Server backups using SAN database snapshots5/22 One of the toughest things about managing a big database is the backup window: The bigger a database gets, the longer SQL Server backups take.
Understanding roles in Oracle-stored procedures5/21 One of the trickiest parts of Oracle's security model is the way that roles (collections of database privileges) interact with stored procedures, functions, and packages.
LyteRAD (Lytecube.com) Integrated application development framework for light-weight database applications; a Java framework for building standalone applications.
Hierarchial Loop III This script displays all of the employees working under a particular employee in a string, separated by a '|' as delimiter.
Test SQL Connectivity This script tests connectivity to SQL Server box from a client machine when there is no SQL Client.
Database Physical & Actual Size Useful on Oracle 8.1.7 onwards or remove the dba_temp_files line & run for earlier versions.
