Author: Alex
-
Wishlist 2022
While working on the app update to the latest version of sp_Blitz and was thinking of adding some other tools, e.g. Index Creation progress, sp_WhoIsActive, tool set from Ola Hallengren or anything else. What do you think? Views: 2169
-
Blitz Excel UI Change Log
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.3 Added 2 new fields to setup Login name and Password by request of users. Defined once, you can collapse…
-
Blitz Excel UI v.0.2
Here Here we have a new release. What has been done:1. Added Office x64 compatibility.2. 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.3. “Extract Everything” trigger-like button allows you to ignore “skip” (Dataset), “hide” (Column),…
-
Blitz Excel UI
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…
-
Blitz Excel In progress
Another quick video about customizable wrapper for great product from Brent Ozar – “First Responder Kit“. This quick demo shows the power of automation I’m working on to help people on day-to-day routing and retrieve various data from Database servers. I feel great potential of the product and will publish more demos to cover other…
-
Excel as BI tool in business
Working in strict environments such as Financial Institution, Insurance broker, government etc., we often find that there is no access to third party tools, which we can use for data analysis due security reason. At the same time, there is well known data representation tool – MS Excel. Want a report immediately? Manager has now…