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 …

Windows 10 – Hide specific User Accounts from the Logon Screen

When you have too many people using your PC, or you want to keep an account secret, use this guide to hide user accounts from the Windows 10 sign-in screen. You can do this using Windows Registry. Read More …

Enabling DNS Registration Refresh Interval

On Active Directory domains is very important that clients set automatically their own DNS names on authoritative DNS servers for Read More …

Linux – Make immutable a file

The chattr command is used by system administrators to restrict the users from changing a file in a particular way or even the administrator can by mistake delete a critical file because of a mis-typed command. But if the immutable flag is set, these mistakes can be avoided. Read More …

Linux – Removing Apache HTTP Server

Removing Apache HTTP Server ensures that, it’s existing files or services will not create conflict when we install Apache HTTP Server from the source code. Read More …

Windows – Clear Group Policy Cache

That’s quite uncommon, but if we need to clear the local cache of Group Policies Objects (GPO) on a workstation/laptop joined to a domain, there are three main methods we can use to accomplish this activity. Read More …