Learn about SQL Server to Azure migration and follow these procedures for a trouble-free migration process If you’re thinking about migrating your...
How to Successfully Migrate SQL Server to Azure SQL Database
read more
database
A User-Centric Tuning Philosophy
Collaborative Holistic Tuning of the Application Stack When planning for this blog, I deliberated over the title much more than anyone should ever...
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…
SQL Diagnostic Manager 12.2 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 12.2. Existing users may upgrade to this version through the Idera...
Improve data modeling with Aqua Data Studio
Data architects spend a major time of their job on data modeling. As such, they need to ensure that change to their data stores is controlled and...
Best IDE for data analysts
Data analysts need good visibility to the right data to make good business decisions. They also require easy access to the appropriate data, and a...
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...
Easier database management with Aqua Data Studio
Database administrators spend most of their time keeping databases running with little time to focus on performance and future-proof the...
Aqua Data Studio: IDE with visual analytics and automation
Aqua Data Studio accelerates data management processes by simplifying common tasks and automating routine operations. Visual analytics Run visual...
Manage schema, models, files and servers with confidence
Aqua Data Studio simplifies data-centric tasks by working on data sources without exposure to complex technical elements, detailed technical skills,...
Manage data with Aqua Data Studio
Aqua Data Studio is the industry-leading, multiple-platform, integrated development environment (IDE) for data. It provides many benefits to a...
SQL Diagnostic Manager 12.0 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 12.0. Existing users may upgrade to this version through the Idera...
Announcing General Availability of SQL Inventory Manager 2.6.3
We’re excited to announce the release of SQL Inventory Manager 2.6.3 Database administrators need a simple, efficient way to discover,...
Announcing the Release of SQL Defrag Manager 3.7
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Announcing Precise 10.3 General Availability
We are pleased to announce the release of Precise 10.3, the company’s application performance monitoring platform. Precise helps IT...
SQL Diagnostic Manager 11.0 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 11.0. Existing users may upgrade to this version through the Idera...
How to simplify routine SQL Server administration tasks
Database administrators need simple and quick ways to manage their SQL Server environment. SQL Admin Toolset provides 24 essential desktop tools for...
How to analyze the health of SQL Server database indexes
To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose,...
How to migrate SQL Server databases and data files
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...
How to ensure that SQL Server databases do not have fragmented indexes
Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation...
How to monitor the health of SQL Server database instances
Determine the health of instances by collecting real-time statistics. Such statistics include backup devices, databases, error logs, locks, logins,...