* Checkpoint
* Checkpoint
* Checkpoint
* checkpoint
* Hooking in calls to QueryExecutionService
* adding cases
* Fleshing out report handlers
* Adding parameter converters
* Adding sqlparam declarations for Top Resource Consumers and Forced Plans
* swapping to object-object to centralize conversion for sqlparams
* Adding sqlparams for GetTrackedQueries
* Added sqlparams for High Variation
* Added Overall ResourceConumption
* Adding params for regressed queries
* Removing WithWaitStats calls, since they're automatically used within QSM when waitstats is an available statistic#
* Adding PlanSummary handlers
* cleaning up orderable queries
* initial test mockout
* adding basic (incorrect) parameter translation
* first test passing, datetimeoffset swapped to ISO format
* Adding test baselines
* Updating nuget package
* Adding get/set
* Adding get/set for result object
* Switching to parameter-less constructor
* Swapping TimeInterval for string-based BasicTimeInterval
* Removing unnecessary usings
* Adding back params comments
* Fixing up request docstrings
* comment tweak
* fix tests failing in pipeline because of line endings not matching
* removing unnecessary usings
* Setting tests to generate queries in UTC for test stability
* Normalizing line endings
---------
Co-authored-by: Kim Santiago <kisantia@microsoft.com>
* fixing up some nullable spots
* Adding database literal support
* Adding tests and support for same database refs
* Fixing test
* merge laggard
* Split database reference tests up
* PR feedback
* Normalizing strings for cross-plat test passing
* Updating Projects nuget package
* Fixing up test
* initial commit
* Initial SqlProjects service + tests
* Added SqlObject script tests; PR feedback
* Added comments for contracts
* Swapping SqlProjectResult for ResultStatus
* Updating tests
* Added automatic test base that provides a working directory and automatic cleanup.
Adding certificate migration for encrypted databases.
Uses notifications to send events back to the client every time each database certificate is migrated.
In this PR, we make the appropriate backend service changes in order to enable the login migrations feature in the SQL migration extension.
Changes include:
updating the Microsoft.SqlServer.Migration.Login NuGet version to the latest version
adding a new request handler for StartLoginMigrations calls, which makes the appropriate calls to the login NuGet
adding ExtensionMethod helper to properly combine exception maps login migration nuget calls
Co-authored-by: Akshay Mata <akma@microsoft.com>
* WIP - update NuGet and add xevent assessment request
* Update API
* Update nupkg to official build
* Add try/catch around individual recommendation models
* Clean up
* Add HS to SQL DB SKU recommendation input
* Update NuGet version and remove metadata
* Remove Content Include from csproj
* Remove unnecessary PrivateAssets tag
* Use official NuGet build
* Remove reference in IntegrationTests
* Update assessment NuGet version and metadata
* Consider Eb VM SKUs without preview flag as they are now GAed
* Update assessment NuGet to 1.0.20220527.33
Updated the E-series VM IOPS, throughput capability based on ms doc as rest endpoint giving very low number on throughput particularly.
Updated only for SKUs with local disk.
Haven't checked if D-series has similar problem, however it wouldn't cause problem as we are not showing any Dev-test recommendation for ADS.
Note : Mostly, any other mismatches wouldn't be relevant for prod recommendations.
msdoc reference : https://docs.microsoft.com/en-us/azure/virtual-machines/edv5-edsv5-series
* Initial check in for SQL migration SKU recommendation feature (#1362)
Co-authored-by: Raymond Truong <ratruong@microsoft.com>
* Integration test for Get SKU Recommendation. (#1377)
* Integration test for Get SKU Recommendation.
* Addressing comments -
1) Moving sample files to data folder.
2) Changed Assert for Positive Justification. Ideally for MI we are expecting ~6 justifications but this might change so sticking with 'recommendation should have atleast one positive justification'.
* Implement start/stop perf data collection (#1369)
* Add SqlInstanceRequirements to SKU recommendation output (#1378)
* test for data collection start and stop (#1395)
* improve error handling, add RefreshPerfDataCollection (#1393)
* WIP - refresh data collection
* Capture messages before logging
* Update Microsoft.SqlServer.Migration.Assessment NuGet version (#1402)
* Update NuGet version to 1.0.20220208.23, update assessment metadata
* Update SKU recommendation metadata
* Include preview SKUs
* Clear message/error queue after refreshing
* Clean up
* Add 'IsCollecting' to RefreshPerfDataCollection (#1405)
Co-authored-by: Neetu Singh <23.neetu@gmail.com>
* checkpoint
* Not having cake, nor eating it
* Working
* Swapping external dll for nupkg
* Extracting statement out of full TSQL
* Improving error message
* Fixing filename capitalization
* Reverting csproj changes
* Adding updated sr.cs file
* VS lost tracking on strings file?
* PR feedback
* resx additions
* More updated string files
* Swapped nuget for dll
* Revert "Swapped nuget for dll"
This reverts commit 6013f3fadf58ebc7e3590a46811d9fd9fc3eaa4a.
* Bumped netcore version to pull in support for extern aliasing nugets
* Revert "Revert "Initial migration service changes for assessment support (#1093)" (#1098)"
This reverts commit e96c0064ad.
* Move SQL Tools Service last in Main project list
* Remove .Net Core 1.0 requirement for Loc and fix mac build
Use StringResourceTool to remove .Net Core 1.0 dependency for Loc
Fixed Mac build by copying the code used in internal repo for build.
- This now mostly matches internal, so expect this should work OK.
Steven Marturano