One of the best new features in PowerShell 7 is the ability to perform parallel execution of script blocks, which can drastically reduce the amount of time it takes to process ForEach-Object loops.

Once you have that installed, we now have the majority of the functionality available to query Azure SQL databases. It is now time to connect to our Azure subscription and associate our account in the ...

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 ...

When creating automation scripts to discover, add, update or remove records from a remote SQL database, you need to make sure your script can successfully connect to the database.

Use PowerShell to script objects on a schedule or in a special order. Use PowerShell if you need to switch between windows and SQL commands or even share data between the two.

Launching a PowerShell Script from Excel, Revisited We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.