Windows Server
Amazing PowerShell One-Liners for System Administrators
Here is a collection of some really cool PowerShell one-liners scripts. I find them very useful for day to day system administration tasks. I will keep adding to this list as I learn more useful commands. List of all installed applications on a Windows device This one-liner searches the Windows...
How to audit SharePoint using powershell
Sometimes you need to know what information you have got in your SharePoint solution. I have been asked this numerous times since GDPR was introduced. Get-SPWeb http://your-sharepoint-site | Select -ExpandProperty Lists | Where { $_.GetType().Name -eq “SPDocumentLibrary” -and -not $_.Hidden } | Select -ExpandProperty Items | Group {$_.ParentList.ParentWeb.Url + “/”...
How to upgrade SQL Server 2016 to SQL Server 2017
Upgrade SQL Server 2016 to SQL Server 2017 author(s) : Richard Bailey Pre-Requisites SQL Server 2017 media (licence if applicable) x64 Bit Operating System and if upgrading must have existing 64bit SQL Server instance. SQL Server 2017 supports upgrade from the following versions of SQL Server: SQL Server 2008 SP4...
How to do a Bare Metal Restore (BMR) on Arcserve backup and restore
This procedure is a step-by-step guide to create a Windows or Linux server (bare metal recovery) from an Arcserve backup. The assumption is being made that the backup is available on the Arcserve backup server or the tape media has already been loaded. Arcserve presents the backups as shared resources...
How to install Microsoft SQL Server 2008 R2 on Windows Server 2012 R2
I was recently asked to install SQL server 2008 R2 on a freelance project for a client. Its been a very long time since I have used such an old version of SQL. But the process is still very straight forward and best of all, SQL 2008 R2 is still...
How to create a Virtual Machine in Hyper-V
How to create a virtual machine in Hyper-V Here is a very quick guide of how to create a virtual machine in Hyper-V In the Hyper-V Manager, select New > Virtual Machine Choose a Name for your Server Choose a location for you Virtual Machine Config file Select Generation 1...
How to install CentOS 7
How to install CentOS 7 Here is a quick guide of how to install CentOS 7. I am doing in using a Hyper-V virtual machine. If you need help creating the Hyper-V Virtual Machine – Click Here Check you have mounted the CentOS media to the virtual Machine. Under the...
Terraform Core Commands
This page is work in progress Thanks Richard 30th November 2018 Terraform commands –help is help Tab completion enabled by terraform -install-autocomplete Subcommands Terraform Syntax The syntax of Terraform configurations is called HashiCorp Configuration Language (HCL). It is meant to strike a balance between human readable and editable as well as being...
Installing Terraform on Windows Desktop and Windows Server
Installing Terraform on Windows Terraform is extremely popular on Linux, but it is now also available on Windows. You need to have PowerShell version 4 or greater installed so it is recommended to install on the following Microsoft Windows products: Windows 10 Desktop Windows Server 2012 Windows Server 2016 It...