PowerShell Functions:Recently I made a PowerShellFunctions. In a previous post I talked about one of the functions used Display-Calendar. I have since updated it to utilize the appropriate verb show. For a list of appropriate PowerShell verbs look no further than: Approved Verbs
I have recently updated it to include:
Sync-WindowsTimeThis starts the Windows Time service and calls w32tm /resync
Why might you use such a command? Perhaps you dual boot and the time is off after rebooting.
ConvertTo-Base64This takes a input and produces a Base64 string:
Results in: TG9vayBvZiBkaXNhcHByb3ZhbA0K
Results in: Look of disapproval
Write-CompressedFilesTakes a directoryPath and writes a zip file in the destinationFile location.
I use this to zip up my module directory and save to my cloud:
Show-CalendarPrevious Blog Post
Get-SqlThis one is probably one of my favorite functions in the library. Here is an example:
You can pipe it to something like:
Or make a query that calls a query:
Hopefully your database doesn't do that, but if it does it is nice to know PowerShell can handle it.
Show-DatabasesWithTableSometimes you need to find a database with a specific table:
Gives you a list of databases with the appropriate table.
As we learned from the previous example you can chain these via the pipe line so you could run a query for each database.