vs2017 build
The annual developer Microsoft Build Conference was held at the Washington State Conference Center in Seattle during May 10-12, 2017. The event had over 5,000 attendees and received a lot of love from the technical community. There were a number of announcements made during this 3-day conference, and in this article I will recap my learnings from a SQL Developer perspective. In the Data Platform, there were a number of new innovations, products and capabilities announced and a lot of emphasis was on using data to fundamentally transform your business. There was focus around serving Artificial Intelligence with Data, which seemed to me to be the future of Data Platform.
年度开发人员Microsoft Build Conference于2017年5月10日至12日在西雅图的华盛顿州会议中心举行。该活动有5,000多名与会者,并受到了技术界的热烈欢迎。 在为期3天的会议中,有许多公告。在本文中,我将从SQL Developer的角度回顾我的学习。 在数据平台中,宣布了许多新的创新,产品和功能,并且很多重点放在使用数据从根本上转变您的业务上。 围绕着为人工智能提供数据服务,我认为这是数据平台的未来。
Microsoft Azure is a global scale cloud platform and has been expanding its reach in the past few years. During the Keynote by Satya Nadella and Scott Guthrie, it was mentioned that more than 90% of the Fortune 500 companies use Microsoft Cloud. They talked about a number of new innovations in Azure which enables developers to leverage cutting edge technology to build enterprise level applications. A number of organizations have started leveraging technologies like AI, IoT, Machine Learning and Advanced Analytics to get a deeper insight into their data, which in turn helps them to better drive their business model.
Microsoft Azure是一个全球规模的云平台,并且在过去几年中一直在扩展其范围。 萨蒂亚·纳德拉(Satya Nadella)和斯科特·古思里(Scott Guthrie)在主题演讲中提到,超过90%的财富500强公司使用Microsoft Cloud。 他们讨论了Azure中的许多新创新,这些创新使开发人员能够利用尖端技术来构建企业级应用程序。 许多组织已开始利用AI,IoT,机器学习和Advanced Analytics等技术来更深入地了解其数据,从而帮助他们更好地推动其业务模型。
将智能带入数据的存放位置 (Bringing intelligence to where data lives)
During the pre-Build event – ‘Microsoft AI Immersion Workshop‘, Joseph Sirosh – Corporate Vice President of Data Platform, talked about Microsoft’s investment in Artificial Intelligence and Machine Learning. He showed a number of cool demos and videos which demonstrated Microsoft’s innovation and vision to bring Artificial Intelligence in every software. The focus was to give more power to developers so that they can use Data + Cloud + AI to build the next generation of enterprise applications. Today’s AI is learning from data and hence making the transition from ‘Application + Intelligence and Database’ to ‘Application and Intelligence + Database’ – in short infusing intelligence to the database.
在“ Microsoft AI沉浸式研讨会 ”预建活动中,数据平台公司副总裁Joseph Sirosh谈到了Microsoft在人工智能和机器学习方面的投资。 他展示了许多很酷的演示和视频,这些演示和视频展示了Microsoft在将人工智能引入每种软件中的创新能力和愿景。 重点是为开发人员提供更多功能,以便他们可以使用Data + Cloud + AI来构建下一代企业应用程序。 当今的AI正在从数据中学习,因此从“应用程序+情报和数据库”过渡到“应用程序和情报+数据库”-简而言之将情报注入数据库。
Analyzing the data efficiently and doing trend analysis helps organizations to make informed decision to drive their Business forward. These new technologies – Cloud, Machine Learning, Artificial Intelligence have great capabilities and power to be a disruptive force in revolutionizing how business currently operate and can totally transform their operations.
有效地分析数据并进行趋势分析可帮助组织做出明智的决定,以推动业务发展。 云,机器学习,人工智能等这些新技术具有强大的功能和力量,可以成为颠覆性的力量,彻底改变企业当前的运营方式并完全改变其运营方式。
You can learn more about AI here.
您可以在此处了解有关AI的更多信息。
SQL Server 2017 –第一个内置AI的商业数据库 (SQL Server 2017 – First Commercial Database with AI built in)
SQL Server 2017 is available in Preview mode currently and you can start using it in your test environments to look at the new capabilities it has to offer. Not only it is the most secure database we have currently, but it is also intelligent with Artificial Intelligence infused in it. There has been a number of enhancements to the core database engine and below are few of the awesome features which SQL Server 2017 has to offer:
SQL Server 2017当前在预览模式下可用,您可以在测试环境中开始使用它来查看它必须提供的新功能。 它不仅是我们目前拥有的最安全的数据库,而且还具有注入了人工智能的智能功能。 核心数据库引擎进行了许多增强,以下是SQL Server 2017必须提供的一些令人敬畏的功能:
- Ability to run SQL Server 2017 database in any platform now – be it Windows Server, Linux or Docker based systems. 现在可以在任何平台上运行SQL Server 2017数据库-无论是基于Windows Server,Linux还是Docker的系统。
- Support for Microsoft Graph Database. 支持Microsoft Graph数据库。
- Performance enhancement with adaptive query processing. It learns from the prior query executions and optimizes itself for superlative performance. 通过自适应查询处理提高性能。 它从先前的查询执行中学习,并优化自身以实现最佳性能。
- Automatic Query Tuning of your T-SQL Queries. It is going a step further than the Query Store feature in SQL Server 2016 where you could monitor and view your regressed queries over a period of time. T-SQL查询的自动查询调整。 它比SQL Server 2016中的查询存储功能更进一步,您可以在一段时间内监视和查看您的回归查询。
- Machine Learning Support with R and Python. R和Python的机器学习支持。
- New string functions and enhanced performance for natively compiled operations. 本地编译操作的新字符串功能和增强的性能。
- Execute Deep Learning Framework like Cognitive Toolkit against data stored inside the database. 对存储在数据库中的数据执行像认知工具包这样的深度学习框架。
- Top notch Security for your application data. 应用程序数据的一流安全性。
- Pause/Resume online rebuilds of indexes so that you have better control and do not impact your application performance. 暂停/恢复在线索引的重建,以便更好地控制并且不影响应用程序性能。
- Machine learning based threat detection and suspicious database activities. 基于机器学习的威胁检测和可疑数据库活动。
Even though it is currently in Preview, there is a Production go live license – indicating that it is Production ready. Lot of organizations are embracing SQL Server 2017 and it has all the potential to be a game changer for them.
即使当前处于“预览”状态,也有“正式上线”许可证-表示已准备就绪。 许多组织都在拥抱SQL Server 2017,它有潜力成为改变他们的游戏规则。
You can download the SQL Server 2017 Preview and learn more about its capabilities.
您可以下载 SQL Server 2017 Preview并了解有关其功能的更多信息。
引入Azure Cosmos DB (Introducing Azure Cosmos DB)
When you host your application, there is every probability that users all over the world will have different latency/response time, depending upon the location of the data centers near them. This is not an ideal scenario. Microsoft announced the release of Azure Cosmos DB – a globally distributed, multi-model managed database service which can help scale your application and can provide data at a high speed across the globe, with a millisecond load latency.
当您托管应用程序时,世界各地的用户很可能会有不同的延迟/响应时间,这取决于它们附近的数据中心的位置。 这不是理想的情况。 微软宣布发布Azure Cosmos DB,这是一种全球分布的多模型托管数据库服务,可以帮助您扩展应用程序,并可以在全球范围内以毫秒级的加载延迟提供高速数据。
Azure Cosmos DB make your data highly available. It allows you to scale your data globally anytime you need. It is a schema agnostic database service and can support various data models like documents, graphs and key-value pairs. Its ability to automatically index your data provides the lightning fast data access speed. It will be highly scalable across geographical regions (millions of transactions per second) and Microsoft will offer SLAs for performance, latency, uptime and consistency.
Azure Cosmos DB使您的数据高度可用。 它使您可以在需要时随时在全球范围内扩展数据。 它是与模式无关的数据库服务,可以支持各种数据模型,如文档,图形和键值对。 它具有自动索引数据的功能,可提供闪电般的快速数据访问速度。 它可以在各个地理区域(每秒数百万个事务)中进行高度扩展,并且Microsoft将提供SLA,以提高性能,延迟,正常运行时间和一致性。
You can learn more about Azure Cosmos DB here.
您可以在此处了解有关Azure Cosmos DB的更多信息。
PostgreSQL和MySQL作为数据库服务的可用性 (Availability of PostgreSQL and MySQL as a Database Service)
Until now, SQL Server was the only database which was available both on premises and as a fully managed database service in the cloud. This has been a setback for developers who preferred to work with MySQL or PostgreSQL database. Based on customer demand, Microsoft announced that they will now support two new managed database services in Azure – MySQL and PostgreSQL. This will enable developers to stand up a MySQL/PostgreSQL database in minutes and scale on the fly, without any downtime.
到目前为止,SQL Server是唯一可在内部使用并作为云中的完全托管数据库服务使用的数据库。 对于喜欢使用MySQL或PostgreSQL数据库的开发人员来说,这是一个挫折。 根据客户需求,Microsoft宣布他们现在将在Azure中支持两项新的托管数据库服务-MySQL和PostgreSQL。 这将使开发人员能够在数分钟内建立一个MySQL / PostgreSQL数据库并即时进行扩展,而不会造成任何停机。
When your database is running as a managed service in Azure, you are freed up from lot of the manual administration work required for your database like patching, periodic backups, monitoring and more. Resources required for your workload can be easily added. If you expect your application usage/traffic to go up for a temporary period of time, you can scale it up during that timeframe and then scale it down – all of this at the expense of no application downtime and there is no need to purchase any additional infrastructure.
当您的数据库作为Azure中的托管服务运行时,您可以免除数据库所需的许多手动管理工作,例如修补,定期备份,监视等。 您的工作负载所需的资源可以轻松添加。 如果您希望应用程序使用量/流量在暂时的时间内增长,则可以在该时间范围内进行扩展,然后再进行缩减–所有这些都以无应用程序停机为代价,并且无需购买任何服务其他基础设施。
You can learn more about these new database services here:
您可以在此处了解有关这些新数据库服务的更多信息:
引入Azure SQL数据库迁移服务 (Introducing Azure SQL Database Migration Service)
Migrating Production on premise database to cloud is always a challenge and has been an impediment for multiple organizations to take that final leap towards moving their infrastructure to Cloud. With the release of the new Azure SQL Database Migration Service, it is lot easier to move your SQL Server or other 3rd party databases (like Oracle and MySQL) to Azure SQL database. It provides an automated workflow to inspect your current database and will guide you through the various changes required for the migration to be successful.
将内部数据库的生产迁移到云上始终是一个挑战,并且一直是多个组织实现将基础架构迁移到云的最后一步。 随着新的Azure SQL数据库迁移服务的发布,将SQL Server或其他第三方数据库(如Oracle和MySQL)迁移到Azure SQL数据库变得更加容易。 它提供了一个自动化的工作流程来检查您当前的数据库,并将指导您完成迁移成功所需的各种更改。
The Migration Service consists of a simple 5 step process to migrate your on premise SQL Server instance to Azure SQL Database:
迁移服务包含一个简单的5步骤过程,该过程可将您的本地SQL Server实例迁移到Azure SQL数据库:
- Enter the Target Server Details 输入目标服务器详细信息
- Enter the Source Server Details 输入源服务器详细信息
- Select the databases that needs to be migrated 选择需要迁移的数据库
- Enter migration settings like the source database server backup location 输入迁移设置,例如源数据库服务器备份位置
- Verify the summary and run the migration. 验证摘要并运行迁移。
Once the database migration is complete, all you need to modify is the connection string in your application to point to the new cloud instance and there you go. That is it – no other modifications are required. The migration process is highly simplified now and hence makes your journey to cloud more pleasant and faster.
数据库迁移完成后,您只需修改应用程序中的连接字符串即可指向新的云实例,然后就可以了。 就是这样–不需要其他修改。 现在,迁移过程已大大简化,因此使您的云之旅更加愉快和快捷。
适用于Android和iOS的新Azure移动应用程序 (New Azure Mobile Application for Android and iOS)
Microsoft announced the release of Azure mobile apps for Android and iOS – which will allow system admins to monitor their applications through mobile devices on the go. You can get real time notifications in your mobile, in case of any critical issues and will also be able to take few actions like restarting a virtual machine through your mobile itself. This will be hugely beneficial for On Call personnel, since they will be able to stay connected to the cloud and have basic level of monitoring, push notifications and corrective action taken in case of an emergency. The mobile app is available for download in Google Play Store and iOS app store.
微软宣布发布适用于Android和iOS的Azure移动应用程序-允许系统管理员通过移动设备监视其应用程序。 如果遇到任何严重问题,您可以在移动设备中获得实时通知,并且还可以采取一些措施,例如通过移动设备本身重新启动虚拟机。 对于随叫随到的人员,这将是非常有益的,因为他们将能够保持与云的连接,并具有基本级别的监视,推送通知和在紧急情况下采取的纠正措施。 可以在Google Play商店和iOS应用商店中下载该移动应用。
You can view detailed information on the Azure Mobile app here.
您可以在此处查看有关Azure移动应用程序的详细信息。
适用于Azure的快照调试器预览 (Snapshot Debugger Preview for Azure)
Debugging issues in Production is tough, especially when your application is running in cloud. Sometimes analyzing the database logs, trace files and IIS logs might not be sufficient to identify the issue in a Production environment. Not to forget the limited debugging option for a Production application. In one of my earlier projects, we had to troubleshoot issues with specific users/workflows in Production environment. It was a painful experience, since these issues could not be recreated in other environments and were reported only in Production.
生产中的调试问题非常棘手,尤其是当您的应用程序在云中运行时。 有时分析数据库日志,跟踪文件和IIS日志可能不足以识别生产环境中的问题。 不要忘记生产应用程序的有限调试选项。 在我较早的项目之一中,我们不得不对生产环境中特定用户/工作流程的问题进行故障排除。 这是一个痛苦的经历,因为这些问题无法在其他环境中重现,并且仅在生产中报告。
In such cases, capturing a snapshot when an exception is thrown is helpful because it shows the state of source code and the values of the variables at that point. This will give you more insight on the Production issues and help you to resolve it faster. This is exactly what the Snapshot Debugger for Azure tool does, without any impact on the Production environment. By adding Application Insights to your .NET application you can enhance the production debugging experience. During the Keynote, Scott Hanselman showed a demo how to remotely debug a .NET application running in Azure through Visual Studio 2017 IDE.
在这种情况下,在引发异常时捕获快照会很有用,因为它会显示源代码的状态以及此时的变量值。 这将使您对生产问题有更多的了解,并帮助您更快地解决问题。 这正是Snapshot Debugger for Azure工具的功能,而对生产环境没有任何影响。 通过将Application Insights添加到.NET应用程序,您可以增强生产调试体验。 在主题演讲中,Scott Hanselman演示了如何通过Visual Studio 2017 IDE远程调试Azure中运行的.NET应用程序的演示。
Additional details are in the link below
其他详细信息在下面的链接中
Introducing the Snapshot Debugger preview for Azure
结论 (Conclusion )
Microsoft Build was a great developer conference and I found the Keynotes and Technical Sessions to be of immense value. Apart from these sessions, there was the Hub area, which consisted of a number of booths and I was able to interact with different Sponsors and Microsoft Engineering Team – Visual Studio, Windows, Azure and more. As the conference came to an end, the biggest value for me apart from learning the latest and greatest in technology, was the connections I was able to make with fellow attendees and Microsoft Engineers.
Microsoft Build是一个很棒的开发者大会,我发现主题演讲和技术会议具有巨大的价值。 除了这些会议之外,还有一个集线器区域,其中包括许多摊位,我能够与不同的赞助商和Microsoft工程团队互动-Visual Studio,Windows,Azure等。 会议结束时,除了学习最新和最先进的技术外,对我来说最大的价值是我与与会者和Microsoft工程师之间的联系。
![](https://www.sqlshack.com/wp-content/uploads/2017/05/machine-generated-alternative-text-cloud-platform.jpeg)
If you are interested to learn more about the other Microsoft Build announcements and hear few of the technical sessions, then make sure you go the Channel 9 site to watch all the recordings.
如果您有兴趣了解有关其他Microsoft Build公告的更多信息,并且很少听到技术讲座,那么请确保您进入Channel 9网站以观看所有录音 。
翻译自: https://www.sqlshack.com/microsoft-build-conference-2017-recap-for-sql-developers/
vs2017 build