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.
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.
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.
The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.
Which RAID should you use with SQL Server? Learn the differences between RAID 0, RAID 1, RAID 5, and RAID 10, along with best practices.
Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.