community.idera.comIderaBlog

Products Design Models and Databases ER/Studio Data Modeling Tools DB PowerStudio Aqua Data Studio All DESIGN ProductsMonitor Database Performance SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager for MySQL Precise for Oracle, Db2, and Sybase All MONITOR ProductsProtect Database Integrity SQL Compliance Manager SQL Secure SQL Safe Backup ALL PROTECT ProductsFree Tools Design Databases SQL Data Profiler Rapid Database Extractor MONITOR DATABASE PERFORMANCE SQL Check SQL Query Store Optimizer SQL Fragmentation Analyzer Protect Database Integrity SQL Permissions Extractor SQL Column Search Manage Databases PowerShell Scripts for SQL Server PowerShell Plus Solutions FOR ENTERPRISES Database Monitoring Diagnostics Solutions Security Solutions Data Governance Compliance IT Performance FOR DATABASES SQL Server Oracle Sybase DB2 MySQL Multi Platforms FOR CLOUD SERVICES Cloud Amazon RDS & S3 Azure SQL Database & Blob Storage Google Database Service Oracle MySQL Cloud Service Snowflake FOR APPLICATIONS Application Performance .NET(including SharePoint) PeopleSoft FOR DATA FABRIC ER/Studio Wherescape Qubole Resources SUPPORT Support Plans Product Support Product Documentation Trial Support Legal RESOURCES Resource Center Blog News Partners EVENTS All EventsNewsletter Signup Contact Sales Customer BUY NOW FREE TRIALS  Featured Blog ER/Studio Data Architect 20.1 General Availability by Jamie Knowles 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 and bug fixes to SQL generation to support your design projects. This makes ER/Studio more reliable, faster, and with better-documented output. Get the latest version today! ER/Studio Data Architect 20.1 Updates to Data […] Read More Introducing IDERA ER/Studio Team Server 20.2 with Microsoft Purview Integration by Jamie Knowles ER/Studio Team Server 20.2 delivers hotly anticipated support for integrating with Microsoft Purview. This integration provides two use cases: The... read more Macros – Display or hide the projects tabs by William W. 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. read more Team Server REST API – Create custom pages by William W. Last week, I shared some scripts to automatically bind custom properties from an Enterprise Data Dictionary, to specific ER Objects. Today, I’ll share some scripts which use the Team Server REST API to get the attributes of an entity or the columns of a table with their attachments & security properties, in order to display all these information in a custom page. read more IDERA ER/Studio TeamServer Database Creation – Oracle Edition – Pluggable Database – Final Edition by Anil M Howdy! In today’s blog post we will carry on with the actual setup and scripts needed to create the repository user and the instructions for IDERA... read more Macros – Also add Data Security Information by William W. 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 IDERA ER/Studio TeamServer Database Creation – Oracle Edition – Pluggable Database – Part 1 by Anil M Howdy! In this short blog post, we shall explore on how to create a Pluggable database for our teamserver database Here are the SQL*Plus commands to... read more Macros – Add even more custom properties by William W. 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 A User-Centric Tuning Philosophy by Scott Stone Collaborative Holistic Tuning of the Application Stack When planning for this blog, I deliberated over the title much more than anyone should ever... read more Macros – Add custom properties to specific objects by William W. 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 – Import objects from a diagrams.net | draw.io XML file by William W. 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. read more ER/Studio Data Architect 20.1 General Availability by Jamie Knowles 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... read more Announcing the General Availability of IDERA SQL Secure 4.4 by Shiva Swaminathan We are excited to announce the general availability of IDERA SQL Secure 4.4. IDERA SQL Secure empowers users to identify vulnerabilities in SQL... read more We are excited to announce the General Availability of DB PowerStudio 18.6! by Lisa IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning, and database management. New benefits DB... read more Setting up ER/Studio Professional / Team Server Repository – AzureSQL by Anil M In this tutorial, you will learn how to set up the ER/Studio Repository on AzureSQL, a cloud-based database service. read more Announcing the General Availability of IDERA SQL Compliance Manager 6.2 by Shiva Swaminathan Introducing IDERA SQL Compliance Manager 6.2: The Latest Release of Our Leading SQL Server Auditing Solution SQL Compliance Manager (CM) is the... read more Macros – Colorize specific attributes by William W. 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 SQL Safe Backup 9.2.2 General Availability by Scott Stone 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... read more SQL Defrag Manager 3.8 General Availability by Scott Stone We’re excited to announce the release of SQL Defrag Manager 3.8 SQL Defrag Manager is an industry leading automated performance solution that... read more SQL Diagnostic Manager 12.3 General Availability by Scott Stone SQL Diagnostic Manager 12.3 is available now. Upgrade or download the free trial version from Idera.com. read more Quick Start Video Guide – ER/Studio MetaWizard Import/Export Bridges by William W. 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.” read...