<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" > <channel> <title>SQL Server Blog</title> <atom:link href="https://blogs.technet.microsoft.com/dataplatforminsider/feed/" rel="self" type="application/rss+xml" /> <link>https://blogs.technet.microsoft.com/dataplatforminsider</link> <description>Official News from Microsoft’s Information Platform</description> <lastBuildDate>Wed, 01 Nov 2017 15:30:10 +0000</lastBuildDate> <language>en-US</language> <sy:updatePeriod>hourly</sy:updatePeriod> <sy:updateFrequency>1</sy:updateFrequency> <item> <title>SQL Server 2017 and Azure Data Services – The ultimate hybrid data platform</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/11/01/sql-server-2017-and-azure-data-services-the-ultimate-hybrid-data-platform/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/11/01/sql-server-2017-and-azure-data-services-the-ultimate-hybrid-data-platform/#respond</comments> <pubDate>Wed, 01 Nov 2017 15:30:05 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=21176</guid> <description><![CDATA[This post was authored by Rohan Kumar, General Manager Database Systems Engineering. Today at PASS Summit 2017, we are showcasing new advances across SQL Server 2017 and our Azure data services. And we’re demonstrating how these products – both on-premises and in the cloud – come together to form the ultimate hybrid data platform. Our recent... <a aria-label="read more about SQL Server 2017 and Azure Data Services – The ultimate hybrid data platform" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/11/01/sql-server-2017-and-azure-data-services-the-ultimate-hybrid-data-platform/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p><em>This post was authored by Rohan Kumar, General Manager Database Systems Engineering.</em></p> <p>Today at PASS Summit 2017, we are showcasing new advances across <a target="_blank" href="https://www.microsoft.com/en-us/sql-server/sql-server-2017" rel="noopener noreferrer">SQL Server 2017</a> and our Azure data services. And we’re demonstrating how these products – both on-premises and in the cloud – come together to form the ultimate hybrid data platform. <strong>Our recent announcements, here at PASS Summit and at Ignite in September are great examples of how we&#8217;re empowering data professionals – like our community here at PASS Summit 2017 – to do more and achieve more.</strong></p> <p>With the recent launch of SQL Server 2017, the first database with AI built-in, you can now run your production workloads on Linux, Windows, and Docker. 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. New features enable analysis of graph data, and advanced analytics using Python and R. We have incorporated your feedback to add features that will make your day-to-day job easier like Adaptive Query Processing and Automatic Plan Correction by finding and fixing performance regressions automatically.</p> <p>In addition, SQL Server 2017 running on Windows and Linux can take advantage of new leaps forward in hardware. As demonstrated today by Bob Ward, SQL Server 2017 on SUSE Enterprise Linux Server on an HPE ProLiant DL380 Gen 10 Server with scalable persistent memory ran queries more than 5 times faster than a fast SSD drive array at 50% of the cost – making it the <strong>world’s first enterprise-grade diskless database server.</strong></p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/11/rohan-1.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/11/rohan-1-500x281.png" alt="" width="500" height="281" class="aligncenter size-mediumlarge wp-image-21195" /></a></p> <p>These new cross-platform capabilities have made SQL Server accessible to users of Windows, Linux and Mac. At PASS Summit, we are excited to provide a<strong> sneak peek at Microsoft SQL Operations Studio</strong>. In a few weeks, users will be able to download and evaluate this free, light-weight tool for modern database development and operations on Windows, Mac or Linux machines for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. Increase your productivity with smart T-SQL code snippets and customizable dashboards to monitor and quickly detect performance bottlenecks in your SQL databases on-premises or in Azure. You’ll be able to leverage your favorite command line tools like Bash, PowerShell, sqlcmd, bcp and ssh in the Integrated Terminal window. Users can contribute directly to SQL Operations Studio via pull requests from the GitHub repository.</p> <p>For customers who are ready to modernize to the cloud, <a target="_blank" href="https://sqldatabase-migrationpreview.azurewebsites.net/" rel="noopener noreferrer">Azure SQL Database Managed Instance and Azure Database Migration Service</a>, both now in private preview, making it easy to lift-and-shift your on-premises SQL Server workloads with few or no changes. The upcoming Azure Hybrid Benefit for SQL Server enables customers to use on-premises SQL Server licenses for the easiest lift and shift of SQL Server workloads to the fully-managed cloud.</p> <p><a target="_blank" href="https://azure.microsoft.com/en-us/services/sql-database/" rel="noopener noreferrer">Azure SQL Database</a> is ready for your most mission-critical workloads. Today, we demonstrated the <strong>high scale and performance of SQL Database, with the ability to insert 1.4 million rows per second</strong>. In addition, we are making it easier than ever to gain insights from data at this scale. We recently made generally available, the ability to run advanced analytics models from Azure Machine Learning super-fast from T-SQL, with new Native T-SQL scoring. And in today’s demos, we show how you can use this new capability to <strong>score large amounts of data in real time – at an average of under 20ms per row</strong>!</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/11/rohan-2.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/11/rohan-2-500x281.png" alt="" width="500" height="281" class="aligncenter size-mediumlarge wp-image-21205" /></a></p> <p>Starting in early 2016, we have been delivering machine-learning based customer value directly into the Azure SQL Database managed service. More recently, we’ve delivered several intelligent capabilities including automatic tuning, performance monitoring and tuning, Adaptive Query Processing, and Threat Detection. These capabilities significantly reduce time requires to manage anywhere from one to thousands of databases and help proactively defend against potential threats. And the preview Vulnerability Assessment feature helps you more easily understand your security and compliance with new initiatives like GDPR.</p> <p>In addition to sharing the same “everything built-in” SKU model with SQL Server for lower total cost of ownership versus competitors, Azure SQL Database adds value to your database with these built-in administration features. Now it’s easier than ever to move to Azure SQL Database with our new partnership with Attunity. Customers can now take advantage of <a target="_blank" href="https://www.attunity.com/products/replicate/attunity-replicate-for-microsoft-migration/" rel="noopener noreferrer">Attunity Replicate for Microsoft Migrations</a>, a free offer that accelerates migrations from various database systems, including Oracle, Amazon Redshift, and PostgreSQL to the Microsoft Data Platform.</p> <p>To simplify analytics in the cloud, we’re releasing a public preview of new hybrid data integration capabilities in <a target="_blank" href="https://azure.microsoft.com/en-us/services/data-factory/" rel="noopener noreferrer">Azure Data Factory</a> including the ability to run SSIS packages within the service. This means you can run your SSIS data integration workloads in Azure, without changing the packages – for true hybrid data integration across on-premises and cloud. And our SSIS partner technologies like Biml can now work to automate and enhance data integration across on-premises and cloud.</p> <p>Dramatic scale investments are now in public preview for <a target="_blank" href="https://azure.microsoft.com/en-us/services/sql-data-warehouse/" rel="noopener noreferrer">Azure SQL Data Warehouse</a>. <strong>With the new Compute-Optimized Tier, you can get up to 100x the performance and 5x the scale</strong>. This new tier builds on the existing optimized for elasticity tier – giving customers the benefit of a fully-managed platform that suits the demands of their workload.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/11/rohan-3.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/11/rohan-3-500x281.png" alt="" width="500" height="281" class="aligncenter size-mediumlarge wp-image-21215" /></a></p> <p>Visualizing data helps users across the organization take informed action. Microsoft delivers Business Intelligence capabilities to help customers model, analyze, and deliver business insights, which can be consumed by business users on mobile devices, on the web or embedded in applications.</p> <p>Analysis Services helps you transform complex data into semantic models making it easy for business users to understand and analyze large amounts of data across different data sources. The same enterprise-grade SQL Server Analysis Services you’ve used on-premises is also available as a fully managed service in Azure. With today’s announcement of the Scale Out feature for Azure Analysis Services, you can easily set the number of replicas for your Azure Analysis Services instances to support large numbers of concurrent users with blazing fast query performance.</p> <p>Power BI is a market leading SaaS service that is easy to get started and simple to use, with data connections to many on-premises and cloud data sources. It allows users across roles and industries to go from data to insights in minutes. A recent key addition to the Power BI portfolio is Power BI Report Server. Power BI Report Server enables self-service BI and enterprise reporting, all in one on-premises solution by allowing you to manage your SQL Server Reporting Services (SSRS) reports alongside your Power BI reports. Today we announce the availability of a new version of Power BI Report Server that will enable keeping Power BI reports on-premises that connect to any data! Read more on the Power BI blog.</p> <p>Microsoft’s guiding principle has been to build the highest performing, most secure, and consistent data platform for all your applications across on-premises and cloud. By joining us on this journey, you can build upon your investments in SQL Server to expand the scope of your role in your organization, from database systems to advanced analytics and artificial intelligence. We look forward to working with you!</p> <p>If you aren’t with us at PASS Summit 2017 this week, you can still see the announcements and demonstrations by purchasing session recordings to stream or download and watch at home. Sign up at the <a target="_blank" href="http://www.pass.org/summit/2017/RegisterNow.aspx" rel="noopener noreferrer">PASS Summit Website</a>.</p> <p>If you’d like to learn more about the latest enhancements in the Microsoft Data Platform, visit <a target="_blank" href="http://www.microsoft.com/data" rel="noopener noreferrer">our data platform webpage</a>, or <a href="https://azure.microsoft.com/en-us/overview/data-platform/">data platform overview on Azure</a>.</p> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/11/01/sql-server-2017-and-azure-data-services-the-ultimate-hybrid-data-platform/feed/</wfw:commentRss> <slash:comments>0</slash:comments> </item> <item> <title>Top five reasons to join us for the PASS Summit 2017 Day 1 Keynote</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/30/top-five-reasons-to-join-us-for-the-pass-summit-2017-day-1-keynote/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/30/top-five-reasons-to-join-us-for-the-pass-summit-2017-day-1-keynote/#respond</comments> <pubDate>Mon, 30 Oct 2017 21:00:40 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=21175</guid> <description><![CDATA[PASS Summit 2017 takes place from November 1 to November 3, in Seattle, Washington at the Washington State Convention Center. This year’s event guarantees to be an exciting time to reconnect with the community, see friends old and new, and learn about new product features and enhancements. Microsoft would like to invite you to join... <a aria-label="read more about Top five reasons to join us for the PASS Summit 2017 Day 1 Keynote" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/30/top-five-reasons-to-join-us-for-the-pass-summit-2017-day-1-keynote/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p><a target="_blank" href="http://www.pass.org/summit/2017/Home.aspx" rel="noopener noreferrer">PASS Summit 2017</a> takes place from November 1 to November 3, in Seattle, Washington at the Washington State Convention Center. This year’s event guarantees to be an exciting time to reconnect with the community, see friends old and new, and learn about new product features and enhancements. <strong>Microsoft would like to invite you to join us for the <a target="_blank" href="http://www.pass.org/summit/2017/Sessions/Keynotes.aspx" rel="noopener noreferrer">Day 1 Keynote by Rohan Kumar</a>, which takes place on Wednesday, November 1, at 8:30 AM.</strong></p> <p>Rohan and the Microsoft Data and AI engineering teams will highlight how our customers and community have shaped the latest products and feature enhancements — many of them based on your feedback. This continuous innovation loop is how we have accelerated innovation across our products and services. But the process doesn’t focus on code, it focuses on you and your requirements. Product telemetry, technology blogs, PASS meetups, all the time and anyway we can, we want to listen to what you have to say.</p> <p>The keynote will be jam-packed with practical demonstrations, giving you a chance to see your feature requests in action. In fact, there are so many great announcements and demos coming that we made a list of the <strong>Top five reasons to join us for the PASS Summit 2017 Day 1 Keynote:</strong></p> <ol> <li><strong>Accelerate performance – Bob Ward</strong> will demonstrate the super fast performance that SQL Server 2017 can achieve, while <strong>Conor Cunningham</strong> will talk about why performance tuning doesn’t have to be manual drudgery anymore.</li> <li><strong>Get started with Dev Ops – Tobias Ternstrom</strong> and <strong>Mihaela Blendea</strong> will show you quick and painless new ways to set up a development environment, made possible by SQL Server 2017 support for Windows and Linux containers.</li> <li><strong>Create powerful insights in real time – Danielle Dean</strong> will demonstrate how high performance and scale in Azure SQL Database can combine with built-in AI to create new and powerful insights from IOT data.</li> <li><strong>Conquer analytics at scale</strong> <strong>–</strong> Community member <strong>Scott Currie, CEO of <a target="_blank" href="https://www.varigence.com/" rel="noopener noreferrer">Varigence</a></strong>, will show you how the latest version of Azure Data Factory can combine with partner technologies like BIML to automate data movement in the cloud. <strong>Julie Straus</strong>s will show off incredible analytics performance gains made possible by the new compute-optimized tier in Azure SQL Data Warehouse.</li> <li><strong>Leverage business intelligence across on-premises and cloud – Christian Wade</strong> will demonstrate fast, interactive analysis over large amounts of data in Analysis Services, on-premises and in the cloud. And <strong>Riccardo Muti</strong> will showcase new features in Power BI Premium that can bring interactive reports and queries and stunning visualizations to your users, wherever your data lives.</li> </ol> <p>That was just a taste of the demos that we hope will surprise you, please you, and make your life just that much easier when you take your new knowledge back to work next week. Registration for this event is almost full, but there are still a few passes left. Or, you can purchase session recordings to stream or download and watch at home. Sign up at the <a target="_blank" href="http://www.pass.org/summit/2017/RegisterNow.aspx" rel="noopener noreferrer">PASS Summit Website</a>.</p> <p>If you’d like to learn more about the latest enhancements in the Microsoft Data Platform, visit our <a target="_blank" href="http://www.microsoft.com/data" rel="noopener noreferrer">data platform webpage</a>, or <a target="_blank" href="https://azure.microsoft.com/en-us/overview/data-platform/" rel="noopener noreferrer">data platform overview on Azure</a>.</p> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/30/top-five-reasons-to-join-us-for-the-pass-summit-2017-day-1-keynote/feed/</wfw:commentRss> <slash:comments>0</slash:comments> </item> <item> <title>Modernize your applications across on-premise and cloud with the Microsoft Data Accelerator Program</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/30/modernize-your-applications-across-on-premise-and-cloud-with-the-microsoft-data-accelerator-program/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/30/modernize-your-applications-across-on-premise-and-cloud-with-the-microsoft-data-accelerator-program/#respond</comments> <pubDate>Mon, 30 Oct 2017 20:00:52 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=21136</guid> <description><![CDATA[Your customers are demanding the latest innovations in every solution you deliver. How do you make sure that your apps meet — and exceed — your customers’ expectations? Leverage the Microsoft Data Accelerator Program, an efficient and reliable upgrade service, to modernize your on-premise or cloud applications. This year, we have expanded the program to... <a aria-label="read more about Modernize your applications across on-premise and cloud with the Microsoft Data Accelerator Program" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/30/modernize-your-applications-across-on-premise-and-cloud-with-the-microsoft-data-accelerator-program/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p>Your customers are demanding the latest innovations in every solution you deliver. How do you make sure that your apps meet — and exceed — your customers’ expectations? Leverage the Microsoft Data Accelerator Program, an efficient and reliable upgrade service, to modernize your on-premise or cloud applications. This year, we have expanded the program to support the scenarios below.</p> <h2>Modernize to SQL Server 2017 to begin your journey to cloud</h2> <p>With SQL Server 2017, now on Windows, Linux, and Docker containers, you can build modern applications using the language of your choice, on-premises or in the cloud. SQL Server 2017 offers tremendous performance features for your mission-critical, intelligence, and data warehouse applications. In-Memory OLTP delivers up to 30x faster transaction processing and columnstore indexes deliver up to 100x faster analytical processing. In addition to these features, SQL Server also owns the top TPC-H performance benchmarks for data warehouse.¹ With SQL Server 2017, you can inject intelligence into your applications with transformative insights and real-time analytics at up to one million R predictions per second.² Leverage these latest enhancements while protecting your application data with the least-vulnerable database over the last seven years.³</p> <h2>Modernize on-premises SQL Server or Oracle apps to Azure SQL Database</h2> <p>Seamlessly transform your on-premises apps to SaaS solutions at a cost-effective scale, with flexible performance and unmatched PaaS capabilities, using Azure SQL Database. Azure SQL Database is a fully-managed relational database-as-a-service that you can use to build data-driven applications in the programming language of your choice. It includes features like provisioning and resizing, built-in high availability (HA), automatic backup, point-in-time-restore, and active geo-replication. In addition to the benefits of PaaS, Azure SQL Database also includes built-in intelligence that helps you dramatically reduce the costs of running and managing databases and maximizes both the performance and security of your applications.</p> <h2>Leverage open source investments by modernizing on-premises apps to Azure SQL Database for MySQL and PostgreSQL</h2> <p>Microsoft Azure is the first-class cloud platform for open source technology that empowers you to bring the tools you love, along with the skills you already have, to build and deploy any application. With Azure Database for MySQL and Azure Database for PostgreSQL, you can now choose your favorite database engine delivered as a fully-managed service with high-availability and dynamic scalability. These services bring the community version of PostgreSQL and MySQL to the cloud, and seamlessly integrate with most common open source programming languages (such as PHP, Python, and Node.js) and application development frameworks (such as WordPress, Magento, Drupal, Django, and Ruby on Rails). If you want to quickly build and deploy a new app, you can now take advantage of managed service capabilities offered by Azure while continuing to use the familiar community tools with your MySQL or PostgreSQL databases.</p> <h2>Lift and shift on-premises SQL Server apps to the cloud with Azure SQL Database Managed Instance</h2> <p>SQL Database Managed Instance is an expansion of the existing Azure SQL Database service designed to quickly and easily move your SQL apps to a fully-managed PaaS, without re-designing your application. Azure SQL Database Managed Instance provides high compatibility with on-premises SQL Server programming model and out-of-box support and tools to manage data and enable new scenarios in the cloud for your applications. This includes features like SQL CLR, SQL Server Agent, and cross-database querying. Using a fully-managed PaaS database frees your IT overhead, dramatically reducing operational costs and redirecting resources to more value-add activities. Azure SQL Database Managed Instance is scheduled to be available for public preview later this fall.</p> <p>Apply to our Microsoft Data Accelerator program to upgrade your on-premises applications or begin the journey to migrate them to the cloud. The Microsoft Data Accelerator provides access to highly reliable, automated upgrade services for the four scenarios highlighted above. Backed by the rich experience of upgrading thousands of applications, Microsoft Data Accelerator enables you to modernize your applications and provide a broader range of platform choices to your customers.</p> <h5><a target="_blank" href="https://info.microsoft.com/microsoft-data-accelerator-program-register.html" rel="noopener noreferrer">Learn more and apply</a> for the Microsoft Data Accelerator Program.</h5> <p>&nbsp;</p> <p><em>¹via <a target="_blank" href="http://www.tpc.org/tpce/results/tpce_perf_results.asp?resulttype=NONCLUSTER&amp;version=1%&amp;currencyID=0" rel="noopener noreferrer">www.tpc.org</a></em><br /> <em>²via <a target="_blank" href="http://www.tpc.org/tpch/results/tpch_perf_results.asp?resulttype=noncluster" rel="noopener noreferrer">www.tpc.org</a></em><br /> <em>³According to the National Institute of Standards and Technology, SQL Server has had the fewest security vulnerabilities over the past seven years when compared with other major database vendors.</em></p> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/30/modernize-your-applications-across-on-premise-and-cloud-with-the-microsoft-data-accelerator-program/feed/</wfw:commentRss> <slash:comments>0</slash:comments> </item> <item> <title>Ask the team that built SQL Server 2017 anything on October 25, 2017</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/23/ask-the-team-that-built-sql-server-2017-anything-on-october-25-2017/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/23/ask-the-team-that-built-sql-server-2017-anything-on-october-25-2017/#comments</comments> <pubDate>Mon, 23 Oct 2017 16:00:42 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=21126</guid> <description><![CDATA[Hi! We’re Travis Wright and Tobias Ternstrom from the Microsoft SQL Server engineering team and we along with other members of the team are hosting a Reddit Ask Me Anything session on /r/Database, Wednesday, October 25, 2017, from 10:00 am to 11:30am PDT. Why are we doing an AMA? SQL Server 2017 was made generally... <a aria-label="read more about Ask the team that built SQL Server 2017 anything on October 25, 2017" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/23/ask-the-team-that-built-sql-server-2017-anything-on-october-25-2017/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p>Hi! We’re Travis Wright and Tobias Ternstrom from the Microsoft SQL Server engineering team and we along with other members of the team are hosting a Reddit Ask Me Anything session on <a target="_blank" href="https://www.reddit.com/r/Database/" rel="noopener noreferrer">/r/Database</a>, <strong>Wednesday, October 25, 2017</strong>, from <strong>10:00 am to 11:30am PDT</strong>.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/10/Reddit-AMA.jpg"><img src="https://msdnshared.blob.core.windows.net/media/2017/10/Reddit-AMA-466x350.jpg" alt="" width="466" height="350" class="aligncenter size-mediumlarge wp-image-21135" /></a></p> <h2>Why are we doing an AMA?</h2> <p>SQL Server 2017 was made <a target="_blank" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/sql-server-2017-on-windows-linux-and-docker-is-now-generally-available/" rel="noopener noreferrer">generally available</a> on October 2, on Windows, Linux and Docker containers. With this release, customers have an even wider choice of development languages, data types, and operating systems. We’re excited to connect with you on Reddit to tell you more about our experiences bringing it to market and answering your questions!</p> <p>We’re also getting ready to join thousands of data professionals in Seattle from October 31 – November 3rd at the <a target="_blank" href="http://www.pass.org/summit/2017/Home.aspx" rel="noopener noreferrer">PASS Summit 2017</a>. We look forward to this gathering every year. If you’re attending or planning to watch online, this AMA is a great time to catch up beforehand.</p> <h3><a target="_blank" href="https://www.reddit.com/r/Database/" rel="noopener noreferrer">Join us!</a> We&#8217;re looking forward to having a conversation with you.</h3> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/23/ask-the-team-that-built-sql-server-2017-anything-on-october-25-2017/feed/</wfw:commentRss> <slash:comments>5</slash:comments> </item> <item> <title>What’s new in SQL Server Management Studio 17.3</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/10/whats-new-in-sql-server-management-studio-17-3/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/10/whats-new-in-sql-server-management-studio-17-3/#comments</comments> <pubDate>Tue, 10 Oct 2017 18:00:59 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=21025</guid> <description><![CDATA[This post was authored by Alan Yu, Program Manager, Microsoft SQL Server We are excited to announce the release of SQL Server Management Studio (SSMS) 17.3! Download SSMS 17.3 and review the Release Notes to get started. SSMS 17.3 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server... <a aria-label="read more about What’s new in SQL Server Management Studio 17.3" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/10/whats-new-in-sql-server-management-studio-17-3/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p><em>This post was authored by Alan Yu, Program Manager, Microsoft SQL Server</em></p> <p><strong>We are excited to announce the release of SQL Server Management Studio (SSMS) 17.3!</strong></p> <p><a target="_blank" href="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms" rel="noopener noreferrer">Download SSMS 17.3</a> and review the <a target="_blank" href="https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms" rel="noopener noreferrer">Release Notes</a> to get started.</p> <p>SSMS 17.3 provides support for almost all feature areas on SQL Server 2008 through <a target="_blank" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/sql-server-2017-on-windows-linux-and-docker-is-now-generally-available/" rel="noopener noreferrer">the latest SQL Server 2017</a>, which is now generally available.</p> <p>In addition to enhancements and bug fixes, SSMS 17.3 comes with two new exciting features:</p> <ul> <li>Import Flat File Wizard</li> <li>XEvent Profiler</li> </ul> <h2>Import Flat File Wizard</h2> <p>The <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-flat-file-wizard" rel="noopener noreferrer">Import Flat File Wizard</a> streamlines the import experience of flat files (.csv, .txt) with an intelligent framework, requiring minimal user intervention or specialized domain knowledge.</p> <p>A common task for a user is to import a flat file to a SQL table. The existing SSMS Import Data wizard provides a much broader set of import capabilities and configuration for defining SQL Server Integration Services packages. This can be useful in many cases, but for the simple task of importing a flat file into a table, a more streamlined experience is desirable. There is a need for a tool or technology that simplifies the import experience by reducing the amount of user configuration required to properly import complex flat file structures.</p> <h4>New import technology</h4> <p>To address this need, we are using the <a target="_blank" href="https://microsoft.github.io/prose/" rel="noopener noreferrer">Microsoft Program Synthesis using Examples</a> (PROSE) SDK. This SDK allows us to take raw semi-structured data and identify patterns in it to perform predictive file splitting, helping the wizard “learn” the structure of a flat file to infer column names, types, delimiters, and more.</p> <p>This simplifies the import flat file experience by requiring the user to only provide an input file and unique file name, and the wizard takes care of the rest.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/10/17.3-1.png"><img width="1261" height="340" class="aligncenter wp-image-21086 size-full" alt="" src="https://msdnshared.blob.core.windows.net/media/2017/10/17.3-1.png" /></a></p> <h2></h2> <h4>Try it now</h4> <p>Try the Import Flat File Wizard yourself by following a <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-flat-file-wizard#started" rel="noopener noreferrer">step-by-step tutorial</a>.</p> <p>To learn more about the Import Flat File Wizard, check out my demo for Channel9:</p> <p><iframe width="960" height="540" src="https://channel9.msdn.com/Shows/Data-Exposed/Introducing-the-new-Import-Flat-File-Wizard-in-SSMS-173/player" allowfullscreen="allowfullscreen" frameborder="0"></iframe></p> <h2>XEvent Profiler</h2> <p>The <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/use-the-ssms-xe-profiler" rel="noopener noreferrer">XEvent Profiler</a> is an easy to launch and customizable SSMS feature that quickly displays a live target view of extended events.</p> <p>In SSMS, the existing extended events functionality already provides a flexible definition of sessions and views, but lacks the “quick view” capability of SQL Profiler. XEvent Profiler generates that view just as fast as SQL Profiler, while also allowing for view customization that can be shared with other SSMS users as a *.viewsettings file.</p> <p>The diagram below illustrates how quick it is to view extended events in your database.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/10/xevent-profiler-diagram.png"><img width="1209" height="357" class="aligncenter wp-image-21045 size-full" alt="" src="https://msdnshared.blob.core.windows.net/media/2017/10/xevent-profiler-diagram.png" /></a></p> <h4>Try it now</h4> <p>Try the XEvent Profiler yourself by following a <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/use-the-ssms-xe-profiler#getting-started" rel="noopener noreferrer">step-by-step tutorial</a>.</p> <p>We challenge you to try out this new feature over SQL Server Profiler. If there are any gaps that require you to use SQL Server Profiler over XEvent Profiler, feel free to comment on this blog. We hope to fill those gaps in future releases.</p> <h2>Contact us</h2> <p>We are open to any questions, feedback, or any feature suggestions for future releases. Please <a target="_blank" href="https://connect.microsoft.com/SQLServer/Feedback" rel="noopener noreferrer">contact us using our form</a>, or tweet to our team’s engineering manager <a target="_blank" href="https://twitter.com/sqltoolsguy?lang=en" rel="noopener noreferrer">@sqltoolsguy</a>.</p> <p>&nbsp;</p> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/10/whats-new-in-sql-server-management-studio-17-3/feed/</wfw:commentRss> <slash:comments>28</slash:comments> </item> <item> <title>Webinar: Get enterprise-grade features at open-source prices with SQL Server 2017 on Linux</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/10/webinar-get-enterprise-grade-features-at-open-source-prices-with-sql-server-2017-on-linux/</link> <pubDate>Tue, 10 Oct 2017 16:00:31 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=21105</guid> <description><![CDATA[IT pros now have the flexibility of running workloads across Windows, Linux, or a combination of both. By taking advantage of SQL Server 2017 on Linux, you’ll get enterprise-grade features at open-source pricing — all backed by Microsoft support and security. It’s never been easier or more cost effective to make the move. SQL Server... <a aria-label="read more about Webinar: Get enterprise-grade features at open-source prices with SQL Server 2017 on Linux" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/10/webinar-get-enterprise-grade-features-at-open-source-prices-with-sql-server-2017-on-linux/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p>IT pros now have the flexibility of running workloads across Windows, Linux, or a combination of both. By taking advantage of SQL Server 2017 on Linux, you’ll get enterprise-grade features at open-source pricing — all backed by Microsoft support and security. It’s never been easier or more cost effective to make the move.</p> <p>SQL Server 2017 combines the best of databases and analytics into one product. New enhancements include real-time intelligence due to faster transactions with In-Memory OLTP, new T-SQL enhancements for in-memory tables and natively compiled stored procedures, ColumnStore performance improvements, and support for LOBS.</p> <p>Join our speakers Debbi Lyons, Sr. Product Marketing Manager and Travis Wright, Principal Program Manager for a webinar on how SQL Server 2017 on Linux provides intelligence on a trusted, industry-leading platform while enabling innovation for all your data.</p> <p>In this live webinar and Q&amp;A, you’ll learn:</p> <ul> <li>What’s new with SQL Server 2017 on Linux and the benefits of building your next Linux project with SQL Server.</li> <li>How to leverage Microsoft’s offer to get a discounted subscription rate.</li> <li>Quick and easy ways to get started with SQL Server 2017, and our suite of free tools available.</li> </ul> <p>Join us Thursday, October 12, 2017, at 9:00 AM Pacific Time (UTC-7). <a target="_blank" href="https://info.microsoft.com/sql-server-2017-on-linux-live-registration.html" rel="noopener noreferrer"><strong>Register now</strong></a> for this webinar on how your data ecosystem can benefit from SQL Server 2017 on Linux.</p> ]]></content:encoded> </item> <item> <title>SQL Server 2012 Service Pack 4 is now available</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/05/sql-server-2012-service-pack-4-is-now-available/</link> <pubDate>Thu, 05 Oct 2017 22:47:28 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=21065</guid> <description><![CDATA[The SQL Server team is excited to bring you the final service pack release for SQL Server 2012. The service pack is now available for download on the Microsoft Download Center and will be coming soon to Visual Studio Subscriptions, MBS/Partner Source, and VLSC. As part of our commitment to software excellence for our customers,... <a aria-label="read more about SQL Server 2012 Service Pack 4 is now available" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/05/sql-server-2012-service-pack-4-is-now-available/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p>The SQL Server team is excited to bring you the final service pack release for SQL Server 2012. The service pack is now available for download on the <a target="_blank" href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7f2d8a4c-cf15-4160-9b73-e95d3279bddb" rel="noopener noreferrer">Microsoft Download Center</a> and will be coming soon to Visual Studio Subscriptions, MBS/Partner Source, and VLSC. As part of our commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2012 deployments.</p> <p><a target="_blank" href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7f2d8a4c-cf15-4160-9b73-e95d3279bddb" rel="noopener noreferrer">SQL Server 2012 Service Pack 4 (SP4)</a> contains a roll-up of released hotfixes as well as more than twenty improvements centered around performance, scalability, and diagnostics based on the feedback from customers and SQL community. These improvements enable SQL Server 2012 to perform faster and scale out of the box on modern hardware design. It also showcases the SQL Server product team’s commitment to providing continued value to in-market releases.</p> <p>SQL Server 2012 Service Pack 4 will include:</p> <ul> <li>All fixes and Cumulative Updates (CUs) for SQL Server 2012 up to and including SQL Server 2012 SP3 CU10.</li> <li>Scalability and performance improvements for SQL Server.</li> <li>Additional monitoring capabilities through enhancements in DMV, Extended Events and Query Plans and the ability to clone the database including statistics with DBCC CLONEDATABASE.</li> <li>New improvements based on Connect feedback items filed by the SQL Server Community.</li> <li>Some of the improvements originally introduced in SQL Server 2014 SP2 and SQL Server 2016 SP1.</li> </ul> <p>Find more information on SQL Server 2012 SP4 by reading the <a target="_blank" href="https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2012-service-pack-4-sp4-released/" rel="noopener noreferrer">detailed Engineering team blog post</a> and the <a target="_blank" href="https://docs.microsoft.com/en-us/sql/sql-server/sql-server-2012-sp4-release-notes" rel="noopener noreferrer">release notes</a>. Download today by visiting the links below:</p> <ul> <li><a target="_blank" href="http://www.microsoft.com/downloads/details.aspx?FamilyID=7f2d8a4c-cf15-4160-9b73-e95d3279bddb" rel="noopener noreferrer">SQL Server 2012 SP4</a></li> <li><a target="_blank" href="http://www.microsoft.com/downloads/details.aspx?FamilyID=1e74faf6-166c-4f1e-9f14-2021439e34d2" rel="noopener noreferrer">SQL Server 2012 SP4 Express</a></li> <li><a target="_blank" href="http://www.microsoft.com/downloads/details.aspx?FamilyID=dbde68c3-e2b6-4e3a-b45a-46f06f95f6a6" rel="noopener noreferrer">SQL Server 2012 SP4 Feature Packs</a></li> </ul> <p>Customers running SQL Server 2012 can extend their product support lifecycle by six years with Premium Assurance. <a target="_blank" href="https://www.microsoft.com/en-us/cloud-platform/premium-assurance" rel="noopener noreferrer">Learn more about this option</a> and <a target="_blank" href="http://download.microsoft.com/download/C/5/1/C51D8E55-5538-4F21-8C9D-A66DB31C4B46/SQL_Server_and_Windows_Server_Premium_Assurance_Datasheet.pdf" rel="noopener noreferrer">read the Premium Assurance datasheet</a> to explore this opportunity to stay compliant with minimal disruption.</p> ]]></content:encoded> </item> <item> <title>Taking your data to the cloud is easier than you thought</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/04/taking-your-data-to-the-cloud-is-easier-than-you-thought/</link> <pubDate>Wed, 04 Oct 2017 18:00:07 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=21006</guid> <description><![CDATA[Data management is shifting away from on-premises towards the many benefits of the cloud. Data is the fuel that energizes businesses in today’s marketplace, and the cloud amplifies this energy. The question then arises — what’s the simplest way to take your data to the cloud? In this free webinar, our Azure experts share how... <a aria-label="read more about Taking your data to the cloud is easier than you thought" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/04/taking-your-data-to-the-cloud-is-easier-than-you-thought/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p>Data management is shifting away from on-premises towards the many benefits of the cloud. <a target="_blank" href="https://info.microsoft.com/modernize-to-cloud-whitepaper-registration.html" rel="noopener noreferrer">Data is the fuel that energizes businesses in today’s marketplace</a>, and the cloud amplifies this energy. The question then arises — what’s the simplest way to take your data to the cloud?</p> <p>In this free webinar, our Azure experts share how and why migration to the cloud is now easier, faster, and more cost-effective. Discover how to:</p> <ul> <li>Realize cost savings by preserving your investment in already purchased on-premises licenses.</li> <li>Save four times the investment you made on cores, leverage cloud flexibility for ROI, and uncover other cost savings in your environment.</li> <li>Migrate easily with the new Azure SQL Database Managed Instance, shifting to the cloud without having to rearchitect apps.</li> <li>Prepare for your migration with four important steps.</li> </ul> <p>Tune in to our live webinar, <em><a target="_blank" href="https://info.microsoft.com/modernize-to-cloud-live-webinar-registration.html" rel="noopener noreferrer">Modernize to the cloud in four quick, easy, and cost-effective steps</a></em>, on October 5, 2017, at 10:00 AM Pacific Time (UTC-7) to learn how modernizing your data with the cloud is within your reach. You’ll also get the chance to have your questions answered in real time by our team. <a href="https://info.microsoft.com/modernize-to-cloud-live-webinar-registration.html">Register today</a>.</p> ]]></content:encoded> </item> <item> <title>Analysis Services Innovations in SQL Server 2017</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/analysis-services-innovations-in-sql-server-2017/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/analysis-services-innovations-in-sql-server-2017/#comments</comments> <pubDate>Mon, 02 Oct 2017 18:00:10 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20897</guid> <description><![CDATA[This post was authored by Christian Wade, Senior Program Manager, Microsoft Microsoft SQL Server Analysis Services (SSAS) enables IT professionals to build semantic models over large, integrated managed datasets for end-user consumption. SSAS runs on Windows and is part of the larger suite of SQL Server’s BI offerings. SSAS 2017 brings a host of new... <a aria-label="read more about Analysis Services Innovations in SQL Server 2017" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/analysis-services-innovations-in-sql-server-2017/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p><em>This post was authored by Christian Wade, Senior Program Manager, Microsoft</em></p> <p>Microsoft SQL Server Analysis Services (SSAS) enables IT professionals to build semantic models over large, integrated managed datasets for end-user consumption. SSAS runs on Windows and is part of the larger suite of SQL Server’s BI offerings. SSAS 2017 brings a host of new connectivity and modeling features for comprehensive, enterprise-scale analytic solutions delivering actionable insights.</p> <p>SSAS 2017 introduces the 1400 <a target="_blank" href="https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/compatibility-level-for-tabular-models-in-analysis-services" rel="noopener noreferrer">compatibility level</a>. Here are just some highlights of the new features:</p> <ul> <li>New infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This enables support for a range of additional data sources, and data transformation and mashup capabilities.</li> <li>Support for BI tools such as Microsoft Excel enables drill-down to detailed data from an aggregated report. For example, when end-users view total sales for a region and month, they can view the associated order details.</li> <li>Object-level security to secure table and column names in addition to the data within them.</li> <li>Enhanced support for ragged hierarchies such as organizational charts and chart of accounts.</li> <li>Various other improvements for performance, monitoring, and consistency with the Power BI modeling experience.</li> </ul> <p>To benefit from the new features for models at the 1400 compatibility level, you’ll need to download and install SQL Server Data Tools (SSDT) 17.0 from <a target="_blank" href="https://msdn.microsoft.com/library/mt204009.aspx" rel="noopener noreferrer">documentation</a>.</p> <p>In SSDT, you can select the new 1400 compatibility level when creating new tabular model projects. Alternatively, you can upgrade an existing tabular model by selecting the Model.bim file in Solution Explorer and setting the Compatibility Level to 1400 in the Properties window. Models at the 1400 compatibility level cannot be downgraded to lower compatibility levels.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/solution-explorer.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/solution-explorer.png" alt="" width="493" height="344" class="aligncenter size-full wp-image-20905" /></a></p> <h2>New infrastructure for data connectivity</h2> <p>1400 models introduce a new infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This is based on the similar Power Query functionality in Power BI Desktop and Microsoft Excel 2016. For more information, please refer to the <a target="_blank" href="https://blogs.msdn.microsoft.com/analysisservices/2016/12/16/introducing-a-modern-get-data-experience-for-sql-server-vnext-on-windows-ctp-1-1-for-analysis-services/" rel="noopener noreferrer">Analysis Services Team blog</a>.</p> <h2>Detail Rows</h2> <p>A much-requested feature for tabular models is the ability to define a custom row set contributing to a measure value. Multidimensional models achieve this by using drillthrough and rowset actions. This allows end-users to view information in more detail than the aggregated level.</p> <p>For example, the following PivotTable shows Internet Total Sales by year from the Adventure Works sample tabular model. Users can right-click the cell for 2010 and then select the Show Details menu option to view the detail rows.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/detail-rows.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/detail-rows-403x350.png" alt="" width="403" height="350" class="aligncenter size-mediumlarge wp-image-20915" /></a></p> <p>By default, all the columns in the Internet Sales table are displayed. This behavior is often not meaningful for the user because too many columns may be shown, and the table may not have the necessary columns to show useful information such as customer name and order information.</p> <h3><em>Detail Rows Expression Property for Measures</em></h3> <p>1400 models introduce the Detail Rows Expression property for measures. It allows the modeler to customize the columns and rows returned to the end user. The following example uses the DAX Editor in SSDT to define the columns to be returned for the Internet Total Sales measure.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/dax-editor.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/dax-editor-451x350.png" alt="" width="451" height="350" class="aligncenter size-mediumlarge wp-image-20916" /></a></p> <p>With the property defined and the model deployed, the custom row set is returned when the user selects Show Details. It automatically honors the filter context of the cell that was selected. In this example, only the rows for 2010 value are displayed.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/detail-rows-2.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/detail-rows-2-500x150.png" alt="" width="500" height="150" class="aligncenter size-mediumlarge wp-image-20926" /></a></p> <p>Further information on Detail Rows is available our blog post, <em><a target="_blank" href="https://blogs.msdn.microsoft.com/analysisservices/2016/12/16/whats-new-for-sql-server-vnext-on-windows-ctp-1-1-for-analysis-services/" rel="noopener noreferrer">What’s new for SQL Server vNext on Windows CTP 1.1 for Analysis Services</a>.</em></p> <h2>Object-Level Security</h2> <p>Roles in tabular models support a granular list of permissions, and row-level filters to help protect sensitive data. 1400 models introduce table- and column-level security allowing sensitive table and column names to be protected in addition to the data within them. Collectively these features are referred to as object-level security (OLS).</p> <p>The following example uses the Role Manager in SSDT to protect sensitive employee information. Unauthorized users cannot access the selected columns using client tools like Power BI and Excel Pivot Tables. Additionally, such users cannot query the columns using DAX or MDX, or measures that refer to them.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/role-manager.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/role-manager-416x350.png" alt="" width="416" height="350" class="aligncenter size-mediumlarge wp-image-20935" /></a></p> <p>Further information on OLS is available in a recent post, titled, <em><a target="_blank" href="https://blogs.msdn.microsoft.com/analysisservices/2017/04/19/whats-new-in-sql-server-2017-ctp-2-0-for-analysis-services/" rel="noopener noreferrer">What’s new in SQL Server 2017 CTP 2.0 for Analysis Services</a>.</em></p> <h2>Ragged Hierarchies</h2> <p>Tabular models with previous compatibility levels can be used to model parent-child hierarchies. Hierarchies with a differing number of levels are referred to as <em>ragged hierarchies</em>. An example of a ragged hierarchy is an organizational chart. By default, ragged hierarchies are displayed with blanks for levels below the lowest child. This can look untidy to users, as shown by this organizational chart in Adventure Works:</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/row-labels.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/row-labels.png" alt="" width="377" height="310" class="aligncenter size-full wp-image-20956" /></a></p> <p>1400 models introduce the Hide Members property to correct this. Simply set the Hide Members property to Hide blank members.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/hide-members.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/hide-members.png" alt="" width="362" height="295" class="aligncenter size-full wp-image-20947" /></a></p> <p>With the property set and the model deployed, the more presentable version of the hierarchy is displayed.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/sql.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/sql-500x299.png" alt="" width="334" height="200" class="aligncenter wp-image-20965" /></a></p> <h2>Other Features</h2> <p>Various other features such as the following are introduced with the 1400 compatibility level. For more information, please refer to the Analysis Services Team blogs, <a target="_blank" href="https://blogs.msdn.microsoft.com/analysisservices/2016/12/16/whats-new-for-sql-server-vnext-on-windows-ctp-1-1-for-analysis-services/" rel="noopener noreferrer"><em>What’s new for SQL Server vNext on Windows CTP 1.1 for Analysis Services</em></a> and <a target="_blank" href="https://blogs.msdn.microsoft.com/analysisservices/2017/04/19/whats-new-in-sql-server-2017-ctp-2-0-for-analysis-services/" rel="noopener noreferrer"><em>What’s new in SQL Server 2017 CTP 2.0 for Analysis Services</em></a>.</p> <ul> <li>Transaction-performance improvements for a more responsive developer experience.</li> <li>Dynamic Management View improvements enabling dependency analysis and reporting.</li> <li>Date relationships to easily create relationships to date dimensions based on date columns.</li> <li>DAX enhancements to make DAX more accessible and powerful. These include the IN operator, and table and row constructors.</li> </ul> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/analysis-services-innovations-in-sql-server-2017/feed/</wfw:commentRss> <slash:comments>1</slash:comments> </item> <item> <title>SQL Server 2017 on Windows Linux and Docker is now generally available</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/sql-server-2017-on-windows-linux-and-docker-is-now-generally-available/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/sql-server-2017-on-windows-linux-and-docker-is-now-generally-available/#comments</comments> <pubDate>Mon, 02 Oct 2017 17:22:31 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20985</guid> <description><![CDATA[This post was authored by Travis Wright, Principal Program Manager, SQL Server Engineering Today, October 2nd, we are excited to announce that SQL Server 2017 is generally available for purchase and download! The new release is available right now for evaluation or purchase through the Microsoft Store, and will be available to Volume Licensing customers later... <a aria-label="read more about SQL Server 2017 on Windows Linux and Docker is now generally available" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/sql-server-2017-on-windows-linux-and-docker-is-now-generally-available/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p><em>This post was authored by Travis Wright, Principal Program Manager, SQL Server Engineering</em></p> <p>Today, October 2nd, we are excited to announce that <a target="_blank" href="https://www.microsoft.com/en-us/sql-server/sql-server-2017" rel="noopener noreferrer">SQL Server 2017</a> is generally available for purchase and download! The new release is available right now for <a target="_blank" href="https://www.microsoft.com/en-us/sql-server/sql-server-downloads" rel="noopener noreferrer">evaluation</a> or purchase through the <a target="_blank" href="https://www.microsoft.com/store/autogeodrop?promoid=sqlserver&amp;prod=sqlserver" rel="noopener noreferrer">Microsoft Store</a>, and will be available to Volume Licensing customers later today. Customers now have the flexibility for the first time ever to run industry-leading SQL Server on their choice of Linux, Docker Enterprise Edition-certified containers and, of course, Windows Server. It’s a stride forward for our <a target="_blank" href="https://myignite.microsoft.com/videos/56554" rel="noopener noreferrer">modern and hybrid data platform</a> across on-premises and cloud.</p> <p>In the 18 months since announcing our intent to bring SQL Server to Linux, we’ve been focused on making SQL Server perform and scale to the industry-leading levels customers expect from SQL Server, making SQL Server feel familiar yet native to Linux, and ensuring compatibility between SQL Server on Windows and Linux. With all the enterprise database features you rely on, from Active Directory authentication, to encryption, to Always On availability groups, to record-breaking performance, SQL Server is at parity on Windows and Linux. We have also brought SQL Server Integration Services to Linux so that you can perform data integration just like on Windows. SQL Server 2017 supports Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu.</p> <p style="text-align: center"><iframe width="560" height="315" src="https://www.youtube.com/embed/uxA6VyrgBnk" frameborder="0" allowfullscreen="allowfullscreen"></iframe></p> <p>There are a number of new features for SQL Server that we think make this the best release ever. Here are just a few:</p> <ul> <li><strong>Container support</strong> seamlessly facilitates your development and DevOps scenarios by enabling you to quickly spin up SQL Server containers and get rid of them when you are finished. SQL Server supports Docker Enterprise Edition, Kubernetes and OpenShift container platforms.</li> <li><strong>AI with R and Python analytics</strong> enables you to build intelligent apps using scalable, GPU-accelerated, parallelized R and now Python analytics running in the database.</li> <li><strong>Graph data analysis</strong> will enable customers to use graph data storage and query language extensions for graph-native query syntax in order to discover new kinds of relationships in highly interconnected data.</li> <li><strong>Adaptive Query Processing</strong> is a new family of features in SQL Server that bring intelligence to database performance. For example, Adaptive Memory Grants in SQL Server track and learn from how much memory is used by a given query to right-size memory grants.</li> <li><strong>Automatic Plan Correction</strong> ensures continuous performance by finding and fixing performance regressions.</li> </ul> <p>Above and beyond these top-line features, there are more enhancements that you haven’t heard as much about, but we hope will truly delight you:</p> <ul> <li><strong>Resumable online index rebuild</strong> lets you stop and start index maintenance. This gives you the ability to optimize index performance by re-indexing more frequently – without having to wait for a long maintenance window. It also means you can pick up right where you left off in the event of a disruption to database service.</li> <li><strong>LOB compression in columnstore indexes</strong>. Previously, it was difficult to include data which contained LOBs in a columnstore index due to size. Now those LOBs can be compressed, making LOBs easier to work with and broadening the applicability of the columnstore feature.</li> <li><strong>Clusterless availability groups</strong> enable you to scale out reads by building an Always On availability group without having to use an underlying cluster.</li> <li><strong>Continued improvement to key performance features</strong> such as columnstore, in-memory OLTP, and the query optimizer to drive new <a target="_blank" href="http://rhelblog.redhat.com/2017/04/19/microsoft-red-hat-hpe/" rel="noopener noreferrer">record-setting performance</a>. We’ll share some even more exciting perf and scale numbers soon!</li> <li><strong>Native scoring in T-SQL</strong> lets you score operational data using advanced analytics in near real-time because you don’t have to load the Machine Learning libraries to access your model.</li> <li><strong>SQL Server Integration Services (SSIS) scale-out</strong> enables you to speed package execution performance by distributing execution to multiple machines. These packages are executed in parallel, in a scale-out mode.</li> <li>Many <a target="_blank" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/analysis-services-innovations-in-sql-server-2017/" rel="noopener noreferrer"><strong>enhancements were made to SQL Server Analysis Services</strong></a> including: <ul> <li>Modern “get data” experience with a number of new connectors like Oracle, MySQL, Sybase, Teradata, and more to come. New transformations enable mashing up of the data being ingested into tabular models.</li> <li>Object-level security for tables and columns.</li> <li>Detail rows and ragged hierarchies support, enabling additional drill-down capabilities for your tabular models.</li> </ul> </li> <li><strong>Enhancements were made to SQL Server Reporting Services</strong> as well, including: <ul> <li>Lightweight installer with zero impact on your SQL Server databases or other SQL Server features.</li> <li>REST API for programmatic access to reports, KPIs, data sources, and more.</li> <li>Report comments, enabling users to engage in discussion about reports.</li> </ul> </li> </ul> <p>In addition to the ability to upgrade existing SQL Server to 2017, there are a few more benefits to renewing your software assurance:</p> <ul> <li><strong>Machine Learning Server for Hadoop</strong>, formerly R Server, brings R and Python based, scalable analytics to Hadoop and Spark environments, and it is now available to SQL Server Enterprise edition customers as a Software Assurance benefit.</li> <li>SQL Server Enterprise Edition Software Assurance benefits also enable you to run <strong>Power BI Report Server</strong>. Power BI Report Server enables self-service BI and enterprise reporting, all in one solution by allowing you to manage your SQL Server Reporting Services (SSRS) reports alongside your Power BI reports. Power BI Report Server is also included with the purchase of Power BI Premium.</li> <li>Lastly, but importantly, we are also modernizing how we service SQL Server. Please see our release management blog for all the details on <a target="_blank" href="https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-the-modern-servicing-model-for-sql-server/" rel="noopener noreferrer">what to expect for servicing SQL Server 2017 and beyond</a>.</li> </ul> <p>Thanks for joining us on this journey to SQL Server 2017. We hope you love it! Going forward, we will continue to invest in our cloud-first development model, to ensure that the pace of innovation stays fast, and that we can bring you even more and improved SQL Server features soon.</p> <p>Here are a few links to get started:</p> <ul> <li><a target="_blank" href="http://www.microsoft.com/sqlserver2017" rel="noopener noreferrer">Learn more about SQL Server 2017</a></li> <li><a target="_blank" href="https://myignite.microsoft.com/sessions/54946" rel="noopener noreferrer">Watch the SQL Server 2017 Deep Dive from Microsoft Ignite 2017</a></li> <li><a target="_blank" href="https://myignite.microsoft.com/videos/56554" rel="noopener noreferrer">Learn about Microsoft’s hybrid data platform strategy from on-premises to cloud</a></li> <li><a target="_blank" href="https://www.microsoft.com/en-us/sql-server/sql-server-downloads" rel="noopener noreferrer">Download a SQL Server 2017 trial evaluation for Windows, Linux or Docker</a></li> <li><a target="_blank" href="https://ms.portal.azure.com/#blade/Microsoft_Azure_Marketplace/GalleryFeaturedMenuItemBlade/selectedMenuItemId/home/searchQuery/SQL%20Server%202017" rel="noopener noreferrer">Create a SQL Server 2017 Azure virtual machine</a></li> </ul> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/sql-server-2017-on-windows-linux-and-docker-is-now-generally-available/feed/</wfw:commentRss> <slash:comments>10</slash:comments> </item> </channel> </rss>