Database Management & Programming News, Articles & Tutorials for Database Administrators
Hitting The Oracle Target 03/30/2015
SGA and PGA management can be confusing. Oracle can make it easier with two views that provide advice on how to set the associated parameters. Read on to see what those views are and how to read the data.
Getting Started with Database Engine Tuning Advisor in SQL Server – Part 2 03/23/2015
Arshad Ali demonstrates how you can use the command line interface to tune SQL queries and how you can use SQL Server Profiler to capture the workload for tuning with Database Engine Tuning Advisor.
Exploding the Myths of Big Data 03/16/2015
As big data application success stories (and failures) have appeared in the news and technical publications, several myths have emerged about big data. This article explores a few of the more significant myths, and how they may negatively affect your own big data implementation.
CBO, Analytic functions and Cardinalities in Oracle 11.2 03/12/2015
In Oracle 11.2 using analytic functions can generate 'interesting' cardinality values that are far larger than they should be. Read on to see just how far off those values can be.
MySQL Fuzzy Text Searching Using the SOUNDEX Function 03/09/2015
Fuzzy searching has become a very prominent feature of Web search engines like Google. You can implement fuzzy text searching within your MySQL database by using a combination of built-in and user functions. Rob Gravelle demonstrates how to use the native SOUNDEX MySQL function.
Introduction to Automating Deployment of SQL Server in Azure IaaS Virtual Machines 03/05/2015
In general, Microsoft Azure provides two types of SQL Server based relational data services, Azure SQL Database Platform-as-a-Service (PaaS) and deploying a SQL Server instance into an Azure Infrastructure-as-a-Service (IaaS) virtual machine. There are obvious implications in regards to the management overhead associated with IaaS-based solutions. Marcin Policht reviews methods that allow you to minimize this overhead, focusing in particular on deployment tasks.
IBM Opens Watson Analytics to Public Beta 12/04/2014
After an early beta of IBM's Watson Analytics pulled in 22,000 early testers, Big Blue is now opening the service to everybody.
Splice Machine Ships Version 1.0 of Hadoop RDBMS 11/19/2014
Splice Machine takes its Hadoop relational database management system (RDBMS) to general availability.
Amazon Claims New Aurora DB Engine Screams With Speed 11/12/2014
NEWS ANALYSIS: Aurora may become a formidable competitor for comparable database engines by MySQL, SAP, Oracle, Teradata and EMC.
OpenStack Juno Cloud Features Trove Database-as-a-Service Updates 10/12/2014
The upcoming open-source OpenStack Juno cloud platform will now support more databases and database features.
Couchbase Launches v3.0 of Its NoSQL Database 10/10/2014
Couchbase 3.0 introduces more than 200 new features and enhancements, including major extensions to its core architecture.
IBM Tweaks DB2 With BLU Acceleration for Big Data 10/03/2014
IBM has updated its DB2 with BLU Acceleration in-memory solution to handle transactional data as well as analytical workloads.
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.
More Database News...