Finally I decided to create a post with latest changes applied to the app, rather than create new post for each version.
Please find download link to the app at the end of the post
v.0.4 (2024-11-19)
- Switched to the ODBC Driver 17 for SQL Server.
- Synced with latest version of First Responder Kit
- Added support sp_WhoIsActive script written by Adam Machanic
- Added Database selector to pick desired Query Store.
Please click here to download the V.4 (20241119) version
v.0.3
- Added 2 new fields to setup Login name and Password by request of users. Defined once, you can collapse the group, save file locally on you PC and this will overwrite setting from XML.
Password field is kind of hidden, but when you click on it – still can see and change it.
I still recommend to use windows authorisation rather than spoil login details, but you have the opportunity now to use both.
- Added “Report a Bug” link to generate a mail template to developer (me)
v. 0.2
- Added Office x64 compatibility.
- You can set SQL Server address via the corresponding cell on the main screen. If the cell is empty – value from XML config file will be used.
- “Extract Everything” trigger-like button allows you to ignore “skip” (Dataset), “hide” (Column), “delete” (Column) functionality and pull all information to Excel.
- Sorted issue to Log some errors.
- Added support to code Application Name to recognize connection on the server. By default it’s application_name=”Blitz_Excel_UI“
Please click here to download the latest version
Views: 6926
Pingback: Blitz Excel UI > 1Pro BI
This is excellent!
I’ve been working on a method of performing the Glenn Berry queries via C# but your way looks a lot better. Much better and easier for capturing a point in time when performing a health check to advise a client on what is going on.
Many thanks for the feedback