____________________________PLAY ANN____________________________

____________________________PLAY OPENING MUSIC____________________________

[Keith] Welcome to the Mind Of Root. I'm Keith Albright

[Rich] and I'm Rich Niemeier.

[Steve] and I'm Steve Murawski and this is Episode 103 streaming live on Ustream.tv on Wednesday June 17, 2009. Today's show is sponsored by Quest Software; Helping you rule your domain.

Chit-Chat - What's going on with you?

[Steve]

  • Well, it's official. I gave my notice at work and they have posted my job on the HR site. I can't go into where I'm going yet, but as the summer goes on, you'll hear a lot more about it.

[Rich]

[Keith]

Housekeeping Items

[Rich]

[Steve]

[Keith]

  • Resume Peer Review - Still going

____________________________READ QUEST AD COPY____________________________

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. Visit www.quest.com forward slash mind of root and download PowerGUI today.

____________________________READ TPN PROMO____________________________

Steve's Topics

  • Data Mining with Excel and SQL Server [STEVE]
-Brent Ozar got me interested in some of the "in the box" capabilities of SQL Server when used with Excel 2007 and a free add-in.
-Excel 2007 supports up to a million rows, and Excel 2010 should be unlimited (pending memory pressure).
-The Excel 2007 Data Mining Add-in provides some cool associative techniques that you can run against a table of data in Excel.
-It uses SQL Server Analysis Serices to look for relationships in your data and presents them to you in a nice neat report.
-Data Mining Tools
-Analyze Key Influencers
-Detect Categories
-Fill From Example
-Forecasting
-Highlight Exceptions
-Scenario Analysis (What-If and Goal Seek)
-Prediction Calculator
-Shopping Basket Analysis
-Link: http://www.sqlserverdatamining.com/ssdm/
-Link: http://www.brentozar.com/archive/2009/06/data-mining-the-stackoverflow-database/
-Link: http://www.microsoft.com/sqlserver/2008/en/us/data-mining-addins.aspx
  • Find that Stored Procedure [KEITH]
-Some DB schema are immense. Our company runs MS Dynamics GP and just the Stored Procedures canned in the software run in the hundereds.
-We also have some custom SP's for reports. Through the upgrade we had one report that didn't work right, so I went to find the SP.
-New to SQL Management Studio 2008, I was looking in the wrong spot, but in tracking it down I came across this trick that will come in handy elsewhere.
-Point to a DB and run this query to list all the Stored Procedures (and lots of details on them)
-I'm looking forward to using this when looking for hooks into our Customer Information System and Dynamics since I can search all the routines with a keyword related to the function I'm looking for.
-Link: http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html

USE Dynamics
SELECT ROUTINE_NAME, ROUTINE_SCHEMA, ROUTINE_BODY, ROUTINE_CATALOG, ROUTINE_DEFINITION, CREATED
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%ProcedureName?%'
AND ROUTINE_TYPE = 'PROCEDURE' ORDER BY ROUTINE_NAME

