SQL Server Database Administrators (DBAs) have a tough job. They are responsible for ensuring database performance, security, and availability—all...
database-management
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- 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
Lessons from Hurricanes Helene and Milton: Why SQL Server DBAs Need a Business Continuity Plan
Hurricanes Helene and Milton were a stark reminder of the devastating impacts natural disasters can have on infrastructure. With entire regions...
Perpetual vs Subscription: SQL Server Tools Pricing Explained
When it comes to purchasing SQL Server tools, businesses often face a key decision: choosing between perpetual and subscription pricing....
Understanding and Managing High Memory Usage in SQL Server
Understanding SQL Server Memory Usage Memory plays a crucial role in SQL Server's performance, serving as the primary storage area for data being...
How SQL DBAs can Proactively Manage 2025 Compliance Changes
As the world becomes more data-driven, regulations around data privacy, security, and management are constantly evolving. In 2025, several major...
Essentials of Database Indexing for SQL Server
What is Database Indexing Database indexing is a technique used to optimize the performance of a database by enabling faster retrieval of records....
How to Avoid SQL Server Deadlocks: 5 Essential Steps for DBAs
Understanding SQL Server Deadlocks In SQL Server management, deadlocks are a common yet frustrating issue that can disrupt database performance. A...
5 Key Data Security Measures to Protect Your SQL Server
Essential Data Security Measures to Avoid Data Breaches Data breaches have become an increasingly significant threat to organizations of all sizes,...
How to Successfully Migrate SQL Server to Azure SQL Database
Learn about SQL Server to Azure migration and follow these procedures for a trouble-free migration process If you’re thinking about migrating your...
SQL Safe Backup 9.2.2 General Availability
We’re excited to announce the release of SQL Safe Backup 9.2.2 SQL Safe Backup is a comprehensive solution for SQL Server database backup and...
SQL Defrag Manager 3.8 General Availability
We’re excited to announce the release of SQL Defrag Manager 3.8 SQL Defrag Manager is an industry leading automated performance solution that...
SQL Diagnostic Manager 12.3 General Availability
SQL Diagnostic Manager 12.3 is available now. Upgrade or download the free trial version from Idera.com.
How to adjust the Java heap size of DB Optimizer
DB Optimizer is a Java-based application designed to assist database administrators and developers in optimizing the performance of database systems. If you are running long…
How to adjust the Java heap size of DB Change Manager
DB Change Manager is a Java-based application designed for managing and tracking changes to databases. If you compare 2 datasources with lots of objects, you…
TempDB Troubles: Identifying and Resolving TempDB Contentions
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction The tempdb system database is a global resource in Microsoft SQL...
SQL Server Alert Management: From Chaos to Clarity
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction In the fast-paced world of database administration, staying ahead...
Navigating SQL Server CPU and Memory Usage Woes
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft SQL Server is a powerful database management system, but...
Deciphering the SQL Server Performance Mysteries
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft's SQL Server is a robust and widely adopted database...
Harnessing Big Data: A Strategic Advantage for Modern Organizations
There are different claims regarding the coinage of the term big data, but the concept of big data has existed since the mid-20th Century....
Improve SQL Server Usage Management and Efficiency
If your organization deals with a high volume of customer data, telemetry, or other metrics, it’s likely you'll have some substantial databases to...
Initialize Transactional Replication from your Backups
This blog provides guidance on the perceived limitations and restrictions on initializing transactional replication subscribers from backups. The...
Manage data and result sets, and SQL queries with Aqua Data Studio
Aqua Data Studio improves access and consistency by accessing data sources from a single tool to minimize the learning curve and maximize the...