Featured Blog
ER/Studio Data Architect 20.1 General Availability
Mastering the Complexities of Analytics for Big Data in Healthcare, Part 2
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...
Announcing the General Availability of IDERA SQL Secure 4.3
We are excited to announce the general availability of IDERA SQL Secure 4.3. IDERA SQL Secure empowers users to identify vulnerabilities in SQL...
Webinar extracts – Maximize Your Productivity with ER/Studio Macros: The Magic Wand for Data Modelers
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.
Macros – Sample macros to import Logical and Physical Data Models from Microsoft Visio to ER/Studio Data Architect
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…
Mastering the Complexities of Analytics for Big Data in Healthcare, Part 1
Analytics for big data has rapidly become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions...
Macros – Using macros to expand or collapse Business Data Objects
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.
Announcing the General Availability of IDERA SQL SAFE Backup 9.2
Introducing IDERA SQL SAFE Backup 9.2: The Latest Release of Our Leading SQL Server Backup Solution IDERA SQL Safe Backup is a comprehensive...
Macros – Shortcuts: a macro to rule them all
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
Migrating SQL Server to Azure SQL Database provides essential benefits. Such advantages include the following: lower cost by shifting expenses from...
ERS 19.3.3 GA
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...
Deploy and manage complex Azure environments
The data management professionals of today are finding their landscape changing. They have multiple database platforms to manage and need to control...
How to Maintain Security Compliance to Prevent a Costly Breach
As businesses and government organizations shift a growing amount of their operations online, data security has become an increasingly important...
Learn about modern data architecture
The data warehouse is an established concept and discipline that is discussed in books, conferences, and seminars. Indeed, data warehouses are a...
Visually compare data in MySQL
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...
Learn more about database migrations
Many information technology professionals may not recognize it, but the bulk of their work has been and continues to be nothing more than database...
Discover why data modeling is data governance
Data modeling is data governance. We define data governance as the execution and enforcement of authority over the definition, production, and usage...
Using C# and .Net to access Data Models
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.
Monitor top metrics in MySQL databases
How MySQL databases perform can affect your organization. For example, if your site takes too long to load or has too many server errors, it can...
Tips for data warehouses and other extensive databases
Whether on-premises or in the cloud, organizations often ask database administrators to create and manage optimal database designs for data...
DBTA 100 2023: The Companies That Matter Most in Data
The need to balance data safety with new data initiatives, deliver business value, and change company culture around data tops this year’s list of...
Understand the return on investment (ROI) in data modeling
For over three decades now, data modeling has been the leading discipline for understanding business data requirements and representing them in a...
Become a SQL Server Management Studio Hero
The world is full of exciting challenges, and we are constantly running daily, chasing our dreams. Especially in the software ecosystem, it is not...
Using PowerShell to organize Data Model Projects
Years after years we are creating new models. Maybe we save all the different projects to the same folder. After a while, we can have many projects in this directory.
This blog post shares a PowerShell Script which copy|move the project files to subfolders created by using the Copyright Year of the projects.
Synchronize MySQL data
Lost your work because you forgot to back it up? Having your database developers do a mountain of work in a short time frame is not the best way to...
Work with and support multiple database platforms
In the ever-changing world of technology, we sometimes inherit environments with multiple database platforms and must continue to manage them. This...
Agile data modeling is not an option but essential
The time has passed when data models could hide in an ivory tower (IT) and locked behind bars only for the IT in‐crowd to be consulted. It is their...
How did the database administrator role change in 2022?
Organizations are experiencing the effects of rapid technological advancement across every sector and industry, causing them to rely on secure and...
Team Server REST API – Import into Google Sheets
In my previous post, we have seen how to obtain the authorization to use the API.
In this one, we create a new blank spreadsheet in Google Sheets which uses the Team Server REST API to directly import and refresh the objects we want.
Design data intensive cloud native applications
The cloud is transforming the way modern-day applications are being designed. Data is at the center of multiple challenges while architecting...
Model data for MongoDB and JSON
Data modeling produces a set of structures for a relational database management system (RDBMS). First, we build the conceptual data model (CDM) to...