Redgate Hub

  • Product articles
  • University
  • Events
  • Forums
  • Community
  • Simple Talk
  • Home
  • Cloud
  • DevOps
  • Sysadmin
  • Development
  • Databases
  • Opinion
  • Books
  • Blogs
  • Log in
  • Sign up
  • Home
  • Sysadmin
  • PowerShell
Greg Moore
24 November 2021
Greg Moore
24 November 2021

Working with PowerShell strings

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

Building an ETL with PowerShell

0
8
  • PowerShell
  • Tools
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
Greg Moore
15 March 2021

PowerShell editors and environments part 2

0
6
  • PowerShell
In this article, Greg Moore demonstrates two additional PowerShell editors: Azure Data Studio Notebooks and Visual Studio Code.… Read more
Greg Moore
02 February 2021
Greg Moore
02 February 2021

PowerShell editors and environments part 1

0
19
  • PowerShell
There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.… Read more
Greg Moore
18 August 2020
Greg Moore
18 August 2020

How to Use Parameters in PowerShell Part II

0
8
  • 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
Greg Moore
13 May 2020
Greg Moore
13 May 2020

How to Add Help to PowerShell Scripts

0
10
  • Database Administration
  • PowerShell
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
Greg Moore
03 March 2020

SQL Server and Undocumented Extended Procedures

0
4
  • PowerShell
  • Tools
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
Greg Moore
03 January 2020

Comments and More in PowerShell

0
13
  • 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
Allen White
17 December 2019
Allen White
17 December 2019

Portable Objects in PowerShell with CLIXML

0
5
  • PowerShell
PowerShell is a widely used tool for administrators. In this article, Allen White shows how to export objects using CLIXML and work with those objects without being connected to the original servers.… Read more
Greg Moore
03 December 2019
Greg Moore
03 December 2019

Building a Countdown Timer with PowerShell

0
13
  • 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
Greg Moore
17 September 2019
Greg Moore
17 September 2019

How to Use Parameters in PowerShell Part I

0
126
  • 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
Greg Moore
22 August 2019
Greg Moore
22 August 2019

PowerShell and Secure Strings

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

Using a Server List to Control PowerShell Scripts

0
11
  • Database Administration
  • PowerShell
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
Greg Moore
29 November 2018

Treating SQL Server as an Object with PowerShell

0
3
  • 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
Laerte Junior
29 October 2018
Laerte Junior
29 October 2018

What Is SQLPSX?

0
7
  • Database Administration
  • PowerShell
SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior demonstrates several useful commands and shows you how to create a SQL Agent job using this library to run daily DBA checks.… Read more
Robert Cain
15 October 2018
Robert Cain
15 October 2018

Testing PowerShell Modules with Pester

0
9
  • PowerShell
In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the functions in a PowerShell module. … Read more
Nicolas Prigent
09 October 2018
Nicolas Prigent
09 October 2018

Azure and Windows PowerShell: Using VM Extensions

0
7
  • Azure
  • PowerShell
In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during the provisioning process.… Read more
Robert Cain
30 August 2018
Robert Cain
30 August 2018

Advanced Testing of Your PowerShell Code with Pester

0
11
  • PowerShell
Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.… Read more
Robert Cain
16 August 2018
Robert Cain
16 August 2018

Introduction to Testing Your PowerShell Code with Pester

0
39
  • PowerShell
Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code.… Read more
Greg Moore
08 August 2018
Greg Moore
08 August 2018

Introduction to PowerShell with SQL Server Using Invoke-SQLCMD

0
27
  • Database Administration
  • PowerShell
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
Next
  • 1
  • 2
  • …
  • 4
  • Exchange
  • General
  • Monitoring
  • PowerShell
  • Unified Messaging

Subscribe for more articles

Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.

Simple Talk

  • FAQ
  • Sitemap
  • About Simple Talk
  • Contact Us