Back to newsletter list
Perspectives
- Dating Advice
This & That
- "Reader to Reader Roundup" Winners
Script Watch
- More Dating Advice
Info to Go
/* ==================================== */
:: **** Perspectives ****
by Karen Bemowski, kbemowski@windowsitpro.com
Dating Advice
Systems administrators often need to include dates and times in
file and folder names. Although VBScript has functions to retrieve and
format dates and times, they're formatted according to the locale and they
usually include characters that you can't use in filenames, such as forward
slashes and colons.
Following the format outlined in the ISO 8601 standard is a better choice
when you need to include dates and times in file and folder names. In
"Creating Date and Time Stamps," Alex K. Angelopoulos explains why following
this format is advantageous, and he shows you how to easily generate ISO 8601
stamps in VBScript code.
I've opened up this article for public viewing so that you can read this
article and download its code. The article will be open for public viewing
only through August 24, so don't delay. If you enjoy reading this article,
you can get more of this type of content by subscribing to Scripting Pro VIP
( http://pentonmedia.whatcounts.com/t?ctl=60EB2:6B7D3383C3CE9444CD77889958FD2497 ).
Like systems administrators, database administrators often need to
generate dates. If you use T-SQL code to obtain and format dates, check out
the article discussed in the Script Watch section.
:: **** This & That ****
"Reader to Reader Roundup" Winners
Last month, the "Reader to Reader Roundup" contest was held. Anyone who
submitted a Reader to Reader article was entered into a drawing. Three names
were randomly chosen. The winners are Juzer Doriwala, Sam Felice, and James
Lim. Each winner received a $25 Amazon.com gift certificate. Congratulations!
:: **** Script Watch ****
More Dating Advice
The need to show the current date (i.e., month, day, and year) in
different formats is a common task for DBAs. Although you can obtain the
current date with T-SQL's GETDATE function, getting the returned date in the
format you need can take a lot of effort and code.
Roy Byrd was tired of having to write custom code every time he needed a
date in a different format, so he wrote the FormatDate function. You can use
this function to display any date in the format you need. All you need to do
is provide two parameters. If you'd like to read more about FormatDate and
download its code, look for the article "Display Dates in the Format You
Need" in the September issue of SQL Server Magazine. The article will be
available online starting August 23. Starting on August 23, go to the
SQL Server Magazine Web site (www.sqlmag.com), enter 96608 in the
InstantDoc ID box, and click Go.
:: **** Info to Go ****
KVM over IP in the Distributed IT Environment
Keyboard/video/mouse (KVM) switches are a valuable management tool, but
they have weaknesses in distributed environments. This white paper presents
the complexities of managing the distributed data center and highlights the
advantages of using a KVM over IP solution for flexible, scalable, affordable
CAT5-based remote access.
http://pentonmedia.whatcounts.com/t?ctl=60EB0:6B7D3383C3CE9444CD77889958FD2497
Taming the Beast: Gain Control of Software Usage and Reduce Audit Risks
Do you have visibility and control over your software license use? Most
organizations face challenges in this area, including understanding vendor
licensing models, cost overruns, missed deadlines, business opportunities,
and lost user productivity. Learn to address these challenges and prepare for
audits in this on-demand Web seminar, available now!
http://pentonmedia.whatcounts.com/t?ctl=60EAD:6B7D3383C3CE9444CD77889958FD2497
File Area Networks: Your First Look at FAN Technology
Regain control over the growing amount of file data in your enterprise.
Learn how file area networks can help you centralize file consolidation,
migration, replication, and failover. Download this eBook and start
streamlining your file management projects today!
http://pentonmedia.whatcounts.com/t?ctl=60EAE:6B7D3383C3CE9444CD77889958FD2497
The Web Isn't Fun Anymore: How Websense Technology Protects Against
Internet-Based Threats
With its wealth of information, the Internet has become integrated into
our personal lives as well as being a necessary business tool. However, it
does have a dark side. This white paper examines technologies that will help
guard against Internet-based threats.
http://pentonmedia.whatcounts.com/t?ctl=60EAF:6B7D3383C3CE9444CD77889958FD2497
Search Thousands of SQL Articles Online and on CD
A SQL Server Magazine Master CD subscription buys you portable,
lightning-fast access to the entire SQL Server article database on CD, plus
exclusive, up-to-the-minute access to the new articles we publish on
SQLMag.com every day. Order your subscription now!
http://pentonmedia.whatcounts.com/t?ctl=60EB1:6B7D3383C3CE9444CD77889958FD2497
Save 1/2 Off Security Pro VIP
Security Pro VIP is an online resource that delivers new articles every
week to help you defend your network. Subscribers also receive tips,
cautionary advice, direct access to our editors for technical Q&As, and
a host of other benefits! Order now, and save up to 50 percent!
http://pentonmedia.whatcounts.com/t?ctl=60EB3:6B7D3383C3CE9444CD77889958FD2497
==== Contact Us ====
About Scripting Central -- scriptingcentral@windowsitpro.com
About product news -- scriptingcentral@windowsitpro.com
About your subscription -- scripting_central@list.windowsitpro.com
=================================
This email newsletter is brought to you by Windows IT Pro, the leading
publication for IT professionals deploying Windows and related technologies.
Subscribe today!
http://pentonmedia.whatcounts.com/t?ctl=60EB4:6B7D3383C3CE9444CD77889958FD2497
To ensure that future email messages you receive from Scripting Central
aren't mistakenly blocked by antispam software, be sure to add
scripting_central@list.windowsitpro.com to your list of allowed senders
and contacts.
Manage Your Account
You are subscribed as tayllorcriss@gmail.com
You are receiving this email message because you subscribed to this
newsletter on our Web site. To ***, click the *** link:
http://pentonmedia.whatcounts.com***id=6B7D3383C3CE9444CD77889958FD2497
View the Windows IT Pro Privacy Policy.
http://pentonmedia.whatcounts.com/t?ctl=60EB5:6B7D3383C3CE9444CD77889958FD2497
Windows IT Pro is a division of Penton Media, Inc.
221 East 29th Street, Loveland, CO 80538, Attention: Customer Service
Department
Copyright 2007, Penton Media, Inc. All Rights Reserved.
