A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database
Effective memory management is crucial for optimal SQL Server performance. Monitoring memory usage helps database administrators identify potential issues and tune database performance. We’ll explore two essential queries that provide insights into how SQL Server uses memory. Prerequisites: Query 1: Read More …
As I am installing ITOP and WordPress I ran into a problem where the authentication did not work. Looking into the issue it seemed the user being created on MySQL needs to be with Authentication Type: Standard. Well, that seems Read More …
Install MySQL Server and workbench on a Windows 2019 Server.