Ars Technica

Powershell. SQL Query. How to determine if a query returns no results?

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

Query SQL Server with PowerShell

Last time, I discussed how to get PowerShell and SQLPS up and running on your machines. And much like my dog chasing its tail, you're probably asking yourself, "Now that I have it, what do I do with ...
GitHub

powershell-script-content-guide.md

The examples listed on this page use [az.sql PowerShell cmdlets](/powershell/module/az.sql/) to create and manage Azure SQL resources. Additional cmdlets for running ...
learn

Run Apache Hive queries by using PowerShell on Microsoft Entra ID-enabled HDInsight clusters

Apache Hive provides a powerful SQL-like interface that you can use to query and analyze data in Azure HDInsight. With Microsoft Entra ID-enabled HDInsight clusters, you can securely authenticate and ...
GitHub

XEvent Query Replayer is a PowerShell script that reads the RPC:Completed and SQL:BatchCompleted events from XEL files captured with Extended Events and replays the Stored ...

XEvent Query Replayer consists of a total of 5 files. The codebase is built within the xe-query-replayer.ps1 and functions.psm1 files. If you want to determine which version of the .NET Framework is ...
Visual Studio Magazine

PowerShell vs. SQL Server Management Studio

When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...