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.
Introducing IDERA SQL Compliance Manager 6.1: The Latest Release of Our Leading SQL Server Auditing Solution SQL Compliance Manager is the leading...
Windows laptops (and servers, too) can get hot, especially during summer. Surprisingly, there is no simple built-in way in Windows to monitor...
Here is a PowerShell function that gets all German holidays, either nationwide or just for your state: function Get-GermanHoliday { param (...
Aqua Data Studio is the industry-leading multi-platform Integrated Development Environment (IDE) for databases with Visual Analytics. This...
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...
With Administrator privileges, a Windows system provides access to the diagnostic data gathered during startup. Windows logs the start time and...
We are excited to announce the general availability of IDERA SQL Secure 4.3. IDERA SQL Secure empowers users to identify vulnerabilities in SQL...
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.
Microsoft Graph is a new unified programming model to manage cloud services such as Microsoft 365 and Azure. Many PowerShell modules and cmdlets...
You may have accounts (inc. trust accounts) in AD that have a null value for msds-SupportedEncryptionTypes. They may have been working "by accident"...
Creating a new file share for your network requires Administrator privilege and this PowerShell code: $Parameters = @{ Name = "Packages" Path =...
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…
To safely enter input, scripts need to display a masked input. The easiest way to do this is to use Read-Host -AsSecureString: # Read-Host $entered...
Analytics for big data has rapidly become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions...
Windows Control Panel is the GUI center for any system configuration. You can launch control panel via console command, too: control [ENTER]....
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.
Get-EventLog is a highly popular cmdlet in Windows PowerShell. With just a few simple parameters, it reads event logs from the primary Windows event...
Ever wanted to automatically convert dates to zodiacs? Here is a fascinatingly simple script that can do it for you, both in English and German:...
Here is a simple and generic way to turn DateTime information into just the ISO string data components you require. For example, if you just need...
Introducing IDERA SQL SAFE Backup 9.2: The Latest Release of Our Leading SQL Server Backup Solution IDERA SQL Safe Backup is a comprehensive...
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 provides essential benefits. Such advantages include the following: lower cost by shifting expenses from...