In this post I will go through how to work with files in PowerShell, specifically how to read and write files. I will go through a handful of different cmdlets you can use to read files, as well as save information down to a file. As with most things PowerShell, it’s actually quite easy! (more…)
Category: PowerShell
Formatting output in PowerShell
This post will go through how to format output for the screen in PowerShell, and is mainly aimed at beginners will little to no experience. Read on to learn how you can control how data is shown in the console! (more…)
Invoke-SqlCommand
In several previous posts I have presented functions to create different kinds of database connections. But a connection to a database is just the first step. The function I’m presenting here will let you use the connection object you get from those functions and send SQL commands to the database. If you expect data back you can indicate that by using the GetResults parameter, and you will get a DataTable object returned to you. (more…)
New-OdbcConnection
This function will let you create a database connection object for connecting to a database using ODBC.
It supports using DSN as well as setting up a DSN-less connection, and will return a database connection object. (more…)
New-OracleConnection
This function will let you create a database connection object for connecting to an Oracle database. It supports the usual parameters; DatabaseServer, DatabaseName, Port and Credential and will return a MySqlConnection object. (more…)
New-MsSqlConnection
This function will let you create a database connection object for connecting to a Microsoft SQL Server database. It supports the usual parameters; DatabaseServer, DatabaseName, Port and Credential and will return a database connection object. (more…)
New-MySqlConnection
This function will let you create a database connection object for connecting to a MySQL database. It supports the usual parameters; DatabaseServer, DatabaseName, Port and Credential and will return a MySqlConnection object. (more…)
The Holy Trinity of PowerShell Cmdlets
If you have just decided to learn PowerShell, and don’t have any prior knowledge of scripting or programming, your first meeting with it can be quite overwhelming.
This blog post is written for the absolute beginner that has no idea where to start. If that is you, please read on to get a jump-start to PowerShell! (more…)
How to add a progress bar to your PowerShell script
[Update] If you want to learn how to calculate seconds remaining when using progress bars, head on over to this post!
A very typical workflow when working with PowerShell, is to iterate through a collection of data. Inside each loop, you would perform some action, like getting or setting some data for instance. Depending on the size of the array, and the particular work you are doing within each iteration, this might often be a part of your script where users get little-to-none feedback that the script is still running.
Usability-wise this is bad, and you should strive to give the user some feedback that ‘stuff is happening‘. In this post I will show you how you can use the Write-Progress cmdlet to add a progress bar to your script, to give the user the needed visibility to know it’s running. (more…)
Quick tip: Determine if input comes from the pipeline or not
Usually you shouldn’t need to know whether data input comes from the pipeline or a parameter, but in case you are in a position where you really need to know, this post will show you a quick and easy way of determining this. (more…)
Communary 