Robert Sheldon


Robert Sheldon is a technical consultant and author of material about Windows, relational database management systems, and business intelligence design and implementation. His latest book is Beginning MySQL (Wiley). Find out more at

Green chalkboard with white drawn figures on it
PowerShell Basics: Custom Objects 2
The Windows PowerShell custom object is an effective, flexible tool that can serve many of your scripting needs. Here's a step-by-step guide to creating them.
Windows PowerShell command prompt
PowerShell Basics: Take Advantage of the PowerShell Integrated Scripting Environment
The Windows PowerShell Integrated Scripting Environment (ISE) lets you write, debug, edit, and run scripts in a single graphical environment.
PowerShell Basics: Filtering Objects 5
PowerShell includes cmdlets to create commands that refine results. Use Where-Object, Select-Object, Select-String, ForEach-Object, and Out-GridView to filter pipeline objects and their data.
PowerShell Basics: Introduction to Objects
The more you understand how objects work within the PowerShell environment, the better you'll be able to take advantage of PowerShell's flexibility and perform the variety of tasks that PowerShell supports.
PowerShell Basics: System Requirements
It can be hard to get a specific PowerShell version running on a specific OS. Here's how to get PowerShell 3.0 or 2.0 running on Windows 7, Windows Server 2012, Windows Server 2008 R2, and Windows Server 2008.
PowerShell Basics: Console Configuration
The more you work in the PowerShell console, the more likely you'll want to customize it to meet your individual development style. Here's how.
Protect Your PowerShell Scripts
Here are three precautions that will go a long way in protecting your PowerShell scripts and securing your system.
Save Your PowerShell Code in Profile and Script Files 1
PowerShell statements that you enter during a session apply only to that session. However, if you put your code into profile files or script files, you can use that code repeatedly from within the PowerShell console without having to re-enter it.
Create Your Own PowerShell Functions 4
You can make PowerShell functions as simple or as complex as necessary. Here's what you need to know to get started.
Working with PowerShell's Data Types
Typically, PowerShell automatically assigns and converts data to its correct data type. Understanding how PowerShell handles data types will help you know when you need to take control and explicitly assign them.
Test for Numerous Conditions with PowerShell's switch Statement
PowerShell's switch statement lets you test for many conditions and perform different actions when those conditions are met, making it ideal for such tasks as retrieving event log entries and performing specific actions based on the type of entry.
Controlling Your Code's Flow with PowerShell's Conditional Statements 1
PowerShell's if, for, and while statements let you present conditions and the actions to occur when those conditions are met. You can even specify the actions to occur when a condition isn't met.
Iterating Through Collections with PowerShell's foreach Loops 1
Windows PowerShell provides two types of foreach loops: the foreach statement and the ForEach-Object cmdlet. Although you can obtain the same results with both types of loops, they differ in several important respects.
Access Security Event Logs with PowerShell
See how using Windows PowerShell with Windows Security event logs can help you guard against intrusion.
Data Manipulation with ADO
ActiveX Data Objects (ADO) let you access, filter, sort, and retrieve data from Microsoft SQL Server and Microsoft Access databases using VBScript and other scripting languages. Here are some of the most common uses of ADO for databases.
Microsoft Stack Master Class

Master-Level Microsoft Stack Class with John Savill
Online Class: Thursdays Oct. 12th-Dec. 21st
30 Hours of Training for $995!

Understand the complete Microsoft solution stack, how the products work together, and how to implement and maintain for a total datacenter and desktop solution. This course covers the latest technology updates including Windows Server 2016 and Windows 10 and will enable the new capabilities to be leveraged in your organization.


Join the Conversation

Sponsored Introduction Continue on to (or wait seconds) ×