BLEIBEN SIE INFORMIERT
mit den ORDIX Newslettern!

Melden Sie sich für unsere Newsletter an und erhalten Sie exklusive Updates zu IT-Trends, spannenden Seminaren und Neuigkeiten der ORIDX AG.

BLEIBEN SIE INFORMIERT
mit den ORDIX Newslettern!

Melden Sie sich für unsere Newsletter an und erhalten Sie exklusive Updates zu IT-Trends, spannenden Seminaren und Neuigkeiten der ORIDX AG.

Code Coverage – Not a Reliable Quality Measure
Dr. Natalie Nikitin
News
One of the typical requirements for new software is a prescribed minimum level of code coverage, i.e., the proportion of the source code that is executed by automated tests. Especially in areas such as medical technology, the automotive industry, or financial systems, 100 % code coverage is often required. But even code that is completely covered b...
Weiterlesen
I don't want to know the password – Using group Managed Service Accounts for Microsoft SQL Server
Andreas Jordan
Microsoft SQL Server
A few days ago, I changed the service account of the SQL Server instances in my lab environment for Always On Availability Groups and now use a group Managed Service Account (gMSA). In the following, I present the necessary adjustments. Which service account do we recommend? As a service account for Microsoft SQL Server, we now generally recom...
Weiterlesen
SQL Server is no longer allowed to phone home – uninstalling CEIP/TELEMETRY service
Andreas Jordan
News
Which services have been created during the installation? After installing a SQL Server instance, I typically look at the installed services with the customer or training participants. During installation, the “SQL Server Configuration Manager” is set up and linked in the Windows Start menu. The advantage of this interface is that only the services...
Weiterlesen
Make yourself invisible: MySQL Generated Invisible Primary Keys
Matthias Jung
MySQL (PDO)
Now and then, smaller, or larger problems arise during consulting missions involving MySQL, which we would like to report here. In this case, our customer wanted to replace a MySQL single instance with a MySQL InnoDB cluster with three nodes. We have reported about the cluster here several times and do not discuss it in detail here. In this specifi...
Weiterlesen
Hello? Is anyone out there? MySQL User Tracking
Matthias Jung
News
In many cases, database accounts accumulate over many years. Especially if no IAM (Identity Access Management) or “Singe-Sign-On” solution is used, the situation arises that accounts “remain lying around” although the real existing user is no longer in the company. Unfortunately, there is no internal system view (table / view) that directly answers...
Weiterlesen
SQL Server and Kerberos: Please do not forget the Service Principal Names
Andreas Jordan
Data Management
When using Windows authentication for a connection to a Microsoft SQL Server, Kerberos is the first choice. Only if the use of this authentication scheme is not possible, NTLM (NT LAN Manager) is used. This is transparent for the user, and NTLM does not impose any restrictions in most cases. Therefore, in many environments it is not even noticed th...
Weiterlesen