|
Database Management & Programming News, Articles & Tutorials for Database Administrators
Managing SQL Server Services with PowerShell 03/24/2014
PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Read on to learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets.
Load Testing in a Big Data Environment 03/20/2014
Load tests give the database administrator (DBA) quite a lot of valuable information and may make the difference between poor and acceptable application performance. But what about a big data environment? Are there any gotchas or traps associated with big data?
Importing XML Data into MySQL Tables Using a Stored Procedure 03/17/2014
In theory, it would seem that a stored procedure would be the perfect vehicle for importing XML data from a file, and yet, the LOAD XML INFILE statement cannot be run within a Stored Procedure. Fortunately, there is a way to get around this limitation.
Oracle Parallel Processing: 'New' and Improved 03/13/2014
In Release 11.2, Oracle has provided three improvements to earlier attempts at controlling parallel execution. These improvements make this feature more manageable, more scalable, and less likely to saturate server resources, such as memory and CPU, than earlier releases of the database. David Fitzjarrell discusses the first of those improvements, parallel statement queuing.
Windows Azure SQL Database - Uploading Data by Using the bcp Utility 03/10/2014
While using a custom SSIS-based project to upload content of an arbitrarily chosen table from an on-premise SQL Server database to Azure PaaS-based SQL Database provides the most flexibility its inherent complexity might not be justified in more simplistic scenarios. Marcin Policht presents an alternative approach that addresses this concern by employing the bcp utility, which not only eliminates the need for any custom development, but also rivals SSIS in terms of its data transfer efficiency.
Review Your BUCKET_COUNT Statistics with DMV 03/03/2014
Greg Larsen discusses the BUCKET_COUNT setting of a HASH index and how to determine how well SQL Server distributes the In-Memory table rows across multiple buckets of a HASH index, by exploring a new DMV, provided with SQL Server 2014, along with the In-Memory OLTP table functionality.
6 Steps for Fighting SQL Injection 03/25/2014
Database usage is on the rise, as well as the applications that interconnect databases, meaning that SQL injection should still be a top concern for IT security pros.
Trustwave Taking Aim at Database Security 03/03/2014
A Trustwave security researcher details database security issues and defensive techniques.
Cloud Database Startup NuoDB Gets $14.2 Million Investment 02/28/2014
NuoDB is a single, logical database that can be deployed via the cloud in multiple locations simultaneously.
Tesora Launches to Focus on OpenStack's Trove DBaaS 02/14/2014
The name change from ParElastic to Tesora signifies the company's commitment to the OpenStack Trove database-as-a-service (DBaaS) project.
VoltDB Launches Version 4.0 of Its In-Memory Operational Database 01/30/2014
VoltDB adds enhanced analytics, expanded integrations, MySQL migration and more to VoltDB 4.0, the latest version of its in-memory database.
MariaDB Open-Source Database Gets Enterprise Release 01/24/2014
MariaDB gets an enterprise edition.
SGI Developing In-Memory Database Appliance for SAP's HANA 01/16/2014
The new SGI appliance will run high-volume databases in DRAM and provide up to 200 times the performance of flash memory.
Neo4j 2.0 Aims to Bring Graph Databases to the Masses 01/15/2014
Neo Technology launches the Neo4j 2.0 graph database with an eye on the broader market.
Oracle DB, Middleware Now Deployable on Verizon Cloud 01/10/2014
Cloud-service customers can bring their Oracle licenses to Verizon or purchase Verizon cloud services, which already include Oracle licenses.
MongoDB Offers Certifications for Developers and DBAs 10/30/2013
MongoDB has announced a new certification program for developers and database analysts that work with the MongoDB NoSQL database.
More Database News...
|
