database-tools

In the previous tip we introduced the PowerShell Gallery and showed how to download content (scripts and modules). Since the PowerShell Gallery is a...

The PowerShell Gallery is a public repository for PowerShell scripts and modules. It is entirely managed by cmdlets. Before you can use the...

In previous versions of PowerShell, session logging (transcripts) were supported only in the PowerShell console, and there could only be one...

PowerShell always supported session logging in the PowerShell console. Simply enter Start-Transcript to log all input and output to a text file....

Beginning with PowerShell 5.0, you can break into the debugger any time (in the PowerShell ISE). Simply press CTRL+B to invoke the debugger while a...

Many of the PowerShell commands are made out of functions. Here is how you can peek into the source code of any function: (Get-Command...

You may have heard about "type accelerators": they are shortcuts for the long .NET type name: PS> [XML] IsPublic IsSerial Name BaseType...

Beginning with PowerShell 3.0, there is a new feature called "Automatic Unrolling": when you specify a property or method on an array, then the...

In PowerShell 4.0 and better, there is a new alternative to the Where-Object cmdlet: $all = Get-Service $all | Where-Object { $_.Status -eq...

In a previous tip we explained how you can clone an existing XML item to add a new item. This works only when there are already some items in the...

Removing items from an XML document is almost trivial: you use XPath to identify the node you want to remove, then remove it. Once you save the XML...

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....

You can use Select-Xml to select content from an XML file, and then change or update its values. This is very powerful. You just need to get...

If you need to make changes to an existing XML document, for example to update inventory data, the easiest way is to load the document into an XML...

Reading XML formatted text is easy when you use an XML object for it. With its method Load(), you can read in content from a file path or a URL. In...

Today we start a little mini series about XML. To create sample data to play with, you will first create a well-formed XML. While you can create XML...