Blog

We are pleased to announce the general availability of SQL Diagnostic Manager 10.3. Existing users may upgrade to this version through the Idera Customer Portal. New users may download the trial version from the Idera Website. This release ...

We are pleased to announce the general availability of SQL Diagnostic Manager for MySQL 8.7. Existing users may upgrade to this version through the Idera Customer Portal. New users may download the trial version from the Idera Website.&nbsp...

Initialization of a transactional replication subscriber is a highly valuable tool. For very large databases (VLDBs), snapshot generation and application can have a considerable performance impact and take a long time. Consequently, initializing a su...

Database security is a hot topic these days, especially with all the new and seemingly never-ending security compliance requirements being imposed such as GDPR. This means that DBAs must up their game when it comes to database security. Some DBAs may...

Hopefully you’ve seen the news by now, but if you haven’t, you should know that earlier this month, Silwood Technologies announced that they have entered into a reseller agreement with IDERA. DBTA covered the announcement on their site, a...

As seasoned database administrators, you should be well on top of your backup strategies. These strategies are not written in stone. It is a journey that any database administrator needs to refine over time. Continue to explore new capabilities of th...

DBArtisan is a product developed by IDERA. It is a multi-platform database administration tool that simplifies your day-to-day tasks. One of those tasks is ensuring that database schemas and data and properly copied from instance to instance. Maybe y...

Database security is a hot topic these days, especially with all the new and seemingly never ending security compliance requirements being imposed such as GDPR. This means that DBAs must up their game when it comes to database security. Some DBAs may...

Database security is a hot topic these days, especially with all the new and seemingly never ending security compliance requirements being imposed such as GDPR. This means that DBAs must up their game when it comes to database security. Some DBAs may...

Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to start performance testing. Performance for an application can be a problem on various dimensions: Ope...

No matter what database you’re working with, at some point performance becomes an issue which may require further investigation into possible causes. Often DBAs will first check that there are no obvious issues such as: Database server or VM r...

Everybody would love to find the mythical “go faster” switch in SQL Server. Unfortunately, this switch does not exist. There are, however, many things that you can do with minimal effort that can speed up your SQL Server instances. You ca...

Data governance is a hot topic lately. Companies are trying to devise and implement governance programs in order to provide some structure around how they manage and protect their enterprise data. But before you can manage what you have in your data ...

When deploying SQL Diagnostic Manager for the first time, it may be necessary to register several SQL Server instances that are to be monitored by the tool. While it is possible to register several instances using the GUI, there is another option tha...

On May 25th, 2018, GDPR (General Data Protection Regulation) went into effect.  This regulation affects anyone who collects PII (Personally Identifiable Information) on EU Members.  This means that even if you are a US-based company, you ma...

We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.1 ER/Studio 17.1 contains improvements and enhancements in a number of areas within the product suite: Data Architect: SQL Server 2017 has been added as a new platform ve...

Designing and managing databases can be a daunting tasks. However, defining database coding standards can help keep everything in order. Join IDERA (@Idera_Software) and host Elizabeth Noble (@SQLZelda) on August 22 at 11 AM CT for a community discu...

Windows Server Failover Clustering (WSFC) provides infrastructure features that support the high-availability and disaster recovery scenarios of hosted server applications such as Microsoft SQL Server. If a cluster node or service fails, automaticall...

Part 5: Newly Added Web Services This is the continuation of Part 4: Newly Added Network Services. This is the fifth and final blog post in a series of 5 that will give you an overview of how to configure the UCM Azure monitoring,...

IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 15 new scripts for Microsoft Azure SQL Database. For Azure SQL Database: Initialize the PowerShell module, set scaling levels, set auditing a...

We are pleased to announce the general availability of SQL Enterprise Job Manager 2.2. Existing users may upgrade to this version through the IDERA Customer Portal. New users may download the trial version from the IDERA website. SQL Enterprise Job...

Microsoft SQL Server stores a significant amount of data in the tempdb system database. Consequently, tempdb can fill up quickly when disk space is low, or the maximum size for database growth is small. Also, specific workloads may cause excessive sp...

Part 4: Newly Added Network Services This is the continuation of Part 3: Newly Added Analysis Services. This is the fourth blog post in a series of 5 that will give you an overview of how to configure the UCM Azure monitoring, alerting...

Database Administrators are responsible for an organization’s most important asset - the data.  This responsibility comes with many challenges, demands, and rewards - from ensuring that databases are available and performing for critical b...

Servers are moving from on-prem to the cloud.  Applications are upgraded, so are operating systems, databases, and hardware.  New users, new transactions, and new usage patterns change how & when an application is used.   A hi...