Database Management & Programming News, Articles & Tutorials for Database Administrators
Getting Started with Hashing in SQL Server 07/24/2014
Encryption brings data into a state which cannot be interpreted by anyone who does not have access to the decryption key, password, or certificates. Hashing brings a string of characters of arbitrary size into a usually shorter fixed-length value or key. Read on to learn about hashing in SQL Server and how it is different from encryption.
Managing Big Data DBAs 07/21/2014
Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?
Exadata: When A Smart Scan Isn't 07/17/2014
Exadata is known far and wide for Smart Scans, but sometimes Oracle can do better without one. Read on to see how to know when Oracle decided to not continue with a Smart Scan.
Importing Into MySQL from Other Databases 07/14/2014
Importing into MySQL from databases of different types is challenging because vendors have their own proprietary tools and SQL extensions. Rob Gravelle presents some software products that can abstract each vendor's particular language so that data may be transferred between them in a seamless process.
Increase DSS Performance by 100x and OLTP by 2x: Switch to Oracle 12c 07/10/2014
The next big thing after Exadata is the new Oracle 12c Database In-memory feature, which will dramatically improve database performance for analytical queries and OLTP without application re-coding.
Using PowerShell to Manage Windows Azure SQL Databases 07/07/2014
Marcin Policht provides a comprehensive overview of Windows PowerShell’s capabilities in regard to managing SQL Databases (or, in general, cloud-resident resources).
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.
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.
More Database News...