SQL Server v.Next EAP/CTP 1.2, New Power BI Content Pack for Azure Active Directory!

SQL Server Early Adoption Program help customers and partners to adopt next version of SQL Server before GA. Windows Management Framework 5.1, Power BI Content Pack for Azure AD! released.

Share online:

SQL Server v.Next Early Adoption Program, aimed at users want to adopt the next version of the relational database management system before general availability on Windows or Linux in production, or use it to build system integrator offerings and independent software vendor applications was announced Friday.

The SQL Server Early Adoption Program (SQL EAP) started in January 2017, is also for partners who want to build SI (system integrator) offerings and ISV (independent software vendor) applications using SQL Server v.Next. "Upon successful validation, these apps and solutions can be supported in production prior to GA."

"Customers and partners who would like to validate new features such as Adaptive Query Processing and High Availability (HA) on Linux are an especially good fit for SQL EAP," added Microsoft.

Benefits of the SQL EAP include:

  • direct access to engineering team via Program Manager Buddy to help your solution adopt the v.Next.
  • SQL EAP participants can bring your workload to SQL Customer Advisory Team Customer Lab for direct testing.
  • SQL EAP customers will be able to try out new features sometimes before public gets to see them.
  • access to a private Yammer group for SQL EAP customers to communicate with engineering team and each other.
  • special support channel help to raise cases for SQL Server v.Next. Customers going into production will be fully supported by Microsoft Support before general availability.

Requirements for SQL EAP:

  • Enroll via this form for evaluation, a PM Buddy aligned to access workload validation and those on track for production deployments.
  • An NDA with Microsoft will be required for participation.
  • SQL EAP customers going in production will need to sign a EULA for permission to use the software in production.

To get started with the SQL Server v.Next CTP 1.2, check out this developer tutorials that show you how to install and use SQL Server v.Next on macOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice.

Here're some useful links:

New Power BI content pack for Azure Active Directory, announced on Friday, this integration of Azure Active Directory application programming interfaces, or APIs, with Power BI lets users download pre-built content packs and dig deeper into all the activities within Azure Active Directory.

The rich visualization experience offered by Power BI enhances the data, and what's more, "you can create own dashboard and share it easily with anyone in the organization." To connect to Azure AD Content Pack (from the team post):

  1. Log into Power BI with your account (same account as your O365 or Azure AD Account)
  2. Select Get Data at the bottom of left navigation pane.
  3. Then select Get in the Services box.
  4. Select Azure Active Directory Activity Logs -> Get.
  5. When prompted, enter your Azure AD Tenant Name
  6. For Authentication Method, select Basic -> Sign In. Enter the Username and Password to complete your sign-in process.
Power BI Content Pack for Azure Active Directory!

Power BI Content Pack for Azure Active Directory!

Windows Management Framework (WMF) 5.1 released to the Microsoft download center, upgrades Windows 7, Windows 8.1, Windows Server 2008 R2, Windows Server 2012, and Windows Server 2012 R2 to the PowerShell, WMI, WinRM and SIL components that were released with Windows Server 2016 and Windows 10 Anniversary Edition.

You can find out more about the WMF 5.1 release in the Release Notes, or download here.

For Windows 7 and Windows Server 2008 R2 the installation instructions have changed significantly. "We have removed the requirement for pre-installing WMF 4 on Windows 7 and Windows Server 2008 R2, but to do so we had create a script for checking the prerequisites that accompanies the MSU in a ZIP file. This affects only Windows 7 and Windows Server 2008 R2. The Install and Configure topic in the release notes provides details on using the script," writes the team.

Update 1701 for Technical Preview Branch of System Center Configuration Manager, released today, brigs the following new preview features include:

  • UEFI inventory data – Hardware inventory can now determine whether the device is UEFI-enabled.
  • Express files support for Windows 10 Cumulative Update, only supported in version 1607 with a Windows Update Agent update included with updates released on Jan 10, 2017 (Patch Tuesday).
  • Validate Device Health Attestation Data via Management Point reporting data for cloud or on-premises health attestation service.
  • Updated Content Library Cleanup Tool (ContentLibraryCleanup.exe) used to remove content that's no longer associated with any package or application from a distribution point (orphaned content) has been updated with fixes for known issues.
  • Host software updates on cloud-based distribution points.
  • Support for Microsoft Azure Government cloud added to Operations Management Suite (OMS) Connector feature.
  • Clients now find software update points using Boundary Group associations.

Also, following imrovements to operating system deployment are included:

  • Support for more applications for the Install Applications task sequence step
  • Expire standalone media
  • Support for additional content in stand-alone media
  • Configurable timeout for Auto Apply Driver task sequence step
  • Package ID is now displayed in task sequence steps
  • Windows 10 ADK tracked by build version
  • Default boot image source path can no longer be changed

VSTest, an extensible unit test execution framework is open sourced today. It has extensibility for different test frameworks, code coverage, test impact analysis, data collection, test result reporting and much more.

It can parallelize across cores, provides process isolation and can integrate with Visual Studio. Tests generally use some test framework and vstest supports many. Many of the test adapters are open source or available as NuGet packages. You can checkout the VS marketplace for a sampling of them.

VS Test platform open sourced