http://www.sqlmag.com/authors/author/author/5777748/rss/5777748en-USFri, 25 May 2012 09:10:16 GMTFri, 25 May 2012 09:10:16 GMThttp://www.sqlmag.com/article/sql-server-integration-services-ssis2/tips-develop-sql-server-integration-services-packages-140969
By Robert Sheldon
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 forward.]]>Robert SheldonThu, 26 Jan 2012 09:54:00 GMThttp://www.sqlmag.com/article/sql-server-integration-services-ssis2/tips-develop-sql-server-integration-services-packages-140969http://www.sqlmag.com/article/windows-powershell/protect-your-powershell-scripts
By Robert Sheldon
Here are three precautions that will go a long way in protecting your PowerShell scripts and securing your system.]]>Robert SheldonTue, 20 Oct 2009 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/protect-your-powershell-scriptshttp://www.sqlmag.com/article/windows-powershell/save-your-powershell-code-in-profile-and-script-files
By Robert Sheldon
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.]]>Robert SheldonWed, 20 May 2009 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/save-your-powershell-code-in-profile-and-script-fileshttp://www.sqlmag.com/article/user-defined-function-udf/create-your-own-powershell-functions
By Robert Sheldon
You can make PowerShell functions as simple or as complex as necessary. Here’s what you need to know to get started.]]>Robert SheldonTue, 14 Apr 2009 00:00:00 GMThttp://www.sqlmag.com/article/user-defined-function-udf/create-your-own-powershell-functionshttp://www.sqlmag.com/article/windows-powershell/working-with-powershell-s-data-types
By Robert Sheldon
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.]]>Robert SheldonMon, 23 Feb 2009 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/working-with-powershell-s-data-typeshttp://www.sqlmag.com/article/net-framework2/accessing-sql-server-data-from-powershell-part-2
By Robert Sheldon
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.]]>Robert SheldonTue, 16 Dec 2008 00:00:00 GMThttp://www.sqlmag.com/article/net-framework2/accessing-sql-server-data-from-powershell-part-2http://www.sqlmag.com/article/windows-powershell/test-for-numerous-conditions-with-powershell-s-switch-statement
By Robert Sheldon
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.]]>Robert SheldonFri, 21 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/test-for-numerous-conditions-with-powershell-s-switch-statementhttp://www.sqlmag.com/article/scripting/accessing-sql-server-data-from-powershell-part-1
By Robert Sheldon
Learn how to use ADO.NET to retrieve SQL Server data through PowerShell scripts.]]>Robert SheldonThu, 13 Nov 2008 00:00:00 GMThttp://www.sqlmag.com/article/scripting/accessing-sql-server-data-from-powershell-part-1http://www.sqlmag.com/article/business-intelligence-development-studio-bids/integrate-mysql-and-sql-server
By Robert Sheldon
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.]]>Robert SheldonThu, 30 Oct 2008 00:00:00 GMThttp://www.sqlmag.com/article/business-intelligence-development-studio-bids/integrate-mysql-and-sql-serverhttp://www.sqlmag.com/article/windows-powershell/controlling-your-code-s-flow-with-powershell-s-conditional-statements
By Robert Sheldon
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.]]>Robert SheldonWed, 29 Oct 2008 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/controlling-your-code-s-flow-with-powershell-s-conditional-statementshttp://www.sqlmag.com/article/windows-powershell/iterating-through-collections-with-powershell-s-foreach-loops
By Robert Sheldon
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.]]>Robert SheldonFri, 26 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/iterating-through-collections-with-powershell-s-foreach-loopshttp://www.sqlmag.com/article/windows-powershell/access-security-event-logs-with-powershell
By Robert Sheldon
See how using Windows PowerShell with Windows Security event logs can help you guard against intrusion.]]>Robert SheldonFri, 19 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/access-security-event-logs-with-powershellhttp://www.sqlmag.com/article/activex/data-manipulation-with-ado
By Robert Sheldon
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.]]>Robert SheldonFri, 05 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/activex/data-manipulation-with-adohttp://www.sqlmag.com/article/windows-powershell/powershell-101-lesson-6
By Robert Sheldon
The PowerShell 101 series concludes by introducing you to PowerShell’s providers and drives.]]>Robert SheldonThu, 26 Jun 2008 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/powershell-101-lesson-6http://www.sqlmag.com/article/activex/accessing-database-data-with-ado
By Robert Sheldon
Accessing Database Data with ADO]]>Robert SheldonFri, 06 Jun 2008 00:00:00 GMThttp://www.sqlmag.com/article/activex/accessing-database-data-with-adohttp://www.sqlmag.com/article/windows-powershell/powershell-101-lesson-5
By Robert Sheldon
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.]]>Robert SheldonTue, 27 May 2008 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/powershell-101-lesson-5http://www.sqlmag.com/article/vbscript/introduction-to-ado
By Robert Sheldon
Learn about the primary ADO objects--Connection, Command, Parameter, Recordset, and Field--and follow example scripts that demonstrate how to use ADO within VBScript.]]>Robert SheldonWed, 14 May 2008 00:00:00 GMThttp://www.sqlmag.com/article/vbscript/introduction-to-adohttp://www.sqlmag.com/article/activex/ado-acronyms
By Robert Sheldon
Learn the definitions for several basic ADO acronyms.]]>Robert SheldonWed, 14 May 2008 00:00:00 GMThttp://www.sqlmag.com/article/activex/ado-acronymshttp://www.sqlmag.com/article/windows-powershell/powershell-101-lesson-4
By Robert Sheldon
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.]]>Robert SheldonMon, 28 Apr 2008 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/powershell-101-lesson-4http://www.sqlmag.com/article/windows-powershell/getting-and-using-the-system-string-object-s-members
By Robert Sheldon
PowerShell treats all strings as System.String objects. Find out how you can learn about and use this object’s methods and properties.]]>Robert SheldonMon, 28 Apr 2008 00:00:00 GMThttp://www.sqlmag.com/article/windows-powershell/getting-and-using-the-system-string-object-s-members