{"id":20695,"date":"2017-09-25T06:00:48","date_gmt":"2017-09-25T13:00:48","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=20695"},"modified":"2024-01-22T22:51:02","modified_gmt":"2024-01-23T06:51:02","slug":"microsoft-for-the-modern-data-estate","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/09\/25\/microsoft-for-the-modern-data-estate\/","title":{"rendered":"Microsoft for the Modern Data Estate"},"content":{"rendered":"
This post was authored by Rohan Kumar, General Manager, Data Systems Group.<\/em><\/p>\n Welcome to Microsoft Ignite 2017! I hope you are able to join us in person, or virtually through the Ignite Live Stream<\/a>, to hear our exciting product announcements for your Data Estate.<\/p>\n This afternoon, I\u2019ll be speaking in the Data General Session about the investments Microsoft has made across our Data and Analytics portfolio. From key announcements about the availability of SQL Server 2017 on Linux and Docker, to innovative programs that let you use on-premises SQL Server licenses to easily lift and shift to the cloud, to great price and performance for analytics workloads in Azure, we have lots of ways to help you unleash the power of your data, across the entire Data Estate. You\u2019ll also get to hear from customers who have come with us on this journey, and whose investments in data and analytics have led to out-innovating and out-performing their competition.<\/p>\n <\/a><\/p>\n Let\u2019s take a look at some of the products and features you\u2019ll hear more about.<\/p>\n With SQL Server 2017<\/a>, we\u2019ve made huge strides of choice for the data platform, and one of the heroes of our new choice paradigm is SQL Server 2017. Starting next Monday, October 2, customers will be able to bring the industry-leading performance and security of SQL Server to Linux and Docker Enterprise Edition containers for production workloads.<\/strong> SQL Server 2017 delivers a mission-critical database with everything built-in, on the platform of your choice. And, it can unlock seamless DevOps with Docker Enterprise Edition containers, bringing efficiency and simplicity to your innovation. As one customer reported:<\/p>\n \u201cThe Linux switchover was very easy. We didn\u2019t have to do anything custom for Azure. It was literally plug and play,\u201d<\/strong> said Dean Chen, VP of Engineering for dv01.<\/p>\n Today we are also announcing a SQL Server on Red Hat Enterprise Linux offer<\/strong><\/a> to help with upgrades and migrations. This offer provides up to 30% off SQL Server 2017 through an annual subscription. When customers purchase new Red Hat Enterprise Linux (RHEL) to support their SQL Server, they will be eligible for another 30% off their operating system. In addition to discounts on SQL Server and Red Hat Enterprise Linux, all of this is backed by integrated support from Microsoft and Red Hat.<\/p>\n Upgrading now to SQL Server 2017 will get you access to these cool features:<\/p>\n With Microsoft\u2019s cloud-first development principle, you\u2019ll find many of these same advances in our database-as-a-service: Azure SQL Database brings your workloads industry-leading performance and security, all on the same core engine as SQL Server.<\/p>\n With intelligent features like Threat Detection and auto-tuning built-in, Azure SQL Database offers the most productive database service, ideal for managing and modernizing data estate with thousands of databases \u2014 delivering a 406% ROI\u00b9 to organizations. Today, we are announcing the upcoming public preview for SQL Database Managed Instance<\/a>, an expansion to the service which offers close to full compatibility with SQL Server \u2014 ideal for migrating database estate to Azure for hassle-free operations. We are also announcing an upcoming public preview for Azure Database Migration Service<\/strong> which will streamline the movement of databases to Azure including SQL Server to Azure SQL Database. But we aren\u2019t stopping there. We will make Azure the most economical and logical choice for existing SQL Server customers with the addition of Azure Hybrid Benefit for SQL Server<\/strong>, a way to re-use on-premises SQL Server licenses to run database-as-a-service in Azure. Azure Hybrid Benefit offers customers big savings compared to moving to other public clouds.<\/p>\n \u201cWe wanted the best of what we do in our data center, which is reliable SQL Servers on flash storage. With the best of what Azure could bring to it\u2026For us we found Azure SQL Database was the best way to do it. We deploy our SQL Server\u2019s schema element into a Managed Instance and we point the application via connection string change directly over the managed instance. We basically picked up our existing infrastructure and were able to deploy to Azure within a few seconds. It allows us to scale the business very quickly, with very minimal effort. The holy grail in a move like this is being able to lift your existing platform, move it into Azure without significant amounts of work, without having to re-engineer things,\u201d<\/strong> said Eric Fleischman, Vice President & Chief Architect of DocuSign.<\/p>\n In addition to making it easier than ever to move to Azure SQL Database, we\u2019re building in new capabilities that make it more compelling than ever to move. SQL Database has new Machine Learning Services<\/strong> for R language advanced analytics, a service that provides a platform for building and deploying intelligent applications in the cloud. And we\u2019re adding other capabilities that leverage SQL Database\u2019s cloud architecture: Intelligent Insights<\/strong> provide automated monitoring at scale and detection of any database performance degradations, faster than possible with traditional means. Not only that the issue is detected, but a root cause analysis is provided to the user, to easily decide on the best way to mitigate problems. With the new Vulnerability Assessment<\/strong>, customers can proactively improve the security state of their database. They get visibility into their security settings and vulnerabilities, and concrete steps to resolve issues and lock down security settings \u2013 an important issue if you\u2019re subject to EU General Data Protection Regulation (GDPR) regulations.<\/p>\n We are helping customers transform with analytics and AI through faster performance, reduced time to value, and intelligence that can redefine customer interactions. With cloud-first innovation, you get a superset of business intelligence and analytics features that work across your entire Data Estate \u2013 on-premises and in the cloud.<\/p>\n Azure Data Factory<\/strong> is a data integration service that now lets you create, schedule, and orchestrate data integration pipelines at scale wherever your data lives, in the cloud or on premises. You can meet security and compliance needs for your data while taking advantage of Azure Data Factory\u2019s extensive orchestration and data movement capabilities while paying only for what you use.<\/p>\n Now in public preview, SQL Server Integration Services (SSIS) customers can easily lift SSIS packages into the cloud using new managed SSIS hosting capabilities in Data Factory. Coming soon, customers who have active SQL Server license on SQL Server will be able to take advantage of the Azure Hybrid Benefit for SQL Server to receive discounted rates on SSIS execution in Data Factory.<\/p>\n Customers are already using these new features to speed data integration. Said David B. McAuley, CTO for Lumedx, \u201cAzure Data Factory has simplified the integration of data from multiple hybrid sources at scale and enabled us to leverage big data and analytics offerings in Azure to drive better health outcomes for our customers.\u201d<\/strong><\/p>\n Azure SQL Data Warehouse<\/a> is a fully-managed, petabyte-scale cloud data warehouse based on SQL Server. Soon we\u2019ll preview a new performance tier that offers 2x the performance and 5x the scale of the current performance tier. This new compute-optimized performance tier leverages the latest Azure hardware with data caching through low-latency Non-Volatile Memory Express (NVMe)-based solid-state disks for the most demanding data warehouse workloads. You are also able to store an unlimited amount of columnar data with each data warehouse. These benefits of increased performance and scale are offered while retaining the ability to pause, resume and dynamically scale your data warehouse to achieve the lowest possible cost.<\/p>\n Finally, you\u2019re probably familiar with how Power BI has been revolutionizing self-service business intelligence, revealing the information stored within your analytics using powerful visualizations. Power BI works across locations and devices to put BI in the hands of all your users. With Power BI Report Server<\/strong>, announced this past May, you can now run Power BI reports on-premises! This unlocks the deployment and distribution of interactive Power BI reports \u2013 and traditional paginated reports \u2013 completely within the boundaries of the organization\u2019s firewall. Power BI Report Server extends the hybrid BI experience by allowing you to build on your on-premises reporting infrastructure while maintaining compatibility with Power BI to ensure a natural transition when you are ready to move to the cloud. And because Power BI Report Server is built on the proven SQL Server Reporting Services technology, it is fully compatible with SSRS<\/strong>. So, you can take advantage of SSRS capabilities when you deploy Power BI Report Server. Power BI Report Server is included with the purchase of Power BI Premium<\/strong> and available as a Software Assurance benefit for SQL Server Enterprise customers<\/strong>.<\/p>\n <\/a><\/p>\n Finally, only Microsoft offers a complete development, application, and data platform that enables developers to build the next-generation of applications that will enrich the world around us. At Ignite, we continue this journey with new support for Azure Functions in Azure Cosmos DB<\/strong> which will dramatically streamline a developer\u2019s ability to build globally distributed apps in a serverless architecture. These capabilities enable developers to build rich, real-time customer experiences based on data and events, with minimal infrastructure overhead. Azure Cosmos DB offers turnkey global distribution across Azure regions and guarantees performance, with single-digit-millisecond latencies at the 99th percentile anywhere in the world. Its multiple consistency models help fine-tune performance for your application, and guaranteed high availability is backed by industry-leading, comprehensive service level agreements (SLAs). And now, you can try it for free<\/a>!<\/p>\n Ready to hear more? Please join me at this afternoon\u2019s Data General Session and for the other exciting sessions in the Ignite Data track. We\u2019ll have lots of advice and ideas help you unleash the power of your data.<\/p>\n\n
SQL Server 2017 on Linux and Docker<\/h2>\n
\n
Easy lift and shift to the cloud with Azure SQL Database Managed Instance and Azure Hybrid Benefit<\/h2>\n
Data Analytics at scale in the cloud with Azure Data Factory and Azure SQL Data Warehouse<\/h2>\n
Build serverless apps with near infinite global-scale with new support for Azure Functions in Azure Cosmos DB<\/h2>\n
Join us<\/h2>\n