Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Cloud
    • Cloud
    • Database
    • Development

    SQL Server Management Studio 180 Review for 2021

    By
    Todd R. Weiss
    -
    April 29, 2019
    Share
    Facebook
    Twitter
    Linkedin
      SQL Server

      Microsoft SQL Server Management Studio 18, which can be used to manage any SQL infrastructure, has been released and is now generally available to users with a long list of updates and improvements.

      The latest version of SQL Server Management Studio (SSMS) was unveiled by Dinakar Nethi, senior program manager for Azure Data, in an April 24 post on the SQL Server Blog.

      “When I joined the SQL Tools team as a PM [program manager] back in October 2018, my top priority was to release SQL Server Management Studio (SSMS) 18,” he wrote. “I expected a fair amount of work but didn’t realize how complicated the process would be. Six months later, having passed several internal checks such as accessibility, privacy, security, compliance, etc. among many others, and after 5 previews, I am very excited to share that SSMS 18 is now generally available.”

      Ultimately, the delays were necessary, he wrote, because the team wanted to ship a product that was better than the version it was replacing.

      SMSS is an integrated environment for managing any SQL infrastructure. It can be used to access, configure, manage, administer and develop all components of SQL Server, Azure SQL Database and SQL Data Warehouse using a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.

      Improvements Include Smaller Download Size

      Among the improvements in SSMS 18 are a smaller download size that’s about half that of the SSMS download that preceded it, an updated Visual Studio 2017 isolated shell that unlocks all the available accessibility fixes as well as the latest security fixes that went into Visual Studio, and the new ability to install SMSS in a custom folder. That capability has been a long standing request from users and can now be accomplished in any folder from both command line and the setup UI, wrote Nethi.

      Other new capabilities include the ability to install SMSS 18 in a language other than the language of the machine’s operating system. That means that users can now, for example, install SSMS German on a French Windows using the Tools | Options | International Settings menu.

      In addition, the new SSMS 18 ships with the MS Object Linking and Embedding Database (OLEDB) driver and is the first release of SSMS that will be fully aware of SQL Server 2019 (compatibility level 150).

      Improved Azure SQL Database support is also included, as well as SLO/Edition/MaxSize database properties now gaining support for custom names, making it easier to support future editions of Azure SQL Databases, wrote Nethi.

      SSMS/Azure Data Studio integration has arrived in the latest version, providing an integrated tool that can be launched from either application.

      Other new features include the ability to launch Azure Data Studio from Tools or Object Explorer, along with a series of general updates such as a new firewall rule dialog that allows users to specify a rule name instead of automatically generating one on behalf of the user, according to Nethi.

      More information on the latest features in SSMS 18 can be found in the release notes for the application, he wrote.

      SSMS 18 can be downloaded immediately from Microsoft.

      Todd R. Weiss
      As a technology journalist covering enterprise IT for more than 15 years, I joined eWEEK.com in September 2014 as the site's senior writer covering all things mobile. I write about smartphones, tablets, laptops, assorted mobile gadgets and services,mobile carriers and much more. I formerly was a staff writer for Computerworld.com from 2000 to 2008 and previously wrote for daily newspapers in eastern Pennsylvania. I'm an avid traveler, motorcyclist, technology lover, cook, reader, tinkerer and mechanic. I drove a yellow taxicab in college and collect toy taxis and taxi business cards from around the world.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×