SQL Server Data Tools 17.0 RC 2 Arrives with New Query Editor Menu Bar

SQL Server Data Tools 17.0 Release Candidate 2 with most noteworthy addition, a menu bar to the Query Editor is released.

Share online:

SQL Server Data Tools 17.0 Release Candidate 2 (RC 2) just been published and it includes several important fixes particularly with the modern Get Data experience.

If you're evaluating new enhancements in Analysis Services Tabular 1400 models, be sure to download and install this latest version HERE.

The most noteworthy feature of this release is a new menu bar in Query Editor, (as shown in the screenshot below), "it provide quick and easy access to functions that Excel and Power BI Desktop provide through Query Editor ribbon," says the team.

Query Editor menu bar in SQL Server Data Tools 17 RC 2

Query Editor menu bar in SQL Server Data Tools 17 RC 2

While Query Editor menu bar isn't a ribbon, it's still very useful user interface element and provide menu arranges commands that act on a query in a clear and logical order like "Rows menu" that help you to remove rows or keep a range of rows. Moreover, following keyboard shortcuts are available too:

  • Keep top 10 rows in a table by pressing Alt+R, then K, and enter 10 in Keep Top Rows dialog box, then press Enter.
  • Remove a selected column by pressing Alt+C, then R.
  • Display Advanced Editor with Alt+ V, E.
  • Simply press Alt key to discover all the available shortcut combinations.

Additionally, using Alt+T, M, T, and then P, sequence you can parse the time values in a column, and is very handy if you find yourself performing a specific action very frequently.

The team further notes, that next on they'll first be "implementing support for shared queries, functions, and parameters," and then "enable as many data sources as possible for close parity with Power BI Desktop."

You can download SQL Server Data tools 17 RC 2 over HERE.

TFS 2017 Process Template Editor, an extension to Visual Studio 2017 is now available in marketplace.

Lastly, GVFS (Git Virtual File System) introduced today, virtualizes file system beneath a Git repo and makes it appear as though all the files in the repo are present, but in reality only downloads a file the first time it is opened.

"GVFS also actively manages how much of the repo Git has to consider in operations like checkout and status, since any file that has not been hydrated can be safely ignored. And because we do this all at the file system level, your IDEs and build tools don't need to change at all," explained the team.

GVFS is available Git, and because, GVFS relies on a protocol extension that any service can implement, the protocol can be downloaded over here. In addition to GVFS sources, "Git now work well on a GVFS-backed repo, and those sources are available here.

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he’s engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.