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. »
Whitepaper: Best Practices for Microsoft Exchange 2007 with HP Server and Storage in Mid-range Sponsored by HP
Get configuration and performance data, best practices, and recommendations to help system administrators deploy Microsoft Exchange Server 2007 on several of the HP MSA family of products. Learn to perform pre-deployment planning and ensure adequate hardware and predictable performance for your specific business requirements. Learn more.
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.
DB2 9.5 and IBM Data Studio - Part 10: Building Stored Procedures5/19 Learn how to take an SQL statement that you built using either
the SQL Editor or the SQL Builder and quickly turn it into a deployed SQL/PL stored
procedure. In addition, this article explains how to move a data development
project between servers.
Posting Microsoft Access Information “Into the clouds”5/16 Part one of this article demonstrated how to retrieve data and save it into XML using Microsoft Access and MSXML. Part 2 shows how to add new data to a Web2 website ("in the clouds").
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.
Tips for moving from SQL Server local disk storage to SANs5/20 SANs are definitely complicated and expensive relative to local disk storage for SQL Server, but there are only a few things database administrators really need to know to get started.
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.
