CSV, Excel, or SQL? It Doesn’t Matter with PowerShell

Structured data is stored in many different ways.  It could be in a CSV file, an Excel workbook, a SQL database, a MySQL database, and so on.  Each has its own purpose with individual strengths and weaknesses.  When managing this data, you typically have to interface with it in completely different ways.  A CSV file can be managed simply in […]

Read more

Stories from the PowerShell Trenches: Day 2

Continuing on with our PowerShell stories series next up we have a story from Josh Duffney about automating System Center Orchestrator! Be careful, when automating development work. I immediately realized that one person running System Center Configuration Manager wasn’t going to work for an enterprise of 16,000 Full time staff, over 25,000 devices and 1000+ applications. Since asking for more […]

Read more

How to build the appropriate PowerShell parameters

A beginner new to writing PowerShell scripts might simply open up his favorite PowerShell script editor and just start coding out what he needs to do.  He may have specific requirements such as create Active Directory (AD) user accounts, setting permission on an Exchange mailbox or perhaps moving some files around. Whatever the case, he has specific requirements: create AD user […]

Read more

Constant and Read-Only PowerShell Variables for Admins Who Fear Change

Most people define a variable in a programming language as a placeholder for something else. The variable is a bucket that stuff goes into, comes out of, gets changed and gets removed. However, there’s a certain subset of PowerShell variables that can be defined but can never change. These sets are called constants and read-only variables. Constants and read-only variables […]

Read more

Use a PowerShell FTP script to upload and download files

Sometimes a system administrator needs to get files from point A to point B. And there are many ways to accomplish this, but one popular method is to use a PowerShell FTP script. Admins can do this by using Windows’ .NET capabilities. Using PowerShell, Windows admins can use the .NET WebClient class. Let’s create a functional PowerShell FTP script from […]

Read more
1 36 37 38 39 40 50