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.
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
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 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
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 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