As many companies are coming to realize, the General Data Protection Regulation (GDPR) issued by the EU, which takes effect in May 2018, has a lot...
ER/Studio Data Architect
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Balancing Data and Processes to Achieve Organizational Maturity
On December 19th, 2017, Ron Huizenga presented a DATAVERSITY webinar on the importance of organizational maturity. His experience with manufacturing...
Looking towards 2018 – GDPR Impact
As 2018 quickly approaches, we have a good opportunity to look towards the future. GDPR will go into effect in May and with it we should see...
Getting Prepared for GDPR
GDPR goes into effect on May 25, 2018. Anyone who captures personal data for EU members will be subject to meeting these compliance guidelines or...
Using Business Processes for Data Governance
Business Processes can be a huge asset for you when you are trying to define your Data Governance Policies. While they aren't specifically...
Data Governance Questions You Should Be Asking
October is National Cybersecurity Awareness Month. Many large data breaches have topped news headlines. With all of this great...
IDERA ER/Studio Repository Database Setup and Ports – Part 1 – SQL Server
Howdy! In this latest blog post, I will be covering the Database setup one would need for our IDERA ER/Studio Repository. ...
Tell Me A Data Story – Part Two
Our new 2 minute video, "Tell Me A Data Story - Part Two" tells the story of a growing business that realizes that things are quickly...
Tell Me A Data Story – Part One
Our new 2 1/2 minute video, "Tell Me A Data Story - Part One" tells the story of a small business who realizes that they need to implement...
Logical to Physical Data Modeling
In the last article we learned how to create a data model from scratch using ER/Studio Data Architect. In part II we will explore about how to...
New patch releases available for ER/Studio 16.5.0 (2016+) and also ER/Studio Team Server 16.1.x (2016)
For customers using ER/Studio 16.5.0 (2016+), the 16.5.1 patch release is now available. This patch contains a number of performance...
What is BPMN?
IDERA's ER/Studio Business Architect allows you to draw both Conceptual Models and Business Process Models. Business Process Models use...
How to Secure Your Data in the Cloud
What happened? On Monday, June 12, 2017, a security researcher discovered that sensitive personal data of nearly all the 200 million registered...
Modeling Graph Data Stores in ER/Studio
Modeling Background Enterprise data environments have become increasingly complex due to a proliferation of different technologies and data...
Tutorial : Setting up ER/Studio Repository with Microsoft SQL Server in Amazon Web Services
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Amazon Web Services Cloud Environment....
Big Data is a Big Deal
Data is proliferating at an accelerated rate, with all the mobile and desktop apps, social media, online purchasing, and consumer loyalty programs...
Why Should A Data Modeler Care About Business Processes?
Data Modelers are responsible for creating and maintaining conceptual, logical and physical data models. These data models are used to define...
What are Business Processes??
Business Processes are a set of tasks or activities that help an organization to define and communicate their goals, optimize their...
Is your SQL drawing a blank? It’s NULL a surprise!
The title of this post is a play on words, but very appropriate. We are going to discuss the inconsistent results, as well as performance...
Golden Nugget: Working with The Repository Security Center
ER/Studio Repository is a server-side model management system that solves the day-to-day challenges of modeling in a team environment, where model...
erwin Announces DM 9.7 – Why All the Fanfare?
You may have seen erwin's recent press release contents announcing DM 9.7 on January 23rd, containing a number of new (to erwin)...
The Value of Data Modeling
How do you convince your management that data models are worth the time and effort they require? You may be dealing with challenges around the value...
Golden Nugget : Naming Standards Templates
Howdy! Today we will be exploring a feature called Naming Standards Template. In a Naming Standards Template you can define standards for...
ER/Studio Model Repository Database Sizing Guide for Oracle Database
Howdy! In a previous article, I showcased on how to implement table statistics and Index Re-orgs in SQL Server for the Model...
Building a Business-Driven Data Architecture
In September, IDERA’s Ron Huizenga joined Eric Little and Malcolm Chisholm for a Hot Technologies session, hosted by Eric Kavanagh of the Bloor...
Unique Features of ER/Studio Data Modeling Tool
Data modeling can be challenging for large enterprise architecture environments, but it provides the much-needed structure and context for an...
The Importance of Enterprise Data Architecture
An expert in enterprise data architecture, IDERA’s Ron Huizenga joined several other panelists on a DMRadio session called “Method to...
Setup ER/Studio Repository with Microsoft SQL Server in Amazon Web Services
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Amazon Web Services Cloud...
Setting up ER/Studio Repository with Microsoft SQL Server in Microsoft Azure Virtual Machines
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Microsoft Azure Cloud. Now I will not be...
ER/Studio Technical Training Sessions by e-Modelers
Are you looking for a deep-dive multi-day online training session for ER/Studio? IDERA is committed to helping our customers make the best use of...