SQL Server vNext CTP 1.1, Update 1612 for Configuration Manager Technical Preview Releases

Microsoft releases update 1612 for Configuration Manager Technical Preview Branch, and SQL Server next version Community Technology Preview 1.1.

Share online:

Update 1612 for the Technical Preview Branch of System Center Configuration Manager release today Dec 16, offering an opportunity to try out new before made generally available.

Also changes for customers using SCCM connected with Microsoft Intune to manage mobile devices released today, now let you "set up multi-factor authentication (MFA) for device enrollment in the Azure portal." The MFA option has been removed in the Configuration Manager console.

New features for desktop include:

  • Azure Active Directory onboarding – Creates a connection between Configuration Manager and Azure AD to be used by other cloud services, such as the Cloud Management Gateway.
  • Windows Hello for Business toast notification – A new Windows 10 toast notification added to let end users know that they need to take additional actions to complete Windows Hello for Business PIN setup.
  • Enhancement for online-licensed apps from the Windows Store for Business – You can now deploy online-licensed apps with a deployment purpose of "Available" to Windows 10 PCs managed with the Configuration Manager client.
  • Express files support for Windows 10 Cumulative Update – Configuration Manager can now support Windows 10 Cumulative Update using Express files.
  • Ability to block installation of an application if specified executables are running – You can now configure a list of executable files (with the extension .exe) in Deployment Type Properties which, if running, will block installation of an application. After installation is attempted, a user will see a dialog box asking them to close the processes that are blocking installation, and then try again.
  • Ability to retry task sequence – If a step doesn't work properly in the task sequence wizard, you can now click "Previous" to retry the process.
  • OData endpoint data access – Configuration Manager now provides a RESTful OData endpoint for accessing Configuration Manager data. The endpoint is compatible with OData version 4, which enables tools such as Excel and Power BI to easily access Configuration Manager data through a single endpoint. Update 1612 for the Technical Preview Branch supports read-only access to objects in Configuration Manager.
  • Data Warehouse for historical reporting – The Data Warehouse enhances reporting for Configuration Manager by storing long-term data for historic reporting. This enables you to look at compliance, application deployment, and more, with reports that show trends over a period of time.

For new installations. download and install the baseline version 1610 of Configuration Manager Technical Preview Branch available on TechNet Evaluation Center.

The next version of SQL Server (SQL Server v.Next) Community Technology Preview (CTP) 1.1 released to both Windows and Linux include enhancements to several database engine and Business Intelligence (BI) capabilities.

In addition, it also adds support for Red Hat 7.3 and Ubuntu 16.10 to SQL Server on Linux. Here is a changelog:

Key enhancements in SQL Server v.Next on Windows CTP 1.1 for Analysis Services tabular models include:

  • New infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This infrastructure enables:
    • Support for additional data sources, such as MySQL. Additional data sources are planned in upcoming CTPs.
    • Data transformation and data mashup capabilities.
  • Support for BI tools such as Microsoft Excel enable drill-down to detailed data from an aggregated report. For example, when end-users view total sales for a region and month, they can view the associated order details.
  • Support for ragged hierarchies in reports, such as organizational and account charts.
  • Enhanced security for tabular models, including the ability to set permissions to help secure individual tables.

Key SQL Server v.Next on Windows and Linux CTP 1.1 database engine enhancements include:

  • Language and performance enhancements to natively compiled T-SQL modules, including support for OPENJSON, FOR JSON, JSON built ins as well as memory-optimized tables support for computed columns.
  • Improved the performance of updates to non-clustered columnstore indexes in the case when the row is in the delta store.
  • Batch mode queries now support "memory grant feedback loops," which learn from memory used during query execution and adjusts on subsequent query executions; this can allow more queries to run on systems that are otherwise blocking on memory.
  • New T-SQL language features:
    • Introducing three new string functions: TRIM, CONCAT_WS, and TRANSLATE
    • BULK IMPORT supports CSV format and Azure Blob Storage as file source
    • STRING_AGG supports WITHIN GROUP (ORDER BY)s

For more information and download, visit the SQL Server v.Next webpage.

SQL Server vNext CTP 1.1 new 1400 Compatibility Level