Learn dbatools in a Month of Lunches

5 Writing to SQL Server

In chapter 4, you were introduced to some of the common dbatools parameters. You also learned how to gather information about databases on multiple instances. This chapter will focus on saving data to the place where SQL Server DBAs feel most comfortable keeping data: a table in a SQL Server database! You will learn a number of ways to write data to a SQL Server table using dbatools. This chapter will be good to keep in mind as you go through the book, because it’s likely you will want to save your PowerShell output to a SQL Server database.

But for now, let’s start with understanding PowerShell’s pipeline. The pipeline in PowerShell is a feature that you need to be familiar with to use PowerShell effectively. We are going ...