The data warehouse is an established concept and discipline that is discussed in books, conferences, and seminars. Indeed, data warehouses are a...
data architecture
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...
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...
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...
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...
Ensure a sustainable architecture for data analytics
Today, you cannot pick up a magazine, read a blog, or hear a webcast without the mention of big data. It has had a profound effect on our...
Setting up IDERA TeamServer Database inSQL Server Availability Groups! – Part 2
TeamServer Database in SQL Server Availability Groups! - Part 2 Howdy! As promised this is part 2 of the setup for IDERA TeamServer in a SQL...
Setting up IDERA TeamServer Database inSQL Server Availability Groups! – Part 1
Setting up IDERA TeamServer Database in SQL Server Availability Groups! - Part 1 Howdy!! Folks! As promised.. I have successfully managed to setup...
Agile versus fragile data modeling workflow
Many data modelers are finding out that their traditional data modeling processes are not a good fit for modern software development methods, such...
Build stronger data architecture teams
When teams work together with a common goal and a passion for success, their projects succeed. When the opposite occurs, everyone loses, including...
Improve data modeling for better data governance
Are your data models supporting data governance? Most data professionals have been involved in data governance programs in our careers. These...
Understanding Azure SQL Database Architecture
This blog will give you a glimpse into the internal architecture of SQL Database and brings to light some of the critical concepts that SQL Database...
Master data modeling for master data domains
Greater dependence on enterprise-class applications has created a demand for centralizing organizational data in their support. Imperatives such as...
Make the most of your metadata
Metadata management is not a new concept. However, it is gaining new adherents as we recognize the value of enterprise data governance. We may have...
Empower operational data governance with data lineage
Much of the conventional guidance about implementing a data governance program focuses on organizational structure and the protocols for defining...
Enable customer business intelligence with data catalogs, business glossaries, and data governance
For over three decades, organizations have relied on data warehouses to support the needs for descriptive analytics of business information...
Align data governance with business-driven data architecture
The role of the data analyst has gained prominence in relation to the recognized criticality of processed and analyzed information as an integral...
We are pleased to announce the general availability (GA) of IDERA ER/Studio 19.2
ER/Studio 19.2 delivers a whole new approach to modelling hierarchical structures such as document-based NoSQL platforms and file formats, with...

Geek Sync | How to Select the Appropriate Approach to Data Governance
There are three distinct approaches organizations can follow to implement Data Governance. There is the command-and-control approach, the...

Documenting a Database
ER/Studio has two primary use cases; designing databases and documenting databases. In this blog we will discuss documenting a database. We need to...

ER/Studio 18.3 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio 18.3 ER/Studio 18.3 contains support for the latest versions of the...

Adapt to the current challenges with collaborative data modeling, architecture, and governance.
Conditions are changing: How can we bring data concerned staff together? The working patterns of people are transforming quickly. People need access...

The Seven Use Cases of ER/Studio
We have been going back to basics with ER/Studio and making sure we do a great job at what the product sets out to deliver. We have narrowed down to...

Large Financial Organization Using ER/Studio to Manage Data – Case Study
This is one of our larger clients. They are a huge financial organization. They use ER/Studio to document and design data assets. As they say...