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

Throughout this series of posts there have been a number of examples of how to use the SQL Server PowerShell provider. However, these were always in context with a specific task (i.e. automating ...

One of the most welcome new features in PowerShell 7 is the ability to perform parallel execution of script blocks. This new parallel execution capability can drastically reduce the amount of time it ...

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. It’s much easier in ...

Unfortunately, not every SQL database is always available when we expect it to be. When you're creating automation scripts to discover, add, update or remove records from a remote SQL database, you ...

Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which means ...