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
|
60 results found for Robert Sheldon, displaying items 1 - 20
|
 |
Protect Your PowerShell Scripts
Here are three precautions that will go a long way in protecting your PowerShell scripts and securing your system.
Windows IT Pro
Save Your PowerShell Code in Profile and Script Files
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.
Windows IT Pro
Save Your PowerShell Code in Profile and Script Files
Windows IT Pro
Create Your Own PowerShell Functions
Windows IT Pro
Create Your Own PowerShell Functions
You can make PowerShell functions as simple or as complex as necessary. Here's what you need to know to get started.
Windows IT Pro
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.
Windows IT Pro
Accessing SQL Server Data from PowerShell, Part 2
Because PowerShell is integrated with the.NET framework, you can leverage the .NET object model within PowerShell scripts and build ADO.NET objects that retrieve SQL Server data; learn how to use ADO.NET to insert, update, and delete SQL Server data.
Windows IT Pro
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
|
|
Register
