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.
Email address: contact@rhsheldon.com
Web site: http://www.rhsheldon.com
|

53 results found for Robert Sheldon, displaying items 1 - 20
|
 |
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.
Windows IT Pro
|
November 13, 2008 |
 |
Accessing SQL Server Data from PowerShell, Part 1
Learn how to use ADO.NET to retrieve SQL Server data through PowerShell scripts.
Windows IT Pro
Integrate MySQL and SQL Server
Need to retrieve MySQL data and insert it into a SQL Server database? SQL Server Integration Services and MySQL connectors let you do so fairly easily.
SQL Server Magazine
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.
Windows IT Pro
Controlling Your Code's Flow with PowerShell's Conditional Statements
Windows IT Pro
Iterating Through Collections with PowerShell's foreach Loops
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.
Windows IT Pro
|
September 19, 2008 |
 |
Access Security Event Logs with PowerShell
See how using Windows PowerShell with Windows Security event logs can help you guard against intrusion.
Windows IT Pro
Access Security Event Logs with PowerShell
Windows IT Pro
|
September 5, 2008 |
 |
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.
Windows IT Pro
PowerShell 101, Lesson 6
Windows IT Pro
PowerShell 101, Lesson 6
The PowerShell 101 series concludes by introducing you to PowerShell's providers and drives.
Windows IT Pro
|
June 6, 2008 |
 |
Accessing Database Data with ADO
Windows IT Pro
PowerShell 101, Lesson 5
Use built-in variables and Windows environment variables in your PowerShell code. And if they don't offer what you need, you can create your own variables.
Windows IT Pro
PowerShell 101, Lesson 5
Windows IT Pro
Introduction to ADO
Windows IT Pro
|
May 14, 2008 |
 |
ADO Acronyms
Learn the definitions for several basic ADO acronyms.
Windows IT Pro
|
May 14, 2008 |
 |
Introduction to ADO
Learn about the primary ADO objects--Connection, Command, Parameter, Recordset, and Field--and follow example scripts that demonstrate how to use ADO within VBScript.
Windows IT Pro
PowerShell 101, Lesson 4
Understanding how to handle strings in PowerShell cmdlets is important. Learn when to enclose strings in quotes and whether to use single or double quotes. Also learn how to handle quotes in strings with special characters.
Windows IT Pro
Getting and Using the System.String Object's Members
PowerShell treats all strings as System.String objects. Find out how you can learn about and use this object's methods and properties.
Windows IT Pro
PowerShell 101, Lesson 4
Windows IT Pro
|
|