IDERA Community
Search
User
Site
Search
User
Home
Blog
Performance Monitoring & Tuning
SQL Diagnostic Manager for SQL Server
SQL Defrag Manager
SQL Diagnostic Manager for MySQL
SQL Doctor
SQL Query Tuner for SQL Server
SQL Workload Analysis for SQL Server
Precise
Uptime Infrastructure Monitor
Database Administration
SQL Admin Toolset
SQL Enterprise Job Manager
SQL Inventory Manager
SQL Safe Backup
Database Security
SQL Compliance Manager
SQL Secure
Data Modeling
ER/Studio Business Architect
ER/Studio Data Architect
ER/Studio Team Server
Database Development & Management
Aqua Data Studio
DB PowerStudio
PowerShell
Power Tips
Ask the Experts
Using PowerShell
Video Library
Script Library
Module Library
Events
Geek Syncs
Live Demos
Free Tools
More
Cancel
Database Tools
More
Blog
New
General Availability of Aqua Data Studio 21.1
We added support for the new serverless platform, Amazon Athena!
ER/Studio Named Best Database Management Software
ER/Studio Data Architect was included in Digital.com's list of the Best Database Management Software…
The Bottom-Line Benefits of SQL Server Monitoring
With SQL Server performance monitoring, your business can avoid the risks of costly downtime.
Be Prepared for Regulatory Changes in the New Year
Compliance is a moving target as new laws are passed and existing standards evolve.
Previous
Feature 0
Feature 1
Feature 2
Feature 3
Feature 4
Next
Options
Browse by Tag
announcements
Aqua Data Studio
cloud
compliance
data architecture
data governance
data modeling
data modeling & architecture
database
database administration
DBA
DBArtisan
diagnostics
ER/Studio
ER/Studio Enterprise Team Edition
events
how to
IDERA
Microsoft SQL Server
monitoring
Monyog
MySQL
MySQL Monitor
MySQL Monitoring
MySQL query
MySQL server monitoring
MySQL slow query log
new version
news
performance
Precise
product updates
releases
security
server down
SQL
SQL Compliance Manager
SQL Diagnostic Manager
SQL Diagnostic Manager for MySQL
SQL Diagnostic Manager for SQL Server
SQL DM for MySQL
SQL Safe Backup
SQL Secure
SQL Server
Uptime Infrastructure Monitor
Latest Posts
By date
By view count
By comment count
Descending
Ascending
How Big Data Modeling Can Improve Business Intelligence
Robert Agar
Big data presents organizations with the raw materials from which to develop business intelligence. the ER/Studio family of data modeling tools can help turn big data resources into actionable insights that provide a company with a competitive edge.
3 Mar 2021
Columnstore Index for SQL Server
Pinal Dave
Introduction When we talk about SQL Server indexes, we are usually discussing the rowstore clustered or non-clustered index. However, along with rowstore indexes, SQL Server has columnstore indexes as well. In today’s blog post, we will be disc...
2 Mar 2021
How to Effectively Reduce SQL Server Database Index Fragmentation
Robert Agar
SQL Server index fragmentation can kill database performance. SQL Defrag Manager helps SQL Server database teams control index fragmentation by automating defragmentation and managing it from a centralized console.
1 Mar 2021
The Benefits of Using an IDE for Database Developers
Robert Agar
Database developers can benefit from the use of an IDE. Aqua Data Studio offers a comprehensive IDE that supports over 30 different databases platforms to help improve productivity and streamline development.
26 Feb 2021
The Top Five Features of SQL Diagnostic Manager for SQL Server
Robert Agar
SQL Diagnostic Manager for SQL Server has many features that make it the perfect tool for SQL Server DBAs. It's a customizable and reliable monitoring solution that lets a database team stay on top of performance-impacting issues.
24 Feb 2021
Filtered Indexes and Performance
Pinal Dave
Introduction During a recent SQL Server Performance Tuning consultation, I was asked a fascinating question by a Senior DBA working with me from the client-side. Let me share this query, as I believe you will find it intriguing as well. “We oft...
23 Feb 2021
Being a Proactive DBA Makes You More Productive
Robert Agar
Taking a proactive approach to database administration can result in increased productivity as issues are dealt with before they become problems. SQL Admin Toolset provides a set of features that assist a proactive DBA to manage their SQL Server environment.
22 Feb 2021
Better Data Governance with These Data Modeling Tips
Robert Agar
Data governance is a valuable method of obtaining consistency regarding enterprise data assets across an organization. Data modeling tools such as those in the ER/Studio family of solutions can improve data governance and the overall understanding of data resources.
19 Feb 2021
The Most Surprising SQL Antipattern We Use
Jeff Iannucci
Do you like hammering nails with screwdrivers? Me neither, but all too often we take this kind of approach when writing our SQL queries. We use the wrong tool for the job, and consequently end up consuming more time and resources to do a simple task....
16 Feb 2021
Why Should You Care About Crypto Mining on Your SQL Servers?
Robert Agar
SQL Servers are inviting targets for crypto miners. This poses multiple problems for DBAs protecting these systems. SQL Secure can help keep your database environment safe by providing visibility into your SQL Servers security.
16 Feb 2021
Identifying SQL Server Performance Problems Part 3
Monica Rathbun
Continuing with our Performance Tuning series as you have learned baselining and knowing your normal system performance metrics is an important part of performance tuning. In
part 1
we discussed collecting vital system metrics such as CPU Utilization...
16 Feb 2021
Troubleshooting Over-Indexing for Performance
Pinal Dave
Introduction I have now warned several times against the mindset that suggests indexing is a silver bullet for SQL Server performance. In the previous blog post, we discussed under-indexing. It is well-known that we may have performance issues if we ...
16 Feb 2021
The Most Important Metrics for Monitoring MySQL Databases
Robert Agar
MySQL provides many metrics that can be used by DBAs to track down problems that impact database performance. SQL Diagnostic Manager for MySQL gives them a valuable tool for real-time monitoring of MySQL metrics that are important for optimal performance.
10 Feb 2021
Troubleshooting Under-Indexing for Performance
Pinal Dave
Introduction All too often, people treat a good index as a silver bullet in terms of SQL Server performance. It is well-known that we will encounter performance issues when we inadequately index our environment. However, we can also expect to encount...
9 Feb 2021
How to Use Data Modeling When Migrating to the Cloud
Robert Agar
There are hidden complexities and opportunities to modernize IT systems when migrating to the cloud. Data modeling is one technique used to address these issues. ER/Studio Data Architect can create data models that increase data awareness and help make migration decisions.
6 Feb 2021
Why Automation is Mandatory for Database Administrators
Robert Agar
DBAs are faced with an increasingly complex role as they struggle to keep up with the demands of handling enterprise data resources effectively. Automation with tools like SQL Diagnostic Manager for SQL Server can help minimize the chances of mistakes and save time spent on routine activities.
5 Feb 2021
Using Data Visualization for More Effective Communication
Robert Agar
Data visualization is a technique that organizations can use to make better use of their data resources. Aqua Data Studio is a versatile database tool that supports the creation of data visualizations from relation, NoSQL, and cloud platforms.
5 Feb 2021
Make Sure You are Using the Right Kind of SQL Server Backup
Robert Agar
Understanding the types of backups and recovery methods available for SQL Server is the key to successfully protecting them. SQL Safe Backup provides a dedicated backup tool that lets you manage enterprise SQL Server backups from a unified console and offers multiple advanced recovery techniques.
3 Feb 2021
How to Perform Valuable Capacity Planning
Robert Agar
Capacity planning is a valuable activity that should be performed in all IT environments. Uptime Infrastructure Monitor provides features designed to facilitate capacity planning along with comprehensive IT monitoring capabilities.
3 Feb 2021
Beginning Indexes for SQL Server Performance
Pinal Dave
Introduction People often characterize indexes as silver bullets for the performance issues in SQL Server. Is it true? Well, yes and no. In this five-part series, we will discuss indexing for SQL Server Performance. In this first part, we will discus...
2 Feb 2021
Don't Let Increased GDPR Fines Hurt Your Bottom Line
Robert Agar
The fines for non-compliance with the GDPR are increasing as authorities try to influence the behavior of organizations in regard to data privacy. SQL Compliance Manager helps database teams ensure that the SQL Server environment complies with the GDPR and other regulatory standards.
1 Feb 2021
Why You Need to Care About SQL Server Fragmentation
Robert Agar
Database fragmentation can slowly eat away at database performance, causing significant problems. SQL Defrag Manager can automate the defragmentation process and help keep your systems running optimally.
29 Jan 2021
The Benefits of Consolidating Your Database Support Tools
Robert Agar
IT consolidation can provide economic and organizational benefits for companies that undertake the task. DBArtisan provides a tool that can consolidate multi-platform database support from a single interface.
27 Jan 2021
Identifying Performance Problems Part 2
Monica Rathbun
Performance Monitoring Tools In this second post we are diving into what tools you can use to capture the important performance metrics you need to gather for baselining your environment.
Be sure to read part one here
. Performance Monitor First...
26 Jan 2021
>