HomeWinBuzzer NewsSQL Server Data Tools 16.4 Now Available, with New SDDT Workspace and...

SQL Server Data Tools 16.4 Now Available, with New SDDT Workspace and More

Microsoft has announced an update for SQL Server Data Tools which pushes the version up to 16.4. It some prominent issues and adds support for Schema Compare in SqlPackage.exe.

-

The Data Tools team released version 16.4 on Tuesday, and it comes with a number of fixes and improvements.

Cheif among these is an integrated Workspace Mode for SDDT Tabular, as well as support from Schema Compare in SqlPackage.exe.

SQL Server Data Tools 16.4 Release Notes

Before we get into the full changelog for this build, it's worth going into more detail about the new Workspace Mode. SDDT Tabular now supports internal SASS instances and starts automatically if the mode is enabled.

This allows users to add data to the model designer without an external server instance. The feature appears in the Tabular Model Designer dialog when creating a new project.

The feature appears in the Tabular Model Designer dialog when creating a new project, where you can tick to enable.

In addition, a number of fixes came from Microsoft Connect:

  • “SSDT: temporal tables broken in VS Data Tools July update 14.0.60629.0, ‘Value cannot be null. Parameter name: reportedElement.'
  • IsPersistedNullable shows as different in SSDT Comparison.
  • Identity is reset when importing a BACPAC.
  • Running SSDT unit tests leaves temp files behind.
  • Backwards compatibility breakage – AppLocal and Nugetization.”

The team also addressed some issues with analysis and reporting services. The list is very long, so we've just highlighted some of the most important below:

  • “SDDT: Error tip pop ups were in the way when editing DAX for DirectQuery calculated columns.
  • Fixed an issue in the SSDT AS tabular projects where width of columns in the manage relationships dialog could not be resized.
  • Pasting large table data could make the tabular project unresponsive in SDDT AS.
  • SSDT AS: pasting full sheet rows from Excel was very slow and created many unwanted columns.
  • Fixed an issue in SSDT AS tabular model editor to mark the model as needing to save changes when renaming connection friendly name.”

These improvements should make SQL Data Tools more usable, well rounded and address some minor annoyances. You can see the full list on the project's team blog.

SourceMicrosoft
Ryan Maskell
Ryan Maskellhttps://ryanmaskell.co.uk
Ryan has had a passion for gaming and technology since early childhood. Fusing the skills from his Creative Writing and Publishing degree with profound technical knowledge, he enjoys covering news about Microsoft. As an avid writer, he is also working on his debut novel.

Recent News

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
Mastodon