Episode 77 - Remember El Morro
Podcast November 29th, 2008
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.
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!