database-tools

Super-Fast Network-Printer Inventory

In our previous tips we introduced all kinds of useful PowerShell functions to ping, scan ports, or contact SNMP devices. Today, it’s time to take a...

Super-Fast Network Scans (Part 3)

In our previous tips we created two fast functions to ping and port-scan remote systems: Test-Ping and Test-RemotePort: function Test-RemotePort {...

Super-Fast Network Scans (Part 2)

In our previous tip we looked at Test-NetConnection and found that it was way too slow, so we replaced it by a much faster Test-RemotePort function....

Super-Fast Network Scans (Part 1)

Port scans can be useful to identify devices or machines in your network, i.e. file servers (port 445), PowerShell remoting targets (port 5985), or...

Creating IPv4 Network Range

Here is a PowerShell code snippet that creates a list of IPv4 addresses for a given segment. You just specify the start and end address: $From =...

Translating Data

Hash tables and dictionaries are perfect lookup tables: whenever your original data contains cryptic numbers or a command returns just numeric...

Best IDE for data analysts

Data analysts need good visibility to the right data to make good business decisions. They also require easy access to the appropriate data, and a...

Automating Defender Antivirus (Part 2)

On Windows, PowerShell comes with cmdlets to automate the built-in antivirus engine “Defender”. In this second part, let’s take a look at how you...

Automating Defender Antivirus (Part 1)

On Windows, PowerShell comes with cmdlets to automate the built-in antivirus engine “Defender”. If you’d like to update the signatures...

Converting Wavelength to RGB

PowerShell is a generic script language so you can do all kinds of stuff with it. Below is a function that takes a light wavelength and converts it...

Storing Any Text Encrypted

Let’s say your script needs sensitive input like connection strings for a database or other text information. One way of managing such secrets is to...

Using Appropriate DataTypes (Part 2)

In part 1 we looked at how data becomes more accessible when converted to a more appropriate .NET data type. If you can't find an existing data type...

Using Appropriate DataTypes (Part 1)

Windows is an API-driven operating system, and PowerShell is, too. Compared to other shells that use plain text as a common denominator and leave it...

Checking Battery Wear and Quality

If you run a laptop you can easily ask WMI for battery status such as charging status. With a little bit more work, though, you can also check the...

Using Enums to Decipher Code IDs

WMI is a great and simple way of gathering information about computers. For example, it’s a snap to determine the type of computer you are on: $info...

Manage data with Aqua Data Studio

Aqua Data Studio is the industry-leading, multiple-platform, integrated development environment (IDE) for data. It provides many benefits to a...

1 4 5 6 7 8 159