Laerte Junior in PowerShell Fun with PowerShell Asynchronous Imagine a candle that is lit and takes 1 hour to burn out. Now imagine one hundred candles. How many... 03 February 2025 7 min read
Laerte Junior in PowerShell Extending Get-Process to show the Process Chain using PowerShell Proxy Functions A proxy function or wrapper function allows you to deploy a custom version of a function or cmdlet while the... 01 July 2024 8 min read
PowerShell Laerte Junior in PowerShell Automating BCP with PowerShell I was talking with a good friend that has an environment with terabytes of information and to create a homolog... 09 February 2024 8 min read
PowerShell Laerte Junior in PowerShell PowerShell Dynamic Parameters and SQL Server Have you ever been in a situation that you want to call a cmdlet or a function with a parameter... 05 January 2024 6 min read
PowerShell Greg Moore in PowerShell Working with PowerShell strings Knowing how to manipulate strings is critical in any language. In this article, Greg Moore explains working with PowerShell strings.… 24 November 2021 12 min read
PowerShell Greg Moore in PowerShell Building an ETL with PowerShell There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to... 22 September 2021 11 min read
PowerShell Greg Moore in PowerShell PowerShell editors and environments part 2 In this article, Greg Moore demonstrates two additional PowerShell editors: Azure Data Studio Notebooks and Visual Studio Code.… 15 March 2021 12 min read
PowerShell Greg Moore in PowerShell PowerShell editors and environments part 1 There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his... 02 February 2021 11 min read
PowerShell Greg Moore in PowerShell How to Use Parameters in PowerShell Part II PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about... 18 August 2020 17 min read
PowerShell Greg Moore in PowerShell How to Add Help to PowerShell Scripts PowerShell scripts are the tool of choice for many admins, but how do you make them easy for others to... 13 May 2020 12 min read
PowerShell Greg Moore in PowerShell SQL Server and Undocumented Extended Procedures Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented... 03 March 2020 11 min read
PowerShell Greg Moore in PowerShell Comments and More in PowerShell Comments are helpful when programming in any language, and PowerShell is no exception. In this article, Greg Moore demonstrates how... 03 January 2020 12 min read
PowerShell Allen White in PowerShell Portable Objects in PowerShell with CLIXML PowerShell is a widely used tool for administrators. In this article, Allen White shows how to export objects using CLIXML... 17 December 2019 16 min read
PowerShell Greg Moore in PowerShell Building a Countdown Timer with PowerShell Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that... 03 December 2019 11 min read
PowerShell Greg Moore in PowerShell How to Use Parameters in PowerShell Part I Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that... 17 September 2019 12 min read
PowerShell Greg Moore in PowerShell PowerShell and Secure Strings Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.... 22 August 2019 13 min read
PowerShell Greg Moore in PowerShell Using a Server List to Control PowerShell Scripts PowerShell is the preferred tool for many DBAs when automating SQL Server administration. In this article, Greg Moore demonstrates how... 29 January 2019 13 min read
PowerShell Greg Moore in PowerShell Treating SQL Server as an Object with PowerShell It’s easy to use invoke-sqlcmd to send T-SQL statements to SQL Server from PowerShell. There is, however, a rich PowerShell... 29 November 2018 14 min read
Database Administration Laerte Junior in Database Administration What Is SQLPSX? SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior... 29 October 2018 12 min read
PowerShell Robert Cain in PowerShell Testing PowerShell Modules with Pester In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the... 15 October 2018 45 min read
