Powershell – Find computer name and domain

Sometimes it’s useful to know the computer name and domain you are working on. The first of the following commands returns the FQDN of the computer on the format whereas the second one returns a list of information about the system. Read More …

Ubuntu 18.04 – Restart network

Here are shown several ways how to restart networking from command line as well as from Graphical User Interface (GUI) on Ubuntu 18.04 Bionic Beaver distribution. Read More …

SQL Server – Creating linked server in SQL Server Management Studio

In SQL Server environments the linked server functionality is commonly used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and access and use the remote data and objects. Read More …

VMware vCenter – Enable Single Sign On (SSO)

Platform Service Controller is a new component in VMware vSphere. The PSC contains all the services that vCenter needs for its functions including Single Sign-On (SSO). This post describes how to configure AD authentication in vCenter Server. Read More …

CentOS / RHEL 7 / Debian – Disable IPv6

If network troubleshooting leads you to believe there’s an issue with IPv6, you may need to shut down that protocol on your Linux machines. Since some hardware doesn’t take advantage of IPv6 (and most admins are still working with IPv4), a temporary and easy solution is to disable IPv6. Read More …

CentOS / RHEL 7 – Regenerate UUID for Network Cards (Physical and Virtualized Environments)

Usually, when cloning VMs on virtualized systems (Hyper-V or VMware, for example) an issue could occur related to vNICs: a vNIC could be renamed and so no more the same of the old VMs (obviously). Read More …

Microsoft SQL Server SSIS – The RPC server is unavailable

Once installed Microsoft SQL Server SSIS (Integration Services) on a Windows Server node, when you try connect to it remotely (SQL Server Integration Service) directly from SSMS you could see an error related to “The RPC server is unavailable”. Read More …

CentOS / RHEL – Managing Networking Service

One of the most common activities on a Linux system is, usually, modify some networking parameters to adapt the system to the actual network; so how can we restart networking service using command line options without restarting the whole system? How can I start / stop and restart networking service on a CentOS/RHEL 7 based system? Read More …

Check mySQL and MariaDB Server Version

There are circumstances where you need to know the version of your database server, e.g., when upgrading the database or patching any known server vulnerabilities. There are a few ways to find out what the version of your MariaDB server is. Read More …

SQL Server – Performance Best Practices

Talking about SQL Server optimization, query tuning is often the fastest way to accelerate SQL Server performance. Most often system-level Read More …