Microsoft Data Amp event announcements
Yesterday was the Microsoft Data Amp event where a bunch of very exciting announcements were made:
- SQL Server vNext CTP 2.0 is now available and the product will be officially called SQL Server 2017:
- SQL Server R Services in SQL Server 2017 is renamed to Machine Learning Services since both R and Python will be supported. More info
- Three new features for Cognitive Services are now Generally Available (GA): Face API, Content Moderator, Computer Vision API. More info
- Microsoft R Server 9.1 released: Real time scoring and performance enhancements, Microsoft ML libraries for Linux, Hadoop/Spark and Teradata. More info
- Azure Analysis Services is now Generally Available (GA). More info
- Microsoft has incorporated the technology that sits behind the Cognitive Services inside U-SQL directly as functions. U-SQL is part of Azure Data Lake Analytics (ADLA)
- More Cortana Intelligence solution templates: Demand forecasting, Personalized offers, Quality assurance. More info
- A new database migration service will help you migrate existing on-premises SQL Server, Oracle, and MySQL databases to Azure SQL Database or SQL Server on Azure virtual machines. Sign up for limited preview
- A new Azure SQL Database offering, currently being called Azure SQL Managed Instance (final name to be determined):
- Migrate SQL Server to SQL as a Service with no changes
- Support SQL Agent, 3-part names, DBMail, CDC, Service Broker
- Cross-database + cross-instance querying
- Extensibility: CLR + R Services
- SQL profiler, additional DMVs support, Xevents
- Native back-up restore, log shipping, transaction replication
- More info
- Sign up for limited preview
More info:
Delivering AI with data: the next generation of Microsoft’s data platform
Snapshots and workload groups too? I will be very glad to have profiler and SQL Agent, and easier cross-database queries. Still I wonder about throttling, and I wonder about pricing, I hope it’s treated more like the VMs in those areas.