SE の雑記

SQL Server の情報をメインに Microsoft 製品の勉強内容を日々投稿

Ignite 2018 の SQL Database の Update

leave a comment

SQL Server 2019 だけでなく、Azure の SQL Server ベースについても様々なアナウンスがありました。

Azure SQL Database | SQL DB Managed Instance general purpose – GA

Effective October 1, 2018, Azure SQL Database Managed Instance general purpose will become generally available. Managed Instance provides the best of SQL Server with the benefits of a fully managed service, allowing you to migrate your on-premises workloads to the cloud with minimal changes. The general-purpose performance tier provides balanced and scalable compute and storage options that fit most business workloads. Create a Managed Instance today and use your SQL Server licenses and active Software Assurance to save up to 55 percent with Azure Hybrid Benefit for SQL Server.

Managed Instance の汎用目的が 2018/10/1 より GA となっています。

Azure SQL Data Warehouse | SQL Vulnerability Assessment

SQL Vulnerability Assessment is an easy-to-use service that you can use to continually monitor your database or data warehouse, ensuring those are maintained at a high level of security at all times and that your organizational policies are met. It provides a comprehensive security report along with actionable remediation steps for each issue found, making it easy to proactively manage your database security stature even if you are not a security expert. Learn more at Azure.com/sqldw

SQL Datawarehouse で脆弱性評価の機能を使うことができるようになりました。

Azure SQL Data Warehouse | Smaller SKU for Compute Optimized Gen2 Tier

SQL DW Compute Optimized Gen2 tier’s performance improvements become more accessible with a smaller SKU; DW500c. The industry-leading query performance of the Compute Optimized Gen2 tier of SQL DW is now accessible to more customers through a new smaller SKU, 500DWc. With this release, customers can get started with a powerful data warehouse in the cloud for as low as $7.56/hour (in the US East region, price varies by region). This new SKU will be generally available on September 5 across 22 Azure global regions. Find out more at Azure.com/sqldw

DW500c という小さいサイズが Gen2 で使えるようになりました。
9/1 から一般提供開始されていたようですが、時間単価が 700 円程度なので検証しやすそうです。

Azure SQL Data Warehouse | Flexible restore points

SQL Data Warehouse is a fast, flexible and secure analytics platform. It now provides user defined restore points enabling you to initiate snapshots before and after significant operations on your data warehouse. This capability enables customers to generate much more granular restore points to ensure that each restore point is logically consistent limiting the impact and reducing the recovery time of restoring the data warehouse should this be needed. User-defined restore points can also be labeled so they are easy to identify and are seamlessly created in the Azure portal

データベースのリストアを柔軟に実行できるようになりました。
ユーザー定義復元ポイントとしてラベル付けもできるようですね。

 

Azure SQL Data Warehouse | Intelligent insights

SQL Data Warehouse intelligent Insights for performance improvement

SQL Data warehouse now provides built-in intelligence delivering recommendations to help ensure your data warehouse is consistently optimized for performance. The service analyzes the current state of your data warehouse, collects telemetry, and surfaces recommendations for your active workload on a daily cadence. These intelligent insights come at no additional cost, are tightly integrated with Azure Advisor, and are automatically available through the Azure portal.

SQL Data Warehouse に Intelligent Insights が追加されました。
クエリ周りのパフォーマンス改善に役立ちそうですね。

Azure SQL Data Warehouse | User defined maintenance scheduling

Azure SQL Data Warehouse Maintenance Scheduling is now Public Preview, a new feature that seamlessly integrates the Azure Service Health Planned Maintenance Notifications with Resource Health Monitor Services. Maintenance scheduling allows customers to plan around the scheduled maintenance events the Azure SQL Data warehouse service uses to roll out new features, upgrades and patches. Find out more at Azure.com/sqldw

SQL Data Warehouse にユーザー定義のメンテナンススケジュールを指定できるようになりました。
これで、プラットフォームとして SQL DW のメンテナンスが必要になった時の実行タイミングをユーザー側である程度制御できるようになりますね。
SQL Data Warehouse では、ETL でロングランのバッチを流すことがありかもしれませんのでこれは結構うれしいですね。

Azure SQL Database | Hyperscale – Public Preview

