Database Management & Programming News, Articles & Tutorials for Database Administrators
Oracle Bloom Filters 09/11/2014
In Oracle releases 10.2.0.x and later join processing can be made more efficient by the use of Bloom filters, primarily to reduce traffic between parallel query slaves. Read on to learn more.
MySQL Date Gotchas 09/08/2014
Rob Gravelle explores the perils of working with dates in MySQL.
How to Manage Microsoft Azure SQL Database Using PowerShell with REST APIs 09/04/2014
Continuing his discussion of a somewhat unorthodox method of managing Azure SQL Database that involves directly invoking REST APIs, Marcin Policht shows some of the unique benefits of REST APIs by demonstrating their unique capabilities that are not available via PowerShell.
TSQL: Understanding How to Use the INSERT Statement to Populate Your Database Tables 09/02/2014
Before you can read data from your database you need to understand how to insert data into the tables in your database. There are a number of different ways to accomplish this. Greg Larsen explores the methods you can use when inserting data into a database table using the INSERT statement.
Oracle: Is Parallel Really Necessary? 08/25/2014
You're running processes in parallel; is it really faster? Sometimes it may not be; read on to see why parallel processing may be creating more work than you'd expect.
Importance of Recovery Model in SQL Server 08/21/2014
Have you ever wondered, especially in the case of a data warehousing scenario, why the transaction log file grows bigger and bigger--sometimes much bigger than your database's data files? What caused it to happen? How do you control it? How does the recovery model of a database control the growing size of the transaction log? Read on to learn the answers.
Microsoft to Cut Azure SQL Prices This Fall 08/27/2014
Microsoft is getting ready to slash prices by up to 50 percent after Azure SQL's new service tiers are made generally available next month.
Microsoft Entices Oracle Shops With SQL Server 2014 Migration Tool 07/25/2014
The company focuses on SQL Server 2014's in-memory capabilities in its bid to siphon enterprise database workloads from rival Oracle.
Oracle Big Data SQL Connects Various Data Sets for Analysis 07/16/2014
This can run a single SQL query on Oracle's own 12C database at the same time as in Hadoop and NoSQL data stores.
Couchbase Raises $60 Million to Fuel NoSQL Database Efforts 06/30/2014
Investors continue to be confident in the prospects of NoSQL database technology.
Google Releases Cayley Open-Source Graph Database 06/27/2014
Cayley will be used to help Google continue to refine the idea of linking data together in graph databases, including Google's Knowledge Graph.
Database Monitoring Key to Reducing Security Breaches 06/13/2014
Only 48 percent of respondents to a recent survey indicated that they test or validate third-party software to ensure it's not vulnerable to SQL injection.
Oracle Launches In-Memory Option for 12C Database 06/10/2014
The 12C In-Memory Option is aimed at enabling ISV applications to accelerate performance by orders of magnitude for several use cases.
Review: Microsoft SQL Server 2014 05/29/2014
Integration with Microsoft's Azure and new business intelligence and Big Data tools are among the most striking features of SQL Server 2014, finds reviewer Paul Ferrill.
Oracle Expands Open-Source High-Availability with MySQL Database Fabric 05/27/2014
MySQL Fabric is a new open-source tool included in MySQL Utilities 1.4
Big Data Survey: Big Data Growing Quickly 05/22/2014
A survey of Big Data professionals indicates that, while confusion remains, the market sector is growing quickly.
More Database News...