When deploying SQL Diagnostic Manager for the first time, it may be necessary to register several SQL Server instances that are to be monitored by...
blog
GDPR and the SQL Security Suite
On May 25th, 2018, GDPR (General Data Protection Regulation) went into effect. This regulation affects anyone who collects PII (Personally...
Top 5 SQL Server cluster setup mistakes
Windows Server Failover Clustering (WSFC) provides infrastructure features that support the high-availability and disaster recovery scenarios of...
Announcing SQL Enterprise Job 2.2 General Availability
We are pleased to announce the general availability of SQL Enterprise Job Manager 2.2. Existing users may upgrade to this version through the IDERA...
Demystify tempdb performance and manageability
Microsoft SQL Server stores a significant amount of data in the tempdb system database. Consequently, tempdb can fill up quickly when disk space is...
Simplify Routine Database Administration Tasks with SQL Admin Toolset
Database Administrators are responsible for an organization’s most important asset - the data. This responsibility comes with many...
Database Performance History
Servers are moving from on-prem to the cloud. Applications are upgraded, so are operating systems, databases, and hardware. New users,...
Monitoring Master-Slave Replication in MySQL 8
MySQL 8 introduced a number of enhancements to improve both replication performance and the monitoring thereof. Improvements included more efficient...
What’s new in SQL Compliance Manager 5.5
Earlier this month SQL Compliance Manager version 5.5 was released. We're super excited about some of the new features that are...
Learn about index fragmentation to improve SQL Server performance
As the data in the database tables of Microsoft SQL Server changes, their indexes change. Over time these indexes become fragmented so that ordered...
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...