By Robert Sheldon, 01/26/2012
These five tips help you avoid a few frustrations that might arise when developing SQL Server Integration Services (SSIS) packages so you keep your development efforts moving ...
By Robert Sheldon, 10/20/2009
Here are three precautions that will go a long way in protecting your PowerShell scripts and securing your system.
By Robert Sheldon, 05/20/2009
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 ...
By Robert Sheldon, 04/14/2009
You can make PowerShell functions as simple or as complex as necessary. Here's what you need to know to get started.
By Robert Sheldon, 02/23/2009
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 ...
By Robert Sheldon, 12/16/2008
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; ...
By Robert Sheldon, 11/21/2008
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 ...
By Robert Sheldon, 11/13/2008
Learn how to use ADO.NET to retrieve SQL Server data through PowerShell scripts.
By Robert Sheldon, 10/30/2008
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.
By Robert Sheldon, 10/29/2008
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 ...
By Robert Sheldon, 09/26/2008
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, ...
By Robert Sheldon, 09/19/2008
See how using Windows PowerShell with Windows Security event logs can help you guard against intrusion.
By Robert Sheldon, 09/05/2008
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. ...
By Robert Sheldon, 06/26/2008
The PowerShell 101 series concludes by introducing you to PowerShell's providers and drives.
By Robert Sheldon, 06/06/2008
By Robert Sheldon, 05/27/2008
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.
By Robert Sheldon, 05/14/2008
Learn about the primary ADO objects--Connection, Command, Parameter, Recordset, and Field--and follow example scripts that demonstrate how to use ADO within VBScript.
By Robert Sheldon, 05/14/2008
Learn the definitions for several basic ADO acronyms.
By Robert Sheldon, 04/28/2008
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 ...
By Robert Sheldon, 04/28/2008
PowerShell treats all strings as System.String objects. Find out how you can learn about and use this object's methods and properties.