Recorded: November 26, 2008
Your Host: Keith Albright and Steve Murawski
Show Length: 1:18:15

This show is brought to you by Quest and Idera.

Automate your admin tasks FAST with Idera’s PowerShellPlus – THE Power Tool for PowerShell. Download a free 14-day trial at www.Idera.com/PowerShellPlus

 

Links:

Read the full show notes here.

Website Picks

Keith – The Linux Fund

When it comes to scripting, you’re a warrior. But mighty warriors need mighty tools!

For awesome PowerShell scripting, nothing matches the might of Quest’s PowerGUI?. Versatile and easy to use, PowerGUI? helps you build commanding scripts that leverage PowerShell’s strength across the enterprise. Now, ruling your domain is easier than ever.

Is your scripting might equal to the challenge? Put the power in your hands. Download PowerGUI today.

Listen Now:

Download Here



Comments

  1. 1
    Jed Reynolds
    December 4th, 2008 at 2:14 pm

    Re: tsql v. powershell: for a beginning admin/dba, yeah, it makes sense to choose one and specialize. With time, admins and developers gets good at both. In a command-line environment, multiple scripting languages are a good idea, because their focuses are different.

    I develop web applications. From an integration level, application health is often maintained through application checks, not just database checks. A clear distinction to me for when to use a scripting language and not SQL is whether I’m leveraging application logic external to the database. These tasks include monitoring and table maintenance.

    For example, I write bash scripts fired from cron that make mysql calls to gather monitoring data and to do table maintenance. When those maintenance tasks are not simple or need application logic, I write them in PHP to bring in my application libraries.

    Likewise, Posh would be a very reasonable language for automating maintenance in a .Net environment. You could load application libraries to check your application and that can imply peering into the database.

    Ultimately your requirements dictate which languages and toolkits are appropriate. Developers, admins and DBAs often learn several programming languages as their careers develop.

    Also, the warning about HBA limitations in vmware is fascinating: good to know!

Leave a Comment

You must be logged in to post a comment.

blank