Skip to content

Commit 27fad20

Browse files
dzsquareddzsquared
committed
updates what is to match faq
1 parent f19ded9 commit 27fad20

1 file changed

Lines changed: 43 additions & 42 deletions

File tree

‎docs/azure-data-studio/what-is.md‎

Lines changed: 43 additions & 42 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@ author: "markingmyname"
88
ms.author: "maghan"
99
ms.reviewer: "alayu, maghan, sstein"
1010
ms.custom: "seodec18, sqlfreshmay19"
11-
ms.date: "01/15/2020"
11+
ms.date: "10/20/2020"
1212
---
1313

1414
# What is Azure Data Studio?
@@ -54,109 +54,110 @@ To learn about authoring extensions, see [Extension authoring](extensions/extens
5454

5555
**Use Azure Data Studio if you:**
5656

57-
- Need to run on macOS or Linux
58-
- Are connecting to a SQL Server 2019 big data cluster
59-
- Spend most of your time editing or executing queries
60-
- Need the ability to quickly chart and visualize result sets
61-
- Can execute most administrative tasks via the integrated terminal using sqlcmd or Powershell
62-
- Have minimal need for wizard experiences
63-
- Don't need to do deep administrative configuration
57+
- Are mostly editing or executing queries.
58+
- Need the ability to quickly chart and visualize result sets.
59+
- Can execute most administrative tasks via the integrated terminal using sqlcmd or PowerShell.
60+
- Have minimal need for wizard experiences.
61+
- Do not need to do deep administrative or platform related configuration.
62+
- Need to run on macOS or Linux.
6463

6564
**Use SQL Server Management Studio if you:**
6665

67-
- Spend most of your time on database administration tasks
68-
- Are doing deep administrative configuration
69-
- Are doing security management, including user management, vulnerability assessment, and configuration of security features
70-
- Make use of the Reports for SQL Server Query Store
71-
- Need to make use of performance tuning advisors and dashboards
72-
- Are doing Import/Export of DACPACs
73-
- Need access to Registered Servers and want to control SQL Server services on Windows
66+
- Are doing complex administrative or platform configuration.
67+
- Are doing security management, including user management, vulnerability assessment, and configuration of security features.
68+
- Need to make use of performance tuning advisors and dashboards.
69+
- Use database diagrams and table designers.
70+
- Need access to Registered Servers.
71+
- Make use of live query stats or client statistics.
7472

75-
### Shell
73+
### Shell features
7674

7775
|Feature|Azure Data Studio|SSMS|
7876
|:---|:---|:---|
7977
|Azure Sign-In|Yes|Yes|
80-
|Dashboard|Yes||
81-
|Extensions|Yes||
78+
|Dashboard|Yes| |
79+
|Extensions|Yes| |
8280
|Integrated Terminal|Yes||
8381
|Object Explorer|Yes|Yes|
8482
|Object Scripting|Yes|Yes|
8583
|Project System|Yes||
8684
|Select from Table|Yes|Yes|
8785
|Source Code Control|Yes||
8886
|Task Pane|Yes||
89-
|Theming|Yes||
90-
|Dark Mode|Yes||
87+
|Themes, including Dark Mode|Yes||
9188
|Azure Resource Explorer|Preview||
92-
|Generate Scripts Wizard||Preview|
93-
|Import/Export DACPAC||Yes|
94-
|Object Properties||Preview|
89+
|Generate Scripts Wizard||Yes|
90+
|Object Properties||Yes|
9591
|Table Designer||Yes|
9692

97-
### Query editor
93+
### Query Editor
9894

9995
|Feature|Azure Data Studio|SSMS|
10096
|:---|:---|:---|
10197
|Chart Viewer|Yes||
10298
|Export Results to CSV, JSON, XLSX|Yes||
99+
|Results to File||Yes|
100+
|Results to Text||Yes|
103101
|IntelliSense|Yes|Yes|
104102
|Snippets|Yes|Yes|
105103
|Show Plan|Preview|Yes|
106104
|Client Statistics||Yes|
107105
|Live Query Stats||Yes|
108106
|Query Options||Yes|
109-
|Results to File||Yes|
110-
|Results to Text||Yes|
111107
|Spatial Viewer||Yes|
112-
|SQLCMD||Yes|
113-
|Notebooks|Yes||
114-
|Save Query as snippet|Yes||
108+
|SQLCMD|Yes|Yes|
115109

116-
### Operating system support
110+
### Operating System Support
117111

118112
|Feature|Azure Data Studio|SSMS|
119113
|:---|:---|:---|
120-
|Linux|Yes||
121-
|macOS|Yes||
122114
|Windows|Yes|Yes|
115+
|macOS|Yes||
116+
|Linux|Yes||
123117

124-
### Data engineering
118+
### Data Engineering
125119

126120
|Feature|Azure Data Studio|SSMS|
127121
|:---|:---|:---|
128-
|Create External Table Wizard|Yes||
129-
|HDFS Integration|Yes||
130-
|Notebooks|Yes||
122+
|External Data Wizard|Preview||
123+
|HDFS Integration|Preview||
124+
|Notebooks|Preview||
131125

132-
### Database administration
126+
### Database Administration
133127

134128
|Feature|Azure Data Studio|SSMS|
135129
|:---|:---|:---|
136130
|Backup / Restore|Yes|Yes|
137-
|Big Data Cluster Support|Yes||
138-
|Flat File Import|Preview|Yes|
131+
|Flat File Import|Yes|Yes|
139132
|SQL Agent|Preview|Yes|
140133
|SQL Profiler|Preview|Yes|
141134
|Always On||Yes|
142135
|Always Encrypted||Yes|
143136
|Copy Data Wizard||Yes|
144-
|Database Engine Tuning Advisor||Yes|
137+
|Data Tuning Advisor||Yes|
138+
|Database Diagrams||Yes|
145139
|Error Log Viewer||Yes|
146140
|Maintenance Plans||Yes|
147141
|Multi-Server Query||Yes|
148-
|Policy-Based Management||Yes|
142+
|Policy Based Management||Yes|
149143
|PolyBase||Yes|
150144
|Query Store||Yes|
151145
|Registered Servers||Yes|
152146
|Replication||Yes|
153147
|Security Management||Yes|
154148
|Service Broker||Yes|
149+
|SQL Assessment|Preview|Yes|
155150
|SQL Mail||Yes|
156151
|Template Explorer||Yes|
157152
|Vulnerability Assessment||Yes|
158153
|XEvent Management||Yes|
159-
|SQL Assessment API Integration||Yes|
154+
155+
### Database Development
156+
|Feature|Azure Data Studio|SSMS|
157+
|:---|:---|:---|
158+
|Import\Export DACPAC|Yes|Yes|
159+
|SQL Projects|Preview||
160+
|Schema Compare|Yes||
160161

161162
## Next steps
162163

0 commit comments

Comments
 (0)