Featured Blog
ER/Studio 20.0 GA
ER/Studio 20.0 delivers a variety of performance improvements, usability features, security improvements, and bug fixes. As a bonus, we’ve improved scalability for enterprise-level usage. Get the latest version today!
TempDB Troubles: Identifying and Resolving TempDB Contentions
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction The tempdb system database is a global resource in Microsoft SQL...
Announcing General Availability of DB PowerStudio (DBPS) version 18.5
We are pleased to announce the general availability of DB PowerStudio version 18.5! IDERA’s DB PowerStudio provides a powerful cross-platform...
Why Data Model? Part 5: We Data Model to be Smart
Author This blog post was authored by Todd Schraml. Always Normalize Logical Data Models The logical data model reflects the common language of the...
ER/Studio 20.0 GA
We are pleased to announce the general availability (GA) of IDERA ER/Studio Data Architect 20.0
ER/Studio 20.0 delivers a variety of performance improvements, usability features, security improvements, and bug fixes. As a bonus, we’ve improved scalability for enterprise-level usage. Get the latest version today!
SQL Server Alert Management: From Chaos to Clarity
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction In the fast-paced world of database administration, staying ahead...
Why Data Model? Part 4: We Data Model to Give Proper Focus to the Enterprise
Author This blog post was authored by Todd Schraml. Unify the Enterprise With Data Modeling Acting locally can be very different than acting...
Navigating SQL Server CPU and Memory Usage Woes
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft SQL Server is a powerful database management system, but...
Why Data Model? Part 3: We Data Model to be Efficient Developers
Author This blog post was authored by Todd Schraml. Why Are Logical Data Models So Important? The logical data model is the foundational artifact...
Save Money and Space With SQL Inventory Manager from Idera
As organizations grow, their data processing and storage needs often grow too. It can be easy to lose track of your inventory when you're in charge...
Making the Most of Historical Data: Preventing Future SQL Server Issues
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Forecasting future SQL Server performance issues can often feel...
Why Data Model? Part 2: We Data Model to Communicate Better
Author This blog post was authored by Todd Schraml. Why Are Entity-relationship Diagrams So Important? One of the IT-only curse words across the...
Announcing the General Availability of IDERA SQL SAFE Backup 9.2.1
Introducing IDERA SQL SAFE Backup 9.2.1: The Latest Release of Our Leading SQL Server Backup Solution IDERA SQL Safe Backup is a comprehensive...
Why Data Model? Part 1: We Data Model to be Good Business Partners
This blog post was authored by Todd Schraml. How Did Data Modeling Get Started? Back when dinosaurs still ruled the world, or at least wax figurines...
Deciphering the SQL Server Performance Mysteries
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft's SQL Server is a robust and widely adopted database...
Do you know the Risks to your Database?
Databases are vitally crucial to modern businesses across all market sectors. They are the repository of an organization’s information resources,...
Harnessing Big Data: A Strategic Advantage for Modern Organizations
There are different claims regarding the coinage of the term big data, but the concept of big data has existed since the mid-20th Century....
ER/Studio 19-3-5 GA
We are pleased to announce the general availability (GA) of IDERA ER/Studio Data Architect 19.3.5 ER/Studio Data Architect 19.3.5 delivers improved...
Key Insights into Ensuring SQL Server Security with These Practices
There are several examples where data theft has halted businesses or resulted in bad press that will leave a tarnished image. For instance, in 2017,...
Macros – The Voice of Data Architect
ER/Studio Data Architect supports programmatic event handling.
To better understand when these events are triggered, I’ll share an updated script of the sample macro: ERSBasicHandlers.bas
Moreover, I’ll also share a second macro which speaks the definition of the selected entities|tables.
Macros – Bulk Harvesting from Excel Spreadsheet List
In a previous post, we have seen how to schedule a reverse engineering of a database using a macro and a quick launch file.
Likewise, I’ll share a macro which also uses the reverse engineer function, through the DiagramManager.ReverseEngineerObject.
However, instead of using a quick launch file, the macro directly extracts the connection settings from an Excel workbook.
Macros – Quickly update the Dimensional Model Table Types
Many different models and notations are supported by ER/Studio Data Architect. A model has one of these 2 model notations: Relational or Dimensional.
When we use a Dimensional diagram, there’s an additional tab available in the Table editor, Dimensional, where we can select the Dimensional Model Table Type and the Table Type and Data Architect updates how the diagram objects are displayed.
In this blog post, I’ll share a macro which replaces the Dimensional Model Table Type and the Table Type for all the Tables|Entities or a selected subset.
Macros – Using macros to import/export attachment bindings to Excel
When we use ER/Studio Data Architect, we can create Submodels to document specific metadata.
For example, we can create Submodels to manage our Conceptual Data Model, to display the datatypes and Null option, or to show the Attachments and Data Security Information bound to the Entities | Tables.
In this blog post, I’ll share 2 different macros which can also export|import the entity and attribute attachment binding information to|from Excel.
Improve SQL Server Usage Management and Efficiency
If your organization deals with a high volume of customer data, telemetry, or other metrics, it’s likely you'll have some substantial databases to...
Macros – Generate lookup tables from Reference Values
With ER/Studio Data Architect, we can use the Data Dictionaries to define Reference Values and to bind them to our Attributes|Columns.
I’ll share a script to generate the lookup tables for all the columns of the selected Tables which use Reference Values Lists. With Physical Data Model, it also generates in the Post SQL tab of the created Reference table, the Insert statements.
Macros – Remove diagrams from the repository using an Excel workbook
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.
Webinar extracts – Do you need to model hierarchical data such as JSON, MongoDB, and Google BigQuery?
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.
Get French Holidays
I saw this blog post and I decided to publish this one for France. Here is a PowerShell function that gets all French holidays…
Compliance and Backup Strategy: A Closer Look at the Connection
The Intersection of Compliance and Digital Data Organizations of all sizes and shapes must comply with government and industry regulations. Some...
Macros – Using macros to create Data Vault objects
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.
Announcing the General Availability of IDERA SQL Compliance Manager 6.1
Introducing IDERA SQL Compliance Manager 6.1: The Latest Release of Our Leading SQL Server Auditing Solution SQL Compliance Manager is the leading...