Breakthrough performance for analytics at an industry leading price
The Microsoft Analytics Platform System can meet the demands of your evolving data warehouse environment with its scale-out, massively parallel processing integrated system supporting hybrid data warehouse scenarios. It provides the ability to query across relational and non-relational data by leveraging Microsoft PolyBase and industry-leading big data technologies. It offers the lowest price per terabyte for large data warehouse workloads.
Read the Analytics Platform System datasheetBenefits
- Up to 100x performance gains over legacy data warehouses
- Relational and non-relational data in one appliance
- Seamless integration of the relational data warehouse and Hadoop with PolyBase
- Linear scale-out to 6 petabytes of user data capacity
- The lowest price per terabyte for a data warehouse appliance in the industry
CHI Institute for Research and Innovation.
With the Microsoft Analytics Platform System’s huge parallel environment, we not only can process but also comprehend large numbers of healthcare records. There is a huge amount of transformation required to integrate and bring this data together at the database level.
Read the case study
Umniah belong.
Business reports are now fired out to managers in minutes rather than days. By combining leading-edge parallel data warehousing capability with a complete refresh of the company’s business reporting and Business Intelligence (BI) resources.
Read the case study
<?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>Thu, 05 Oct 2017 22:47:28 +0000</lastBuildDate>
<language>en-US</language>
<sy:updatePeriod>hourly</sy:updatePeriod>
<sy:updateFrequency>1</sy:updateFrequency>
<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>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/05/sql-server-2012-service-pack-4-is-now-available/#respond</comments>
<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>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/05/sql-server-2012-service-pack-4-is-now-available/feed/</wfw:commentRss>
<slash:comments>0</slash:comments>
</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>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/04/taking-your-data-to-the-cloud-is-easier-than-you-thought/#respond</comments>
<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>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/04/taking-your-data-to-the-cloud-is-easier-than-you-thought/feed/</wfw:commentRss>
<slash:comments>0</slash:comments>
</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/#respond</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>0</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&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>8</slash:comments>
</item>
<item>
<title>View on-demand: Microsoft Data Platform – SQL Server 2017 and Azure Data Services</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/29/view-on-demand-microsoft-data-platform-sql-server-2017-and-azure-data-services/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/29/view-on-demand-microsoft-data-platform-sql-server-2017-and-azure-data-services/#respond</comments>
<pubDate>Fri, 29 Sep 2017 16:00:12 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20885</guid>
<description><![CDATA[Did we miss you at Microsoft Ignite in Orlando this year? That’s OK! You can still stream the Data General Session, Microsoft Data Platform – SQL Server 2017 and Azure Data Services on-demand. In this session Rohan Kumar, General Manager, Data Systems Group, discusses all the latest news — from upcoming SQL Server 2017 general... <a aria-label="read more about View on-demand: Microsoft Data Platform – SQL Server 2017 and Azure Data Services" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/29/view-on-demand-microsoft-data-platform-sql-server-2017-and-azure-data-services/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p>Did we miss you at Microsoft Ignite in Orlando this year? That’s OK! You can still stream the Data General Session, <a target="_blank" href="https://myignite.microsoft.com/videos/56554" rel="noopener noreferrer">Microsoft Data Platform – SQL Server 2017 and Azure Data Services</a> on-demand.</p>
<p style="text-align: center"><iframe width="560" height="315" src="https://www.youtube.com/embed/hcTFYefWCso" frameborder="0" allowfullscreen="allowfullscreen"></iframe></p>
<p>In this session Rohan Kumar, General Manager, Data Systems Group, discusses all the latest news — from upcoming SQL Server 2017 general availability, to the new Azure Hybrid Benefit for SQL Server, to serverless computing with Azure Cosmos DB and Azure Functions. Hear how to take your SQL Server Integration Services to the cloud with Azure Data Factory’s new hybrid functionality, plus learn about the latest performance and scale enhancements for Azure Data Services. This 75-minute session is packed with demonstrations and customer testimonials from the likes of ASOS, Caradigm, and dv01.</p>
<p>Join us now:</p>
<ul>
<li>Watch the <a target="_blank" href="https://myignite.microsoft.com/videos/56554" rel="noopener noreferrer">Data Platform general session on SQL Server 2017 and Azure Data Services</a></li>
<li>See other <a target="_blank" href="https://myignite.microsoft.com/videos/" rel="noopener noreferrer">Microsoft Ignite 2017 sessions on-demand</a></li>
<li><a target="_blank" href="https://www.microsoft.com/en-us/sql-server/sql-server-2017" rel="noopener noreferrer">Learn more about SQL Server 2017</a></li>
</ul>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/29/view-on-demand-microsoft-data-platform-sql-server-2017-and-azure-data-services/feed/</wfw:commentRss>
<slash:comments>0</slash:comments>
</item>
<item>
<title>Enhancing query performance with Adaptive Query Processing in SQL Server 2017</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/28/enhancing-query-performance-with-adaptive-query-processing-in-sql-server-2017/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/28/enhancing-query-performance-with-adaptive-query-processing-in-sql-server-2017/#respond</comments>
<pubDate>Thu, 28 Sep 2017 17:00:33 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20816</guid>
<description><![CDATA[This post was authored by Joe Sack, Principal Program Manager, Data Systems Group, Microsoft SQL Server 2017 and Azure SQL Database introduce a new generation of query processing improvements that will adapt optimization strategies to your application workload’s runtime conditions. For this first version of this adaptive query processing feature family, we have three new... <a aria-label="read more about Enhancing query performance with Adaptive Query Processing in SQL Server 2017" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/28/enhancing-query-performance-with-adaptive-query-processing-in-sql-server-2017/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p><em>This post was authored by Joe Sack, Principal Program Manager, Data Systems Group, Microsoft</em></p>
<p>SQL Server 2017 and Azure SQL Database introduce a new generation of query processing improvements that will adapt optimization strategies to your application workload’s runtime conditions. For this first version of this <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/adaptive-query-processing" rel="noopener noreferrer">adaptive query processing</a> feature family, we have three new improvements: <a target="_blank" href="https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/04/19/introducing-batch-mode-adaptive-joins/" rel="noopener noreferrer">batch mode adaptive joins</a>, <a target="_blank" href="https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/11/29/introducing-batch-mode-adaptive-memory-grant-feedback/" rel="noopener noreferrer">batch mode memory grant feedback</a>, and<a href="https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/04/19/introducing-interleaved-execution-for-multi-statement-table-valued-functions/"> interleaved execution for multi-statement table</a> valued functions.</p>
<p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/aqp.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/aqp-500x199.png" alt="" width="500" height="199" class="aligncenter size-mediumlarge wp-image-20825" /></a></p>
<h2>Legacy optimization behavior</h2>
<p>During optimization, the cardinality estimation process is responsible for estimating the number of rows processed at each step in an execution plan. Cardinality estimation uses a combination of statistical techniques and assumptions and when estimates are accurate (enough), we make informed decisions around the order of operations and physical algorithm selection.</p>
<p>When estimates are <em>inaccurate</em>, the query optimizer may make poor decisions regarding algorithm selection and order of operations. The cost of incorrect estimates can result in:</p>
<ul>
<li>Slow query response time due to inefficient plans</li>
<li>Excessive resource utilization (CPU, Memory, IO)</li>
<li>Spills to disk due to insufficient memory grant requests</li>
<li>Reduced throughput and concurrency due to excessive memory grant sizes</li>
</ul>
<p>There are several reasons why incorrect cardinality estimates occur, from missing or stale statistics to inadequate statistics sample rates, bad parameter sniffing scenarios or cases where SQL Server does not have visibility to cardinality estimates and must make fixed-estimate guesses (e.g. multi-statement table valued functions, table variables, XQuery references).</p>
<p>Prior to SQL Server 2017, if we make poor assumptions due to bad cardinality estimates, we do not change our query plan execution strategy during execution.</p>
<h2>Adapting to your workloads</h2>
<p>The new adaptive query processing feature family in SQL Server 2017 and Azure SQL Database introduces three new techniques for adapting to your application workload characteristics.</p>
<h3>Batch Mode Adaptive Joins</h3>
<p>The query optimizer has three physical operator options for processing a join operation: nested loop, merge, and hash match. Which algorithm is appropriate or necessary, is highly dependent on the cardinality estimates of the join inputs. If we have inaccurate input cardinality estimates, this can result in the selection of an inappropriate join algorithm.</p>
<p>The new <strong>batch mode adaptive join</strong> feature enables the choice of a hash join or nested loop join method to be deferred until <em>after</em> the first input has been scanned. The adaptive join operator defines a threshold that is used to decide when to switch to a nested loop plan. Your plan can then dynamically switch to a better join strategy during execution using a single cached plan.</p>
<p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/batch-mode-adaptive-join.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/batch-mode-adaptive-join.png" alt="" width="342" height="255" class="aligncenter wp-image-20826" /></a></p>
<h3>Batch Mode Memory Grant Feedback</h3>
<p>A query’s execution plan in SQL Server includes the minimum required memory needed for execution and the ideal memory grant size to have all rows fit in memory. When memory grant sizes are inadequate or excessive, performance suffers. Excessive grants result in wasted memory and reduced concurrency. Insufficient memory grants cause expensive spills to disk.</p>
<p>Addressing repeating workloads, batch mode memory grant feedback recalculates the actual memory required for a query and then updates the grant value for the cached plan. When an identical query statement is executed, the query uses the revised memory grant size, reducing excessive memory grants that impact concurrency and fixing underestimated memory grants that cause expensive spills to disk.</p>
<p>Inadequate grant scenario:</p>
<p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/InadequateGrantScenario.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/InadequateGrantScenario-500x174.png" alt="" width="500" height="174" class="aligncenter size-mediumlarge wp-image-20865" /></a></p>
<p> </p>
<p>Excessive grant scenario:</p>
<p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/excessive-scenario.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/excessive-scenario-500x169.png" alt="" width="500" height="169" class="aligncenter size-mediumlarge wp-image-20837" /></a></p>
<h3>Interleaved execution for multi-statement table valued functions</h3>
<p>Interleaved execution for multi-statement table valued functions (MSTVFs) changes the unidirectional boundary between the optimization and execution phases for a single-query execution and enables plans to adapt based on the revised cardinality estimates. During optimization, if we encounter a candidate for interleaved execution, which for SQL Server 2017 is currently multi-statement table valued functions (MSTVFs), we will pause optimization, execute the applicable subtree, capture accurate cardinality estimates, and then resume optimization for downstream operations.</p>
<p>MSTVFs have a fixed cardinality guess of “100” in SQL Server 2014 and SQL Server 2016, and an estimate of “1” for earlier versions.</p>
<p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/pre-2017.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/pre-2017.png" alt="" width="256" height="192" class="aligncenter wp-image-20845" /></a></p>
<p>Interleaved execution helps workload performance issues that are due to these fixed cardinality estimates associated with multi-statement table valued functions. With interleaved execution, we will use the actual row counts from the MSTVF to make plan optimizations downstream from the MSTVF references. The result is a better-informed plan based on actual workload characteristics.</p>
<p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/2017.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/2017-500x191.png" alt="" width="440" height="168" class="aligncenter wp-image-20846" /></a></p>
<h3>Enabling adaptive query processing</h3>
<p>Adaptive query processing is enabled in SQL Server 2017 and Azure SQL Database under compatibility level 140. To learn more about this compatibility level, see <a target="_blank" href="https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/07/07/public-preview-of-compatibility-level-140-for-azure-sql-database/" rel="noopener noreferrer">Public Preview of Compatibility Level 140 for Azure SQL Database</a>.</p>
<h3>Learning more about adaptive query processing</h3>
<p>For a comprehensive overview of all three features, see the Books Online topic <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/adaptive-query-processing#interleaved-execution-for-multi-statement-table-valued-functions" rel="noopener noreferrer">Adaptive query processing in SQL databases</a>.</p>
<p>To see the adaptive query processing feature family in-action, see the video interview with Scott Klein on Channel 9:</p>
<p><iframe width="960" height="540" src="https://channel9.msdn.com/Shows/Data-Exposed/SQL-Server-2017-Adaptive-QP/player" allowfullscreen="allowfullscreen" frameborder="0"></iframe></p>
<h2>Just getting started</h2>
<p>We have several other opportunities in the query processing space to further add and enhance workload-adaptation mechanisms and strategies. Continued investment in the adaptive query processing feature family will help support and meet the requirements of a wide range of workload characteristics, from high-throughput transaction processing workloads to petabyte-scale relational data warehousing databases. Have feedback related to the query processor or other areas in SQL Server? If so, please submit feedback via the <a target="_blank" href="https://connect.microsoft.com/sql/feedback" rel="noopener noreferrer">Microsoft Connect</a> website.</p>
<p> </p>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/28/enhancing-query-performance-with-adaptive-query-processing-in-sql-server-2017/feed/</wfw:commentRss>
<slash:comments>0</slash:comments>
</item>
<item>
<title>SQL Server 2017: Fast, faster, and the fastest database everywhere you need it</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/27/sql-server-2017-fast-faster-and-the-fastest-database-everywhere-you-need-it/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/27/sql-server-2017-fast-faster-and-the-fastest-database-everywhere-you-need-it/#comments</comments>
<pubDate>Wed, 27 Sep 2017 14:00:44 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<category><![CDATA[performance]]></category>
<category><![CDATA[SQL Server 2017]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20716</guid>
<description><![CDATA[This post was authored by Bob Ward, Principal Architect, Database Systems Group “I feel the need, the need for speed”. That is a quote from the character Maverick, played by Tom Cruise, in one of my favorite movies, Top Gun. It makes me think of one of the top reasons why someone chooses a database... <a aria-label="read more about SQL Server 2017: Fast, faster, and the fastest database everywhere you need it" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/27/sql-server-2017-fast-faster-and-the-fastest-database-everywhere-you-need-it/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p><em>This post was authored by Bob Ward, Principal Architect, Database Systems Group</em></p>
<p>“I feel the need, the need for speed”. That is a quote from the character Maverick, played by Tom Cruise, in one of my favorite movies, Top Gun. It makes me think of one of the top reasons why someone chooses a database engine. It must be fast and perform to the needs of all types of workloads accessing data.</p>
<p>SQL Server 2017 sets the standard when it comes to speed and performance. Based on the incredible work of SQL Server 2016 (See the blog series <a target="_blank" href="https://blogs.msdn.microsoft.com/bobsql/tag/it-just-runs-faster/" rel="noopener noreferrer">It Just Runs Faster</a>), <em><strong>SQL Server 2017</strong></em> <em><strong>is fast: built-in, simple, and online</strong></em>. Maybe you caught my presentation at Microsoft Ignite where I demonstrated 1 million transactions per minute on <em>my laptop</em> using the popular tool HammerDB¹ by simply installing SQL Server out of the box with no configuration changes (with the HammerDB client and SQL Server on the same machine!)</p>
<p>Consider for a minute all the built-in capabilities that power the speed of SQL Server. From a SQLOS scheduling engine that minimizes OS context switches to read-ahead scanning to automatic scaling as you add NUMA and CPUs. And we parallelize everything! From queries to indexes to statistics to backups to recovery to background threads like LogWriter. We partition and parallelize our engine to scale from your laptop to the biggest servers in the world.</p>
<p>Like the enhancements we made as described in <em>It Just Runs Faster,</em> in SQL Server 2016, we are always looking to tune our engine for speed, all based on customer experiences. Take, for example, <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/logs/database-checkpoints-sql-server" rel="noopener noreferrer">indirect checkpoint</a>, which is designed to provide a more predictable recovery time for a database. We boosted scalability of this feature based on customer feedback. We also made scalability improvements for parallel scanning and consistency check performance. No knobs required. Just built-in for speed.</p>
<p>One of the coolest performance aspects to built-in speed is online operations. We know you need to perform other maintenance tasks than just run queries, but keep your application up and running, so we support online backups, consistency checks, and index rebuilds. SQL Server 2017 enhances this functionality with <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/indexes/guidelines-for-online-index-operations" rel="noopener noreferrer">resumable online index</a> builds allowing you to pause an index build and resume it at any time (even after a failure).</p>
<p><em><strong>SQL Server 2017</strong><strong> is faster than you think</strong></em>. SQL Server 2017 was designed from the beginning to run fast on popular Linux distributions such as Red Hat Enterprise Linux, SUSE Linux Enterprise, and Ubuntu whether that is on your server or a Docker Container. Don’t believe it? Check out our <a target="_blank" href="http://rhelblog.redhat.com/2017/04/19/microsoft-red-hat-hpe/" rel="noopener noreferrer">world record 1TB TPC-H benchmark result (non-clustered) for SQL Server on Red Hat Enterprise Linux</a>. Even though this is our first release on Linux, we know how to configure and run SQL Server on Linux for maximum speed. Read our <a target="_blank" href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-performance-best-practices" rel="noopener noreferrer">best practices guide</a> for performance settings on Linux in our documentation. We know it performs well because our customers tell us. Read the amazing <a target="_blank" href="https://customers.microsoft.com/en-us/story/dv01" rel="noopener noreferrer">story of dv01</a> and how SQL Server on Linux exceeded their performance expectations as they migrated from PostgreSQL</p>
<p>One of the key technologies to achieve a result like this is <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview" rel="noopener noreferrer">columnstore indexes</a>. This is one of the most powerful features of SQL Server for high-speed analytic queries and large databases. Columnstore indexes boost performance by organizing columnar data in a new way than traditional indexes, compressing data to reduce memory and disk footprint, filtering scans automatically through rowgroup elimination and processing queries in batches. SQL Server runs at warp speed for data warehouses and columnstore is the fuel. At Microsoft Ignite, I demonstrated how columnstore indexes can make PowerBI with Direct Query against SQL Server faster handling the self-service, ad-hoc nature of PowerBI queries.</p>
<p>SQL Server also excels at transaction processing, the heart of many top enterprise workloads. Got RAM? Not only does columnstore use in-memory technologies to achieve speed, but our <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/in-memory-oltp-in-memory-optimization" rel="noopener noreferrer">In-Memory OLTP</a> feature focuses on optimized access to memory-optimized tables. This feature is named OLTP, but it can be so much more. ETL staging tables, IoT workloads, table types (no more tempdb!), and “caching” tables. One of our customers was able to get a throughput of <a target="_blank" href="https://blogs.msdn.microsoft.com/sqlcat/2016/10/26/how-bwin-is-using-sql-server-2016-in-memory-oltp-to-achieve-unprecedented-performance-and-scale/" rel="noopener noreferrer">1.2M batch requests/sec</a> using SCHEMA_ONLY memory-optimized tables. To really boost transaction processing, also consider using SQL Server’s support for Persistent Memory (NVDIMM-N) and our <a target="_blank" href="https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/12/02/transaction-commit-latency-acceleration-using-storage-class-memory-in-windows-server-2016sql-server-2016-sp1/" rel="noopener noreferrer">optimization for transaction log</a> (get ready for WRITELOG waits = 0!) performance. SQL Server 2017 supports any Persistent Memory technology supported on Windows Server 2016 and later releases.</p>
<p>Many customers I talk to have great performance when they first deploy SQL Server and their application. Keeping SQL Server fast and tuned is more of the challenge. SQL Server 2017 comes with features to <em><strong>keep you fast and tuned</strong></em> automatically and adaptively. Our Query Processing engine has all types of capabilities to create and build query plans to maximize the performance of your queries. We have created a new <em>feature family</em> in SQL Server 2017 to make it smarter, called <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/adaptive-query-processing" rel="noopener noreferrer">Adaptive Query Processing</a>. Imagine running a query that is not quite the speed you expect because of insufficient memory grants (which is a thorn in the side of many SQL Server users, as it can lead to a spill to tempdb). With Adaptive Query Processing, future executions of this query will have a corrected calculated memory grant avoiding the spill, all without requiring a recompilation of the query plan. Adaptive Query Processing handles other scenarios such as adaptive joins and interleaved execution of Table Valued Functions.</p>
<p>Another way to keep you tuned is the amazing feature we added in SQL Server 2016 called <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store" rel="noopener noreferrer">Query Store</a>. Query Store provides built-in capabilities to track and analyze query performance all stored in your database. For SQL Server 2017, we made tuning adjustments to Query Store to make it more efficient based on learnings in our Azure SQL Database service where Query Store is enabled for millions of databases. We added wait statistics so now you have an end-to-end picture of query performance. Perhaps though the most compelling enhancement in SQL Server 2017 is <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/automatic-tuning/automatic-tuning" rel="noopener noreferrer">Automatic Tuning</a>. Parameter Sniffing got you down? Automatic Tuning uses Query Store to detect query plan regressions and automatically forces a previous plan that used to run fast. What I love about this feature is that even if you don’t have it turned on, you can see recommendations it has detected about plan regressions. Then you can either manually force plans that you feel have regressed or turn on the feature to have SQL Server do it for you.</p>
<p>SQL Server 2017 is the <em><strong>fastest database everywhere</strong></em> you need it. Whether it is your laptop, in your private cloud, or in our Azure public cloud infrastructure. Whether it is running on Linux, Windows, or Docker Containers, we have the speed to power any workload your application needs.</p>
<p>As I mentioned above, back in April, we announced our <a target="_blank" href="http://rhelblog.redhat.com/2017/04/19/microsoft-red-hat-hpe/" rel="noopener noreferrer">world record TPC-H 1TB data warehousing workload (non-clustered) for SQL Server 2017</a> running on a HPE ProLiant DL380 Gen9 using RedHat Enterprise Linux².</p>
<p>Perhaps you missed the announcement in June of 2017, of a <a target="_blank" href="https://lenovopress.com/lp0720-sr950-tpch-benchmark-result-2017-07-11" rel="noopener noreferrer">new world record TPC-E benchmark result</a>³ on SQL Server 2017 on Windows Server 2016 running on a Lenovo ThinkSystem SR650 continuing to demonstrate our leadership in database performance. This benchmark running on a 2 socket system using <a target="_blank" href="https://www.intel.com/content/www/us/en/processors/xeon/scalable/xeon-scalable-platform.html" rel="noopener noreferrer">Intel’s Xeon Scalable Processors</a> has set a new standard for price and performance, becoming the first TPC-E benchmark result ever to be under $100/tpsE.</p>
<p>We continued to show our proven speed for analytics by announcing in July of 2017 a <a target="_blank" href="https://lenovopress.com/lp0720-sr950-tpch-benchmark-result-2017-07-11" rel="noopener noreferrer">new TPC-H 10TB (non-clustered) world record benchmark result</a><sup>4 </sup>of <strong>1,336,109 QppH</strong> on Windows Server 2016 using a Lenovo ThinkSystem SR950 system with 6TB RAM and 224 logical CPUs.</p>
<p>While benchmarks can show the true speed of SQL Server, we believe it can perform well with your workload and maximize the computing power of your server. Perhaps you caught the session at Ignite where my colleague Travis Wright showed how we can scan a 180 Billion row table (from a 30TB database) in our labs in under 20 seconds powering 480 CPUs to 100% capacity. And if you don’t believe SQL Server is deployed in some of the biggest installations and servers in the world, I recently polled some of our field engineers, SQL Customer Advisor Team, and MVPs asking them for their largest SQL Server deployments. Over 30 people responded, and the <em>average</em> footprint of these installations was 3TB+ RAM on machines with 128 physical cores. Keep in mind that SQL Server on can theoretically scale to 24TB RAM on Windows and 64TB on Linux. And it supports the maximum CPUs of those systems (64 sockets with unlimited cores on Windows and 5120 logical CPUs on Linux). Look for more practical and fun demonstrations of the speed of SQL Server in the future.</p>
<p>It could be that you are consolidating your deployments and want to run SQL Server using Azure Virtual Machine, but not sure if the capacity is there for your performance needs. Consider that Azure Virtual machine has the new <a target="_blank" href="https://docs.microsoft.com/en-us/azure/virtual-machines/linux/sizes-memory#m-series" rel="noopener noreferrer">M-Series</a>, which supports up to 128 vCPUs, 2TB RAM, and 64 Data Disks with a capacity of 160,000 IOPS. It could be that in your environment you want to scale out your read workload with Availability Group secondary replicas but don’t want to invest in Failover Clustering. SQL Server 2017 introduces the capability of <a target="_blank" href="https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/read-scale-availability-groups#read-scale-availability-groups-without-cluster" rel="noopener noreferrer">read-scale availability groups</a> <em>without clustering</em> supported both on Windows and Linux. Two other very nice performance features new to SQL Server 2017 are <a target="_blank" href="https://docs.microsoft.com/en-us/sql/integration-services/scale-out/integration-services-ssis-scale-out" rel="noopener noreferrer">SSIS Scale Out</a>, for those with data loading needs, and <a target="_blank" href="https://docs.microsoft.com/en-us/sql/advanced-analytics/r/how-to-do-realtime-scoring" rel="noopener noreferrer">native scoring</a>, which integrates machine learning algorithms into the SQL Server engine for maximum performance.</p>
<p>SQL Server 2017 brings to the database market a unique set of features and speed. A database engine that is fast, built-in with the power to scale, and even faster when taking advantage of technologies like columnstore Indexes and In-Memory OLTP. An engine that provides automation and adapts to keep you fast and tuned. And the fastest database everywhere you need it.</p>
<p>Stay tuned for future blog posts providing more details on SQL Server performance both on this blog and the <a target="_blank" href="http://aka.ms/bobsql" rel="noopener noreferrer">bobsql blog</a>.</p>
<h3>Resources</h3>
<ul>
<li><em>¹<a target="_blank" href="http://www.hammerdb.com/" rel="noopener noreferrer">HammerDB</a> is an open-source performance tool. The demo and results shown are not official TPC benchmark results and all testing was done with a workload derived from the TPC-C benchmark.</em></li>
<li><em>²1TB TPC-H benchmark result: <a target="_blank" href="https://community.hpe.com/t5/Servers-The-Right-Compute/Microsoft-SQL-Server-Linux-and-HPE-Performance-Benchmark-Love/ba-p/6960184#.WbrMaciGNPY" rel="noopener noreferrer">Hewlett Packard Enterprise</a>; <a target="_blank" href="http://www.tpc.org/3327" rel="noopener noreferrer">TPC</a>, as of September 27th, 2017.</em></li>
<li><em>³TPC-E benchmark result: <a target="_blank" href="https://lenovopress.com/lp0708-sr650-tpce-benchmark-result-2017-07-11" rel="noopener noreferrer">Lenovo Press</a>; <a target="_blank" href="http://www.tpc.org/4080" rel="noopener noreferrer">TPC</a> as of September 27, 2017.</em></li>
<li><em><sup>4</sup>10TB TPC-H benchmark result: <a target="_blank" href="https://lenovopress.com/lp0720-sr950-tpch-benchmark-result-2017-07-11" rel="noopener noreferrer">Lenovo Press</a>; <a target="_blank" href="http://www.tpc.org/3328" rel="noopener noreferrer">TPC</a>, as of September 27, 2017.</em></li>
</ul>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/27/sql-server-2017-fast-faster-and-the-fastest-database-everywhere-you-need-it/feed/</wfw:commentRss>
<slash:comments>4</slash:comments>
</item>
<item>
<title>In-database Machine Learning in SQL Server 2017</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/26/in-database-machine-learning-in-sql-server-2017/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/26/in-database-machine-learning-in-sql-server-2017/#comments</comments>
<pubDate>Tue, 26 Sep 2017 16:30:51 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20797</guid>
<description><![CDATA[This post is authored by Sumit Kumar, Senior Program Manager, Microsoft and Nellie Gustafsson, Program Manager, Microsoft We are excited to announce the general availability of SQL Server 2017 and Machine Learning Services. You can start using Python-based in-database Machine Learning Services for production usage now. With support for both R and Python, we have... <a aria-label="read more about In-database Machine Learning in SQL Server 2017" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/26/in-database-machine-learning-in-sql-server-2017/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p><em>This post is authored by Sumit Kumar, Senior Program Manager, Microsoft and Nellie Gustafsson, Program Manager, Microsoft</em></p>
<p>We are excited to announce the general availability of SQL Server 2017 and Machine Learning Services. You can start using Python-based in-database Machine Learning Services for production usage now. With support for both R and Python, we have rebranded ‘R Services’ to ‘Machine Learning Services’. SQL Server now supports the three most <a target="_blank" href="http://www.kdnuggets.com/2017/05/poll-analytics-data-science-machine-learning-software-leaders.html" rel="noopener noreferrer">popular</a> data science languages and enables you to use the latest AI and ML packages from the open source world in-database, across ALL editions on Windows – making SQL Server 2017 the commercial database with built-in AI.</p>
<p>As we have covered in previous <a target="_blank" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/19/python-in-sql-server-2017-enhanced-in-database-machine-learning/" rel="noopener noreferrer">posts</a>, there are many advantages of using this technology, such as the elimination of data movement, ease of deployment, improved security and better scale and performance. These abilities make SQL Server a powerful enterprise platform for machine learning. Examples of what some customers have built using Machine Learning Services:</p>
<ul>
<li><a target="_blank" href="https://customers.microsoft.com/en-US/story/pros" rel="noopener noreferrer">Pricing optimization</a> models</li>
<li>Predictive analytics solutions to gain <a target="_blank" href="https://customers.microsoft.com/en-us/story/transforming-real-estate-data-services-with-hybrid-cloud-technologies" rel="noopener noreferrer">real-estate property insights</a></li>
<li>Better and more accurate models for <a target="_blank" href="https://customers.microsoft.com/en-us/story/acxiom-corporation" rel="noopener noreferrer">more precisely targeted marketing</a></li>
<li><a target="_blank" href="https://customers.microsoft.com/en-US/story/heartlandbank" rel="noopener noreferrer">Financial models</a> for banking</li>
</ul>
<h2>In-database Python integration</h2>
<p>With the full support of in-database Python in SQL Server <a target="_blank" href="https://docs.microsoft.com/en-us/sql/advanced-analytics/what-s-new-in-sql-server-machine-learning-services" rel="noopener noreferrer">Machine Learning Services</a> in SQL Server 2017, the vast population of Python developers and ML practitioners can now leverage the power of SQL Server alongside their Python code. And the SQL Server developers now have access to the extensive Python ML and AI libraries from the open source ecosystem along with the latest innovations from Microsoft (<em>revoscalepy</em> and <em>microsoftml</em> libraries) for developing intelligent applications with in-database analytics.</p>
<h3><em>Python operationalization with T-SQL</em></h3>
<p>Full Python integration with the sp_execute_external_script <a target="_blank" href="https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql" rel="noopener noreferrer">infrastructure</a> in SQL Server enables the enterprise-grade operationalization of Python models and scripts as simple stored procedures.</p>
<p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/application-developer.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/application-developer-1024x535.png" alt="" width="879" height="459" class="aligncenter size-large wp-image-20785" /></a></p>
<p>Streaming data from SQL to Python processes and MPI ring parallelization support provides much-improved performance to the Python scripts.</p>
<h3><em>Python remote </em>compute<em> in SQL Server</em></h3>
<p>With the SQL Server remote compute context, data scientists and developers can push the compute of Python code to the server from their development environments, to explore data and develop models without the need to move data.</p>
<p><a href="https://msdnshared.blob.core.windows.net/media/2017/09/data-scientists.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/09/data-scientists-1024x531.png" alt="" width="879" height="456" class="aligncenter size-large wp-image-20786" /></a></p>
<p>In-database Python integration is not limited to just machine learning and AI solutions – it is equally useful for general purpose data analysis work by combining Python and SQL in powerful ways; leveraging strengths of respective languages.</p>
<h2>Orders of magnitude faster scoring</h2>
<p>After <a target="_blank" href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/10/11/1000000-predictions-per-second/" rel="noopener noreferrer">demonstrating</a> industry leading 1 million+ rows/sec batch scoring performance, we are now introducing <a target="_blank" href="https://docs.microsoft.com/en-us/sql/advanced-analytics/sql-native-scoring" rel="noopener noreferrer">Native Scoring</a> for even faster prediction! Some concurrent prediction scenarios require close to real-time response times. Models trained using the RevoScaleR and revoscalepy packages are supported by this new PREDICT verb (a system table value function) which makes it easy to embed this performant scoring functionality in regular T-SQL SELECT statements without invoking the R or Python runtime. Native scoring is also available on SQL Server on Linux.</p>
<p><a target="_blank" href="https://docs.microsoft.com/en-us/sql/advanced-analytics/real-time-scoring" rel="noopener noreferrer">Real-time scoring</a> is also available to SQL Server 2016 customers on upgrading in-database R to the latest release of Microsoft Machine Learning Server.</p>
<h2>Improving R package management in SQL Server</h2>
<p>One of the key values of R is its vibrant community with thousands of open source packages. We have further improved the <a href="https://docs.microsoft.com/en-us/sql/advanced-analytics/r/r-package-management-for-sql-server-r-services">R package management</a> in SQL Server. We have a rich set of R functions to do package management in SQL Server that gives users the ability to install, uninstall and manage packages in various roles and scopes. In addition, it is now possible to install R packages on SQL Server using TSQL commands (CREATE EXTERNAL LIBRARY). This approach ensures availability of the previously installed packages when a server fails over.</p>
<h2>Machine Learning Server</h2>
<p>Along with the general availability of SQL Server 2017, we have also <a target="_blank" href="https://aka.ms/mlserver92" rel="noopener noreferrer">announced the general availability</a> of the new Microsoft Machine Learning Server! This is the underlying software that is integrated into SQL Server as Machine Learning Services. Machine Learning Server is the transformation of <a target="_blank" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/19/introducing-microsoft-r-server-9-1-release/" rel="noopener noreferrer">Microsoft R Server</a> into an even more flexible platform that offers a choice of R and Python languages and brings the best of algorithmic innovations from the open source world and Microsoft. Its multi-platform support enables customers to build portable models wherever their data is and operationalize the models on platforms like SQL Server, making the intelligence easily consumable by business applications.</p>
<p>Key new algorithmic innovations of Machine Learning Server benefitting the SQL Server scenarios are:</p>
<h3><em>Revoscalepy</em></h3>
<p>This <a href="https://docs.microsoft.com/en-us/r-server/python-reference/revoscalepy/revoscalepy-package">package</a> has the Pythonic version of Microsoft’s proprietary <em>Parallel External Memory Algorithms</em> (APIs for linear and logistic regressions, decision tree, boosted tree and random forest) and a rich set of APIs for <em>ETL</em>, remote <em>compute contexts</em> and <em>data sources</em>. These are the same scalable and parallelized algorithms (with ‘rx’ prefix) that have been the differentiating value proposition of Microsoft R Server and allow scaling analytics to arbitrarily large datasets, way beyond the available memory.</p>
<h3><em>microsoftml</em></h3>
<p>This <a target="_blank" href="https://docs.microsoft.com/en-us/r-server/python-reference/microsoftml/microsoftml-package" rel="noopener noreferrer">package</a> is a set of state of the art, battle-tested ML algorithms and transforms with Python bindings including deep neural net, one class SVM, fast tree, forest, linear and logistic regressions etc. In addition, this package contains pre-trained models for extracting features from images using ResNet models, and doing sentiment analysis from English language text, which dramatically simplifies the creation and deployment of complex AI scenarios on image and text data.</p>
<p>We have also simplified the pricing model to make it easier to acquire and use Machine learning Server on Hadoop. Each SQL Server EE core under Software Assurance gives you rights to use Machine Learning Server on 5 nodes of Hadoop.</p>
<h2>Call to action</h2>
<p>SQL Server Machine Learning Services is available in all editions of SQL Server 2017 on Windows and we encourage you to <a target="_blank" href="https://www.microsoft.com/en-us/sql-server/sql-server-2017" rel="noopener noreferrer">download</a> and explore the above-mentioned enhancements in the free express or developer editions. Our R and Python <a href="http://aka.ms\mlsqldev">getting started tutorials</a> will walk you through building your first machine learning solutions with SQL Server. You can find additional <a target="_blank" href="https://docs.microsoft.com/en-us/sql/advanced-analytics/tutorials/machine-learning-services-tutorials" rel="noopener noreferrer">tutorials</a> on Microsoft docs.</p>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/26/in-database-machine-learning-in-sql-server-2017/feed/</wfw:commentRss>
<slash:comments>3</slash:comments>
</item>
<item>
<title>New managed SQL server Integration Service hosting capability in Data Factory</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/25/new-managed-sql-server-integration-service-hosting-capability-in-data-factory/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/25/new-managed-sql-server-integration-service-hosting-capability-in-data-factory/#comments</comments>
<pubDate>Mon, 25 Sep 2017 14:00: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=20645</guid>
<description><![CDATA[This week at Ignite, we announced new capabilities in Azure Data Factory (ADF) service available in public preview for customers. Azure user preview terms of use can be found here. SQL Server Integration Services (SSIS) customers can easily lift their SSIS packages into the cloud using new managed SSIS hosting capabilities in Data Factory. This... <a aria-label="read more about New managed SQL server Integration Service hosting capability in Data Factory" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/25/new-managed-sql-server-integration-service-hosting-capability-in-data-factory/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p>This week at Ignite, we announced new capabilities in Azure Data Factory (ADF) service available in public preview for customers. <a href="https://azure.microsoft.com/en-us/support/legal/preview-supplemental-terms/">Azure user preview terms of use can be found here</a>. SQL Server Integration Services (SSIS) customers can easily lift their SSIS packages into the cloud using new managed SSIS hosting capabilities in Data Factory. This can be achieved by utilizing a new feature called “Integration Runtimes” (IR). By spinning-up an SSIS IR in Azure Data Factory, you will have the ability to execute, manage, monitor and deploy SSIS packages in the cloud. Get started now by visiting <a href="https://docs.microsoft.com/en-us/azure/data-factory/tutorial-deploy-ssis-packages-azure">this step-by-step instructional tutorial</a> on how to leverage Azure Data Factory to provision an SSIS service where you can deploy, manage and monitor your SSIS packages in the cloud.</p>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/25/new-managed-sql-server-integration-service-hosting-capability-in-data-factory/feed/</wfw:commentRss>
<slash:comments>1</slash:comments>
</item>
<item>
<title>SQL Server 2017 and Red Hat Enterprise Linux offer</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/25/sql-server-2017-and-red-hat-enterprise-linux-offer/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/25/sql-server-2017-and-red-hat-enterprise-linux-offer/#comments</comments>
<pubDate>Mon, 25 Sep 2017 13:00:50 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20655</guid>
<description><![CDATA[This post was authored by John ‘JG’ Chirapurath, General Manager, Data Platform Marketing. Microsoft has heard from you, our customers, that your data estate gets bigger, more complicated, and more diverse every year. You need solutions that work across platforms, whether on-premises or in the cloud, and that meet your data workloads where they are. Embracing... <a aria-label="read more about SQL Server 2017 and Red Hat Enterprise Linux offer" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/25/sql-server-2017-and-red-hat-enterprise-linux-offer/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p><em>This post was authored by John ‘JG’ Chirapurath, General Manager, Data Platform Marketing.</em></p>
<p>Microsoft has heard from you, our customers, that your data estate gets bigger, more complicated, and more diverse every year. You need solutions that work across platforms, whether on-premises or in the cloud, and that meet your data workloads where they are. Embracing this choice, earlier today we announced the <strong>general availability of SQL Server 2017 on Linux, Windows, and Docker on October 2, 2017</strong>.</p>
<p>Today, Microsoft and Red Hat are delivering on choice by announcing the availability of Microsoft SQL Server 2017 on <a target="_blank" href="https://www.redhat.com/en/technologies/linux-platforms/enterprise-linux" rel="noopener noreferrer">Red Hat Enterprise Linux</a>, the world’s leading enterprise Linux platform. As Microsoft’s reference Linux platform for SQL Server, Red Hat Enterprise Linux extends the enterprise database and analytics capabilities of SQL Server by delivering it on the industry-leading platform for performance, security features, stability, reliability, and manageability.</p>
<p>Customers will be able to bring the performance and security features of SQL Server to Linux workloads. <a target="_blank" href="https://www.microsoft.com/en-us/sql-server/sql-server-2017" rel="noopener noreferrer">SQL Server 2017</a> on Red Hat Enterprise Linux delivers mission-critical OLTP database capabilities and enterprise <a target="_blank" href="http://h20195.www2.hpe.com/V2/GetDocument.aspx?docname=a00007695enw" rel="noopener noreferrer">data warehousing</a> with in-memory technology across workloads. SQL Server 2017 embraces developers by delivering choice in language and platform, with container support that seamlessly facilitates DevOps scenarios. The new release of SQL Server delivers all of this, built-in. And, it runs wherever you want, whether in your datacenter, in Azure virtual machines, or in <a target="_blank" href="https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fredhat.com%2Fen%2Fblog%2Fmicrosoft-sql-server-2017-red-hat-enterprise-linux-data-peas-and-linux-carrots&data=02%7C01%7CAnshul.Rampal%40microsoft.com%7C33b0209700fb4c3247b908d501e3c99b%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636417000226874752&sdata=tSPEvd6ZeHZGNDKgFme67gsToIdtsEO0Zx%2FnstUy%2FpU%3D&reserved=0" rel="noopener noreferrer">containers running on Red Hat OpenShift Container Platform</a>!</p>
<p>Also starting October 2nd until June 30th, 2018, we are launching a <strong>SQL Server on Red Hat Enterprise Linux</strong> <strong>offer</strong> to help with upgrades and migrations. This offer provides up to 30% off SQL Server 2017 through an annual subscription. When customers purchase a new Red Hat Enterprise Linux subscription to support their SQL Server, they will be eligible for another 30% off their Red Hat Enterprise Linux subscription price.</p>
<p>In addition to discounts on SQL Server and Red Hat Enterprise Linux, all of this is backed by <a target="_blank" href="https://www.redhat.com/en/about/press-releases/microsoft-and-red-hat-deliver-new-standard-enterprise-cloud-experiences" rel="noopener noreferrer">integrated support from Microsoft and Red Hat</a>. Learn more about this offer, plus how SQL Server and Red Hat work together for performance and reliability at low TCO by talking to your local Red Hat or Microsoft seller today!</p>
<p>For more information on Microsoft SQL Server 2017 on Red Hat Enterprise Linux, stop by the Red Hat booth #527 at Microsoft Ignite.</p>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/25/sql-server-2017-and-red-hat-enterprise-linux-offer/feed/</wfw:commentRss>
<slash:comments>3</slash:comments>
</item>
</channel>
</rss>
