What to Know Before Choosing a Database Management System
A database management system, also called DBMS, is a program that allows admins to access, alter, and analyze a database. In this article, I’ll describe the functions of a database management system and review different types of databases. While this isn’t a comprehensive list of all DBMS types, it’s a start if you’re looking for … Read more What to Know Before Choosing a Database Management System
What Is Sharding? Database Sharding, Scaling, and You
One of most important questions for any modern database administrator is, “How do different databases scale?” There are different approaches to database scaling, and not all of them are applicable in all contexts. An increasingly popular approach to database scaling is sharding, but what is database sharding, and how does it help databases scale? What … Read more What Is Sharding? Database Sharding, Scaling, and You
What Is a Storage Array? Data Server and Disk Architecture
A storage array, also called a disk array, is a data storage system for block-based storage, file-based storage, or object storage. Rather than store data on a server, storage arrays use multiple drives in a collection capable of storing a huge amount of data, managed by a central management system. The performance of storage arrays … Read more What Is a Storage Array? Data Server and Disk Architecture
Comparing Aurora Pricing and Performance to MySQL, RDS, and SQL Server Databases
Software developers may use a relational database management system (RDBMS) to create, read, update, and delete back-end data, and they can work with and change these systems with custom SQL statements. However, there are several RDBMSs to choose from, and each one is designed with particular use cases in mind and differs in features, pricing, … Read more Comparing Aurora Pricing and Performance to MySQL, RDS, and SQL Server Databases
How to Do Performance Tuning in Oracle
Oracle performance tuning is a crucial step in ensuring speedy application function and data retrieval. Here’s what you need to know to improve database performance. All database administrators (DBAs) are familiar with the onerous task of increasing database performance. To accelerate application function, DBAs have to expedite query response time, which means DBAs must have … Read more How to Do Performance Tuning in Oracle
First Look at SQL Operations Studio
Since the release of SQL Server® 2017 on Linux®, DBAs have been waiting for a native release of SQL Server Management Studio (SSMS) on Linux. At this point, Microsoft has stated that they have no plans for a native Linux version of SSMS. However, they have just released a preview version of SQL Operations Studio, … Read more First Look at SQL Operations Studio
Maximizing Database Performance – MySQL Tuning Best Practices
With the added complexity of growing data volumes and ever changing workloads, database performance tuning is now necessary to maximize resource utilizations and system performance. However, performance tuning is often easier said than done. Let’s face it, tuning is difficult for a number of reasons. For one thing, it requires a significant amount of expertise … Read more Maximizing Database Performance – MySQL Tuning Best Practices
How SQL Server DMVs Can Be a Savior in SQL Azure, Too
Be it SQL Server or the improved version of SQL Server on the cloud called as SQL Azure, when it comes to monitoring, there is nothing as powerful as DMVs (Dynamic Management Views). For a primer, Dynamic Management Views (DMVs) are a set of virtual views which expose the internal states of SQL Server deployment. … Read more How SQL Server DMVs Can Be a Savior in SQL Azure, Too
Must-know Tips and Tools for Oracle Virtualization
These days, even business-critical applications are being virtualized, and with the increasing costs and complexity of data environments, it’s not surprising. Some estimate that large organizations are as much as 70% virtualized already, with no plans to go back to physical servers. Virtualization, however, introduces new challenges for the Oracle DBA, including getting visibility to … Read more Must-know Tips and Tools for Oracle Virtualization
TDD: A Blueprint for Choosing Metrics
Test Driven Development (TDD) is not only a discipline we like to write about, we practice it ourselves every day. This is a blog post we shared with our friends over at Rainforest QA. Because we know you can’t enough of a good thing, we’re re-posting it here. Enjoy! Librato is a prolific engineering shop. … Read more TDD: A Blueprint for Choosing Metrics