[STEVE] That works or you could search the ROUTINE_NAME field instead of the definition. I can see some scenarios where you might get false positives from searching the definition for a portion of the procedure name. One specific scenario where the above query will backfire is if you have a SQL CLR stored proc (which has no ROUTINE_DEFINITION). (Sorry, I'm very picky about my SQL Query formatting)

USE Dynamics

DECLARE @ProcedureName? NVarChar?(128)

SET @ProcedureName? = '%ProcedureName?%'
SELECT ROUTINE_NAME
, ROUTINE_SCHEMA
, ROUTINE_BODY
, ROUTINE_CATALOG
, ROUTINE_DEFINITION
, CREATED
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_NAME LIKE @ProcedureName?
AND ROUTINE_TYPE = 'PROCEDURE'
ORDER BY ROUTINE_NAME

  • Scripting Games [KEITH]
-The Scripting Games are in full swing!
-I'm the guest commentator for Event #1 in the beginner area, with both a VBScript (yuck!) and PowerShell solution.
-Link: http://blogs.technet.com/heyscriptingguy/archive/2009/06/14/everything-scripting-games-come-here-if-you-are-lost.aspx
-Link: http://blogs.technet.com/heyscriptingguy/archive/2009/06/14/hey-scripting-guy-event-1-solutions-from-expert-commentators-beginner-and-advanced-100-meter-dash.aspx
  • Perfmon Counter - Processor\% Interrupt Time [STEVE]
-This is the amount of time, as a percentage that the processor spends dealing with interruptions due to hardware requests. The higher this percentage, the more your hardware is demanding of your processor and that leaves less capacity for running your services and applications.
-Numbers over 15% are an indication of some hardware issues
-Link: http://technet.microsoft.com/en-us/magazine/2008.08.pulse.aspx
  • IT Pro's - Want Virtualization - Forget about Virtual PC [STEVE]
-First off, I want to thank Ben (The Virtual PC Guy), for his straightforward answer, though I really don't like it.
-If you need to work with any x64 technology (exchange, sharepoint, server 2008 R2, and more) in a virtualized environment (for testing), you are limited to Hyper-V or going with a third party solution (VMWare Workstation?).
-The purpose for Virtual PC has been re-aligned to providing backward compatibility, not as a general virtualization product.
-Link: http://blogs.msdn.com/virtual_pc_guy/default.aspx
-Link: http://blogs.msdn.com/virtual_pc_guy/archive/2009/06/15/creating-virtual-machines-with-windows-virtual-pc.aspx
  • Error Creating Outlook Profile [KEITH]
-Nothing new in getting errors with Outlook.
-Neat little fix. Just delete the MAPISVC.INF file from both locations and recreate.
-NOTE: You'll probably have to reboot to get the files free for deletion since Outlook locks everything hard.
-Link: http://www.bayareapchelper.com/Windows-Tips/Outlook-2003-Error-creating-profile.html
  • Kindle Source Code Released? [STEVE]
-I came across this from Jim Minatel's blog (Editor for Wrox Publishing)
-Jim has a couple of questions
-Will we see competing hardware devices running clones or forks of the Kindle source?
-If we do see 3rd party devices, will their users be able to buy from the Amazon Kindle store?
-Will we see Kindle software solutions for existing hardware platforms? Amazon's already released Kindle for iPhone (which I use). Will we see other vendors use it too?
-Will this allow other retailers to sell Kindle ebooks from their site directly to other devices?
-Could new Kindle clones or stores mean DRM-free Kindle books?
-Interesting questions, what do you think? Does this matter?
-Code seems to be released under the GPL (which one, I'm not sure)
-Link: http://wroxblog.typepad.com/minatel/2009/06/kindle-source-code-release-what-does-it-mean.html
-Link: http://www.amazon.com/gp/help/customer/display.html?ie=UTF8&nodeId=200203720
  • Snow Leopard to support Exchange natively [KEITH]
-Nice feature to help drive corporate adoption.
-I always hated that Outlook was required as a separately licensed (pronounced purchased) product to make Exchange work.
-$29 upgrade....Hello, Microsoft. Did you hear that?!?!?!
-Link: http://www.apple.com/macosx/exchange.html

____________________________PLAY SWEEPER____________________________

Listener Feedback

From listener.... Petri Lopia

Resume review thing is really good idea so you guys should keep doing it but maybe once in a month or something like that (so that you could get enough resumes)?

I would like to send my resume for review but I'm just trying to do my resume so...

It would be really good to have "resume gallery" on MoR? pages where peoples like me could get ideas and so on how to write their own resume and what kind it should be.

Website Picks

Rich - http://

Steve - http://

Keith - http://

Last Call

Anyone....Anyone....Buehler.....Buehler....

Closing Test- I'd like to thank everyone in the chat on UStream?.tv we always enjoy the additional comments and interaction. everyone should remember that there are numerous ways one can interact with the show. For listener feedback post comments on the main show site, or email us at feedback[at] MindofRoot?.com.

It's always fun to see where our listeners live, put a pin on our frappr map there is a link to this on the main show site.

To become even more involved you can leave suggestions for future shows on the topics request wiki. Again a link to the wiki can be found on the main show site.

There is a link to the wiki on the main show site. If you would like to participate in the show; either through an interview, a segment contribution, or any other way, please let us know. We are also a member of the Techpodcast network. Check out some other great shows by going to Techpodcast.com.

test end-

All right, well that is it for the show. For listener feedback; you can email us at Feedback [at] mindofroot.com or post a comment on the main site at mindofroot.com. If you use iTunes, you could write a review. If you just want to show us your listening, drop a pin on the Frappr map...there's a link on the show site.

Lastly, you can drop any show ideas or topic requests on the wiki. There is a link to the wiki on the main show site. If you would like to participate in the show; either through an interview, a segment contribution, or any other way, please let us know. We are also a member of the Techpodcast network. Check out some other great shows by going to Techpodcast.com.