Monitoring & Performance
Security & Compliance
Data Modeling and Architecture
Aqua Data Studio
SQL Development and Tuning
Uptime Cloud Monitor
Uptime Infrastructure Monitor
Ask the Experts
sql diagnostic manager
Blog - Post List
By view count
By comment count
GDPR and the SQL Security Suite
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...
19 Jul 2018
Announcing ER/Studio 17.1 General Availability
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...
19 Jul 2018
August #SQLChat - SQL Server Coding Standards
Designing and managing databases can be a daunting tasks. However, defining database coding standards can help keep everything in order. Join IDERA (
) and host Elizabeth Noble (
) on August 22 at 11 AM CT for a community discu...
19 Jul 2018
Top 5 SQL Server cluster setup mistakes
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...
18 Jul 2018
Lots more support for Azure monitoring! Part 5 of 5
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,...
17 Jul 2018
Updated Free Tool: PowerShell Scripts for SQL Server 6.0: Added Scripts for Microsoft Azure SQL Database
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...
12 Jul 2018
Announcing SQL Enterprise Job 2.2 General Availability
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
. SQL Enterprise Job...
12 Jul 2018
Demystify tempdb performance and manageability
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...
11 Jul 2018
Lots more support for Azure monitoring! Part 4 of 5
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...
10 Jul 2018
Simplify Routine Database Administration Tasks with SQL Admin Toolset
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...
10 Jul 2018
Database Performance History
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...
3 Jul 2018
Lots more support for Azure monitoring! Part 3 of 5
Part 3: Newly Added Analysis Services This is the continuation of
Part 2: Details of All Azure Monitored Services
. This is the third blog post in a series of 5 that will give you an overview of how to configure the UCM Azure monit...
3 Jul 2018
What's new in SQL Compliance Manager 5.5
Earlier this month SQL Compliance Manager version 5.5 was released. We're super excited about some of the new features that are available. One of our Sales Engineers was nice enough to create this video with the highlights and features of...
29 Jun 2018
Why Data Breach is a Significant Part of GDPR
Last week I spoke at DAMA Day in NYC. The day was focused on GDPR and all of the implications in the regulation. I decided to focus my talk on why Data Breach is such a big deal that it has its own articles included in the GDPR Regulation. Data...
28 Jun 2018
Learn about index fragmentation to improve SQL Server performance
As the data in the database tables of Microsoft SQL Server changes, their indexes change. Over time these indexes become fragmented so that ordered data retrieval becomes less efficient. Consequently, the fragmentation adversely affects the performan...
27 Jun 2018
Changing Lanes: Part II. Shifting between Relational and Big Data Platforms
In the last blog
, I covered Shifting Roles with Relational and Big Data Platforms and how that is affecting the people and their roles within companies. This blog will focus on the actual platforms and what it means to be Relational vs NoSQL. W...
26 Jun 2018
Lots more support for Azure monitoring! Part 2 of 5
Part 2: Details of All Azure Monitored Services This is the continuation of
Part 1: Monitor Azure Resources from Uptime Cloud Monitor
. This is the second blog post in a series of 5 that will give you an overview of how to configure th...
26 Jun 2018
How to increase SQL Server performance with existing hardware
Unlike their failed counterparts, solutions are successful solely because systems, users, and organizations have come to depend upon them. Solutions are not necessarily successful because they were well crafted, intelligently designed, or adhere to a...
20 Jun 2018
Lots more support for Azure monitoring! Part 1 of 5
Part 1: Monitor Azure Resources from Uptime Cloud Monitor As of today,
IDERA Uptime Cloud Monitor
(UCM) now supports monitoring for more Microsoft Azure services including Azure Virtual Machines, Azure MSSQL, Azure database for MySQL and Azure d...
19 Jun 2018
Data Lineage - The Power to Connect the Dots in ER/Studio
Howdy! Ever considered or wanted to know how Data would move around the organization? Data Lineage is a key driver that ensures on connecting the right dots with the business and its sources. According to Technopedia: "Definition - What does Da...
18 Jun 2018
How to become a database administrator for SQL Server
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...
13 Jun 2018
Announcing the GA Release of SQL Compliance Manager 5.5
We’re excited to announce the release of SQL Compliance Manager 5.5 SQL Compliance Manager is a comprehensive database auditing solution that monitors and tracks changes to SQL Server objects and data, and sends alerts on suspicious activity. ...
7 Jun 2018
How to learn PowerShell for free
Microsoft’s Windows PowerShell is a task-based command-line shell and scripting language. It is an automation platform and scripting language that simplifies the management of Windows environments. It is designed primarily for system admin...
6 Jun 2018
July #SQLChat - Death of the DBA
“The DBA is dying” has been a common concept for at least 15 - 20 years. What makes this time period different? Join IDERA (
) and host Kenneth Fisher (
) on Wednesday, July 25 at 11 AM CT for a community discu...
6 Jun 2018
Connecting to PostgreSQL and MySQL via ODBC to IDERA's ER/Studio Data Architect
Howdy! Introduction: In this blog post, we will show you how easy it is to connect to MySQL and PostgreSQL via ODBC. As you are aware we can reverse engineer databases natively with SQL Server Oracle Hive Sybase ASE Azure SQLDB and Mongo...
4 Jun 2018