I've been trying for years to get dbatools to import faster. There's a lot of plain-text code to import and even more help. Binary modules like Microsoft's SqlServer module benefit from prior compilation and can be imported in like 500-900ms whereas dbatools generally takes 2-5 seconds.

I've written about module …

When I first joined Mastodon, I was excited to learn that fedifinder and debirdify can help find my Twitter friends on Mastodon. Both are web-based tools that search your follows and/or followers on Twitter for possible Mastodon accounts, then export the results to a CSV file.

First thing I'd recommend doing? Find your …

After moving from Twitter to Mastodon, I wrote a blog post about how aliases can help us keep a consistent social media presence even if we change servers.

This means that even though dbatools is currently using the fosstodon.org server as [email protected], I'll be linking [email protected] on all of our …

Just recently, I was presenting at a conference and when I got to the intro slide, I realized how weird it is that Twitter will no longer be a part of that. I used to dedicate a whole slide saying "Find me on Twitter, I'm @cl" and now ¯\(ツ)/¯.

Thing is, I found a server I like so far but what if I move? What …

Mastodon feels like the 2007 Internet -- it's exciting and hasn't been plagued by SEO-gaming websites and "a group of five websites, each consisting of screenshots of text from the other four."

Initially, I was pretty gutted by the sale of Twitter but now I see that what I was afraid of losing connections …

One of my GitHub Actions, mssqlsuite makes it ultra easy to install SQL Server on Linux, Windows and macOS runners. When working on the macOS portion, I was surprised that docker was not built-in.

Turns out, GitHub had to remove docker from the macOS images because of licensing issues.

Workarounds

One of the most …

Code signing your scripts, modules and applications can help increase enterprise adoption, as large organizations often prohibit running unsigned tools on Windows. Signed code allows machines to verify that what they're running hasn't been altered or compromised by a third party, which ultimately increases their …

I've used ExpressVPN for years and it's worked great on all my devices until one day, when it stopped even trying to make a connection from my Mac Mini.

As soon as I'd hit the connect button, it said it couldn't detect an internet connection -- even though I totally had an Internet connection. So I uninstalled, …

Years ago before I learned PowerShell, I was using T-SQL to do things it just wasn't meant to do, namely SQL Server estate management. T-SQL is incredibly efficient when managing data, but it's not very efficient when managing SQL Server instances.

For example, say you need to perform a task against each database. The …

This post is about Import-DbaCsv, a command within the dbatools PowerShell module for SQL Server.

I've been writing about CSV imports using PowerShell for a pretty long time and in VBScript for even longer. Initially, my primary concerns were ease-of-use and speed. Over time, I realized that what mattered most was: …