ISTQB Foundation Level 2018 Certification

Recently I decided to do another certification. Since I was able to gain some experience in the context of testing in the last years and because testing is an interesting and important topic, I decided to go for a foundation level certification in testing. ISTQB (International Software Testing Qualifications Board) is a global provider of […]

[HOWTO] Identify objects in EA database that refer to non existing classifiers

While working with Enterprise Architect (EA), it has already happened a few times that for unknown reasons objects in EA database referred to classifier GUIDs that are not or no longer existing. If the underlying database is an oracle database, such entries can be found by using the following SQL query.

[SecondFirstTry] Connecting to a server based repository in Sparx Enterprise Architect with TLS 1.2 correctly

I grabbed the task to transfer a Enterprise Architect repository from one MSSQL server to another. Sparx Enterprise Architect ships with an action called “Project Transfer” that supports repository transfer from DBMS to DBMS, so I decided to use this built-in functionality. Before the project transfer can be started the transfer type (in my case […]

[HOWTO] Create an EA Project in a Microsoft Azure SQL Database

This blog post serves as a thought support and describes the necessary steps to create a Sparx Enterprise Architect project in a Microsoft Azure SQL database. Prerequisites Enterprise Architect v14 Microsoft SQL Server Management Studio 18 (for direct download click here) Enterprise Architect Schema Creation Scripts for Microsoft SQL Server EASchema_1220_SQLServer.sql EASchema_1220_SQLServer_Update1.sql Enterprise Architect Initial […]

WPF Series -13- Advanced Installer

The last post in this series deals with the packaging of a WPF application. To simplify the installation of our WPF application we decided to package the application as MSI (Microsoft Installer) using Advanced Installer. In the following I show you the most important steps in using Advanced Installer. Prerequisites Download Advanced Installer Install Visual […]

WPF Series -12- Global Exception Logging

During development and debugging of our WPF application some exceptions occurred which were not caught by the code. Such unhandled exceptions are not logged automatically. In order to obtain information about any unhandled exceptions in production and to simplify error analysis, we looked for a way to handle and log unhandled exceptions. After some research […]

WPF Series -11- Custom MetroDialog

After a long break it’s finally time to continue with the WPF series. Today I’ll show you how we implemented a custom metro dialog. Our dialog contains 2 comboboxes and gets displayed during data export to determine the accuracy of the data to be exported. Let’s have a look at the code. AccuracySelectionDialog.xaml First we […]

[HOWTO] Create Enterprise Architect Stereotype Reference Data using PowerShell

This is a follow-up to the blog post [HOWTO] Convert Images to Enterprise Architect Model Images. As already described there, we wanted to use the official cisco network topology icons (B/W: EPS (7.6 MB) | JPG (4 MB)) in Enterprise Architect to associate them with elements. The import of the images into Enterprise Architect has […]

[HOWTO] Convert Images to Enterprise Architect Model Images

We wanted to use the official cisco network topology icons (B/W: EPS (7.6 MB) | JPG (4 MB)) in Enterprise Architect to associate them with elements. To avoid importing these icons manually one by one we automated this process by creating model images reference data using PowerShell. The model images reference data can then be […]

[HOWTO] Add ListBox to Visio Sheet and access it in Visual Basic

Last week I had to deal with Visual Basic in Microsoft Visio Professional 2016. I wanted to fill a ListBox with items containing data from an Excel file. First I searched for a ListBox shape in the shapes pane of Visio and added a ListBox shape to the sheet. However I could not access it […]