SQL Server, Analytics, .Net, Machine Learning, R, Python
Mitch Wheat has been working as a professional programmer since 1984, graduating with a honours degree in Mathematics from Warwick University, UK in 1986. He moved to Perth in 1995, having worked in software houses in London and Rotterdam. He has worked in the areas of mining, electronics, research, defence, financial, GIS, telecommunications, engineering, and information management. Mitch has worked mainly with Microsoft technologies (since Windows version 3.0) but has also used UNIX. He holds the following Microsoft certifications: MCPD (Web and Windows) using C# and SQL Server MCITP (Admin and Developer). His preferred development environment is C#, .Net Framework and SQL Server. Mitch has worked as an independent consultant for the last 10 years, and is currently involved with helping teams improve their Software Development Life Cycle. His areas of special interest lie in performance tuning
Tuesday, February 05, 2013
SQL Diagnostic Runner: Version 1.0
Glenn Berry mentioned the runner for his diagnostic scripts I wrote a few weeks ago. He also mentioned it would be nice to have a UI version. I had already written a basic UI when I initially released the command line version. So here it is, warts and all! (along with a minor update to the command line version)
Comments and feedback welcome.
Thank you, David. I didn't have a local named instance to test against. No excuses1 I didn't test it. Fixing now...
FYI: I've tried running it on SQL Server 2012 sp1, and there are a few problems.
@Henrik Staun Poulsen: What errors do you receive? What doesn't work? have you tried running the TSQL script directly in SSMS?
I have uploaded a rebuilt copy of both the command line and UI runner (version 18.104.22.16845). Just tested against a local 2012 named instance with the latest version of Glenn's 2012 script. Worked Fine. Just in process of applying SP1 to 2012 ....
MSN, Email: mitch døt wheat at gmail.com