Featured Blog

Navigating SQL Server 2014 End of Life: What it Means for Your Data and How Idera Can Help

by

In July 2024, Microsoft SQL Server 2014 reached its end of life (EOL). This milestone marks the end of extended support from Microsoft, which has significant implications for your databases and data if you’re still running SQL Server 2014. Whether you’re a seasoned Database Administrator (DBA) or a business professional, understanding what this means and […]
Read More

Macros – Also add Data Security Information

by

This is the third post regarding the binding of custom properties to specific ER objects.

In this one, we’ll support some new ER objects (Models, Submodels, Business Data Objects) and we’ll filter the types of ER objects that can be bound to each Attachment Type.

Even more importantly, we’ll also integrate the Data Security Information so it can also be automatically bound to their relative ER Objects.

read more

Macros – Add even more custom properties

by

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.

read more

Macros – Add custom properties to specific objects

by

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.).

read more

Macros – Colorize specific attributes

by

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.

read more

How to adjust the Java heap size of DB Optimizer

by

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.

read more

Macros – Switch domains from one data dictionary to another one

by

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.

read more
1 2 3 … 88

Categories