|
Database Management & Programming News, Articles & Tutorials for Database Administrators
Are There Safeguards to Prevent the DBA from Dropping a Table? 05/27/2014
How do you ensure that the DBA doesn't, or can't, drop a table accidentally? Oracle has at least two ways to ensure that a table cannot be accidentally dropped but there are some limitations to those methods. David Fitzjarrell looks at those methods to see which one works for the DBA account.
TokuMX Compared to MongoDB Using a Specific Common Use Case 05/22/2014
Former AOL database architect and independent database consultant John Schultz benchmarks basic MongoDB from MongoDB, Inc. and TokuMX, the Tokutek high-performance distribution of MongoDB, to see which one performs best at scale. Focusing on a number of important performance characteristics — such as storage I/O and database insertion rates – Schultz tracked the degradation in performance for both products as database size increased. Here are his results.
Transparent Data Encryption (TDE) in SQL Server 05/19/2014
There are several ways to implement encryption in SQL Server; Arshad Ali focuses on Transparent Data Encryption (TDE), which was introduced in SQL Server 2008 and is available in later releases.
Do We Still Need Database Design in the Era of Big Data? 05/15/2014
Many big data application implementations seem to begin with an existing data warehouse, one or more new high-volume data streams, and some specialized hardware and software. The data storage issue is often accommodated by installing a proprietary hardware appliance that can store huge amounts of data while providing extremely fast data access. In these cases, do we really need to worry about database design?
Importing XML, CSV, Text, and MS Excel Files into MySQL 05/12/2014
For MySQL administrators who would rather not write and maintain their own import code, there are tools that can markedly simplify the importing of data from various sources. Rob Gravelle demonstrates how to use the Navicat Database Admin Tool to acquire data from XML, .csv, .txt, and Excel files.
Modifying a Primary Key Index in Oracle 11.2.0.x 05/08/2014
Some business decisions may need to be redone, like making a non-unique primary key index unique. In Oracle 12c it's a simple task, but in Oracle 11.2. and earlier it's a bit more involved but still possible. Read on to see how this can be done.
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.
New Rules for Database Design in the Cloud 05/19/2014
With a database in the cloud, the challenges of remotely hosted storage must be addressed.
Microsoft SQL Server 2014 Already Powering Production Workloads 05/18/2014
Early bird special? Microsoft's newest database delivers some massive performance and efficiency gains for early customers.
More Microsoft SQL on Azure Update Details Emerge 05/06/2014
Microsoft releases more details on its upgraded cloud-based database offering as it gears up for an official launch.
Microsoft Previews SQL Database on Azure Upgrades 05/02/2014
Microsoft continues to make the case for the cloudification of business databases with new service tiers, improved service-level agreements and enhanced business continuity options.
[VIDEO] Where Are Database Threats Today? 04/28/2014
Amichai Shulman, CTO of Imperva, explains why SQL injection is not a database threat and discusses the current state of Oracle database patching.
Microsoft Gives Details on Its Analytics Platform System 04/26/2014
By combining SQL Server and Hadoop, Microsoft is positioning APS as an affordable gateway to big data analytics for enterprises.
Microsoft SQL Server 2014: The Ambient Intelligence Database 04/18/2014
Eyeing the Internet of things, the software giant touts the high-performance innovations that the newest version of SQL Server has to offer enterprises.
Tesora Updates DBaaS Platform, Focuses on OpenStack Icehouse 04/17/2014
Tesora updated its database virtualization engine to provide better performance from its Trove-based database as a service (DBaaS).
More Database News...
|
