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

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 …

Powershell – Variable for Null, Empty String and White Space

More often than not, we create variables with the intent they will hold a value. We typically then choose to act upon that value. Therefore, if a variable doesn’t have value, this is something we would want to check against in our conditional logic flow. Read More …

Enable WinRM with Group Policy for PowerShell Remoting

PowerShell Remoting really can makes a routine work a lot easier, but it requires quite a bit of work to get all the remote computers ready to take the remoting calls, such as automatically start Windows Remote Management service. Read More …

Powershell – If -And & If -Or Statements

One of the best statements for filtering data is the If clause. For scripts that require precise flow control you could incorporate PowerShell’s -And, the benefit is that your test could now include multiple conditions. Read More …

Enabling Powershell Remoting

To enable Powershell remoting, you need run the following cmdlet: Enable-PSRemoting In workgroup environments, enable classic mode authentication for network Read More …