Two New Features in SQL Server Management Studio

Microsoft has updated its SQL Server Management Studio to version 17.3, adding two features along with various minor enhancements and bug fixes.

SSMS 17.3, made available for download earlier this month, adds an Import Flat File Wizard and an XEvent Profiler.

The Import Flat File Wizard streamlines the process of importing a flat file into a SQL table, which was previously done with the Import Data wizard, which provided a lot more functionality than is needed for a simple flat file import.

"There is a need for a tool or technology that simplifies the import experience by reducing the amount of user configuration required to properly import complex flat file structures," Microsoft said in a blog post.

The Import Flat File Wizard
[Click on image for larger view.] The Import Flat File Wizard (source: Microsoft).

That technology is actually being provided by the Microsoft Program Synthesis using Examples (PROSE) SDK. It examines raw semi-structured data in order to find patterns to facilitate predictive file splitting, in effect inferring the appropriate column names, types, delimiters and so on.

So, instead of going through the configuration and settings associated with the Import Data Wizard, developers need only identify the input file and assign it a new name to import it. The exact steps for doing that are provided in a tutorial.

The other new feature, XEvent Profiler, can display a live target view of Extended Events, the general event-handling system for server systems. Extended Events supports the correlation of data from SQL Server, and sometimes correlation of data from the OS and database applications.

The XEvent Profiler
[Click on image for larger view.] The XEvent Profiler (source: Microsoft).

"In SSMS, the existing extended events functionality already provides a flexible definition of sessions and views, but lacks the 'quick view' capability of SQL Profiler," Microsoft explained. "XEvent Profiler generates that view just as fast as SQL Profiler, while also allowing for view customization that can be shared with other SSMS users as a *.viewsettings file."

There's a tutorial for that, too.

Other enhancements to SSMS 17.3 include:

  • Updated waits filtering and categorization in Performance Dashboard historical waits report.
  • Added the syntax check of the "Predict" function.
  • Added the syntax check of the External Library Management queries.
  • Added SMO support for External Library Management.
  • Added "Start PowerShell" support to "Registered Servers" window (requires a new SQL PowerShell module).
  • Always On: added read-only routing support for availability groups.
  • Added an option to send tracing details to the Output Window for "Active Directory - Universal with MFA support" logins (off by default; needs to be turned on in user settings under "Tools > Options > Azure Services > Azure Cloud > ADAL Output Window Trace Level").
  • Query Store:
    • Query Store UI will be accessible even when QDS is OFF as long as QDS have recorded any data.
    • Query Store UI now exposes waits categorization in all the existing reports. This will let customers unlock the scenarios of Top Waiting Queries and many more.
  • Made inclusion of the scripting parameters headers optional (off by default; can be enabled in user settings under "Tools > Options > SQL Server Object Explorer > Scripting > Include scripting parameters header") - Connect item 3139199.
  • Removed "RC" branding.

Details on these changes and much more information is provided in the release notes.

About the Author

David Ramel is an editor and writer for Converge360.

comments powered by Disqus


  • What's Next for ASP.NET Core and Blazor

    Since its inception as an intriguing experiment in leveraging WebAssembly to enable dynamic web development with C#, Blazor has evolved into a mature, fully featured framework. Integral to the ASP.NET Core ecosystem, Blazor offers developers a unique combination of server-side rendering and rich client-side interactivity.

  • Nearest Centroid Classification for Numeric Data Using C#

    Here's a complete end-to-end demo of what Dr. James McCaffrey of Microsoft Research says is arguably the simplest possible classification technique.

  • .NET MAUI in VS Code Goes GA

    Visual Studio Code's .NET MAUI workload, which evolves the former Xamarin.Forms mobile-centric framework by adding support for creating desktop applications, has reached general availability.

  • Visual Studio Devs Quick to Sound Off on Automatic Updates: 'Please No'

    A five-year-old Visual Studio feature request for automatic IDE updates is finally getting enacted by Microsoft amid a lot of initial developer pushback, seemingly misplaced.

  • First Official OpenAI Library for .NET Goes Beta

    Although it seems Microsoft and OpenAI have been deeply intertwined partners for a long time, they are only now getting around to releasing an official OpenAI library for .NET developers, joining existing community libraries.

Subscribe on YouTube