Robert Sheldon

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 www.rhsheldon.com.

Articles
Green chalkboard with white drawn figures on it
PowerShell Basics: Custom Objects
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.
filter
PowerShell Basics: Filtering Objects 4
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.
PowerShell
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
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.
NEW: John Savill's Microsoft Stack Master Class

Get 30 hours of detailed instruction covering the complete Microsoft solution stack. Invest a few hours each week and become THE Microsoft expert in your organization.

Thursdays, October 2nd to December 11th

John Savill will cover topics including:

* Deploying, Managing, and Maintaining Windows
* Key Features of Active Directory from Windows 2000 to Windows Server 2012
* Key elements of System Center 2012 and System Center 2012 R2
* Deploying, Migrating to and Managing Hyper-V in Your Organization
* Implementing a Private Cloud
* Using PowerShell to Automate Common Tasks

Enroll by September 25th and SAVE $245!
 

Upcoming Conferences

Register now to get the best rates available!

Windows Forums

The Windows IT Pro forums are moving to myITforum.com! Get answers to questions, share tips, and engage with the IT professional community.

Sponsored Introduction Continue on to (or wait seconds) ×