Nginx – Enable HTTP/2

Hypertext Transfer Protocol Version 2 (HTTP/2) is the latest version of the HTTP protocol, published as an IETF standard in RFC 7540 in 2015. The focus of the protocol is on performance; specifically, end-user perceived latency, network and server resource usage. Read More …

Powershell – Check and find the product GUID of an installed MSI setup

The product code is the unique GUID of identifying an application or product release; In other words, different versions and languages of Product must have different product codes. Also, ProductCode can be used to query feature state, and product state. For example, installer API “MsiQueryFeatureStateEx()” and “MsiQueryProductState()”, etc. Read More …

Linux – scp transfer files (passwordless) between systems

SSH (Secure SHELL) is a network protocol that is used to login into remote servers for execution of commands and programs. It is also used to transfer files from one computer to another computer over the network using secure copy (SCP) Protocol. Let’s see how to automate, passwordless, using Public/Private keys, file transfers between systems. 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 …

Microsoft Edge – Open from Run or Command Prompt

As many (almost all) applications available on Microsoft Windows platforms can be called from Run command (as even from Command Prompt and Powershell). Users who have been experiencing issues with the Start menu or Start menu search can use the Run command to launch their favorite programs, admin tools and settings. 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 …

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 Server 2016 – Disk and Share quorum members (Failover Clustering)

Let’s begin by saying and focus that computer clusters (Windows-based) require 3 or more voting member systems to be stable. A failover cluster is a group of independent servers which work collaboratively to ensure high availability and scalability for workloads such as File Server, Exchange, SQL, and Virtual Machines. Read More …