Skip to content

Instantly share code, notes, and snippets.

@flcdrg
Last active February 18, 2024 04:53
Show Gist options
  • Save flcdrg/7d00c69c2cde8309a8594abaa897a9a6 to your computer and use it in GitHub Desktop.
Save flcdrg/7d00c69c2cde8309a8594abaa897a9a6 to your computer and use it in GitHub Desktop.
Update-AUPackages Report #powershell #chocolatey

Update-AUPackages

15 2018.2.16.230139 UTC: 2018-02-16 23:01 flcdrg/au-packages

This file is automatically generated by the update_all.ps1 script using the AU module.

History

Last run was OK

Finished 15 packages after 5.2 minutes.
1 updated, 1 pushed, 0 ignored
0 errors - 0 update, 0 push.

Pushed

Icon Name Updated Pushed RemoteVersion NuspecVersion
sql-server-management-studio True πŸ”Έ True 14.0.17224.0 14.0.17213.0

OK

Icon Name Updated Pushed RemoteVersion NuspecVersion
beyondcompare False False 4.2.4.22795 4.2.4.22795
dotnetdeveloperbundle False False 2.0.1.2371 2.0.1.2371
iguana False False 6.0.7 6.0.7.20171211
iguana.install False False 6.0.7 6.0.7.20171211
iguana.portable False False 6.0.7 6.0.7
microsoft-teams False False 1.1.00.2251 1.1.00.2251
ozcode False False 3.1.0.3913 3.1.0.3913
ozcode-vs2017 False False 3.1.0.3913 3.1.0.3913
PDFXchangeEditor False False 7.0.324.2 7.0.324.2
sql-server-management-studio True πŸ”Έ True 14.0.17224.0 14.0.17213.0
sqltoolbelt False False 2.0.1.2371 2.0.1.2371
typescript-vs2015 False False 2.7.2.0 2.7.2.0
ubiquiti-unifi-controller False False 5.6.30 5.6.30
ubiquiti-unifi-controller-5.4.x False False 5.4.19 5.4.19
ubiquiti-unifi-controller-5.5.x False False 5.5.24 5.5.24

beyondcompare

beyondcompare - checking updates using au version 2018.2.16.230139

URL check
  https://www.scootersoftware.com/BCompare-fr-4.2.4.22795.exe
  https://www.scootersoftware.com/BCompare-jp-4.2.4.22795.exe
  https://www.scootersoftware.com/BCompare-4.2.4.22795.exe
  https://www.scootersoftware.com/BCompare-de-4.2.4.22795.exe
nuspec version: 4.2.4.22795
remote version: 4.2.4.22795
No new version found

dotnetdeveloperbundle

dotnetdeveloperbundle - checking updates using au version 2018.2.16.230139

URL check
  ftp://support.red-gate.com/patches/DotNETDeveloperBundle/13Feb2018/DotNETDeveloperBundle.exe
nuspec version: 2.0.1.2371
remote version: 2.0.1.2371
No new version found

iguana

iguana - checking updates using au version 2018.2.16.230139

URL check
  http://dl.interfaceware.com/iguana/windows/6_0_7/iguana_6_0_7_windows_x64.exe
  http://dl.interfaceware.com/iguana/windows/6_0_7/iguana_6_0_7_windows_x86.exe
nuspec version: 6.0.7.20171211
remote version: 6.0.7
No new version found

iguana.install

iguana.install - checking updates using au version 2018.2.16.230139

URL check
  http://dl.interfaceware.com/iguana/windows/6_0_7/iguana_6_0_7_windows_x64.exe
  http://dl.interfaceware.com/iguana/windows/6_0_7/iguana_6_0_7_windows_x86.exe
nuspec version: 6.0.7.20171211
remote version: 6.0.7
No new version found

iguana.portable

iguana.portable - checking updates using au version 2018.2.16.230139

URL check
  http://dl.interfaceware.com/iguana/windows/6_0_7/iguana_noinstaller_6_0_7_windows_x64.zip
  http://dl.interfaceware.com/iguana/windows/6_0_7/iguana_noinstaller_6_0_7_windows_x86.zip
nuspec version: 6.0.7
remote version: 6.0.7
No new version found

microsoft-teams

microsoft-teams - checking updates using au version 2018.2.16.230139

URL check
  https://statics.teams.microsoft.com/production-windows-x64/1.1.00.2251/Teams_windows_x64.exe
  https://statics.teams.microsoft.com/production-windows/1.1.00.2251/Teams_windows.exe
nuspec version: 1.1.00.2251
remote version: 1.1.00.2251
No new version found

ozcode

ozcode - checking updates using au version 2018.2.16.230139

URL check
  http://downloads.oz-code.com/files/OzCode_3.1.0.3913.exe
nuspec version: 3.1.0.3913
remote version: 3.1.0.3913
No new version found

ozcode-vs2017

ozcode-vs2017 - checking updates using au version 2018.2.16.230139

URL check
  http://downloads.oz-code.com/files/OzCode_3.1.0.3913_FOR_VS2017.vsix
