Here is a handy custom class I created for PowerShell 5+ that can query an SQL database. The class creates a SQL connection using the System.Data.SqlClient.SqlConnection class in .Net, and gives you full access to this object for information or to manipulate parameters. The class can also query the list of tables and views available in … Continue reading PowerShell Custom Class for Querying a SQL Server
Tag: powershell custom class
PowerShell Tip! Create Background Jobs with a Custom Class
PowerShell 5 introduced the capability to create custom classes. Classes are a convenient way to create an object with your own custom definition, and can include properties and methods. There could be many potential use cases for such a custom class, but here's one that is handy: background jobs. PowerShell comes with some cmdlets for … Continue reading PowerShell Tip! Create Background Jobs with a Custom Class
Ping Multiple Computers Rapidly with a Custom PowerShell Class
Today I published a custom class for users of PowerShell 5 that allows you to ping multiple computers very quickly using a custom PS object. It uses .Net runspaces to create a parallel processing environment to ensure speedy execution, and stores useful information about the ping results in the custom object, such as: The full … Continue reading Ping Multiple Computers Rapidly with a Custom PowerShell Class