Featured Blog
ER/Studio Data Architect 20.1 General Availability
Macros – Add even more custom properties
This post follows the previous one, “Macros – Add custom properties to specific objects”, where we shared scripts to automatically bind Attachments to ER Objects.
In this one, we will share new versions of the different scripts that allow using shared Attachments for various types of ER Objects (instead of duplicating them for each ER Object), and also support Relationships and Views.
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...
Macros – Add custom properties to specific objects
Sometimes, you may need to specify custom properties for various objects such as Entities, Tables, Attributes, etc.
The macros I’ll be sharing in this post, allow us to:
– Export the attachments from the current project
– Import attachments from an Excel Workbook
– Bind the attachments to specific objects (Entities, etc.).
Macros – Import objects from a diagrams.net | draw.io XML file
A script that imports a particular diagrams.net XML file (formerly draw.io) including specific Data used to retrieve the properties required to create the Entity Relationship Diagram.
ER/Studio Data Architect 20.1 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio Data Architect 20.1 ER/Studio 20.1 delivers a variety of improvements...
Announcing the General Availability of IDERA SQL Secure 4.4
We are excited to announce the general availability of IDERA SQL Secure 4.4. IDERA SQL Secure empowers users to identify vulnerabilities in SQL...
We are excited to announce the General Availability of DB PowerStudio 18.6!
IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning, and database management. New benefits DB...
Setting up ER/Studio Professional / Team Server Repository – AzureSQL
In this tutorial, you will learn how to set up the ER/Studio Repository on AzureSQL, a cloud-based database service.
Announcing the General Availability of IDERA SQL Compliance Manager 6.2
Introducing IDERA SQL Compliance Manager 6.2: The Latest Release of Our Leading SQL Server Auditing Solution SQL Compliance Manager (CM) is the...
Macros – Colorize specific attributes
Using the data modeling features of ER/Studio Data Architect we can create automatic and customized data model diagrams. ER/Studio Data Architect provides functionality such as automatic layouts, custom colors and fonts for our objects, and relationship line control.
To make our model more attractive and easier to read, we can change the background, outline, and font colors along with the font type entities/tables, attributes/columns, views, and relationships in our data model. We can use specific colors and/or fonts to help us organize our data model.
In this blog post, I’ll share a macro which shows how to manage the colors from a script. With the macro, we can search for a string and colorize the attributes and columns which match the string.
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.
Quick Start Video Guide – ER/Studio MetaWizard Import/Export Bridges
Are you ready to streamline your data management processes effortlessly?
Look no further!
We are thrilled to announce the release of our latest video guide: “ER/Studio MetaWizard Import/Export Bridges – Quick Start Video Guide.”
SQL Diagnostic Manager for MySQL 8.9.5 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager (SDM) for MySQL 8.9.5 Existing users may upgrade to this version...
How to Set Up IDERA ER/Studio Repository Database on SQL Server
This tutorial guides you through the process of setting up IDERA ER/Studio Repository on a Microsoft SQL Server. It is essential to ensure that the SQL Server environment is correctly configured to support ER/Studio Repository.
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 profiling sessions, open many different tabs, you may need to adjust the memory used by DB Optimizer to avoid out-of-memory errors.
Macros – Add or Remove the Relationships in the Submodels
ER/Studio Data Architect provides an important navigation feature called Submodels.
In this post, I’ll share a macro which can be used to add|remove the relationships to|from the submodels.
General Availability of Aqua Data Studio (ADS), version 23.1!
Aqua Data Studio is the industry-leading multi-platform Integrated Development Environment (IDE) for databases with Visual Analytics. This...
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 may need to adjust the memory used by DB Change Manager to avoid out-of-memory errors.
Database Backup and Restores Drills in SQL Server
Creating backups and restoring them is crucial for maintaining the integrity and availability of data in Microsoft SQL Server. Here's a set of...
Setting up Failover Groups for AzureSQLDB for IDERA TeamServer
Setting up Failover Groups for Azure SQL Database is crucial for ensuring high availability and disaster recovery. Here’s a step-by-step guide to...
Macros – Switch domains from one data dictionary to another one
In this post, I’ll be sharing a macro based on this sample, updated to switch the bindings for all the domains included in the source dictionary and available in the target data dictionary (with the same name). If there’s no domain with the same name in the target data dictionary, the domain binding will remain unchanged.
For instance, if you intend to replace the domain bindings from the local data dictionary with those included in an Enterprise Data Dictionary.
Using the Glossary Tool Tips
With Team Server, you can easily manage your Business Glossaries and Terms. You can directly create them in Team Server or you can synchronize them with Collibra.
Macros – How to edit the Definitions and Notes with Excel
In this post, I’ll share a video which shows how to export your Definitions and Notes from ER/Studio Data Architect, edit them with Excel, and finally import the updated Definitions and Notes back to ER/Studio Data Architect.
The Locks, Blocks, and Deadlocks of SQL Server: Unraveling the Knots
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Concurrency control is a fundamental part of any database...
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...
Announcing General Availability of DB PowerStudio (DBPS) version 18.5
We are pleased to announce the general availability of DB PowerStudio version 18.5! IDERA’s DB PowerStudio provides a powerful cross-platform...
Why Data Model? Part 5: We Data Model to be Smart
Author This blog post was authored by Todd Schraml. Always Normalize Logical Data Models The logical data model reflects the common language of the...
ER/Studio 20.0 GA
We are pleased to announce the general availability (GA) of IDERA ER/Studio Data Architect 20.0
ER/Studio 20.0 delivers a variety of performance improvements, usability features, security improvements, and bug fixes. As a bonus, we’ve improved scalability for enterprise-level usage. Get the latest version today!