Microsoft Certified Professional Magazine


Feb. 23, 2010 News Variable Pipeline Planning; Database Wars; Win7 Anti-Piracy Update; IE 9


- UltraBac -- Affordable Data Protection Solutions

- Try Fluke Networks' EtherScope Analyzer on your network FREE

- Best Practices for Active Directory

----------->>>> NOTE: GET THIS NEWSLETTER IN HTML FORMAT <<<<-----------

You are receiving MCPmag News in text format, but you can now receive
this newsletter in HTML format. To change formats, go to:

----------->>>>  --------------------------------------- <<<<-----------

- Prof. PowerShell: Variable Pipeline Planning
- Data Driver: Who Has the Edge in Database Wars?
- Redmond Radio: Win7 Anti-Piracy Update; SQL Service Packs; IE 9
- Cloud Ices Office 2010 Profits; MS Security Guru
  Jumps to Amazon
- Special Offers: Tools for Distributed IT Systems; Exchange 2010 Archiving  


UBDR Gold technology provides lightning fast physical or virtual
restores. The software works with every Windows server or
workstation, and can be used to restore to dissimilar hardware.
Perform virtual-based disaster recoveries using either VMware or
MS Virtual Server host machines. Lots of optional agents (TSM,
VMDK, etc.) are available.

Get your free trial today!

REDMOND NOTE: TechMentor Conference in March!
Just a reminder that March 8-12 is your window of opportunity to get
smart and practical and more productive with today's tech.

That's right, it's TechMentor, and our Spring event takes place in
Orlando. Learn from the likes of Don Jones, Greg Shields, Mark Minasi,
Rick Vanover and others in an approachable setting as they offer their
best practices on managing all aspects of the IT infrastructure.

Make plans to attend today; details at .

Michael Domingo, Editor



Leave it to the -OutVariable parameter to get you the results that
can be reused later.

By Jeffery Hicks

If you've been using PowerShell for a while, you've probably created
some complex pipeline expressions. I'd say the pipeline is probably
one of the reasons PowerShell shines as an administrative and
automation tool. However, you may have also run into problems trying
to re-use or access a variable from earlier in the pipeline. Here's
a one-line example:

PS C:\> get-childitem $env:temp -recurse | where {-Not
$_.PSIsContainer} | group-object extension | Sort Count,Name |
format-table Count,Name -autosize

This works just fine but perhaps you'd also like to add a custom
column in the table that shows a percentage based on the total
files, found from Get-ChildItem. By the time Format-Table is run,
the file objects are no longer in the pipeline.

The solution is to take advantage of the common parameter -OutVariable.
Every cmdlet supports this parameter. In this example I need to use it
with Where-Object:

PS C:\> get-childitem $env:temp | where {-Not $_.PSIsContainer}
-OutVariable files

The parameter has an alias of -ov. When I run this command, I still
get normal output but a new variable called $files is also created
that stores the results. When you use the parameter just specify
the name you want for the variable. You don't include the $ character.

By the way an expression like this sort of achieves ...

Continue reading.

Jeffery Hicks, MCSE,MCSA,MCT, is a Microsoft MVP and an IT veteran
with almost 20 years of experience, much of it spent as an IT
consultant specializing in Windows server technologies. He works
today as an independent author, trainer and consultant. Jeff has
co-authored or authored several books, courseware, and training
videos on administrative scripting and automation. His latest
book is Windows PowerShell 2.0: TFM (SAPIEN Press 2010) . You can follow Jeff at and .

SPONSOR: Try Fluke Networks' EtherScope Analyzer on your network FREE
IT professionals: complete your daily tasks fast. Try Fluke Networks'
EtherScope Analyzer to: measure Ethernet performance, install wired
and wireless LANs, validate LAN installations, and troubleshoot LAN
and WLAN problems.

Get a trial today!


IBM and Microsoft have been positioning themselves for times like
these. One report offers its theories as to why they'll win customers
at the expense of Oracle.

By David Ramel

I found all kinds of interesting stuff in Information Technology
Intelligence Corp.'s recent 2010 Database Deployment Trends Survey,
which predicts more companies will be upgrading their infrastructure
this year, thus allowing database vendors a rare chance to persuade
customers to switch their RDBMS allegiances.

Usually, the cost and hassle of switching database systems is

