HP StoreOnce SQL Plug-in: Faster, efficient backup for Microsoft SQL Server databases

Post by Ian Blatchford (thank you)

Today’s BURA Sunday blog continues conversations started in recent posts from colleagues in HP Storage that have covered storage infrastructure and protection to optimize Microsoft SQL Server deployments.

Parissa talked about how deploying SQL Server databases on HP 3PAR StoreServ 7450 would save you from the tradeoff between database performance and resiliency. All-flash storage means very low latency and Peer Persistence between two distributed 3PAR StoreServ arrays provides resiliency against catastrophic site failure. Ashwin previewed the StoreOnce plug-in that enables DBAs to run direct backups from the SQL Server database to a StoreOnce appliance. He also described some of the benefits of using HP Data Protector for organizations who want to include SQL Server database protection as part of a centralized data protection process.

Read on here

Five Reasons to run MS-SQL on All-Flash

Post by George Crump (thank you)

Applications are often the key service that data centers provide to their organizations. The speed at which these applications can respond to the user’s requests is often THE measurement of how IT is perceived by the organization. As a result IT departments spend a lot of time and resources making sure the database application is running at peak performance at all times.

Read on here

High Speed Backup and Restore for Databases

Good post by Hu Yoshida (thank you)

Surveys show that backup and restore remain at the top of the list of concerns for data centers. Each year as volumes increase, the struggle to meet SLAs and manage backup windows increases. Many enterprises with very large databases have come to rely on techniques such as simultaneously backing up data through multiple backup streams (multi-streaming) and backing up multiple sources to a single backup device (multiplexing). While these techniques can speed up backup dramatically, it makes it difficult to dedupe using traditional hashing techniques, which results in increased storage costs for backup.

Read on here

Compression Becoming More Important in the Age of Big Data

Comprestimator Utility V1.2.01

Post by Craig S. Mullins (thank you)

DBAs and database professionals have been aware of the pros and cons of compressing data for years. The traditional argument goes something like this: with compression you can store more data in less space, but at the cost of incurring CPU to compress the data upon insertion (and modification) and decompress the data upon reading it.

Read on here

Are DBAs Still Needed?

Good post by Troy L. Coleman (thank you) – so there is no need anymore for the good old DBA ?

Since IBM unveiled its big data strategy, there’s been an interesting response. Some have focused on the role of the DBA, wondering if advancements like IBM Data Analytics Accelerator for z/OS (IDAA) and Netezza, which are designed to eliminate concerns over index design when storing data, make DBAs obsolete.

Read on here