If you need to change the content of a specific cell in an Excel spreadsheet, take a look at this sample code: $ExcelPath =...
ps1
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Cleaning Week: Deleting CBS Log File
Windows maintains a log file named cbs.log in $env:windir\logs\cbs. It logs various pieces of information related to the Windows trusted installer,...
One-Liner Random Password Generator
Check out this simple way of creating temporary passwords: -join...
Adding New Nodes to an XML Document
If you need to add new items to an XML document that already contains such items, the easiest way is to search for an existing item, then clone it....
Bringing Window in the Foreground
PowerShell can use Add-Type to access internal Windows API functions. This way, it is easy to bring any process window into the foreground. Here is...
Enabling Telnet Client and Watching Star Wars
By default, the Telnet client is disabled on Windows systems. You can easily enable it with a one liner in PowerShell, though. Just launch a...
Enabling PowerShell Remoting with NTLM
By default, PowerShell remoting uses Kerberos authentication and works only in domain environments, and only when you specify computer names, not IP...
Test-Connection with Timeout
The Test-Connection cmdlet implements a simple ping to check whether a system responds to an ICMP request. Unfortunately, you cannot specify a...
Use Get-CimInstance with DCOM
PowerShell 3.0 added an alternative to Get-WmiObject: Get-CimInstance seems to work very similar and can retrieve information from the internal WMI...
Waiting for Process Launch
PowerShell has a built-in support to wait until a process or many processes end: simply use Wait-Process. There is no support to do the opposite:...
Try CTRL+SPACE!
In the PowerShell ISE, there are two key shortcuts that can help you. Pressing TAB works just like in the console, and each time you press TAB, you...
Updating Your Office Phone Number in Active Directory
If you have installed the free RSAT tools from Microsoft, you can use PowerShell to update information stored in your AD user account, for example...
Cloning Active Directory Security Settings
Whenever you add delegation rights to an AD object (i.e. allow a user to manage the members of an organizational unit), you really invoke a change...
Bulk-Remove Protection for Accidental Deletion in AD
By default, AD objects are protected from accidental deletion. To remove this protection for all objects in a given scope (i.e. all objects in an...
Using Green Checkmarks in Console Output
In a previous tip you have seen that the PowerShell console supports all characters available in a TrueType font. You just need to convert the...
Using Symbols in Console Output
Did you know that console output can contain special icons like checkmarks? All you need to do is set the console to a TrueType font like...
Removing Whitespace (and Line Breaks)
You may know that each string object has a method called Trim() that trims away whitespace both from the beginning and end of a string: $text =...
Understanding break, continue, return, and exit
Do you know off-hand what "break", "continue", "return", and "exit" do? These are powerful language...
Getting Registry Values and Value Types
Get-ItemProperty can easily read registry values, but you do not get back any information about the registry value type. Get-ItemProperty -Path...
Using “more” in the PowerShell ISE
PowerShell ISE In the PowerShell console, you can pipe commands to the old-fashioned “more.com”, or better yet, to Out-Host...
Measuring Website Response (and Execution Times)
PowerShell 3.0 and later Sometimes it is important to know just how long a command takes. For example, to monitor web site response times, you could...
Exporting Out-GridView Content
PowerShell 3.0 and later Out-GridView is a very useful cmdlet to output results to an extra window. Unlike outputting to the console, Out-GridView...
Finding Explicit Permissions
All PowerShell versions Typically, NTFS permissions in the file system are inherited. You can, however, add explicit permissions to files and...
Accessing COM Objects without ProgID
All Versions Typically, to access COM objects, these objects need to register themselves in the Windows Registry, and PowerShell needs the...