: It facilitates communication via Shared Memory (local), TCP/IP (remote/internet), and Named Pipes (LAN) using the Tabular Data Stream (TDS) protocol. Major Feature Improvements in 17.x
: Integrated tools like Activity Monitor , Query Execution Plans , and the Query Store for identifying resource bottlenecks and slow queries.
Some of the other notable features in SSMS 2017 include:
| SQL Server Version | Supported? | Notes | |--------------------|------------|-------| | 2017 (Windows/Linux) | ✅ Full | All features work | | 2016 | ✅ Full | — | | 2014/2012 | ✅ Full | — | | 2008/2008 R2 | ✅ Partial | No Linux containers, no new execution plan features | | 2019 | ⚠️ Limited | Upgrade to SSMS 18.x recommended |
Overall, SSMS 2017 provides a comprehensive set of tools for managing and developing SQL Server databases.
SQL Server Management Studio (SSMS) 2017 offers several good features. Here are some of the notable ones:
SSMS 2017 operates as a workstation-side interface in a client-server architecture. Its primary components include:
Chat live
Monday to Saturday 9am - 6pm
Sunday Closed
Call us
United Kingdom Monday to Saturday 9am to 6pm Sunday Closed
Ireland Monday-Friday: 9am to 5pm sql server management studio 2017
United Kingdom 0333 733 4422
Ireland +353 (0)1 8424833
Calls from landlines cost up to 9p per minute, mobile tariffs may vary - please check with your provider : It facilitates communication via Shared Memory (local),
Partner disclaimer: Google, Google Play, YouTube, Android TV and other marks are trademarks of Google LLC. Google Assistant is not available in certain languages and countries.