Data Warehousing DBAs usually work with huge tables, often possessing hundreds of millions or even billions of rows. And occasionally, these DBAs...
posts
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Top metrics to monitor in your MySQL databases
As tables increase in size and more users come online, it becomes increasingly necessary to fine-tune your MySQL database server from time to time....
Business Value Metrics for Data Governance
As data professionals, we recognize and understand the need for data governance, focusing on data quality in particular. We have made some progress...
What are visual SQL tuning diagrams?
SQL queries are the primary mechanism to interact with databases. Therefore, ensuring that SQL queries perform well is essential. An important...
SQL Performance, Part 4: Additional Considerations
Today’s blog post concludes our four-part look into SQL performance and optimization. Part one introduced and explained relational...
Is GDPR a Grinch?
Most people know that GDPR went into effect in May of 2018. For those of you who don't know, GDPR was put in place to protect people's PII...
Surprises in 2018 and Predictions for 2019
Recently I was asked to contribute my thoughts on what things in database technology were a surprise in 2018 along with what trends and topics would...
What are the top 4 performance makers and breakers for SQL Server?
Successful solutions are successful solely because systems, users, and organizations have come to depend upon them. Such solutions are not...
SQL Performance, Part 3: Multiple Table Access Methods
In part one of our overview of SQL performance we examined relational optimization; part two took a look at query analysis and introduced...
Six SQL Server performance boosters with your existing hardware
Nearly all successful applications can benefit from the performance-driven strategies outlined in this whitepaper. Many of the categories and items...
Why your Always On solution is not always on
Microsoft markets a variety of SQL Server availability technologies under the umbrella term Always On. Always On is a broad term covers many...
SQL Performance, Part 2: Query Analysis and Access Path Formulation
In part one of our overview of SQL performance we examined relational optimization and the things that impact it. In today’s blog post, we...
Five database administration mistakes that can cost you your job
Everyone makes mistakes. Database administrators are no exception to that rule. When database administrators make mistakes, they are often the ones...
SQL Performance, Part 1: Relational Optimization
Application developers must code efficient SQL and understand how to optimize SQL in order to develop efficient applications. But it is not just the...
Seven steps to alert effectively
Automated alerts are essential to performance monitoring. Automated alerts enable spotting issues in infrastructures, identifying their causes, and...
Introducing IDERA SQL DM Performance Insights for Azure Data Studio
IDERA is pleased to announce the introduction of IDERA SQL DM Performance Insights, a Microsoft Azure Data Studio (ADS) extension which displays key...
Introducing the 2018-2019 Class of IDERA ACEs!
Introducing the 2018-2019 Class of IDERA ACEs! We are excited to introduce our 2018-2019 class of IDERA ACEs! This program helps active members of...
November #SQLChat – Let’s Talk About Data Analysis!
A solid data analysis process and capable tools are key components of a strong data professional's skill set. Join IDERA (@Idera_Software) and...
Learn more about SQL Server statistics
Statistics, or “stats,” are fundamental components of SQL Server performance, but vastly under-appreciated and misunderstood. They are...
How to balance database security versus database performance
The security of any database can be improved. However, that likely degrades the performance of the database. The cost increases to improve database...
How to Find and Fix SQL Server Deadlocks
Introduction Locking is required for concurrent operations of relational databases to prevent data inconsistency and loss. However, locking impairs...
Data Modeling Still Important in a Big Data, Analytics World
As more organizations embrace big data and analytics to gain insight from extremely large data sets the tools and systems that we use to manage data...
GDPR vs CCPA – A Quick Look
On June 28th, 2018, California enacted the California Consumer Privacy Act (CCPA). It will go into effect on January 1, 2020. Guidelines must...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 3
This is the third part of a three-part series of blog posts. Read also the first part and second part. Analyze Queries In addition to...
DBA Paradox – Plus ca change, plus c’est la meme chose
The quote comes from Jean-Baptiste Karr. And while some may not be familiar with the source and that original language version, almost...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 2
This is the second part of a three-part series of blog posts. Read also the first part. Click here to view the third part. Get Overview The...
We’ll See You at PASS Summit 2018!
It’s that time of year again! IDERA is excited to see everyone at PASS Summit 2018! This year’s summit will take place from November...
How to Set Up MySQL 8 Cluster Replication
In the Setting up Basic Master-Slave Replication in MySQL 8 blog, we went through the process of setting up two MySQL servers on the same box for...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 1
This is the first part of a three-part series of blog posts. Click here to view the second part. Overview SQL Diagnostic Manager for...
The Simple 3-2-1 Rule for Backups
Earlier this month, one of Microsoft's Azure data centers encountered an outage that impacted customers worldwide. Microsoft recently...