As the data in the database tables of Microsoft SQL Server changes, their indexes change. Over time these indexes become fragmented so that ordered...
blog
Changing Lanes: Part II. Shifting between Relational and Big Data Platforms
In the last blog, I covered Shifting Roles with Relational and Big Data Platforms and how that is affecting the people and their roles within...
How to increase SQL Server performance with existing hardware
Unlike their failed counterparts, solutions are successful solely because systems, users, and organizations have come to depend upon them. Solutions...
How to become a database administrator for SQL Server
Database administrators need to handle all facets of managing Microsoft SQL Server ranging from installation and patching to creating databases to...
Setting up Basic Master-Slave Replication in MySQL 8
Since April 19th, when MySQL 8.0 became Generally Available (GA), the MySQL community has been abuzz with excitement over all of the new features...
Analyze MySQL & MariaDB Error Log Messages using Monyog
The MySQL error log is an essential part of database server performance monitoring. Whenever something goes wrong or performance degrades, the Error...
Announcing the GA Release of SQL Compliance Manager 5.5
We’re excited to announce the release of SQL Compliance Manager 5.5 SQL Compliance Manager is a comprehensive database auditing solution that...
July #SQLChat – Death of the DBA
“The DBA is dying” has been a common concept for at least 15 - 20 years. What makes this time period different? Join IDERA...
Enhance Database Performance with SQL Tuning in DB Optimizer
In today's economy it is imperative that database developers work smarter, not harder, to meet the demands put on them by line of business...
Welcome AquaCluster Users to the IDERA Community!
We are excited to welcome the AquaCluster users to the IDERA Community! As you know, IDERA acquired AquaFold in July 2017, and we are committed to...
Using Precise for Database to Tune Tables and Indexes
When looking at a database to improve performance, I look at three types of tuning; statement, object, and instance. I want to walk you through some...
Creating a Data Culture Through Continuous Improvement
Far from a one-off effort, data quality and data culture require continuous improvement and optimization. Industry leading organizations recognize...
Databases Don’t Build Themselves
Last week I was fortunate to be asked to present during the IDERA Live Event. There were many great presentations and those who attended received a...
How To Improve a Business-critical Third-party Application by Optimizing Its Generic Database Settings
Problem Background A business-critical third-party application for Microsoft SQL Server configured the database with generic settings, including...
What Happened to My Database?
Every DBA has at some point asked: “What the heck happened to my database?” In this blog, we’ll review some of the more common...
How Monyog Helps Profile Slow Queries in MariaDB
MariaDB came into being the day that Oracle announced the purchase of Sun in 2010. In order to keep it free under the GNU GPL, Michael Widenius...
Essential Alerting for Oracle, DB2, and Sybase DBAs
Precise tests availability, space, deadlocks, backups, jobs, CPU, load and performance trending plus many more conditions on a scheduled basis with...
Backing Up Databases in a High Availability Group
If you are a database administrator, then you are no stranger to the idea that data must be highly available. High availability simply...
TEMP is A Four Letter Word
It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming...
Database Execution Plans Can Lie
Quote: Do not put your faith in what statistics say until you have carefully considered what they do not say. ~William W. Watt. I started this...
The Evolution of Database Tuning Approaches
Imagine that you’re the lead DBA managing a high profile, mission critical production database whose application processes $20 million per...
Managing Mountains of Data with the Cloud
When is data less valuable? How do you manage data as it becomes less valuable? In the good old days the answer to these questions was easy; it was...
Improve MariaDB Performance using Query Profiling
Query profiling is a useful technique for analyzing the overall performance of a database. Considering that a single mid-to-large sized application...
Error Logging in MySQL 8
Although only available as a Release Candidate, MySQL 8 is already proving itself to be a huge leap forward in many regards. Error logging is no...