Useful Powershell Commands
View all ports in use Get-NetTCPConnection | ? {$_.State -eq “Listen”} | sort LocalPort -Descending
Category: Website Development
How to search the Microsoft SQL Full Text Search index
Use this query in SQL Management Studio to directly search the Full Text Search index. select * from sys.dm_fts_parser(‘”search term”‘, 1033, NULL, 0) Note that there are upcoming changes to FTI, including many deprecated functions, so if you’re using it extensively you probably have some work to do.
How to install PHP 5.6 on CentOS 6.10
I just did a fresh install of CentOS 6.10 today and needed to install PHP. It had been a while, so I needed a refresher. Note: PHP 5.6 is pretty much End Of Life, so you should be installing PHP 7.2, or higher at this point in time. That said, sometimes you have to support… Continue reading How to install PHP 5.6 on CentOS 6.10
How to use Tail in Windows Powershell
Windows is slowly, but surely, catching up to the hundreds of useful utilities for reading file content that *nix have had for forever. As you know, opening a 1 gig log file in notepad is impossible. Even using Notepad++, which can open some pretty large files, will not open a 1 gig file. Thank you,… Continue reading How to use Tail in Windows Powershell
Vagrant status is “running” but VirtualBox shows “Powered Off” Windows 10
You’ve installed Vagrant and run vagrant up and then vagrant ssh successfully. You then start VirtualBox Manager and it shows that it is powered off: In order to see the actual status, press SHIFT then right-click on the icon for Virtual Box, then click Run as Administrator You will see that it reports the VM… Continue reading Vagrant status is “running” but VirtualBox shows “Powered Off” Windows 10
How to get what version of Powershell you are using
Microsoft Windows Powershell is a very useful tool that brought some sanity to managing Windows outside the GUI. To find the version you are running, open Powershell, paste and hit enter: $PSVersionTable.PSVersion Result: Windows PowerShell Copyright (C) 2015 Microsoft Corporation. All rights reserved. PS C:\Users\username> $PSVersionTable.PSVersion Major Minor Build Revision —– —– —– ——– 5 0… Continue reading How to get what version of Powershell you are using
How to fix GitHub Desktop client window desktop offscreen
Simple fix for the GitHub Desktop application opening, but the window appearing off screen. I tried ALT+M to move, etc, without any luck. The easiest way I found: Close the app and go to: %APPDATA%\GitHub Desktop\ Delete window-state.json Restart. That’s it.
Export Sites and Application pools in IIS
Open CMD as Administrator: Export AppPools All %windir%\system32\inetsrv\appcmd list apppool /config /xml > c:\apppools.xml Single %windir%\system32\inetsrv\appcmd list apppool “MyAppPool” /config /xml > c:\myapppool.xml Export Sites %windir%\system32\inetsrv\appcmd list site /config /xml > c:\sites.xml or in txt format (not very useful) %windir%\system32\inetsrv\appcmd list site > c:\sites.txt
How to install Apache and PHP 7.2 on Windows Subsystem for Linux
There are a few tips and tricks I found for this installation. Here are the details. Check Windows Version First, here’s the entire Microsoft section on WSL. I highly recommend reading through it. There are various differences between the latest Windows 10 updates, so this might not work for your version! I’m on Windows 10… Continue reading How to install Apache and PHP 7.2 on Windows Subsystem for Linux
How to install PHP Manager in IIS 10 or higher
PHP Manager is a useful tool for configuring PHP in IIS. It is no longer supported, however, and a Registry trick is required to install it. Overview PHP Manager allows you to configure multiple versions of PHP for multiple VHosts on an IIS server. While it adds some overhead to the configuration, it can be… Continue reading How to install PHP Manager in IIS 10 or higher