Database Management & Programming News, Articles & Tutorials for Database Administrators
Performance Tuning in the Age of Big Data 06/17/2013
Big Data is here, or will soon be here for the majority of IT enterprises. Database Administrators must now deal with large volumes of data and new forms of high-speed data analysis. If your responsibility includes performance tuning, here are the areas to focus on that will become more and more important in the age of Big Data.
Using Oracle Enterprise Manager Command Line Interface Part 1 - Installing and Basic Configuration 06/13/2013
The Oracle Enterprise Manager 12c command line interface (Enterprise Manager Command Line Interface - EM CLI) can be used to configure several options that allow for monitoring and auditing the actions performed by users in the graphical interface. Karen Reliford shows you how to install and configure the EM CLI Client.
Oracle Hybrid Columnar Compression in Exadata 06/10/2013
Hybrid Columnar Compression is a compression option available only for tables residing on Exadata storage, which besides Exadata includes Axiom, the SPARC SuperCluster and the Sun ZFS Storage Appliance. Read on to learn more.
MySQL Cursors and Loops 06/06/2013
A loop is a programming construct that executes a block of code repeatedly based on a condition. Cursors, on the other hand, are utilized to process each row returned by a SELECT statement. Read on to learn about various loop types supported by MySQL as well as an introduction to cursors.
xp_cmdshell for Non-System Admin Individuals 06/03/2013
When SQL Server is first installed out of the box, the extended stored procedure “xp_cmdshell” is not enabled; once it's enabled the default behaviors is that it is only available to the logins that have System Admin permissions. Greg Larsen shows you how to setup xp_cmdshell so non-System Admins can use this extended stored procedure.
Managing Slowly Changing Dimension with MERGE Statement in SQL Server 05/28/2013
Slowly Changing Dimension (SCD) Transformation is a quick and easy way to manage smaller slowly changing dimensions but it has several limitations and does not perform well when the number of rows or columns gets larger. Arshad Ali explores some of the alternatives you can use for managing larger slowly changing dimensions.
PostgreSQL Maven Tom Lane Heads to Salesforce 05/24/2013
The cloud CRM upstart brings a top contributor into the fold as it embarks on a transition to open source.
Oracle Releases Open Source MySQL 5.6 with NoSQL Features 02/05/2013
New database release provides performance and scalability gains
Couchbase 2.0 Advances Open Source NoSQL Database 12/12/2012
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/2012
Microsoft is venturing deeper into in-memory database technology and challenging SAP and Oracle.
VMware Gemfire 7 Scales In-Memory Data Grid 10/31/2012
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/2012
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/2012
Big week for Oracle as databases open and closed inch toward release.
More Database News...