|
Database Management & Programming News, Articles & Tutorials for Database Administrators
The Trouble with SQL Tuning 03/28
Database administrators tend to think of SQL tuning as necessary, important, even critical. The reality is that the savings realized by tuning SQL, usually manifested in saved CPU time and decreases in elapsed times, may offset the costs incurred in time and resources.
Oracle Database 11g: Working with the Data Masking Pack 03/25
DBAs often need to provide a full clone of a production system for a development and/or testing system. To address the balance between protecting the data while providing realistic test data, some form of data masking is required. Oracle Database 11g's new Data Masking Pack feature provides a permanent, one way mask of sensitive data.
Partitioning in SQL Server: Managing Sliding Window Scenario 03/21
The concept of a sliding window scenario is to manage and keep the same number of partitions on a partitioned table over time. Learn how in this step-by-step from Arshad Ali.
SQL Server 2012 Integration Services - PowerShell-Based Project Deployment 03/18
Marcin Policht shows you how to deploy SSIS projects using PowerShell.
Monitoring Smart Scans in Oracle Exadata 03/14
You really want to have Smart Scans working on an Oracle Exadata machine. But how do you know they're working? David Fitzjarrell shares a few ways to prove you have Smart Scans working for you.
Oracle Contiguous Data Range via Full Outer Joins 03/11
Selecting a contiguous data range, when the source data range is incomplete, requires producing the missing data and merging it with the source data set. Alexander Polishchuk describes a method of generating the required data in Oracle and merging it via full outer join or union data set operator.
Oracle Releases Open Source MySQL 5.6 with NoSQL Features 02/05
New database release provides performance and scalability gains
Couchbase 2.0 Advances Open Source NoSQL Database 12/12
It's not just about CouchDB and memcached anymore as new release goes beyond legacy roots.
Project Hekaton: Microsoft Bakes In-Memory Tech into SQL Server 11/09
Microsoft is venturing deeper into in-memory database technology and challenging SAP and Oracle.
VMware Gemfire 7 Scales In-Memory Data Grid 10/31
VMware adds native JSON and improved scale to Gemfire
Open Source Project Red Dwarf Brings Database as a Service to the OpenStack Cloud 10/16
Joint HP Rackspace venture is pushing forward at OpenStack in effort to enable a new world cloud database services.
Oracle Pushes both MySQL 5.6 and Oracle Database 12c Forward 10/02
Big week for Oracle as databases open and closed inch toward release.
Better Business Intelligence in SQL Server 2012 05/23
In addition to Big Data, Microsoft introduced components for integration, analysis and better reporting in SQL Server 12.
SAP Scaling Up Its Database Efforts 04/13
SAP is scaling up its database efforts, including the in-memory HANA and Sybase database technologies.
10Gen Takes Open Source NoSQL MongoDB Commercial with Red Hat 04/09
New partnership will expand the enterprise footprint of MongoDB.
Simplify with IBM's DB2 10 04/06
IBM's DB2 10, which will be available April 30, touts many new features, including adaptive compression and multi-temperature data management.
More Database News...
Receive news via our XML/RSS feed
|
