Greg Moore in PowerShell

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

29 January 2019 13 min read

Sysadmin

Arvind Kumar in Sysadmin

Robotics Process Automation: The New Digital Assistant

When most of us think of robotics used in enterprises, automating manufacturing processes comes to mind. Robotics Process Automation (RPA),...

02 January 2019 9 min read

PowerShell

Greg Moore in PowerShell

Treating SQL Server as an Object with PowerShell

It’s easy to use invoke-sqlcmd to send T-SQL statements to SQL Server from PowerShell. There is, however, a rich PowerShell...

29 November 2018 14 min read

Database Administration

Laerte Junior in Database Administration

What Is SQLPSX?

SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior...

29 October 2018 12 min read

PowerShell

Robert Cain in PowerShell

Testing PowerShell Modules with Pester

In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the...

15 October 2018 45 min read

PowerShell

Nicolas Prigent in PowerShell

Azure and Windows PowerShell: Using VM Extensions

In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure...

09 October 2018 10 min read

PowerShell

Robert Cain in PowerShell

Advanced Testing of Your PowerShell Code with Pester

Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to...

30 August 2018 19 min read

PowerShell

Robert Cain in PowerShell

Introduction to Testing Your PowerShell Code with Pester

Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as...

16 August 2018 23 min read

PowerShell

Greg Moore in PowerShell

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

08 August 2018 10 min read

T-SQL Programming

Phil Factor in T-SQL Programming

The Crimes of Chicago: Working with Data in MongoDB

NoSQL databases like MongoDB are gaining popularity, but using the right tools for the job at hand is most important....

03 August 2018 26 min read

PowerShell

Nicolas Prigent in PowerShell

Azure and Windows PowerShell: Getting Information

In the second part of his series, Nicolas Prigent describes in detail how to automate the login process using PowerShell...

26 June 2018 12 min read

PowerShell

Nicolas Prigent in PowerShell

Hyper-V and PowerShell: Shielded Virtual Machines

In Windows Server 2016, Microsoft have implemented a strong security concept called Shielded Virtual Machines. Shielded VMs have been improved...

04 June 2018 13 min read

PowerShell

Nicolas Prigent in PowerShell

PowerShell Day-to-Day Admin Tasks – Part 6: Real-Time IT Dashboard

Creating a real-time IT dashboard is essential for IT professionals for managing their environments and to be proactive. A Few...

02 May 2018 11 min read

PowerShell

Robert Cain in PowerShell

Create Azure VMs with PowerShell Part 2

The ability to quickly spin up a virtual machine is one of the great things about Azure. In this article,...

30 April 2018 16 min read

PowerShell

Robert Cain in PowerShell

Create Azure VMs with PowerShell Part 1

Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In...

21 April 2018 23 min read

PowerShell

Nicolas Prigent in PowerShell

Azure and Windows PowerShell: The Basics

IT shops do not want to spend time and energy managing infrastructure and servers as was done in the past....

29 December 2017 11 min read

PowerShell

Robert Cain in PowerShell

PowerShell Functions for Reusability and Restartability in Azure

The key to efficient development is reusability. When developing scripts for administration, being able to restart a script where it...

29 November 2017 15 min read

General

Nicolas Prigent in General

Building and Deploying Nano Servers

Microsoft has introduced an installation option of Windows Server 2016 that provides an operating system designed and optimized for Cloud...

24 August 2017 9 min read

Monitoring

Padmaja U.K

Tushar Jangle in Monitoring

Monitoring Azure Cloud and Hybrid Environments

Cloud-based services and applications must still be monitored just like the on-premise ones. You still need most of your data...

19 June 2017 11 min read

.NET

Michael Sorens in .NET

High Performance PowerShell with LINQ

PowerShell is a scripting language, and like all scripting languages it struggles to perform well with rapid iterative processes such...

19 May 2017 46 min read