PowerShell

PowerShell Tag Archive

How to install Microsoft’s SQL Server Driver for PHP

Jan Reilink
Windows Server
13 April 20168 May 2020

In this article I’ll show you how to install the Microsoft SQL Server Driver for PHP 7+. This makes the use of an SQL Server database back-end for your PHP website easy. If you want to communicatie with SQL Server using PHP you need to rely on some additional software and PHP extensions. This post walks you through the steps necessary to install the SQL Server driver and SQLSRV extension for PHP 7+, on Windows Server IIS of course.

Jan Reilink
GNU Linux
27 November 20156 March 2020

OpenSSL comes in handy when you need to generate random passwords, for example for system accounts and services. In this short post I’ll give you a quick example on how to generate random passwords with OpenSSL in Linux (Bash), Windows and PHP…

Jan Reilink
PowerShell
8 October 201525 August 2020

Here is how you can verify whether an external command in PowerShell was executed successfully or not by its errorlevel. Simply by verifying PowerShell’s return value, or exit code…

Jan Reilink
PowerShell
20 September 201516 January 2020

How to retrieve the Hyper-V virtual machine’s serial number with PowerShell? Sometimes you need to have the serial number of a Hyper-V virtual machine (VM, or guest). We, for instance, use this serial number in our automatic, unattended deployment of the guest operating system. But then you need to know how to find this serial number…

Tunnel RDP through SSH & PuTTY

Jan Reilink
Windows Server
28 April 20159 November 2020

How to tunnel Remote Desktop (RDP) over SSH with PuTTY.

Have you ever been in a situation where you needed to perform remote administration on a Windows Server, and the RDP port 3389 is blocked on a firewall? Did you know you can tunnel RDP over SSH with PuTTY? This particularly comes in handy when there is no VPN available to the remote network… Here is how to set up a RDP SSH tunnel with PuTTY.

Jan Reilink
PowerShell
10 April 201516 January 2020

How to monitor Windows Servers with PowerShell

As a Windows Server and IIS administrator, you want your Windows services to run at all times. One can monitor Windows services in many, many, ways. Some of our customers websites may depend on certain services, which may be hard to monitor externally. For those Windows services that need local monitoring, I like to schedule a PowerShell script. Here is one…

Jan Reilink
PowerShell
7 April 20158 May 2020

To get and set File Server Resource Manager NTFS quota, you now have to use PowerShell‘s FileServerResourceManager cmdlets. In the past, I used to get and set NTFS directory quota with the dirquota command, which is deprecated. A behavioral change for me (and you?) I can live with: it’s pretty easy to get directory information with Get-FsrmQuota and change dirquota using Set-FsrmQuota.

Application Pool Specific Time Interval recycle settings

Set IIS Application Pool recycle defaults to Specific Times, not Regular Time Interval

Jan Reilink
PowerShell, Windows Server
3 April 201529 June 2020

By default, an IIS application pool (or “AppPool”) recycles on a regular time interval of 1740 minutes, or 29 hours. One reason for this time interval is that application pools don’t recycle at the same moment every day (every day at 07.00 for example). However, sometimes you want to change this regular time interval to a specific time schedule. And when you try to configure this in IIS Manager, it gives you an error. Luckily, AppCmd and PowerShell come to the rescue!

Jan Reilink
Windows Server
4 March 201511 November 2020

In my environment, I had to set up a new Windows Deployment Services (WDS) configuration for Windows 8.1 Enterprise. To roll out in our office (some 20+ workstations). I wanted to install some additional software at the same time, without using Microsoft Deployment Workbench, because I find the interface too slow. The solution? Read on…

Jan Reilink
PowerShell
4 January 201530 January 2020

Find all files from one owner in Windows using PowerShell

In Windows, you sometimes need to find all files owned by a specific user. Recursively on your Windows Server NTFS file system. PowerShell has some nice cmdlets and features to automate this task for you. Here you’ll find example PowerShell scripts to find and list files owned by a specific user…

dism.exe /online /Cleanup-Image /AnalyzeComponentStore

Disk Cleanup in Windows Server

Jan Reilink
Windows Server
22 December 201410 December 2020

Over time, as your Windows Server runs longer, more and more disk space is eaten. Simply gone! Investigating the disk usage leaves you clueless; there are no large log files, crash dumps, or there is no software to be removed. Where did that space go?

The answer: Windows Updates, Service Pack, and hotfix installations.

Jan Reilink
PowerShell, Windows Server
12 December 201416 January 2020

How to add DNS servers – or resolvers – to a Windows Server network adapter, or interface using WMI and the netsh command. This one is quite old but may come in handy sometimes. In this example we use Google’s Public DNS server addresses and localhost to add as DNS Servers on our server.

Jan Reilink
Windows Server
30 June 201411 March 2020

When a Windows Communications Foundation (WCF) web service returns a 404 Not Found error, after installing the HTTP-Activation feature in IIS, you might need to add an extra Handler to your IIS configuration.

Jan Reilink
PowerShell, Windows Server
27 May 201422 January 2020

How to install WebSocket Protocol support in IIS through PowerShell‘s Install-WindowsFeature cmdlet. Simply install and enable support for the WebSocket protocol on Windows Server IIS.

Jan Reilink
Code base
26 May 20149 February 2021

Simple MySQL connection test from your website with ASP.NET, PHP & classic ASP. Whenever you need a MySQL connectivity test from a website or server, it’s handy to have various test scripts nearby. Whether it is because you are setting up a new website or you have just installed a new server and are running your tests.

PowerShell

How to install Microsoft’s SQL Server Driver for PHP

Generate pseudo-random passwords with OpenSSL

PowerShell return value, exit code, or ErrorLevel equivalent

Get Hyper-V guest serial number with PowerShell

Tunnel RDP through SSH & PuTTY

Monitor Windows services with PowerShell

PowerShell Get-FsrmQuota and Set-FsrmQuota

Set IIS Application Pool recycle defaults to Specific Times, not Regular Time Interval

Software deployment through WDS

PowerShell: find all files owned by a particular user

Disk Cleanup in Windows Server

WMI/netsh to add DNS servers on network adapters

.svc WCF web service returns 404 Not Found on IIS 8

How to install the Web-WebSockets feature in IIS using PowerShell

How to: Test MySQL database connectivity in ASP.NET, PHP, ASP