Greg Moore

Greg Moore is a graduate of RPI. There, he majored in CompSci, but probably spent as much time hiking, canoeing, caving and rock-climbing as he did studying. He started working with SQL Server 4.21a in 1995 and has survived numerous upgrades. He's been a Director and later VP of IT at several startups including PowerOne Media, TownNews and Traffiq and now consults. These days, when he's not busy with playing with SQL Server or spending time with his family, he can often be found underground caving or teaching cave rescue with the NCRC. While his focus is on the operations side of DBA, his interests include DR, performance and general IT problem solving. He is the author of: IT Disaster Response: Lessons Learned in the Field.

Follow Greg Moore via

Greg Moore 24 November 2021

Working with PowerShell strings

PowerShell

Knowing how to manipulate strings is critical in any language. In this article, Greg Moore explains working with PowerShell strings.… Read more

PowerShell

Greg Moore 22 September 2021

Building an ETL with PowerShell

There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work.… Read more

Greg Moore 15 March 2021

PowerShell editors and environments part 2

PowerShell

In this article, Greg Moore demonstrates two additional PowerShell editors: Azure Data Studio Notebooks and Visual Studio Code.… Read more

PowerShell

Greg Moore 02 February 2021

PowerShell editors and environments part 1

PowerShell

There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.… Read more

PowerShell

Greg Moore 18 August 2020

How to Use Parameters in PowerShell Part II

PowerShell

PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about PowerShell parameters, Greg Moore realized that there is even more to talk about. This article covers using pipelined parameters and more. … Read more

PowerShell

Greg Moore 13 May 2020

How to Add Help to PowerShell Scripts

PowerShell scripts are the tool of choice for many admins, but how do you make them easy for others to use? In this article, Greg Moore shows how to add professional looking help to your scripts that work just like the help in cmdlets. … Read more

Greg Moore 03 March 2020

SQL Server and Undocumented Extended Procedures

Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented procedures for automating tasks, and that PowerShell may have what you need instead. … Read more

Greg Moore 03 January 2020

Comments and More in PowerShell

PowerShell

Comments are helpful when programming in any language, and PowerShell is no exception. In this article, Greg Moore demonstrates how to use comments to document code and to add prerequisites in PowerShell with #Requires.… Read more

PowerShell

Greg Moore 03 December 2019

Building a Countdown Timer with PowerShell

PowerShell

Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that can create a window for a countdown timer.… Read more

PowerShell

Greg Moore 17 September 2019

How to Use Parameters in PowerShell Part I

146

PowerShell

Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that takes parameters.… Read more

146

PowerShell

Greg Moore 22 August 2019

PowerShell and Secure Strings

PowerShell

Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server. … Read more

PowerShell

Greg Moore 29 January 2019

Using a Server List to Control PowerShell Scripts

PowerShell is the preferred tool for many DBAs when automating SQL Server administration. In this article, Greg Moore demonstrates how to use a server list to control which tasks are performed on which servers.… Read more

Greg Moore 29 November 2018

Treating SQL Server as an Object with PowerShell

PowerShell

It’s easy to use invoke-sqlcmd to send T-SQL statements to SQL Server from PowerShell. There is, however, a rich PowerShell library, sqlps, that can be used instead. In this article, Greg Moore shows how to use sqlps to treat a SQL Server instance as an object.… Read more

PowerShell

Greg Moore 08 August 2018

Introduction to PowerShell with SQL Server Using Invoke-SQLCMD

PowerShell is the preferred scripting tool used by Windows and Active Directory administrators. It can also be used to administer SQL Server or even just export data. In this article, Greg Moore demonstrates how to use the PowerShell cmdlet Invoke-SQLCMD to export data from SQL Server.… Read more