Azure SQL Database Hyperscale is a new, highly scalable service tier that adapts on-demand to your workload’s needs, quickly auto-scaling up to 100TB per database, eliminating the need to pre-provision storage resources and significantly expanding the potential for app growth without being limited by storage size. This new service tier also provides the ability to scale compute and storage resources independently, giving you the flexibility to optimize performance for your workloads. Azure SQL Database Hyperscale will initially be available for single database deployments.

個人的には、これが一番興味のある内容です。
新しいアーキテクチャの SQL Database がリリースされます。
Public Preview は、 10/1 となるようなので少し先ですが、コンピュート / データストレージ / ログストレージが独立し、個別にスケールするような新しいアーキテクチャの SQL Database がリリースされます。

詳細については、次を確認。

Azure SQL Database | Intelligent QP updates – public preview

The Intelligent query processing feature family improves the performance of existing workloads with minimal implementation effort. This feature family includes three new preview offerings, including row mode memory grant feedback, approximate query processing, and table variable deferred compilation. Row mode memory grant feedback optimizes memory usage for repeating workloads. Table variable deferred compilation improves plan quality and overall performance for queries referencing table variables, and approximate query processing is designed to provide aggregations across large data sets where responsiveness is more critical than absolute precision.

Adaptive Query Processing を発展させた Intelligent QP が Public Preview ですね。
これは、以前発表されたものの再掲ですな。

Azure Database Migration Service: SQL to Azure SQL Database offline migration support

Now generally available, the Azure Database Migration Service provides you the ability to assess SQL Server workloads running on-premises or on VMs, and to perform offline migrations to Azure SQL Database Managed Instance. Visit the Migrate to Azure SQL Database Managed Instance offline using DMS tutorial webpage for more information.

DMS のオフラインマイグレーションの GA も再掲ですね。

Azure Database Migration Service: Support for SQL to Azure SQL DB Managed Instance online migrations

You can now migrate SQL Server databases to Azure SQL Database Managed Instance with minimal downtime by using preview functionality in the Azure Database Migration Service. Use the Azure portal to create an instance of Azure DMS as a first step in perform migrations from SQL Server on-premises or on virtual machines to Azure SQL Database Managed Instance.

DMS のオンラインマイグレーションも再掲と。

Microsoft R Server is now Microsoft Machine Learning Server

Machine Learning Server (previously known as Microsoft R Server) is a flexible enterprise platform for analyzing data at scale, building intelligent apps, and discovering valuable insights across a business now with full support for Python and R. Transform your business with scalable, enterprise-grade R and Python-based data analytics using your data and existing investments.

なぜこのタイミングで感がありますが、R Server は ML Server になりましたという、SQL Server 2017 のタイミングのお話が。

 

Data Migration Assistant | GA

Data Migration Assistant (DMA): Support for Azure SQL DB Managed Instance now in preview

Now in preview, Data Migration Assistant (DMA) provides support to help you to migrate on-premises SQL Server databases to Azure SQL Database Managed Instance. DMA detects compatibility and feature parity issues that can impact database functionality in target Azure SQL Database Managed Instance databases. More details: https://www.microsoft.com/en-us/download/details.aspx?id=53595

データベースの移行に使える DMA が GA し、Managed Instance は Preview として対応しましたと。

Azure Data Studio | GA

Today we’re pleased to announce Azure Data Studio, a new open source, cross-platform desktop environment for data professionals using the Azure Data family of on-premises and cloud data platforms on Windows, MacOS, and Linux.

Previously released under the name of SQL Operations Studio, Azure Data Studio offers a modern editor experience for managing data across multiple sources with fast intellisense, code snippets, source control integration, and an integrated terminal. Azure Data Studio is engineered with the data platform user in mind, with built-in charting of query result-sets and customizable dashboards.

Azure Data Studio is complementary to SQL Server Management Studio with experiences around query editing and data development while SQL Server Management Studio still offers the broadest range of administrative functions and remains the flagship tool for platform management tasks.

Azure Data Studio will continue to be updated on a monthly bases and currently offers built-in support for SQL Server on-premises and Azure SQL Database, along with preview support for Azure SQL Managed Instance, Azure SQL Data Warehouse and SQL Server 2019 Big Data. Learn more:

Documentation

Product Page

SQL Operations Studio と呼ばれていたツールが Azure Data Studio となり GA しました。
SQL Server 2019 対応がいろいろと含まれています。

 

色々あって追いきれない…。

Written by masayuki.ozawa

9月 25th, 2018 at 12:40 am

Posted in SQL Database

Tagged with

Leave a Reply

*