Instantly Stage Data Using PowerShell

Why? There are so many times I’ll receive a random CSV and be asked to compare something to a table in a database. Sometimes it’s just easier to work with these results in SQL Server. It’s pretty straight forward to perform this task using the “Import Flat File” option in SQL Server Management Studio (SSMS)….

To PowerShell, or Not To PowerShell

I’m opening up a can of worms with this topic. PowerShell usage is a heavily debated topic in the SQL Server community. This is similar to the classic “Tabs or Spaces” as an indentation style debate, there’s no clear winner. Both sides love to argue their preference. We all know spaces win. Or do tabs…