nuspec version: 3.1.0.3913
remote version: 3.1.0.3913
No new version found

PDFXchangeEditor

PDFXchangeEditor - checking updates using au version 2018.2.16.230139

URL check
nuspec version: 7.0.324.2
remote version: 7.0.324.2
No new version found

sql-server-management-studio

sql-server-management-studio - checking updates using au version 2018.2.16.230139

URL check
nuspec version: 14.0.17213.0
remote version: 14.0.17224.0
New version is available
Automatic checksum skipped
Updating files
  $Latest data:
    FullChecksum              (String)     770675775E650BC4B16D26895C5FEE10D1BAF07526762DA46ED0F031CAC418C6
    FullUrl                   (Uri)        https://download.microsoft.com/download/8/8/3/883FD1FA-FE61-4E83-85F9-FA46D4A5B866/SSMS-Setup-ENU.exe
    NuspecVersion             (String)     14.0.17213.0
    PackageName               (String)     sql-server-management-studio
    Release                   (String)     17.5
    ReleaseNotes              (String)     
#### [SSMS 17.5](download-sql-server-management-studio-ssms.md)

Generally available | Build number: 14.0.17224.0

##### What's new

**General SSMS**

Data Discovery & Classification:

- Added a new SQL Data Discovery & Classification feature for discovering, classifying, labeling & reporting sensitive data in your databases. 
- Auto-discovering and classifying your most sensitive data (business, financial, healthcare, PII, etc.) can play a pivotal role in your organizational information protection stature.
- Learn more at [SQL Data Discovery & Classification](../relational-databases/security/sql-data-discovery-and-classification.md).

Query Editor:

- Added support for SkipRows option to the Delimited Text External File Format for Azure SQL DW. This capability allows users to skip a specified number of rows when loading delimited text files into SQL DW. Also added the corresponding intellisense/SMO support for the FIRST_ROW keyword. 

Showplan:

