Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve Connection Dialog - Advanced Settings panel #18961

Open
croblesm opened this issue Mar 20, 2025 · 2 comments
Open

Improve Connection Dialog - Advanced Settings panel #18961

croblesm opened this issue Mar 20, 2025 · 2 comments

Comments

@croblesm
Copy link
Contributor

croblesm commented Mar 20, 2025

The Advanced Connection Settings panel in the MSSQL extension needs an updated layout to make it simpler and more intuitive. The changes should include:

  • Search Settings: Add a "Search settings" textbox at the top.
  • General Category: Introduce a new top category called General (for core settings) that is expanded by default but can be collapsed.
  • Connection Type Visibility: Move Connection Type (Application intent) under General and display it more prominently with radio buttons for “Read & Write Mode (Default)” vs. “Read-Only Mode.”
  • Restructure Categories: Reorganize the remaining settings to be more intuitive (e.g., combine Failover & Replication, remove the Database Initialization category).

Below is a reference screenshot (example of how the collapsed/expanded sections might appear):

Image
Image
Image
Image
Image
Image

Proposed Layout Tree for the panel:

Advanced Connection Settings
├── General (Top-level / Core Settings)
│   ├── Port
│   ├── Application name (Default: vscode-mssql)
│   ├── Connection timeout (seconds - Default: 30)
│   ├── Connection Type (Application intent)
│   │   ├── Read & Write Mode (Default)
│   │   └── Read-Only Mode
│   └── Multi-subnet failover (Checkbox)
├── Security & Encryption
│   ├── Always Encrypted
│   │   ├── Disabled
│   │   └── Enabled
│   ├── Secure Enclaves
│   │   ├── Disabled
│   │   └── Enabled
│   ├── Attestation Protocol
│   │   ├── Host Guardian Service
│   │   └── Azure Attestation
│   ├── Enclave Attestation URL
│   ├── Persist security info (Checkbox)
│   ├── Host name in certificate
│   └── Type system version
├── Connection Resiliency
│   ├── Command timeout
│   ├── Connect retry count
│   └── Connect retry interval
├── Failover & Replication
│   ├── Replication (Checkbox)
│   └── Failover partner
├── Pooling Settings
│   ├── Pooling (Checkbox)
│   ├── Min pool size
│   ├── Max pool size
│   ├── Load balance timeout
│   └── Packet size
└── Data Source & Context
    ├── Context connection (Checkbox)
    ├── Workstation ID
    ├── Current language
    └── Attach DB filename
@croblesm croblesm added this to the March Release 2025 milestone Mar 20, 2025
@croblesm croblesm changed the title Improve MSSQL Connection Dialog Layout Improve MSSQL Connection Dialog - Advanced Settings Mar 20, 2025
@croblesm croblesm changed the title Improve MSSQL Connection Dialog - Advanced Settings Improve Connection Dialog - Advanced Settings panel Mar 20, 2025
@croblesm
Copy link
Contributor Author

cc @jdesai-24

@Benjin
Copy link
Contributor

Benjin commented Mar 21, 2025

Moving this out because this is coming in too late for Ask Mode this month.

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

No branches or pull requests

2 participants