1Pro BI

Blitz Excel UI

—

by

Alex
in

There are bunch of great scripts for MS SQL Server DBAs and SQL Developers for query analysis and performance tuning, but I use set of scripts created by Brent Ozar – sp_Blitz. It’s free. Free for downloading. Free to use. Brent also has great classes for DBAs, consultants, developers how to use them properly.

I decided to wrap the scripts into Excel tables. We all know about great SQL Server Management Studio (SSMS). It’s great. But it produced result into grids and to do sort, filtering you need to export it to MS Excel.

Excel VBA enabled UI for sp_Blitz
Excel VBA enabled UI for sp_Blitz

Easy to use and configure

Very quick demo about it

Change log and the latest version always available from this post

Views: 5809

Comments

35 responses to “Blitz Excel UI”

  1. Brent Ozar Avatar
    Brent Ozar

    THAT IS GENIUS, and I love it. Seriously, really nice work. I’d never thought of connecting directly from Excel. That is so slick.

    Reply
    1. Alex Avatar
      Alex

      Thank you, Brent. Appreciated.

      Reply
  2. Andrew Peterson Avatar
    Andrew Peterson

    Awesome! 1,000,000 points!

    Reply
    1. Alex Avatar
      Alex

      Thank you, Andrew.

      Reply
  3. Eric Patterson Avatar
    Eric Patterson

    Very interesting. Is there any kind of documentation for setting up and running? We do not install office on our servers, so I may try running this via O365 at some point.

    Reply
    1. Alex Avatar
      Alex

      Thank you, Eric. I think this is straight forward and FAQ worksheet has most of explanation. The tool should be fully supported by MSO365. But feel free to give me a shout if you have any other question or suggestion for the tool. Planing to support it.

      Reply
  4. Breck Dahlin Avatar
    Breck Dahlin

    Great job Alex

    Reply
    1. Alex Avatar
      Alex

      Thank you, Breck.

      Reply
  5. Alberto Avatar
    Alberto

    That’s really awesome! Thanks for sharing!

    Reply
    1. Alex Avatar
      Alex

      Glad you like it. Enjoy. Will support it for sure.

      Reply
    2. Thomas M Holden Avatar
      Thomas M Holden

      Amazing! Can’t wait to start using it in the AM!

      Reply
  6. Francesco Mantovani Avatar
    Francesco Mantovani

    Amazing! I will use it for sure

    Reply
    1. Alex Avatar
      Alex

      Fantastic! Thanks, mate

      Reply
  7. Jordan Avatar
    Jordan

    Great concept. It isn’t working for me on a 64-bit system. Searching the Internet suggests using PtrSafe as part of the Declare statements but also changing the code to use 64-bit libraries. Are you able to effect those changes?

    Reply
    1. Alex Avatar
      Alex

      Hi Jordan. As i work on 32 bit office i didn’t test it on x64. But please be sure will sort this and update shortly

      Reply
    2. Alex Avatar
      Alex

      Dear Jordan. Feel free to download latest version with x64 compatibility sorted via the post https://1pro.bi/blitz-excel-ui-v02/

      Reply
  8. Mark Avatar
    Mark

    Hi Alex,
    Great work!
    When I start the .xlsm file I immediately get an error message:
    “The code in this project must be updated for use on 64-bit systems.”
    Any idea?
    Greets,
    Mark

    Reply
    1. Alex Avatar
      Alex

      Hi Mark. Many thanks. Will update this or next week. I use office 32bit. But will sort the issue shortly

      Reply
    2. Alex Avatar
      Alex

      Hi Mark. New version is out and Office x64 compatibility should be sorted for now. https://1pro.bi/blitz-excel-ui-v02/

      Reply
  9. anoop Avatar
    anoop

    hello,
    I downloaded and when I try to run excel on sql installed on my laptop. I see following message
    Compile Error: the code in project must be updated for use on 64 bit systems. Please review and update declare statements and then mark them with Ptrsafe attribute.

    As I am no Vb expert, please can you help.

    Looking forward to using this…
    Thanks,

    Reply
    1. Alex Avatar
      Alex

      Hi Anoop. Thank you for your feedback. Will sort the issue this or next week. Cheers

      Reply
    2. Alex Avatar
      Alex

      Hi Anoop.
      New version is out and Office x64 compatibility should be sorted for now. https://1pro.bi/blitz-excel-ui-v02/

      Reply
  10. Mike Avatar
    Mike

    Is there any instruction on how to use this? I opened this and my Excel immediately became “Not Responding”. Thanks.

    Reply
    1. Alex Avatar
      Alex

      Mike. I will try to simplify initial setup, fix few small issues and extend some functionality in next few days. Feel free to open xml file and edit server=”[PutMyServerAddress]”.

      Reply
    2. Alex Avatar
      Alex

      Hi Mike.
      I released new version. You can specify SQL Server address now from UI.
      Feel free to download it from the post https://1pro.bi/blitz-excel-ui-v02/

      Reply
  11. Ray Avatar
    Ray

    This is a great find for me. Thanks for the time and effort put into this.

    Reply
    1. Alex Avatar
      Alex

      Thank you for your feedback, Ray

      Reply
  12. Blitz Excel UI v.0.2 > 1Pro BI

    […] For those who doesn’t know about sp_Blitz (if any) please visit Brent’s website or read another post […]

    Reply
  13. jaimin Avatar
    jaimin

    Hi Alex, Good Work but my requirement to access sql server remotely using sql server username and password. Can you please help me how to make it work. I did try to find an option in xml file but did not see any option. Really appreciate your help.

    Reply
    1. Alex Avatar
      Alex

      Hi Jaimin
      Many thanks for the comment.
      Will move connection string out from VBA code later on this week.
      I will provide a link to you later

      Reply
  14. TheSQLGuru Avatar
    TheSQLGuru

    Well done!! I look forward to watching this effort progress!

    Reply
    1. Alex Avatar
      Alex

      Thanks! 🙂

      Reply
  15. Jaimin Avatar
    Jaimin

    Hi Alex,
    Any update on my request.

    Thanks

    Reply
    1. Alex Avatar
      Alex

      Jaimin. Please test the latest version. You can read about the changes from this post

      Reply
    2. Alex Avatar
      Alex

      Hi Jamin, does new version work for you?

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *