After a while, you may have added lots of projects in your ER/Studio Repository.
In this blog post, I’ll share a script which can generate a worksheet with all the Diagrams added to the Repository and remove diagrams from the Repository using a list provided through a spreadsheet.
On August the 22nd, I have presented a webinar: Do you need to model hierarchical data such as JSON, MongoDB, and Google BigQuery?
In this post, I’ll share a video with the most interesting extracts. This video provides chapters, so do not hesitate to navigate to the ones you are the most interested by.
I saw this blog post and I decided to publish this one for France. Here is a PowerShell function that gets all French holidays…
The Intersection of Compliance and Digital Data Organizations of all sizes and shapes must comply with government and industry regulations. Some...
Some years ago, Sultan shared a post regarding Data Vault modeling with ER/Studio. I strongly recommend to read it before this one.
The different Data Vault providers implement common objects but the attributes can differ. In this blog post, I’ll share an archive with some macros which can create hubs, satellites and links.
Introducing IDERA SQL Compliance Manager 6.1: The Latest Release of Our Leading SQL Server Auditing Solution SQL Compliance Manager is the leading...
Aqua Data Studio is the industry-leading multi-platform Integrated Development Environment (IDE) for databases with Visual Analytics. This...
In Part 1, we discussed the properties of big data and how it affects the data gathered in the healthcare industry. Here we go over methods for...
We are excited to announce the general availability of IDERA SQL Secure 4.3. IDERA SQL Secure empowers users to identify vulnerabilities in SQL...
On May the 9th, I have presented a webinar: Maximize Your Productivity with ER/Studio Macros: The Magic Wand for Data Modelers
In this post, I’ll share a video with the most interesting extracts. This video has chapters, so do not hesitate to navigate to the ones you are the most interested by.
Visio can draw charts, plans and diagrams.
Some people have used Visio to create their Logical and/or Physical Data Models and they would like to import their drawings in a data architecture and design tool: ER/Studio Data Architect.
In this blog post, I’ll share 2 scripts which can import Entities & Attributes from a Visio Drawing page. I have tested it with 2 different samples…
Analytics for big data has rapidly become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions...
In my previous post, I shared a script to quickly manage your macro shortcuts. In this one, I’ll share 3 different scripts to expand or collapse your Business Data Objects.
Introducing IDERA SQL SAFE Backup 9.2: The Latest Release of Our Leading SQL Server Backup Solution IDERA SQL Safe Backup is a comprehensive...
In this post, I’ll share a script which lets you add shortcuts to macros that you may want to quickly access from various places in ER/Studio Data Architect.
This code will allow you to quickly manage your macro shortcuts and associate them with any existing macros, including those in any subfolders beneath your Macros Directory.
Migrating SQL Server to Azure SQL Database provides essential benefits. Such advantages include the following: lower cost by shifting expenses from...
We are pleased to announce the general availability (GA) of IDERA ER/Studio Team Server 19.3.3 ER/Studio Team Server 19.3.3 delivers support...
The data management professionals of today are finding their landscape changing. They have multiple database platforms to manage and need to control...
As businesses and government organizations shift a growing amount of their operations online, data security has become an increasingly important...
The data warehouse is an established concept and discipline that is discussed in books, conferences, and seminars. Indeed, data warehouses are a...
As with any database, there are many ways to compare the data within a MySQL database. We can compare data for: Accuracy: If we entered the data...
Many information technology professionals may not recognize it, but the bulk of their work has been and continues to be nothing more than database...
Data modeling is data governance. We define data governance as the execution and enforcement of authority over the definition, production, and usage...
In my previous blog post, I shared a PowerShell Script which uses the ER/Studio Data Architect COM automation interface.
During this post, we’ll create an application, using the Microsoft .NET Framework with the language C#, which can also connect to ER/Studio Data Architect.