In a blog posted Thursday titled "Database Competition Heats Up," ITIC

   A wholesale switch from one platform to another requires
   significant capital expenditure monies. Additionally, the
   business must also invest a lot of time and energy in
   converting to a new platform, testing new applications,
   rewriting scripts and re-training DBAs and getting them
   certified on the new environment. For CIOs, CTOs and IT
   departments this prospect has roughly the same appeal as
   having root canal without Novocain.

But with companies scrambling to remain competitive after two and half
years of cutting costs amid the economic downturn, they will be
upgrading their systems and possibly switching their vendors, ITIC said.

The research firm concluded: "What will distinguish the DBMS market
this year is that the always intense and vociferous vendor rivalries
will heat up even more over the next 12 months."

So I wondered which of the Big 4 database vendors have an advantage
going forward, specifically related to ...

Continue reading.

David Ramel is features editor at MSDN Magazine .


Hosted by Michael Domingo

In this week's episode:

- Windows 7 Gets Anti-Piracy Update
- New SQL Server Service Packs Coming
- IE 9 Details Expected in March
- Dell Buys KACE

Click here to download and listen!

Prefer to download automatically via iTunes? Go to , click on "Subscribe with iTunes"
and when iTunes opens up, be sure to configure your subscription
settings to download each show weekly! Also, win an
cap, only by listening to the Podbean version!

Send e-mail to Michael Domingo, Editor, at if
you experience problems listening to or need help with the podcast.


You said you can't get enough Microsoft news. We heard ya, so we've
dredged the Web and filtered all stuff Redmond in this handy Web
site. Here's what crossed the wire recently:

* Cloud Computing Is Disrupting Microsoft Office 2010 and its
  Profit Margins (ReadWriteWeb)

* Microsoft on EU Antitrust Talks: Just Like 'Fatal Attraction'
  (Main Justice)

* Microsoft security guru jumps to Amazon in latest defection

* Report: Chinese programmer wrote code used against Google (CNET)

Check out here:

SPONSOR: Best Practices for Active Directory
Are you planning on making changes to your Active Directory (AD)
environment? Find out what you must consider before changing your
AD domains. Get the best practices you need for a carefully planned
and properly managed migration.

Download this paper.


** Webcast: "Are your IT systems distributed? Or convoluted?"

Hear Mary Johnston Turner, IDC Research Director for Enterprise
Systems Management Software, discuss opportunities for using
integrated, automated IT management tools to improve operational
efficiency while improving service levels. She will share recent
IDC research on the benefits of IT management automation and integration.

Register today for this FREE Webcast!

** White Paper: "The Case for Third-Party Archiving in Microsoft
Exchange Server 2010"

Are Microsoft's improved archiving features in Exchange Server 2010
enough to cover YOUR company's needs? See why third-party archiving
solutions are still necessary.

Read this FREE paper today!
** Discounts on Windows 2008/Books at

Your company is looking at migrating to Windows Server 2008, but
you're lacking the resources to do the job right. Get a jump on
studying with new books at deep discount from Check
out "Introducing Windows Server 2008" by Mitch Tulloch and the
Microsoft Windows Server Team (Microsoft Press; ) and "Windows Server 2008 Unleashed" from
Rand Morimoto et al. (Sams; ). Dozens more
at deep discount at

You can also order Windows Server 2008 Standard Edition with 5 CALs along with the Windows Server 2008 Resource
Kit , both at less than retail.

Want Windows 7? It's available here:

More Windows Server 2008 resources at


Sign up today for a free yearly subscription to Redmond magazine!
Each issue brings you hands-on problem solving advice, tactical tips,
real-world reviews, news analysis and strategic insights. Start or
continue your FREE subscription now!


We cover Enterprise Windows news, certification, security updates,
SQL, Java, SOA, virtualization and more. To review the entire
list and subscribe, click here:



NEWSLETTER FEEDBACK: Michael Domingo, Editor,

ADVERTISERS -- Want to sponsor this newsletter? Contact
Matt Morollo at

Microsoft Certified Professional Magazine,
Redmond Media Group
16261 Laguna Canyon Road, Suite 130
Irvine, CA 92618-3608
Phone 949-265-1520
Fax   949-265-1528

Newsletter problems: 


To review our Privacy Policy, visit our Web site at

Copyright 2010 1105 Media, Inc. News may only be
redistributed in its unedited form. Written permission from the
editor must be obtained to reprint the information contained within
this newsletter.