Pivot tables have long been the standard tool for summarizing and analyzing data in Excel, and they work well for many tasks. But if you've ever found yourself clicking through multiple menus just to ...

When you first start writing scripts, modularity, reusability, and best practices may not be top of mind. As your scripts become more complex, however, creating reusable elements becomes essential. By ...

Allowing for the right kind of input into PowerShell functions is important. It can mean the difference between writing a function once and forgetting about it constantly having to refactor it to ...

If you are building PowerShell longer than a few lines, it is good practice to break up your code into reusable snippets. This way you can only call the code snippet over and over instead of ...

Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...