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](https://1pro.bi/wp-content/uploads/2021/08/Screenshot-2021-08-10-225608.jpg)
Change log and the latest version always available from this post
Views: 5688
THAT IS GENIUS, and I love it. Seriously, really nice work. I’d never thought of connecting directly from Excel. That is so slick.
Thank you, Brent. Appreciated.
Awesome! 1,000,000 points!
Thank you, Andrew.
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.
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.
Great job Alex
Thank you, Breck.
That’s really awesome! Thanks for sharing!
Glad you like it. Enjoy. Will support it for sure.
Amazing! Can’t wait to start using it in the AM!
Amazing! I will use it for sure
Fantastic! Thanks, mate
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?
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
Dear Jordan. Feel free to download latest version with x64 compatibility sorted via the post https://1pro.bi/blitz-excel-ui-v02/
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
Hi Mark. Many thanks. Will update this or next week. I use office 32bit. But will sort the issue shortly
Hi Mark. New version is out and Office x64 compatibility should be sorted for now. https://1pro.bi/blitz-excel-ui-v02/
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,
Hi Anoop. Thank you for your feedback. Will sort the issue this or next week. Cheers
Hi Anoop.
New version is out and Office x64 compatibility should be sorted for now. https://1pro.bi/blitz-excel-ui-v02/
Is there any instruction on how to use this? I opened this and my Excel immediately became “Not Responding”. Thanks.
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]”.
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/
This is a great find for me. Thanks for the time and effort put into this.
Thank you for your feedback, Ray
Pingback: Blitz Excel UI v.0.2 > 1Pro BI
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.
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
Well done!! I look forward to watching this effort progress!
Thanks! 🙂
Hi Alex,
Any update on my request.
Thanks
Jaimin. Please test the latest version. You can read about the changes from this post
Hi Jamin, does new version work for you?