The latest generally-available (GA) quality release of SQL Server Management Studio (SSMS) 16.4, with new PowerShell cmdlets to help perform SQL Server login management and read/write data is released.
This SSDT 16.4 update adds support for “Schema Compare” in SqlPackage.exe and the Data-Tier Application Framework (DacFx) API. “The files can now be created, loaded, compared, and otherwise used now by the Data-Tier Application Framework API,” writes SQL Server team.
Another new feature is the addition of the analysis service “Integrated Workspace Mode” for SSDT Tabular—”making it possible to create and organize data internally.” Even, it’s now easier to switch tabular projects on explicit work space servers over to the new feature “so that you can continue your task without much hassle.”
“In integrated workspace mode, SSDT Tabular dynamically starts its internal SSAS instance in the background and loads the database so that you can add and view tables, columns, and data in the model designer, and if you add additional tables, columns, relationships, and so forth, you are automatically modifying the workspace database, as well,” explains team.
“Integrated workspace mode does not change how SSDT Tabular works with a workspace server and database. What changes is where SSDT Tabular hosts the workspace database.”
In additon, SQL Server 2016 Report Builder update is now available and includes items that are reported to the team via Microsoft Connect.
One of the items included is the ability to take advantage of the Windows “snap” functionality with Report Builder now fully supports this feature.
Also, some other items related to creating and editing shared datasets are also addressed in this release. For example, “default parameter values not persisting properly with a shared dataset saved to the report server,” writes team.
Additionally, Microsoft System Center Operations Manager, along with the Service Manager management packs, provides an excellent monitoring platform for Service Manager.
Many important pieces that are vital to Service Manager health can be monitored, including:
- Checking SQL Server to be sure the Broker Service is enabled
- Checking the Service Manager Grooming History to be sure cleanup of the CMDB is taking place
- Checking workflows for problems
- Checking MPS sync for failures