Windows Server 2016 – Configure DNS Zone Transfer

DNS (Domain Name System) is one of the many systems that keeps the Internet humming and is responsible for resolving human-readable hostnames into machine-readable IP addresses. DNS servers host what are known as zones. Read More …

Active Directory – Check if a DC is a Global Catalog

There are several ways to find out if a Domain Controller has the Global Catalog role enabled. In this article, Read More …

Microsoft – Changing SID of cloned VMs

On the machine level, every computer is identified by a unique value; named Security ID or SID. SID is calculated in the process of the installation of every Windows machine. Whether the computer is part of the workgroup (or it’s just a stand-alone computer), the value of SID is not crucial. 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 …

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 …

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 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 …

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 …