The PowerShell script in the article uses the SQLPS PowerShell module which may not exist on the computer on which you run the script. Modern versions of SQL Server or SSMS will install a SqlServer module instead; and this may not be immediately available for use in a script. It may be necessary (or expedient, at least) to add the following line to the script:

Import-Module SqlServer