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
Blog
New
Previous
Feature 0
Feature 1
Feature 2
Feature 3
Feature 4
Next
Options
Subscribe by email
More
Cancel
Browse by Tag
announcements
Aqua Data Studio
cloud
data architecture
data governance
data modeling
data modeling & architecture
database
database administration
database monitoring
database performance
database tools
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
new version
news
performance
Precise
product updates
releases
security
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
Tags
Subscribe by email
More
Cancel
By date
By view count
By comment count
Descending
Ascending
How to become a database administrator for SQL Server
Peter V.
Database administrators need to handle all facets of managing Microsoft SQL Server ranging from installation and patching to creating databases to managing permissions that allow users to use the databases. However, more than anything, they are respo...
26 May 2022
Virtual machine snapshots versus database backups
Peter V.
Virtual Machine Snapshots Virtual machines provide exciting possibilities concerning backup, recovery, and cloning of databases. Convenient mechanisms are available for obtaining consistent snapshots of data volumes in virtual machines. Correctly imp...
25 May 2022
Five important features of SQL Diagnostic Manager
Peter V.
SQL Diagnostic Manager
is a robust performance monitoring, alerting and diagnostics solution for SQL Server. It proactively notifies of health, performance, and availability problems via a desktop console, a web console add-on, and mobile device...
24 May 2022
Quickly deliver relevant data to the right people to improve DevOps
Peter V.
Challenge As the number of projects for developing applications increases, organizations struggle with quality assurance, release management, and infrastructure support. Provisioning an instance of a production database for a development team can tak...
23 May 2022
Top SQL Server backup mistakes and how to avoid them
Peter V.
Backing up SQL Server databases is one of the most important tasks DBAs perform in their SQL Server environments every day. The backup process is so important it often requires well-defined processes, checklists, and multiple database administrators ...
21 May 2022
How to monitor Always On availability groups
Peter V.
Always On availability groups are part of an integrated solution with the goal of achieving the highest level of data availability and disaster recovery for organizations. Availability groups grant database administrators the ability to automatically...
20 May 2022
How to monitor tempdb databases
Peter V.
Introduction The tempdb system database is a workspace used to hold temporary user objects, results created through queries and sorts, and other objects created by the SQL Server Database Engine. Because of the significant amount of data stored ...
19 May 2022
Deliver data-driven capabilities with data modeling
Peter V.
Werner Enterprises is a transportation and logistics leader with more than 8,000 trucks, 24,000 trailers and nearly 13,000 employees. Today, 65 years since the company was founded, it is an asset-based logistics provider and one of the five largest t...
19 May 2022
How to plan future capacity
Peter V.
Capacity planning, especially when done for Microsoft SQL Server, is not for the faint of heart. Storage and disk capacity are apparent, but to right-size databases for a new SQL Server implementation or migration, there is a lot more than space to c...
18 May 2022
How to monitor and diagnose SQL query performance
Peter V.
Executing resource-intensive SQL queries requires a significant amount of processor time, memory, and bandwidth, and storage. Resource-intensive SQL queries prevent other SQL queries from using these resources. This can eventually lead to blocking. C...
17 May 2022
Four unique features of ER/Studio Data Architect
Peter V.
Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models, propagate changes from one model to the other in both directions, create database scripts, and reverse-enginee...
16 May 2022
How to tune the performance of SQL Server, Azure SQL Database and Amazon RDS
Peter V.
SQL Doctor
diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance information, analyze it, and determine the resolution in minutes rather than hours. Leverage ...
13 May 2022
How to ensure that databases are backed up regularly
Peter V.
Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases. Determine which databases are not backed up within the last specified number of days.Display the last backu...
12 May 2022
How to analyze the health of database indexes
Peter V.
To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose, display these statistics of indexes: The percentage of rows modified since statistics were last upda...
11 May 2022
How to migrate databases and data files
Peter V.
Do you need to: Move databases from one instance to another (for example, to move a performance-intensive database to a faster hard drive to speed up performance)? Copy databases from one instance to another or on the same instance. Migra...
10 May 2022
How to ensure that databases do not have fragmented indexes
Peter V.
Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation level of indexes.Filter the results by Filter the results by server, database, and table. Sort in...
9 May 2022
Announcing the General Availability of SQL Secure 4.0
Elan Kol
We are pleased to announce the general availability of SQL Secure 4.0 SQL Secure is the industry-leading, state of the art auditing and security solution for SQL Servers that helps identify vulnerabilities with SQL Server configurations and access, e...
9 May 2022
How to monitor the health of database instances
Peter V.
Determine the health of instances by collecting real-time statistics (including backup devices, databases, error logs, locks, logins, performance counters, processes, and agent errors). With the Server Statistics tool of
SQL Admin Tool...
6 May 2022
Discover 10 lesser-known capabilities of SQL Diagnostic Manager
Peter V.
Introduction This blog post describes ten lesser-known features of SQL Diagnostic Manager with links to short how-to videos and additional resources. Learn how to add custom counters and custom SQL scripts, capture deadlocks, integrate with SCOM, mon...
5 May 2022
Combine PowerShell and SQL Diagnostic Manager to automate SQL Server monitoring
Peter V.
Run new and existing PowerShell scripts with
SQL Diagnostic Manager
and utilize the vast power of PowerShell via the customizable monitoring environment. Run scripts to automatically react to problems detected by the monitoring environment,...
4 May 2022
Keep track of database performance with Uptime Infrastructure Monitor
Peter V.
Uptime Infrastructure Monitor
Uptime Infrastructure Monitor (UIM)
is an enterprise tool that provides a unified view for Information Technology systems monitoring. Although comprehensive and scalable, UIM is also easy to use and deploys in minut...
3 May 2022
How can SQL Workload Analysis help you?
Peter V.
To find the key points of how
SQL Workload Analysis
can help you, look for the ducks
throughout this blog post! What Is SQL Workload Analysis? It is an add-on to
SQL Diagnostic Manager
and a component of the IDERA Dashb...
2 May 2022
Discover how cardinality affects performance
Peter V.
Cardinality is a term from set theory that deals with the size of a set. Data cardinality can affect query plans and performance. Minimize the effects of cardinality adjustments. Create efficient SQL queries in low cardinality environments. Read the ...
29 Apr 2022
Make SQL Server performance easy
Peter V.
Every database administrator hates to wake up at midnight just to learn there is an emergency with their database. Sometimes, even though their hardware specifications are above par and they know everything was working fine earlier that day, database...
28 Apr 2022
>