This session is designed to help data analysts and developers manage the problem of one-off data formats that occur on a regular frequency. PowerShell is a very flexible scripting language, allowing developers and analysts (yes, developers and analysts - not just admins) to build powerful solutions with less effort than some other languages/processes. Pairing PowerShell with SQL Server provides another level of flexibility to develop repeatable, lightweight transformations. Through the use of multiple demos, common built-in cmdlets useful for analysts and developers will be shown. We'll also explore the PowerShell Gallery a couple useful modules, before expanding into ADO.Net classes to select, insert and update data in a SQL Server database.