The data management professionals of today are finding their landscape changing. They have multiple database platforms to manage and need to control...
Peter
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...
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...
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...
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...
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...
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...
Fundamentals of database people and DevOps
DevOps is a software delivery philosophy that focuses on delivering quality faster. The environment of everyone is different. But we can translate...
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...
Understand indexes to write better queries
It is easy to learn how to query a database for information. SQL is a declarative language, meaning we tell the engine what to get, not how to get...
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...
Compare four leading database tools
Today, many roles within an organization work with the ever growing amounts of data in databases. No longer are databases the purview of just the...
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...
ER/Studio and metadata
What is metadata? The term metadata arises often when discussing data architecture. Summarizing, it refers to data about data. However,...
Achieve more with fewer resources
The current uncertainty in the economy is causing many organizations to look for ways of making their operations more productive. These...
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...
Data modeling solutions for data warehousing and business intelligence
IDERA helps business intelligence (BI) and data warehouse (DW) architects to better design, document, and reuse data elements to create a more...
How to select a database tool
Choosing a database development and management tool does not need to be a complicated process, but you should at least determine what features are...
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...
Improve database development
Wherever data takes the organization, the database must follow. And wherever the database goes, database administrators and developers must take the...
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...