SQL Agent Insights:Documentation:Download and Installation: Difference between revisions
| Line 9: | Line 9: | ||
== Installation == | == Installation == | ||
* Using | * Using "File Explorer" navigate to where you saved the SQL Agent Insight downloaded zip file; usually in your Downloads folder. | ||
* NOTE: Windows may flag the downloaded file and block it from running on your computer. To rectify this issue (before extracting/unzipping), in File Explorer, right-click on the zip file, and on the General tab, click the Unblock checkbox, click Apply / OK to proceed. | * NOTE: Windows may flag the downloaded file and block it from running on your computer. To rectify this issue (before extracting/unzipping), in File Explorer, right-click on the zip file, and on the General tab, click the Unblock checkbox, click Apply / OK to proceed. | ||
| Line 15: | Line 15: | ||
** You would then require to unblock each file individually to prevent execution errors. | ** You would then require to unblock each file individually to prevent execution errors. | ||
** However, if you wanted to unblock all files after extraction (unzipping) you can run this PowerShell: | ** However, if you wanted to unblock all files after extraction (unzipping) you can run this PowerShell: | ||
<blockquote> | |||
''dir [path and filename of the extracted zip file] -Recurse | Unblock-File'' | |||
</blockquote> | |||
For example: | |||
<blockquote> | |||
''dir C:\Users\Me\Downloads\SQLAI_v0.22.2010.0.zip -Recurse | Unblock-File'' | |||
</blockquote> | |||
Right-click on the downloaded SQL Agent Insight zip file and select "Extract All...". | |||
* A new dialog will appear asking for the destination to extract the files. You can "Browse…" to select a new location if desired, but you can leave the defaults and then click the "Extract" button near the bottom. Wait for this to complete, and should take no longer than 10 seconds. | |||
* If you didn’t unblock the downloaded file post download and have already extracted the contents, see above on how to use PowerShell to recursively unblock the files so they can be used. | |||
= Main User Interface = | = Main User Interface = | ||
Revision as of 22:44, 15 January 2023
Download and Installation
Download
- Using the top navigation menu system over at brentec.ca, hover over SQL Agent Insight (at the top of the page).
- Click on Download
- On the download page, complete the captcha and then click on the Download button to obtain your copy of SQL Agent Insight.
Installation
- Using "File Explorer" navigate to where you saved the SQL Agent Insight downloaded zip file; usually in your Downloads folder.
- NOTE: Windows may flag the downloaded file and block it from running on your computer. To rectify this issue (before extracting/unzipping), in File Explorer, right-click on the zip file, and on the General tab, click the Unblock checkbox, click Apply / OK to proceed.
- NOTE: Failing to unblock the zip file will block ALL files in the zip file once extracted (see process below).
- You would then require to unblock each file individually to prevent execution errors.
- However, if you wanted to unblock all files after extraction (unzipping) you can run this PowerShell:
dir [path and filename of the extracted zip file] -Recurse | Unblock-File
For example:
dir C:\Users\Me\Downloads\SQLAI_v0.22.2010.0.zip -Recurse | Unblock-File
Right-click on the downloaded SQL Agent Insight zip file and select "Extract All...".
- A new dialog will appear asking for the destination to extract the files. You can "Browse…" to select a new location if desired, but you can leave the defaults and then click the "Extract" button near the bottom. Wait for this to complete, and should take no longer than 10 seconds.
- If you didn’t unblock the downloaded file post download and have already extracted the contents, see above on how to use PowerShell to recursively unblock the files so they can be used.
Main User Interface
Connecting to an Instance of SQL Server®
Preferences
Back to Documentation Main
Microsoft® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.