How-To Geek on MSN

5 everyday actions that Power Query does better than regular Excel tools

Replace manual Excel tasks with conditional columns, smart merging, the unpivot tool, and more.
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 ...