|
Database Management & Programming News, Articles & Tutorials for Database Administrators
Understanding New Column Store Index of SQL Server 2012 08/30
Column Store Index is a new feature in SQL Server 2012 that improves performance of data warehouse queries several folds. Arshad Ali discusses the new Column Store Index in detail, how it differs from regular indexes, and why and how it improves the performance of the same query by several folds.
SQL Server 2012 Integration Services - Advanced Functionality of Dtexec.exe 08/27
Dtexec.exe offers a number of auxiliary features helpful in automating a variety of package management tasks. We will focus here on exploring this less commonly known functionality and present examples illustrating its use.
Strategies for Improved Data Availability in DB2 08/23
Apart from recoverability, data availability is the most important aspect of design. If correct and timely data is not available, customers may be lost and business will suffer. Database designers and application designers are responsible for designing data availability into a system. Here are the best ways to ensure this.
Using Non-unique Indexes for Primary Keys -- A Case Study 08/20
Sometimes Oracle does more work than expected. When validating a primary key constraint using an existing non-unique index Oracle takes an unexpected path and, in doing so, can fail to create the constraint. Read on to see how Oracle 'can't see the forest for the trees.'
Oracle Enterprise Manager 12c Cloud Control - Incident Manager - Part One 08/16
Oracle has made great strides in providing tools and techniques for administrators to be able to take steps to proactively monitor their systems for performance, error conditions and/or unusual behavior. This trend definitely continues with the new feature in Oracle Enterprise Manger 12c Cloud Control called Incident Manager.
Testing Your MySQL Stored Procedures with MyTAP 08/13
If your MySQL database interfaces with applications or is used to generate reports then chances are good that it contains some massive stored procedures. In that case, you had better set up some type of unit testing framework so that you can verify that your SQL code is doing what it should. This article introduces MyTAP, a unit-test suite based on the Test Anything Protocol (TAP).
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.
SAP to Challenge Oracle's Database Business? 03/16
Mark your calendars and prepare for fireworks. SAP to announce big database news in April.
Microsoft SQL Server Gets a Big Data Revamp 03/07
Improvements abound as Microsoft overhauls SQL Server to handle Big Data challenges for businesses.
Couchbase Moving Forward In 2012 01/20
NoSQL startup is gearing up for a major new database release.
Can you Make Money with a Cloud Database as a Service? 12/19
Xeround has raised millions for its database app technology as demand for cloud services ramps up.
Salesforce Heroku Offers Standalone Cloud-Based PostgreSQL Database 11/28
Since 2007, Heroku has offered database-as-a-service to its platform-as-a-service customers for use with Heroku platform applications. Now the company is extending the service for use with any cloud platform.
MongoDB - Why Does NoSQL Matter? 11/07
NoSQL isn't a fad, it's delivering real business value today.
More Database News...
Receive news via our XML/RSS feed
|
