Understanding SQL Server Deadlocks In SQL Server management, deadlocks are a common yet frustrating issue that can disrupt database performance. A...
![How to Avoid SQL Server Deadlocks: 5 Essential Steps for DBAs](https://blog.idera.com/wp-content/uploads/2024/06/AdobeStock_584971759-1080x675.jpeg)
Understanding SQL Server Deadlocks In SQL Server management, deadlocks are a common yet frustrating issue that can disrupt database performance. A...
The newest version of SQL Compliance Manager is here! SQL Compliance Manager enables you to proactively monitor, alert, and report on the compliance...
Essential Data Security Measures to Avoid Data Breaches Data breaches have become an increasingly significant threat to organizations of all sizes,...
Don’t Take Chances - Backup Your SQL Data! With an overwhelming amount of blog posts, news articles, LinkedIn horror stories, and water cooler chats...
Learn about SQL Server to Azure migration and follow these procedures for a trouble-free migration process If you’re thinking about migrating your...
Create a solid recovery plan. A critical part of your backup process needs to include recovery procedures. You should have a rehearsed recovery...
Don’t Be a Victim. Stay Ahead of These Top SQL Security and Compliance Threats You don’t have to be a DBA in the trenches to know that there have...
Within ER/Studio Data Architect, we have the option to view one tab for each opened project or to hide these tabs.
In this post, I’ll share a macro that allows us to toggle the display of project tabs.
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.
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.
Collaborative Holistic Tuning of the Application Stack When planning for this blog, I deliberated over the title much more than anyone should ever...
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.).
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.
We are excited to announce the general availability of IDERA SQL Secure 4.4. IDERA SQL Secure empowers users to identify vulnerabilities in SQL...
IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning, and database management. New benefits DB...
Introducing IDERA SQL Compliance Manager 6.2: The Latest Release of Our Leading SQL Server Auditing Solution SQL Compliance Manager (CM) is the...
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.
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...
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 is available now. Upgrade or download the free trial version from Idera.com.
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...
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.
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.
Aqua Data Studio is the industry-leading multi-platform Integrated Development Environment (IDE) for databases with Visual Analytics. This...