Perspectives
This & That
Script Watch
Scripter's Toolkit
Info To Go
Perspectives
by Karen Bemowski, [email protected]
Scripting News (Really!)
Like you, I find scripting an engaging topic, but let's face it--when
talking shop with fellow scripters, not many discussions about current events
slip into the conversation. In the next few weeks, however, two noteworthy
events might become a hot topic among scripters.
The first is that Microsoft is acquiring Winternals Software, a company that offers systems-recovery and data-protection solutions. More important, Microsoft is also acquiring Sysinternals, Winternals' freeware Web site. Many scripters use Sysinternals freeware--such as the Autoruns tool and the tools in the PsTools suite--in their scripts.
Mark Russinovich and Bryce Cogswell founded both Winternals and Sysinternals. Mark will join the Microsoft Platforms and Services Division as a technical fellow. Bryce will join Microsoft's Windows Component Platform Team as a software architect.
While this acquisition is good for Mark and Bryce, you might be wondering whether it's bad for you. It begs the question, "What's going to happen to Sysinternals and its free tools?" In his Sysinternals blog, Mark writes, "...the site will remain for the time being while Microsoft determines the best way to integrate it into its own community efforts, and the tools will continue to be free to download." To read Mark's blog about the acquisition, go to http://www.sysinternals.com/blog/2006/07/on-my-way-to-microsoft.html . You can read the official Winternals press release about the acquisition at http://www.winternals.com/Company/PressRelease92.aspx.
The second noteworthy event that might crawl into your scripting conversations is the discovery of another Windows PowerShell worm. (The first was reported about a year ago.) In the article "Hackers Try to Crack Windows PowerShell" (http://news.com.com/Hackers+try+to+crack+Windows+PowerShell/2100-1002_3-6101106.html), CNET News.com reports that security software giant McAfee has detected a worm called MSH/Cibyzvirus, which targets PowerShell. The article states that, "The worm doesn't exploit a specific security hole in PowerShell. Instead, it abuses the product's ability to execute scripts by attempting to trick users into downloading and running malicious code. To do this, it uses a series of product names that may be attractive to Kazaa users. If run, the worm will overwrite some file types, change registry details and place itself in the machine's Kazaa shared folder in order to spread."
The only information I can find about the worm on the Microsoft Web site is in the Windows PowerShell blog (http://blogs.msdn.com/powershell/archive/2006/08/03/687838.aspx). To begin, the blog notes that the PowerShell worm won't work on and can't infect PowerShell in its default configuration. "This is a proof-of-concept virus whose 'Worm' replication mode is just a simple file copy and could have been implemented in any language which supports copying files. The fact that the worm is written in PowerShell rather than another scripting language or even as an executable has actually made it even harder for this virus to spread since the additional security features around PowerShell scripts result in many additional steps for the user to perform before an infection can take place."
The blog goes on to say that, "Unlike some worms, the so-called 'PowerShell Worm' does not take advantage of any vulnerability within PowerShell to spread automatically. Although classified as a worm the PowerShell Worm depends upon the user performing a series of fairly complex set of steps to circumvent and disable the numerous security features of PowerShell before any infection can take place."
There you have it--two news tidbits that you can talk to your fellow scripters about if you haven't already done so. However, I don't advise that you work it into a conversation with your family or friends. They'll likely have that "Yeah--so what?" expression on their face. They don't know what they're missing.
This & That
New Blog by T-SQL Guru Itzik Ben-Gan
If you use T-SQL in your scripting projects, you'll want to check out
Itzik Ben-Gan's new "Puzzled by T-SQL" blog. Currently, Itzik has posted a
three-part blog titled "Quaere Verum - Clustered Index Scans." Besides
covering technical topics, Itzik plans to include his famous puzzles as well
as personal insights. You can find his blog at
http://www.sqlmag.com/blog/index.cfm?action=blogindex&DepartmentID=1016.
Take the Windows IT Pro or SQL Server Magazine Salary Survey
We need your help! Windows IT Pro and SQL Server Magazine are launching
their third annual Industry Salary Surveys. They want to find out all about
you and what makes you a satisfied IT or database professional. When you
complete the survey (about 10 minutes of your time), you'll be entered in a
drawing for one of five $100 American Express gift certificates. Look for the
survey results--and see how you stack up against your peers--in the December
issue of Windows IT Pro and SQL Server Magazine. If you're an IT professional, take the Windows IT Pro salary survey at https://websurveyor.net/wsb.dll/12237/WITPSalarySurvey06.htm.
If you're a database professional, take the SQL Server Magazine salary survey at https://websurveyor.net/wsb.dll/12237/SQLSalarySurvey06.htm.
Script Watch
T-SQL Function to the Rescue
If you need to extract plain text out of strings that contain
markup-language formatting, you can let the ScrapeText function do all the
work for you. This T-SQL function accepts an HTML string as input and returns
a plain text string. Learn more about this function in the Reader to Reader
article "Pull Out Text from HTML Code" in the September issue of SQL Server
Magazine.
Scripter's Toolkit
Save Time and Aggravation with These Debugging Tools
In scripts, calls to external programs are useful, yet challenging to
debug. These calls make many tasks possible, ranging from simple tasks (such
as stringing together commands) to complex tasks (such as joining several
specialized programs so that they work as a unit). Many complications can
arise to increase the challenge:
To debug calls to external programs, I created a stand-in program named WinDummy that you can call in place of the real program. WinDummy parses the command line and lists the parameters exactly the way the real program will see them. If your script calls several programs, you can copy and rename WinDummy as many times as needed. You can run WinDummy from any directory because it requires no support files.
I also created a companion program, WWSimStatus, that simulates status codes returned by external programs, such as xcopy.exe. With WWSimStatus, you have an easy, safe way to simulate any status code generated by an external program.
You can use WinDummy and WWSimStatus to test any script that calls an external program, including VBScript, Perl, and Windows shell (.bat and .cmd) scripts. You can also use WinDummy and WWSimStatus to test programs such as Visual Basic for Applications (VBA) macros and custom standalone programs written in Visual Basic (VB), C, or any other programming language.
Since I created WinDummy in 2002, it has earned its keep. Before long, I expect to feel the same way about WWSimStatus. Both programs are freeware. You can download WinDummy at http://www.wizardwrx.com/FREEBIES/WinDummy.html . You can download WWSimStatus at http://www.wizardwrx.com/FREEBIES/WWSimStatus.html . I hope that these programs can save you many hours and much grief.
Editor's Note: Thanks to David Gray for sharing his freeware programs. David had sent in an article about them in response to the "I Want YOU!" call for submissions (http://www.windowsitpro.com/Windows/Article/ArticleID/49902/49902.html). An expanded version of this article will appear in the September issue of Windows Scripting Solutions, for which he'll receive $100. If you have any scripts or code you'd like considered, please send them to me at [email protected] or [email protected].
Info To Go
Gear up for TechX World Roadshow
Hear first-hand from today's leading interoperability experts, vendors,
and peers at this exclusive one-day event. You'll learn about managing OS
interoperability, directory migration, data interoperability, and much more.
This event provides in-depth information on how Windows and other systems
cooperate with each other.
http://www.techxworld.com/registration/?code=0802emailannc
Are you protected company-wide against spyware, keyloggers, adware, and
backdoor Trojans? Test the state-of-the-art scanning engine that uses threat
signatures from multiple sources to track down the culprits that antivirus
solutions alone can't protect you against. Download your free 30-day trial of
CounterSpy Enterprise today!
http://www.windowsitpro.com/go/download/sunbelt/counterspy/?code=0802emailannc
Did you know that wasteful processes can drive the cost of document management
and output to as high as 10-15% of your company's annual revenues? Download
this free white paper today and find out how you can use fax solutions to
achieve cost control, security and compliance, increased workflow, and more.
http://www.windowsitpro.com/go/whitepapers/Faxback/faxing?code=0802emailannc
Learn how to gather evidence of compliance across multiple systems and link
the data to regulatory and framework control objectives. View this on-demand
Web seminar today!
http://www.windowsitpro.com/go/seminars/bindview/multiregcompliance/?partnerref=0802emailannc
Total Cost of Ownership--TCO. It's every executive's favorite buzzword, but
what does it really mean, and how does it affect you? In this podcast,
Ben Smith explains how your organization can use virtualization technology
to measurably improve the TCO for servers and clients.
http://www.windowsitpro.com/go/podcast/hp/virtualization/?code=0802emailannc
Secure Your Online Data Transfer with SSL
Increase your customers' confidence and your business by securely
collecting sensitive information online. In this free white paper, you'll
learn about the various applications of SSL certificates and their appropriate
deployment, along with details of how to test SSL on your Web server.
http://www.windowsitpro.com/go/whitepapers/thawte/ssl?code=0802featnl
Uncover Essential Windows Knowledge Through Excavator
Try out the ultimate vertical search tool--Windows Excavator. Windows
Excavator gives you fast and thorough third-party information while filtering
out unwanted content. Visit http://www.winexcavator.com today!
Save $40 off Windows IT Pro Magazine
Subscribe to Windows IT Pro Magazine magazine today and SAVE up to $40! Along with your 12 issues, you'll get FREE access to the entire Windows IT Pro Magazine online
article archive, which houses more than 9,000 helpful IT articles. This is a
limited-time offer, so order now:
https://store.pentontech.com/index.cfm?s=1&promocode=eu2068uw
Contact Us
This email newsletter is brought to you by Windows IT Pro, the leading publication for IT professionals deploying Windows and related technologies. Subscribe today!
https://store.pentontech.com/index.cfm?s=1&promocode=eu205xfb
View the Windows IT Pro Privacy Policy.
http://www.winnetmag.com/aboutus/index.cfm?action=privacy
Windows IT Pro is a division of Penton Media, Inc. 221 East 29th Street, Loveland, CO 80538, Attention: Customer Service Department
Copyright 2006, Penton Media, Inc. All Rights Reserved.