Powershell – How to use Transcripts to keep history of commands and output

The primary tool for logging Powershell activity has been the Start-Transcript cmdlet. Simply enter this cmdlet followed by a path and filename for the log file that you want to create. PowerShell will populate the log file with every subsequent command that is entered. 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 – 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 …