- Enabled display of estimated plan button for SQL Data Warehouse
- Added new showplan attribute *EstimateRowsWithoutRowGoal*; and added new showplan attributes to *QueryTimeStats*: *UdfCpuTime* and *UdfElapsedTime*. For more information, see [Optimizer row goal information in query execution plan added in SQL Server 2017 CU3](http://support.microsoft.com/help/4051361).



##### Bug fixes

**General SSMS**

Showplan:

- Fixed Live Query Statistics elapsed time, to show engine execution time instead of time elapsed for LQS connection.
- Fixed an issue where showplan was not able to recognize Apply logical operators like GbApply and InnerApply.
- Fixed an issue related to ExchangeSpill.

Query Editor:

- Fixed on issue related to SPIDs where SSMS could throw an error like "Input string was not in a correct format. (mscorlib)" when executing a simple query preceded by a "SET SHOWPLAN_ALL ON". 


SMO:

- Fixed an issue where SMO was not able to fetch AvailabilityReplica properties in case the server collation happened to be case-sensitive (as a result, SSMS could display an error message like "The multi-part identifier "a.delimited" could not be bound."
- Fixed an issue in DatabaseScopedConfigurationCollection class, where incorrectly handling collations (as a result, an SSMS running on an ma machine with a Turkish locale could display an error like "legacy cardinality estimation is not valid scoped configuration" when right clicking on a database running on a server with a case-sensitive collation).
- Fixed an issue in JobServer class, where SMO was not able to fetch SQL Agent properties on a SQL 2005 server (as a result, SSMS was throwing an error like "Cannot assign a default value to a local variable. Must declare the scalar variable "@ServiceStartMode" and, ultimately, was not displaying the SQL Agent node in Object Explorer).

Templates: 

- "Database Mail": fixed a couple of typos [(https://feedback.azure.com/forums/908035/suggestions/33143512)](https://feedback.azure.com/forums/908035/suggestions/33143512).  

Object Explorer:
- Fixed an issue where Managed Compression would fail for indexes (https://feedback.azure.com/forums/908035-sql-server/suggestions/32610058-ssms-17-4-error-when-enabling-page-compression-o).

Auditing:
- Fixed an issue with the *Merge Audit Files* feature.
<br>

##### Known issues

Data classification:
- Removing a classification and then manually adding a new classification for the same column results in the old information type and sensitivity label being assigned to the column in the main view.<br>
*Workaround*: Assign the new information type and sensitivity label after the classification was added back to the main view and before saving.

    UpgradeChecksum           (String)     D0DBDC0FC4413854C7040FC3E18CDA3A0E09C4E496F46075215A3C9C5684B33E
    UpgradeUrl                (Uri)        https://download.microsoft.com/download/8/8/3/883FD1FA-FE61-4E83-85F9-FA46D4A5B866/SSMS-Setup-ENU-Upgrade.exe
    Version                   (String)     14.0.17224.0
  sql-server-management-studio.nuspec
    setting id: sql-server-management-studio
    updating version: 14.0.17213.0 -> 14.0.17224.0
  tools\chocolateyInstall.ps1
    (^[$]fullUrl\s*=\s*)('.*')          = $1'https://download.microsoft.com/download/8/8/3/883FD1FA-FE61-4E83-85F9-FA46D4A5B866/SSMS-Setup-ENU.exe'
    (^[$]fullChecksum\s*=\s*)('.*')     = $1'770675775E650BC4B16D26895C5FEE10D1BAF07526762DA46ED0F031CAC418C6'
    (^[$]upgradeUrl\s*=\s*)('.*')       = $1'https://download.microsoft.com/download/8/8/3/883FD1FA-FE61-4E83-85F9-FA46D4A5B866/SSMS-Setup-ENU-Upgrade.exe'
    (^[$]release\s*=\s*)('.*')          = $1'17.5'
    (^[$]upgradeChecksum\s*=\s*)('.*')  = $1'D0DBDC0FC4413854C7040FC3E18CDA3A0E09C4E496F46075215A3C9C5684B33E'
Running au_AfterUpdate
Attempting to build package from 'sql-server-management-studio.nuspec'.
Successfully created package 'C:\projects\au-packages\sql-server-management-studio\sql-server-management-studio.14.0.17224.0.nupkg'
Package updated
Chocolatey v0.10.8
Attempting to push sql-server-management-studio.14.0.17224.0.nupkg to https://push.chocolatey.org
sql-server-management-studio 14.0.17224.0 was pushed successfully to https://push.chocolatey.org

sqltoolbelt

sqltoolbelt - checking updates using au version 2018.2.16.230139

URL check
  ftp://support.red-gate.com/patches/SQLToolbelt/15Feb2018/SQLToolbelt.exe
nuspec version: 2.0.1.2371
remote version: 2.0.1.2371
No new version found

typescript-vs2015

typescript-vs2015 - checking updates using au version 2018.2.16.230139

URL check
  https://download.microsoft.com/download/6/D/8/6D8381B0-03C1-4BD2-AE65-30FF0A4C62DA/2.7.2-TS-release-dev14update3-20180212.1/TypeScript_Dev14Full.exe
nuspec version: 2.7.2.0
remote version: 2.7.2.0
No new version found

ubiquiti-unifi-controller

ubiquiti-unifi-controller - checking updates using au version 2018.2.16.230139

URL check
  https://www.ubnt.com/downloads/unifi/5.6.30/UniFi-installer.exe
nuspec version: 5.6.30
remote version: 5.6.30
No new version found

ubiquiti-unifi-controller-5.4.x

ubiquiti-unifi-controller-5.4.x - checking updates using au version 2018.2.16.230139

URL check
  https://www.ubnt.com/downloads/unifi/5.4.19/UniFi-installer.exe
nuspec version: 5.4.19
remote version: 5.4.19
No new version found

ubiquiti-unifi-controller-5.5.x

ubiquiti-unifi-controller-5.5.x - checking updates using au version 2018.2.16.230139

URL check
  https://www.ubnt.com/downloads/unifi/5.5.24/UniFi-installer.exe
nuspec version: 5.5.24
remote version: 5.5.24
No new version found

Update History

Showing maximum 30 dates.
Click on the first letter of the package name to see its report and on the remaining letters to see its git commit.


2018-02-15 (1) Typescript-vs2015

2018-02-12 (1) Dotnetdeveloperbundle

2018-02-08 (1) Ubiquiti-unifi-controller

2018-02-07 (1) Sqltoolbelt

2018-02-06 (1) Pdfxchangeeditor

2018-02-05 (1) Pdfxchangeeditor

2018-02-02 (1) Pdfxchangeeditor

2018-01-31 (2) Sqltoolbelt – Typescript-vs2015

2018-01-30 (2) Beyondcompare – Microsoft-teams

2018-01-18 (3) Microsoft-teams – Sqltoolbelt – Typescript-vs2015

2018-01-12 (1) Sqltoolbelt

2018-01-11 (1) Microsoft-teams

2018-01-08 (1) Ubiquiti-unifi-controller

2018-01-04 (1) Sqltoolbelt

2018-01-03 (1) Sqltoolbelt

2017-12-22 (1) Typescript-vs2015

2017-12-21 (1) Pdfxchangeeditor

2017-12-18 (1) Sqltoolbelt

2017-12-14 (2) Pdfxchangeeditor – Microsoft-teams

2017-12-13 (1) Sqltoolbelt

2017-12-12 (2) Sqltoolbelt – Ubiquiti-unifi-controller

2017-12-07 (2) Sql-server-management-studio – Sqltoolbelt

2017-12-06 (1) Microsoft-teams

2017-12-05 (1) Sqltoolbelt

2017-12-01 (1) Pdfxchangeeditor

2017-11-30 (2) Microsoft-teams – Sqltoolbelt

2017-11-29 (4) Iguana – Iguana.install – Iguana.portable – Sqltoolbelt

2017-11-27 (1) Sqltoolbelt

2017-11-25 (3) Microsoft-teams – Sqltoolbelt – Ubiquiti-unifi-controller

2017-10-31 (2) Sqltoolbelt – Typescript-vs2015

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment