Category: Scripting
BCP for Flat File ETL
Brent Ozar is hosting today’s #TSQL2sday about the most recent issue you closed. Working with a consulting firm for a variety of clients, I tend…
Quickly execute a folder of SQL scripts using dbatools and PowerShell
I have often run into a situation where it’s been necessary to execute a bunch of scripts handed to me by developers or others. When…
Putting The PowerShell Window Title To Better Use | xkln.net
I’ll admit that I typically use VSCode for most of my scripting, but Milosh Djuric put together some neat PS to make the console window…
Automating File Processing with Python and SQL Server
Garry Bargsley ( b | t ) asks us this month what does “Automate all the things” mean to you. After all, if we have…
Review: Windows PowerShell 2.0 Best Practices – Introduction
A while back I received a review copy of Windows PowerShell 2.0 Best Practices by Ed Wilson (blog | twitter) and the Windows…
Powershell – Comparison Operators
I’m writing this one so I remember these operators. Powershell doesn’t use standard operators such as =, <, , !=, etc. These operators are used…
Powershell – Quite note on Objects
I’m sure this comes as no surprise to anyone who’s dabbled in Powershell, but just about everything in Powershell has an Object underneath. The results…
Powershell – Piping
One of the most often-used features I’ve seen so far in Powershell has been the concept of piping the results of commands into other commands…
Powershell – Arrays & Hash Tables
I don’t have too much to say about Arrays at this point, but as I’m partly blogging this for my own education, I’ll put down…
Powershell – Variables
I’ve just started to play around with variables in Powershell. I used them a little bit before this, but am in the process of figuring…