Database

The challenge of server sprawl, coupled with the desire to reduce energy costs and the increasing demand for computer resources and rack space, make today an ideal time to consider Microsoft SQL Server 2005 for database consolidation in 64-bit computing environments.
This article will focus on:

A clear understanding of the problem of server sprawl

Steps for a […]

This SAP Insight explores the importance of master data and the barriers to achieving sound master data, describes the ideal master data management solution, and explains the value and benefits of effective management of master data.
Many organizations operate under the belief that they are using master data, but the truth is that they are relying […]

Richard and I run a panel discussion on the compliance features of SQL Server 2008 while at Tech Ed US IT Pro week in Orlando, Florida. The discussion focuses around the tools built into SQL Server to make it easier to support compliance requirements like SOX and PCI.
The SQL Server Compliance Panel is made up […]

Richard and I talk to Allan Hirt about using virtualization with SQL Server. Allan digs into where virtualization makes sense for SQL Server and when it doesn’t. And yes, its true, sometimes virtualizing SQL Server really does make sense!
Allan Hirt has been using SQL Server in various guises since 1992. For the past ten years, […]

Richard and I talk to Erin Welker about Data Partitioning in SQL Server 2005 and 2008. Erin digs into the advantages of partitioning for OLTP and OLAP, as well as the changes between 2005 and 2008. Check out Erin’s blog here.
Erin has spent 25 years in Information Technology development, management, database administration and business intelligence. […]

This course is designed to complement the Oracle two-day DBA documentation.
In this free course you will find detailed information on the tasks outlined in the chapters of the Oracle two-day DBA manual, including step-by-step instructions.
List of Lessons

Introduction

Installing Oracle and Building the Database

Getting Started with Oracle Enterprise Manager

Configuring the Network Environment

Managing the Oracle Instance

Managing Database Storage […]

This paper examines Oracle Accelerate to determine whether it has what it takes to deliver genuine value to midsize organizations.
Oracle Accelerate does a remarkably thorough job of addressing the issues that midsize organizations wrestle with on a daily basis. Based on a comprehensive and pragmatic approach, Oracle Accelerate offerings may meet the requirements of these […]

Learn how to reduce query response time from hours to seconds, support real time data warehousing, optimize your storage and lower operating costs.
Today, data warehouse users face novel and demanding challenges. Data is growing rapidly due to diverse market forces. User populations are rising sharply to support new activities like Business Intelligence and self service […]

Discover how to lower computer energy costs by reducing workstation power consumption without impacting user productivity.
Most organizations considering green computing initiatives start in the data center, but the cold hard truth is that in many organizations more computing power and heat waste is generated outside of the data center. Saving energy, power, and cooling also […]

We recently conducted an interview with Michael Manos, Senior Director of Data Center Services at Microsoft, on RunAs Radio. Microsoft’s been working on a substantial set of data center build-outs, and so Richard and I figured there’s a lot we can all learn from someone like Michael. Not many people have to think as carefully […]

This white paper outlines how modern data grid technologies can improve data availability, performance and scalability when implementing an SOA.
When choosing an SOA strategy, corporations must rely on solutions that ensure data availability, reliability, performance, and scalability. Read this white paper, look at the challenges in selecting an SOA strategy, and how clustered caching can […]

Read this in-depth analysis of 56 customers showed significant differences between the value delivered to SMBs by Oracle and SAP today.
With both Oracle and SAP ramping up their efforts to attract small and medium-sized businesses (SMBs) to their enterprise applications, many have wondered: can they deliver successful deployments to smaller customers?
As Nucleus has found […]

This paper examines Oracle Accelerate to determine whether it has what it takes to deliver genuine value to midsize organizations.
Oracle Accelerate does a remarkably thorough job of addressing the issues that midsize organizations wrestle with on a daily basis. Based on a comprehensive and pragmatic approach, Oracle Accelerate offerings may meet the requirements of these […]

Co-presented by MySQL AB and O’Reilly Media, the sixth annual MySQL Conference & Expo will take place April 15-18, 2008 in Santa Clara, California. The event is expected to bring over 1,600 Open Source and database users together to harness the power of MySQL and celebrate the active MySQL ecosystem. The call for participation is […]

Learn how DB2 9’s data row compression saves up to 80% in disk space.
The new data row compression technology in DB2 9 can save up to 80% savings on disk space and I/O improvements of up to 40%. If the volume of the data you need to manage is exploding, you may want to take […]

As any person who’s remodeled their home will tell you, choosing the right tool for the right job makes all the difference. The same statement applies when choosing the right database for a project. Some databases are basic, some are battery operated, and some are mighty power tools. Below is a guide on selecting the […]