SQL Data Warehouse, SQL Stretch Database and App Service Hits GA in Azure Government

Azure Managed Cache and In-Role Cache Service shutdown reminder. AzureAD PowerShell v2.0 is now in public preview! Azure App Service generally available in Azure Government.

Share online:

With the arrival of SQL Database v12, the Azure SQL Data Warehouse and Azure SQL Stretch Database in Microsoft Azure Government are generall available announced on October 13.

"Azure SQL Data Warehouse, is cloud-based and is built on massively parallel processing (MPP) architecture, SQL Data Warehouse allows you to manage your data quickly and flexibly."

Benefits of SQL Data Warehouse include: "Scalability through a massively parallel processing (MPP) architecture, Automatic backups and rapid resizing abilities, and Built-in auditing and threat detection."

"SQL Server Stretch Database part of SQL Server 2016 selectively, securely and transparently migrate on-premise cold or historical data, to Azure," explains azure team. This allow you to free up disk space and reduce enterprise storage costs, "without impacting existing business operations and applications."

Benefits include of Stretch Database include: "Cost effective online cold data, Reduced local storage and maintenance costs, Entire table always online and accessible, No application changes, and Supports Always Encrypted and Row-Level Security," team said.

Another general availability announced on Thursday, is of Azure App Service on Azure Government.

App Service is a cloud platform which enables developers to build, deploy and run powerful web apps, mobile back-ends and API apps that connect to data anywhere in the cloud. It is an integrated solution which streamlines development and provides powerful DevOps capabilities while meeting your needs for security, reliability, and scalability.

Here's what Azure App Service providing developers with:

With "Web and API Apps" you can host any website, web app, or API app in the cloud. It offer a wide array of Web development frameworks including .NET, NodeJS, PHP, Python, and Java. Additionally, it provides source code control integration with Visual Studio Team Services, GitHub, and more.

While, "Mobile Apps" provide a full set of client and server SDKs for building engaging mobile apps on Windows, iOS, and Android. You can easily integrate with popular identity providers, add secure corporate sign-on to your mobile apps, and create robust mobile apps with offline data synchronization.

Lastly, the team notes that following features will be fully enabled in Azure Government as well include: "Deployment options (continuous integration), MySQL in-app, App Service editor, and VNET integration."

Azure AD PowerShell v2.0 is now in public preview of new V2 version of Azure Active Directory PowerShell cmdlets.

"PowerShell is an important tool in the toolkit of nearly every IT professional who manages Azure Active Directory."

Further, the team said, that in futture all new capabilities will be provided through the new AzureAD PowerShell Module. And you will see continual updates. Additionally, they are working to make "all functionality of the old MSOL module available in the new module." When complete, "you will be able to rely completely on the new AzureAD module for all of your needs," added azure team.

Probably the most notable functionality in the new PowerShell cmdlets is "Modern Authentication and MFA." It also includes "new management capabilities for Applications and Certificate Authority through PowerShell."

For a full list of all available cmdlets and how to use them, check out AzureAD PowerShell reference documentation.

The latest release of Azure Mobile Apps iOS client SDK 3.2.0 with added Refresh Token feature, updated with iOS 10/Swift 3.0 support, and made performance improvement.

Updates in this release include:

  • "We extended support for Refresh Token for all of our iOS customers. This feature was previously only captured in our Managed SDK 2.1.0 and later versions to enable a smoother development experience around identity provider token expiry. For more information on this feature, see the Refreshing User Logins in App Service Mobile Apps blog post.
  • We added support for the latest iOS environments, including iOS 10 and Swift 3.0. It also works with Xcode 8.0.
  • We optimized network performance by reusing NSURLSession objects. This is particularly apparent in long-running async operations like data pulls. (Shout out to Damien Pontifex for his continuous support in helping to improve our iOS SDK through open source contributions)," writes azure team.

The latest Mobile Apps iOS Quickstart is also available and compatible with this release of the iOS SDK.

Microsoft is also reminding us of December 2015 annoucement of retiring "Azure Managed Cache service" and "Azure In-Role Cache" support by November 30, 2016.

Today, the team suggest that all currently active users of these services to move off them as early as possible, before the deadline. To this end, they recommending to consider 'Redis Cache' as a replacement for the caching needs. It offers more features and options.

Also, an updated migrate from Managed Cache Service to Azure Redis Cache documentation webpage is live to facilitate your migration efforts.

If you are not aware, "Azure Redis Cache, based on the popular open-source implementation, is a fully-managed and high-performance caching solution that supersedes the Managed Cache and In-Role Cache services."

Images for SQL Server 2016 on Windows Server 2016 Data Center now in the Azure Marketplace. All automated Portal experiences (storage configuration, optimization for a targeted workload, automated patching) work with these images.

With SQL Server 2016 images, "you can now take advantage of a Bring-Your-Own-License (BYOL) if you already have an agreement." That way you can get migrated to Windows Server 2016 without hassle.

However, SQL Server RTM Express might not show up in the search results, But a fix is making its way soon.

Here are the versions available:

  • SQL Developer – Free full edition of SQL Server for development/testing (no production)
  • SQL Express – Entry level free database for lightweight workloads (1 GB memory, 10 GB storage)
  • SQL Web – Low-cost database for low to medium-size web applications
  • SQL Standard – Core Database capabilities for medium-size workloads
  • SQL Enterprise – Full edition of SQL Server with comprehensive capabilities for mission-critical or large transactional processing, data warehousing, and business intelligence workloads, writes azure team.

To get started, visit Azure Marketplace.

SQL Sever 2016

Windows Server 2016

Beta 3 adds support for the following Azure Management Libraries for Java: "Virtual machine scale sets, Load balancers, Parallel creation of virtual machines and other resources, Virtual machine extensions, Key vault and Batch."

You can acces at GitHub.

SQL Server 2016 Express Edition in Windows Containers reached public availability on 10/13.

With this public availability, the "image is now available on Docker Hub," while the "build scripts are hosted on SQL Server Samples GitHub repository," writes SQL server team.

SQL Server 2016 in a Windows container benefits include: "Quickly create and start a set of SQL Server instances for development or testing, Maximize density in test or production environments, especially in microservice architectures, and Isolate and control applications in a multi-tenant infrastructure," team explained.

This image can be used in both Windows Server Containers as well as Hyper-V Containers. Youn can get SQL Server 2016 Express Edition Docker Image here, Installation Scripts here.