The following SQL Query provide list of databases: SELECT name, database_id, create_dateFROM sys.databases;GO See also the Microsoft documentation for View list of databases on SQL Server

The following SQL Query provide list of active connections. SELECTDB_NAME(dbid) as DBName,COUNT(dbid) as NumberOfConnections,loginame as LoginNameFROMsys.sysprocessesWHEREdbid > 0GROUP BYdbid, loginame; See also the Microsoft documentation for sys.sysprocesses.

This explains how to add a cron job to ESXi host. And later make it reboot persistent. Firstly, add the cron job to the root crontab:Edit /var/spool/cron/crontabs/root # vi /var/spool/cron/crontabs/root Add the line (all on one line) 5 0 * *

Continue ReadingESXi – Add cron Job

TuneD project: https://tuned-project.org/ TuneD is a system tuning service for Linux. It provides a number of pre-configured tuning profiles, each optimized for unique workload characteristics, including CPU-intensive job needs, storage/network throughput responsiveness, or power consumption reduction. Install TuneD on OpenSUSE: sudo

Continue ReadingOptimize a host with TuneD

I had a new system, and have installed OpenSUSE 15.5 on it.So far so good, but later I noticed that using my mobile phone as network device was no longer working. I found this page Tethering via USB doesn’t works

Continue ReadingUsing tethering via USB port

Prerequisites Step 1: Installing BIND As always start with updating the system: Once updated and reboot, install BIND and its utilties Edit the main BIND configuration file named named.conf: Inside the configuration file, set the options for your DNS server.

Continue ReadingHow to Set Up a Primary DNS Server with BIND on CentOS 9

I know, Oracle Linux Virtualization Manager is scheduled to be end-of-life (in 2026). But still wanting to be able to install it, was a bit more difficult. Mainly due the fact it’s EOL (I presume). But here are the installation

Continue ReadingInstalling oVirt on Oracle Linux (Self-Hosted)

By default you can not log in to Cockpit by root user. You can fix this issue by editing the /etc/cockpit/disallowed-users file. Remove the root entry. (if needed add/remove other users if applicable). Restart Cockpit service: Now you can access

Continue ReadingAllow root access to Cockpit

Prerequisites Installation Cockpit Login into the server. Fist step is to update the system: Once updated and rebooted, install Cockpit When installed, enable and start the Cockpit service Configuring Firewall If firewall is running, you need to allow traffic on

Continue ReadingHow to Install and Set Up Cockpit on CentOS 9