SQL Server Management Studio Version 17.2 Now Available

By | In Blog, SQL Server | December 21st, 2017

Microsoft has released an update to Management Studio, bringing it up to Version 17.2. The latest fixes and new features give you better control over SQL Server. Take a look at all of the changes and get ready to upgrade Management Studio to gain access to them.

Always Encrypted Fixes

The Always Encrypted feature that comes with SQL Server 2016 got plenty of tweaks and fixes to make it even more useful. Some of the problems that Microsoft fixed with Management Studio Version 17.2 include working with multiple schemas on an existing database, adding Always Encrypted on a table, using the Encrypted Column wizard on databases with system views, and refreshing modules once you configure encryption.

These quality of life fixes help you get more out of the Always Encrypted feature available in this version of SQL Server.

Import Flat File to SQL Wizard

Do you want an easy way to import your flat files into your SQL databases? Now you have a streamlined wizard that works with your CSV and TXT files. With its intelligent framework, called Program Synthesis using Examples, you spend less time trying to get your records to import the way you want them to. Some of the elements that it automatically understands include delimiters, column names, the types of data that you’re importing and other important characteristics.

XEvent Profiler

You can access this new node through Object Explorer. Its main purpose is to give you a live viewer panel, allowing you to get more information on events occurring in SQL Server.

This real-time view lets your database administrators watch diagnostic events as they happen. They can use this information to proactively address performance issues or troubleshoot errors that bring down your databases.

XEvent Profile has deep integration with SQL Server Management Studio, allowing you to leverage the scalability of this platform. You can replace third-party event viewers if you’ve been relying on those.

SMO Support

Another welcome addition to Management Studio is Server Management Objects support. This feature brings a great deal of flexibility to the table. You primarily use it to develop any custom management applications you need for your daily operations. While SQL Server Management Studio is powerful on its own, you will run into scenarios that it doesn’t cover out of the box.

That’s where SMO support steps in. Your database administrators can create exactly what they need to make their jobs easier. Repetitive maintenance tasks get automated, and admins can easily put together new apps based on your organization’s changing needs.

This feature also helps you bring third-party applications into your infrastructure. The ease of integration empowers your company to use best-in-class software, rather than sticking with solutions that fall within strict compatibility parameters.

SQL Server Management Studio Version 17.2 brings a bevy of powerful tools to the table. If you don’t already have a SQL Server version that supports this update, it’s time to schedule an upgrade.

These features offer potent advantages for any organization. If all of your competitors run the latest versions and you’re still holding off on a migration, you end up falling behind competitively or spending more resources to maintain the status quo.

Don’t let that happen to your organization. Contact Datavail today to discover your upgrade options and ensure a smooth and stress-free migration.

Contact Us
Eric Russo
Senior Vice President of Database Services
Eric Russo is SVP of Database Services overseeing all of Datavail’s database practices including project and managed services for MS SQL, Oracle, Oracle EBS, MySQL, MongoDB, SharePoint and DB2. He is also the Product Owner for Datavail Delta, a database monitoring tool. He has 21 years’ experience in technology including 16 years in database management. His management success and style has attracted top DBAs from around the world to create one of the most talented and largest SQL Server teams. He has been with Datavail since 2008: previous to that his work experiences include DBA Manager at StrataVia, Senior Web Developer at Manifest Information Systems and SQL Server DBA at Clark County, Nevada.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).