This is mostly for my reference, but you can use it, too :)

Create Basic Datatable

 1$dt = New-Object System.Data.Datatable
 2[void]$dt.Columns.Add("First")
 3[void]$dt.Columns.Add("Second")
 4[void]$dt.Columns.Add("Third")
 5
 6# Add a row manually
 7 …

Update 1/4: Removed conversion of datatable to list. That just wasted memory, as this works on all enumerables.

I don't have a practical application for this method, but I wanted to figure out how to do it anyway. Doing so was frustrating but kinda fun. It forced me to learn about lamdas in PowerShell which I'll …

Update 1/18/2015: This native PowerShell script can process over 165,000 rows a second. I'm so pumped. My million row CSV with 9k dupes processed in 6.4 seconds. I actually tried this using LINQ in PowerShell, but it seemed exponetially slower as the dataset grew.

A user on reddit's PowerShell subreddit asked for the …

Last year, I finally started working with SMO (SQL Management Objects) within PowerShell and I absolutely love it. Below are a few recipes that I created and use extensively throughout my SQL Management scripts, which you can find on ScriptCenter. Some recipes show more than one way to perform a task.

These SMO recipes …

While researching how connect to a detached MDF and read the internal file structure of the internal files, including LDF files, I kept seeing suggestions for using the undocumented DBCC command DBCC checkprimaryfile. Initially, my code looked like this:

 1# SQL Server is required to read the file contents
 2 …

Here are two straight-forward ways to create Scheduled Tasks within Windows using PowerShell. One script creates a PowerShell Scheduled Job, and the other creates a classic Windows Scheduled Task. You can read about the differences here. PowerShell v3 and above required.

Create a Scheduled Job

The following script …

Microsoft ConnectM isn't letting me sign in to post this workaround, but I just ran into a bug with the OleDbProviderSettings within SMO.

<img
  loading="lazy"
  decoding="async"
  alt="smobug"
  
    class="image_figure …</picture></figure></a></p>