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, 31 Aug 2017 16:00:33 +0000</lastBuildDate>
<language>en-US</language>
<sy:updatePeriod>hourly</sy:updatePeriod>
<sy:updateFrequency>1</sy:updateFrequency>
<item>
<title>Six reasons to consider SQL Server 2017—especially if you’re on Linux</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/31/six-reasons-to-consider-sql-server-2017-especially-if-youre-on-linux/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/31/six-reasons-to-consider-sql-server-2017-especially-if-youre-on-linux/#respond</comments>
<pubDate>Thu, 31 Aug 2017 16: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=20625</guid>
<description><![CDATA[“Data is currency” is the rule of thumb in business. As with money, business data must be accessible, accurate, and usable across disparate contexts if an organization is to realize greater ROI while keeping costs under control. CIOs understand that the need to manage data—its location, composition, and utility—is as important as managing a balance... <a aria-label="read more about Six reasons to consider SQL Server 2017—especially if you’re on Linux" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/31/six-reasons-to-consider-sql-server-2017-especially-if-youre-on-linux/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p>“Data is currency” is the rule of thumb in business. As with money, business data must be accessible, accurate, and usable across disparate contexts if an organization is to realize greater ROI while keeping costs under control. CIOs understand that the need to manage data—its location, composition, and utility—is as important as managing a balance sheet. For many companies, the solution is SQL Server, the industry gold standard for database management.</p>
<p>But what about the many tech startups and cloud enterprises running open-source platforms? These organizations face challenges with reliably integrating, categorizing, and accessing all types of business data in an often-heterogeneous world of platforms, apps, and devices.</p>
<p>The good news is <a target="_blank" href="https://www.microsoft.com/en-us/sql-server/sql-server-2017" rel="noopener noreferrer">SQL Server 2017 runs on Linux</a>. Two Linux-based organizations, <a target="_blank" href="http://www.cco.com/" rel="noopener noreferrer">Convergent Computing</a> and<a target="_blank" href="https://www.dv01.co/" rel="noopener noreferrer"> dv01</a>, migrated to SQL Server 2017 for the capabilities and tools to manage and optimize their data “currency.” They share their stories in the new e-book, <em><a target="_blank" href="https://info.microsoft.com/top-six-reasons-companies-make-the-move-to-sql-server-2017-register.html" rel="noopener noreferrer">SQL Server 2017 on Linux: Top Six Reasons Companies Make the Move</a></em>.</p>
<p>In the e-book, leadership at Convergent and dv01 cover the benefits they gained with SQL on Linux, including:</p>
<ul>
<li>Flexibility. Use familiar languages on the platform and cloud of your choice.</li>
<li>Performance. Take advantage of faster queries with simultaneous analytics and transaction processing.</li>
<li>Security. Protect your data at rest and in motion with centrally managed, Always Encrypted protection.</li>
<li>Cost. Expand your hardware options and achieve ROI more quickly with Linux.</li>
<li>Simplicity. Migrate without the complexity of advanced customizations or third-party solutions.</li>
<li>Everything built in. Reduce TCO with all the enterprise-level features you need.</li>
</ul>
<p><a target="_blank" href="https://info.microsoft.com/top-six-reasons-companies-make-the-move-to-sql-server-2017-register.html" rel="noopener noreferrer">Download the free e-book</a> to see how SQL Server 2017 can help your organization protect and optimize its data.</p>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/31/six-reasons-to-consider-sql-server-2017-especially-if-youre-on-linux/feed/</wfw:commentRss>
<slash:comments>0</slash:comments>
</item>
<item>
<title>Now available in India: Azure Database for MySQL and Azure Database for PostgreSQL</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/21/now-available-in-india-azure-database-for-mysql-and-azure-database-for-postgresql/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/21/now-available-in-india-azure-database-for-mysql-and-azure-database-for-postgresql/#respond</comments>
<pubDate>Mon, 21 Aug 2017 18:00:03 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20595</guid>
<description><![CDATA[We recently announced public preview availability of Azure Database for PostgreSQL and MySQL in West and Central India. PostgreSQL and MySQL are ubiquitous names in the world of open source relational databases, as these database engines have been widely embraced by developers in recent years. Microsoft’s Azure cloud is a first-class platform for open source... <a aria-label="read more about Now available in India: Azure Database for MySQL and Azure Database for PostgreSQL" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/21/now-available-in-india-azure-database-for-mysql-and-azure-database-for-postgresql/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p>We recently announced public preview availability of Azure Database for PostgreSQL and MySQL in West and Central India. PostgreSQL and MySQL are ubiquitous names in the world of open source relational databases, as these database engines have been widely embraced by developers in recent years. Microsoft’s Azure cloud is a first-class platform for open source technology that allows you to bring the tools you love, along with the skills you already have, and deploy any application. The availability of Azure Database for MySQL and PostgreSQL services in India provides app developers the ability to choose from a wider number of geographies and deploy their favorite database on Azure — without the complexity of managing and administering the databases.</p>
<p>Learn more about the new availability of Azure Database for MySQL and Azure Database for PostgreSQL in our <a target="_blank" href="https://azure.microsoft.com/en-us/blog/announcing-azure-database-for-mysql-and-azure-database-for-postgresql-availability-in-india-2" rel="noopener noreferrer">recent post on the Azure blog</a>.</p>
<p>You can create an Azure Database for MySQL by following the steps mentioned in <a target="_blank" href="https://docs.microsoft.com/azure/mysql/quickstart-create-mysql-server-database-using-azure-portal?WT.mc_id=msftossdbind" rel="noopener noreferrer">MySQL documentation</a>, and you can create an Azure Database for PostgreSQL by following the steps outlined in <a target="_blank" href="https://docs.microsoft.com/azure/postgresql/quickstart-create-server-database-portal?WT.mc_id=msftossdbind" rel="noopener noreferrer">PostgreSQL documentation</a>. As you can see from the screenshots below, the “Location” drop-down now allows you to select India as a region!</p>
<p><a href="https://msdnshared.blob.core.windows.net/media/2017/08/mysql-postgresql-availability-india.png"><img src="https://msdnshared.blob.core.windows.net/media/2017/08/mysql-postgresql-availability-india.png" alt="" width="857" height="677" class="aligncenter wp-image-20596 size-full" /></a></p>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/21/now-available-in-india-azure-database-for-mysql-and-azure-database-for-postgresql/feed/</wfw:commentRss>
<slash:comments>0</slash:comments>
</item>
<item>
<title>SQL Server 2017 Release Candidate 2 (RC2) is now available</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/02/sql-server-2017-release-candidate-2-rc2-is-now-available/</link>
<pubDate>Wed, 02 Aug 2017 17:00:09 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20555</guid>
<description><![CDATA[Microsoft is pleased to announce availability of SQL Server 2017 Release Candidate 2 (RC2), which is now available for download. The release candidate represents an important milestone for SQL Server. Development of the new version of SQL Server along most dimensions needed to bring the industry-leading performance and security of SQL Server to Windows, Linux,... <a aria-label="read more about SQL Server 2017 Release Candidate 2 (RC2) is now available" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/02/sql-server-2017-release-candidate-2-rc2-is-now-available/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p>Microsoft is pleased to announce availability of SQL Server 2017 Release Candidate 2 (RC2), which is <a target="_blank" href="https://www.microsoft.com/sqlserver2017" rel="noopener noreferrer">now available for download</a>.</p>
<p>The release candidate represents an important milestone for SQL Server. Development of the new version of SQL Server along most dimensions needed to bring the industry-leading performance and security of SQL Server to Windows, Linux, and Docker containers is complete. We are continuing to work on performance and stress testing of SQL Server 2017 to get it ready for your most demanding Tier 1 workloads, as well as some final bug fixes.</p>
<p>We invite you to test out RC2 today, and to let us know how it’s working for you. If you have questions, you can join the discussion of SQL Server 2017 at <a target="_blank" href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home" rel="noopener noreferrer">MSDN</a>. If you run into an issue or would like to make a suggestion, you can let us know through <a target="_blank" href="https://connect.microsoft.com/SQLServer" rel="noopener noreferrer">Connect</a>. We look forward to hearing from you!</p>
<h2>Get started with SQL Server 2017 RC2 today!</h2>
<p>Try the release candidate of the SQL Server 2017 today! Get started with our <a target="_blank" href="http://www.microsoft.com/sql-server/developer-get-started" rel="noopener noreferrer">updated developer tutorials</a> that show you how to install and use SQL Server 2017 on macOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice. For more ways to get started, try the following:</p>
<ul>
<li>Watch our recent <a target="_blank" href="https://info.microsoft.com/sql-server-on-linux-town-hall-security-register.html" rel="noopener noreferrer">Security</a> and <a target="_blank" href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Finfo.microsoft.com%2Fsql-server-on-linux-town-hall-monitoring.html&data=02%7C01%7Cdelyons%40microsoft.com%7Cb5c7284f464d4b74452808d490dfa483%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636292737754593275&sdata=YPGbSnkVidyLV5Yrc5WosFeXZcHGFJbsvjkELqMMXbw%3D&reserved=0" rel="noopener noreferrer">Monitoring</a>, <a target="_blank" href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Finfo.microsoft.com%2Fsql-server-on-linux-town-hall-client-tools.html&data=02%7C01%7Cdelyons%40microsoft.com%7Cb5c7284f464d4b74452808d490dfa483%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636292737754593275&sdata=Fwz0FQ%2FgqT9WgqlYKN2tD7BMmD9xH28NTxMmpR1a0Ak%3D&reserved=0" rel="noopener noreferrer">Client Tools</a>, <a target="_blank" href="https://info.microsoft.com/sql-server-on-linux-town-hall-sql-server-agent-register.html" rel="noopener noreferrer">SQL Server Agent</a> or <a target="_blank" href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Finfo.microsoft.com%2Fsql-server-on-linux-town-hall-backup.html&data=02%7C01%7Cdelyons%40microsoft.com%7Cb5c7284f464d4b74452808d490dfa483%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636292737754593275&sdata=9A9Ls1iXdUh546IXxMtomQ8lFw579KiHZ4tV5huSR70%3D&reserved=0" rel="noopener noreferrer">Backup</a> engineering town halls on-demand</li>
<li>Learn more about <a target="_blank" href="https://www.microsoft.com/en-us/sql-server/developer-get-started/sql-devops/" rel="noopener noreferrer">DevOps using SQL Server</a></li>
<li><a target="_blank" href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-red-hat" rel="noopener noreferrer">Install on Red Hat Enterprise Linux</a></li>
<li><a target="_blank" href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ubuntu" rel="noopener noreferrer">Install on Ubuntu Linux</a></li>
<li><a target="_blank" href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-suse-linux-enterprise-server" rel="noopener noreferrer">Install on SUSE Linux Enterprise Server</a></li>
<li><a target="_blank" href="https://docs.microsoft.com/en-us/sql/linux/" rel="noopener noreferrer">Pull and run a Linux Docker container on Linux, Windows, or macOS</a></li>
<li><a target="_blank" href="https://www.microsoft.com/evalcenter/evaluate-sql-server-vnext-ctp" rel="noopener noreferrer">Download the preview for Windows</a></li>
<li><a target="_blank" href="https://azure.microsoft.com/en-us/marketplace/?term=%22SQL+Server+vNext%22" rel="noopener noreferrer">Create a SQL Server on Linux virtual machine in Azure</a></li>
<li><a target="_blank" href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-active-directory-authentication" rel="noopener noreferrer">Active Directory Authentication with SQL Server on Linux</a></li>
<li><a target="_blank" href="https://aka.ms/eapsignup" rel="noopener noreferrer">Sign up for the Early Adoption Program (EAP)</a> – The Early Adoption Program is designed to help customers and partners evaluate new features in SQL Server 2017, and to build and deploy applications for SQL Server 2017 on Windows and Linux.</li>
</ul>
]]></content:encoded>
</item>
<item>
<title>Microsoft Drivers v4.3.0 for PHP for SQL Server released!</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/18/microsoft-drivers-v4-3-0-for-php-for-sql-server-released/</link>
<pubDate>Tue, 18 Jul 2017 16:00:00 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20545</guid>
<description><![CDATA[This post was authored by Meet Bhagdev, Program Manager, Microsoft Hi all, We are excited to announce the Production Ready release for the Microsoft Drivers v4.3.0 for PHP for SQL Server. The drivers now support Debian Jessie and macOS. The driver enables access to SQL Server, Azure SQL Database, and Azure SQL DW from any... <a aria-label="read more about Microsoft Drivers v4.3.0 for PHP for SQL Server released!" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/18/microsoft-drivers-v4-3-0-for-php-for-sql-server-released/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p><em>This post was authored by Meet Bhagdev, Program Manager, Microsoft</em></p>
<p>Hi all,</p>
<p>We are excited to announce the Production Ready release for the <a href="https://www.microsoft.com/en-us/download/details.aspx?id=55642">Microsoft Drivers v4.3.0 for PHP for SQL Server</a>. The drivers now support Debian Jessie and macOS. The driver enables access to SQL Server, Azure SQL Database, and Azure SQL DW from any PHP application on Linux, Windows, and macOS.</p>
<p>Notable items for the release:</p>
<h2>Added</h2>
<ul>
<li>PHP 7.1 support</li>
<li>Added Unicode Column name support (<a href="https://github.com/Microsoft/msphpsql/issues/138">issue #138</a>)</li>
<li>Support for <a href="https://github.com/Microsoft/msphpsql/wiki/Features#TNIR">transparent connections to AlwaysOn Availability Groups</a>. The driver quickly discovers the current AlwaysOn topology of your server infrastructure and connects to the current active server transparently.</li>
<li>Added support for sql_variant data type with limitation (<a href="https://github.com/Microsoft/msphpsql/issues/51">issue #51</a> and <a href="https://github.com/Microsoft/msphpsql/issues/127">issue #127</a>)</li>
<li><b>Debian Jessie</b> (tested on Debian 8.7) and <b>macOS</b> (El Capitan and above) support</li>
<li><a href="https://github.com/Microsoft/msphpsql/wiki/Connection-Resiliency">Connection Resiliency</a> support for Windows</li>
<li><a href="https://github.com/Microsoft/msphpsql/wiki/Connection-Pooling-on-Linux-and-Mac">Connection pooling</a> support for Linux and macOS</li>
</ul>
<h2>Fixed</h2>
<ul>
<li>Fixed the assertion error (Linux) when fetching data from a binary column using the binary encoding (<a href="https://github.com/Microsoft/msphpsql/issues/226">issue #226</a>)</li>
<li>Fixed PECL installation errors when PHP was installed from source (<a href="https://github.com/Microsoft/msphpsql/issues/213">issue #213</a>)</li>
<li>Fixed issue output parameters bound to empty string (<a href="https://github.com/Microsoft/msphpsql/issues/182">issue #182</a>)</li>
<li>Fixed a memory leak in closing connection resources</li>
<li>Fixed load ordering issue in MacOS (<a href="https://github.com/Microsoft/msphpsql/issues/417">issue #417</a>)</li>
<li>Fixed the issue with driver loading order in macOS</li>
<li>Fixed null returned when an empty string is set to an output parameter (<a href="https://github.com/Microsoft/msphpsql/issues/308">issue #308</a>)</li>
<li><b>SQLSRV only</b>
<ul>
<li>Fixed sqlsrv client buffer size to only allow positive integers (<a href="https://github.com/Microsoft/msphpsql/issues/228">issue #228</a>)</li>
<li>Fixed sqlsrv_num_rows() when the client buffered result is null (<a href="https://github.com/Microsoft/msphpsql/issues/330">issue #330</a>)</li>
<li>Fixed issues with sqlsrv_has_rows() to prevent it from moving statement cursor (<a href="https://github.com/Microsoft/msphpsql/issues/37">issue #37</a>)</li>
<li>Fixed conversion warnings because of some const chars (<a href="https://github.com/Microsoft/msphpsql/issues/332">issue #332</a>)</li>
<li>Fixed debug abort error when building the driver in debug mode with PHP 7.1</li>
<li>Fixed string truncation when binding varchar(max), nvarchar(max), varbinary(max), and xml types (<a href="https://github.com/Microsoft/msphpsql/issues/231">issue #231</a>)</li>
<li>Fixed fatal error when fetching empty nvarchar (<a href="https://github.com/Microsoft/msphpsql/issues/69">issue #69</a>)</li>
<li>Fixed fatal error when calling sqlsrv_fetch() with an out of bound offset for SQLSRV_SCROLL_ABSOLUTE (<a href="https://github.com/Microsoft/msphpsql/issues/223">issue #223</a>)</li>
</ul>
</li>
<li><b>PDO_SQLSRV only</b>
<ul>
<li>Fixed issue with SQLSRV_ATTR_FETCHES_NUMERIC_TYPE when column return type is set on statement (<a href="https://github.com/Microsoft/msphpsql/issues/173">issue #173</a>)</li>
<li>Improved performance by implementing a cache to store column SQL types and display sizes (<a href="https://github.com/Microsoft/msphpsql/issues/189">issue #189</a>)</li>
<li>Fixed segmentation fault with PDOStatement::getColumnMeta() when the supplied column index is out of range (<a href="https://github.com/Microsoft/msphpsql/issues/224">issue #224</a>)</li>
<li>Fixed issue with the unsupported attribute PDO::ATTR_PERSISTENT in connection (<a href="https://github.com/Microsoft/msphpsql/issues/65">issue #65</a>)</li>
<li>Fixed the issue with executing DELETE operation on a nonexistent value (<a href="https://github.com/Microsoft/msphpsql/issues/336">issue #336</a>)</li>
<li>Fixed incorrectly binding of unicode parameter when emulate prepare is on and the encoding is set at the statement level (<a href="https://github.com/Microsoft/msphpsql/issues/92">issue #92</a>)</li>
<li>Fixed binary column binding when emulate prepare is on (<a href="https://github.com/Microsoft/msphpsql/issues/140">issue #140</a>)</li>
<li>Fixed wrong value returned when fetching varbinary value on Linux (<a href="https://github.com/Microsoft/msphpsql/issues/270">issue #270</a>)</li>
<li>Fixed binary data not returned when the column is bound by name (<a href="https://github.com/Microsoft/msphpsql/issues/35">issue #35</a>)</li>
<li>Fixed exception thrown on closeCursor() when the statement has not been executed (<a href="https://github.com/Microsoft/msphpsql/issues/267">issue #267</a>)</li>
</ul>
</li>
</ul>
<h2>Limitations</h2>
<ul>
<li>No support for input/output parameters when using sql_variant type</li>
</ul>
<h2>Known issue</h2>
<ul>
<li>When pooling is enabled in Linux or macOS
<ul>
<li>unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostics information, such as error messages, warnings, and informative messages</li>
<li>Because of this unixODBC bug, fetch large data (such as xml, binary) as streams as a workaround. See the examples <a href="https://github.com/Microsoft/msphpsql/wiki/Connection-Pooling-on-Linux-and-Mac">here</a>.</li>
</ul>
</li>
</ul>
<h2>Survey</h2>
<p>Let us know how we are doing and how you use our driver by taking our pulse survey: <a href="https://www.surveymonkey.com/r/CZNSBYW">https://www.surveymonkey.com/r/CZNSBYW</a>.</p>
<h2>Get started</h2>
<ul>
<li><a href="https://www.microsoft.com/en-us/sql-server/developer-get-started/php/ubuntu"><b>Ubuntu + SQL Server + PHP 7</b></a></li>
<li><a href="https://www.microsoft.com/en-us/sql-server/developer-get-started/php/rhel"><b>RedHat + SQL Server + PHP 7</b></a></li>
<li><a href="https://www.microsoft.com/en-us/sql-server/developer-get-started/php/windows"><b>Windows + SQL Server + PHP 7</b></a></li>
<li><a href="https://hub.docker.com/r/lbosqmsft/mssql-php-msphpsql/"><b>Docker</b></a></li>
<li><a href="https://www.microsoft.com/en-us/download/details.aspx?id=55642"><b>Download Center</b></a></li>
</ul>
<h2>Getting Drivers for PHP5 and older runtimes</h2>
<p>You can download the Microsoft PHP Drivers for SQL Server for PHP 5.4, 5.5, and 5.6 from the download center: <a href="https://www.microsoft.com/en-us/download/details.aspx?id=20098">https://www.microsoft.com/en-us/download/details.aspx?id=20098</a>. Version 3.0 supports PHP 5.4, version 3.1 supports PHP 5.4 and PHP 5.5, and version 3.2 supports PHP 5.4, 5.5, and 5.6.</p>
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td><b>PHP Driver</b></td>
<td><b>Version Supported</b></td>
</tr>
<tr>
<td>v3.2</td>
<td>PHP 5.6, 5.5, 5.4</td>
</tr>
<tr>
<td>v3.1</td>
<td>PHP 5.5, 5.4</td>
</tr>
<tr>
<td>v3.1</td>
<td>PHP 5.4</td>
</tr>
</tbody>
</table>
<p>Meet Bhagdev (<a href="mailto:meetb@microsoft.com">meetb@microsoft.com</a>)</p>
<p><a href="https://msdnshared.blob.core.windows.net/media/2017/07/msftlovesphp.png"><img title="msftlovesphp" style="padding-top: 0px;padding-left: 0px;padding-right: 0px;border: 0px" border="0" alt="msftlovesphp" src="https://msdnshared.blob.core.windows.net/media/2017/07/msftlovesphp_thumb.png" width="765" height="431" /></a></p>
]]></content:encoded>
</item>
<item>
<title>SQL Server 2017 containers for DevOps scenarios</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/17/sql-server-2017-containers-for-devops-scenarios/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/17/sql-server-2017-containers-for-devops-scenarios/#comments</comments>
<pubDate>Mon, 17 Jul 2017 16:05:00 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20525</guid>
<description><![CDATA[This post was authored by Tony Petrossian, Partner Group Program Manager, Database Systems Group SQL Server 2017 will bring with it support for the Linux OS and containers running on Windows, Linux, and macOS. Our goal is to enable SQL Server to run in modern IT infrastructure in any public or private cloud. With support... <a aria-label="read more about SQL Server 2017 containers for DevOps scenarios" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/17/sql-server-2017-containers-for-devops-scenarios/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p><em>This post was authored by Tony Petrossian, Partner Group Program Manager, Database Systems Group</em></p>
<p><a href="https://www.microsoft.com/en-us/sql-server/sql-server-2017">SQL Server 2017</a> will bring with it support for the Linux OS and containers running on Windows, Linux, and macOS. Our goal is to enable SQL Server to run in modern IT infrastructure in <strong>any</strong> <strong>public or private cloud</strong>.</p>
<p>With support for containers, SQL Server can now be used in many popular DevOps scenarios. Developers working with Continuous Integration/Continuous Deployment (CI/CD) pipelines can now include SQL Server 2017 containers as a component of their applications for an integrated build, test, and deploy experience.</p>
<p><strong>CI/CD automation with containers </strong>– Using containers greatly simplifies the development, testing, and deployment of applications. This is achieved by the packaging of all dependencies, <strong>including SQL Server</strong>, into a portable, executable environment that reduces variability and increases the speed of every iteration in the CI/CD pipeline. This also enforces a consistent experience for all participants since they can share the same state of an application in their containers. Developers can improve applications in their local environments during the first part of the Continuous Integration process.</p>
<p>The development process starts by taking a container that represents the current state of a production application, including a subset of the sanitized data. Developers can then add their features and fixes to it, while having the ability to verify the functionality of the application at any moment. Then, the container can be sent to a testing/quality assurance environment where it can be tested with a larger, more representative dataset.</p>
<p>Continuous Deployment is a critical part of DevOps pipelines. With a successful CD pipeline, a validated and self-contained version of the application is available. Developers can publish and share fully configured containers with all application dependencies, <strong>including SQL Server</strong>, with their peers. This can significantly improve developers’ ability to collaborate as they can all work on the same exact configurations simultaneously without having to build the complicated environment necessary for developing and testing applications with many components.</p>
<p><strong>Parallel testing made fast and easy</strong> – Developers can automate the large-scale testing of containerized applications that <strong>include SQL Server</strong>. Thousands of tests can execute in parallel using high-density container deployments with managed container services. Kubernetes, Docker Swarm, or other orchestration systems can be used to easily manage a large number of test executions. Long-running test cycles can be optimized by load balancing the executions across multiple pods that spin up on demand and spin down when finished.</p>
<p>The Microsoft SQL Server development team is now taking advantage of these capabilities in building, testing, and publishing the new versions of SQL Server 2017. The team uses Azure Container Services to deploy hundreds of containers managed by a large Kubernetes cluster to execute all daily tests of SQL Server. Hundreds of thousands of tests are executed within hours of the availability of a new build! This methodology has enabled the team to run more tests in less time with fewer resources.</p>
<p><strong>Multi-OS development, test, and production environments</strong> – With the containerization of the app, developers no longer need to be concerned about aligning stages of the development and production pipeline with the same exact distribution and version of Linux. Developers can containerize their application environment, <strong>including SQL Server</strong>, to abstract it from the operating system of the underlying host. Whether part of the pipeline is operated on Ubuntu and other parts in Red Hat Enterprise Linux (RHEL), the ability to containerize the entire application environment eliminates the need to overcome challenges of a cross-platform environment. Developers are also free to choose their preferred development environment without worrying about compatibility issues in later parts of the pipeline. With SQL Server 2017, developers can run SQL Server Linux Docker images on macOS, Windows, and Linux.</p>
<p><strong>Deploying SQL Server into production – </strong>As new versions of the application are tested and verified, builds of the containers are published for use in staging and production. The exact version of the SQL Server that was used throughout the development and testing pipeline is now in the production image, and the team can be confident that the entire stack, <strong>including SQL Server,</strong> has been tested as one unit and is ready for use.</p>
<p><a href="http://aka.ms/sqldevops">Learn more</a> about how to better integrate your SQL Server data/database on the DevOps cycle.</p>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/17/sql-server-2017-containers-for-devops-scenarios/feed/</wfw:commentRss>
<slash:comments>4</slash:comments>
</item>
<item>
<title>First release candidate of SQL Server 2017 now available</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/17/first-release-candidate-of-sql-server-2017-now-available/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/17/first-release-candidate-of-sql-server-2017-now-available/#comments</comments>
<pubDate>Mon, 17 Jul 2017 16:00:00 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20516</guid>
<description><![CDATA[We are pleased to announce availability of the first public release candidate for SQL Server 2017, Release Candidate 1 (RC1), which is now available for download. This means that development work for the new version of SQL Server is complete along most dimensions needed to bring the industry-leading performance and security of SQL Server to... <a aria-label="read more about First release candidate of SQL Server 2017 now available" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/17/first-release-candidate-of-sql-server-2017-now-available/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p>We are pleased to announce availability of the first public release candidate for <a href="https://www.microsoft.com/sqlserver2017">SQL Server 2017</a>, Release Candidate 1 (RC1), which is now available for download. This means that development work for the new version of SQL Server is complete along most dimensions needed to bring the industry-leading performance and security of SQL Server to Windows, Linux, and Docker containers.</p>
<p>In our seven community technology previews (CTPs) to date, SQL Server 2017 has delivered:</p>
<ul>
<li><b>Linux support for tier-1, mission-critical workloads</b> <b>–</b> SQL Server 2017 support for Linux includes the same high availability solutions on Linux as Windows Server, including Always On availability groups integrated with Linux native clustering solutions like Pacemaker.</li>
<li><b>Graph data processing in SQL Server</b> <b>–</b> With the <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/20/graph-data-processing-with-sql-server-2017/">graph data features available in SQL Server 2017</a> and Azure SQL Database, customers can create nodes and edges, and discover complex and many-to-many relationships.</li>
<li><b>Adaptive query processing</b> <b>–</b> <a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/adaptive-query-processing">Adaptive query processing</a> is a family of features in SQL Server 2017 that automatically keeps database queries running as efficiently as possible without requiring additional tuning from database administrators. In addition to the capability to adjust batch mode memory grants, the feature set includes batch mode adaptive joins and interleaved execution capabilities.</li>
<li><b>Python integration for advanced analytics</b> <b>–</b> Microsoft Machine Learning Services now brings you the ability to run <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/19/python-in-sql-server-2017-enhanced-in-database-machine-learning/">in-database analytics using Python</a> or R in a parallelized and scalable way. The ability to run advanced analytics in your operational store without ETL means faster time to insights for customers while easy deployment and rich extensibility make it fast to get up and running on the right model.</li>
</ul>
<h2>Key enhancements in Release Candidate 1</h2>
<p>In SQL Server 2017 RC1, there were several feature enhancements of note:</p>
<ul>
<li><b>SQL Server on Linux Active Directory integration – </b>With RC1, SQL Server on Linux supports Active Directory Authentication, which enables domain-joined clients on either Windows or Linux to authenticate to SQL Server using their domain credentials and the Kerberos protocol. Check out the <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-active-directory-authentication">getting started instructions</a>.</li>
<li><b>Transport Layer Security (TLS) to encrypt data – </b>SQL Server on Linux can use TLS to encrypt data that is transmitted across a network between a client application and an instance of SQL Server. SQL Server on Linux supports the following TLS protocols: TLS 1.2, 1.1, and 1.0. Check out the <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-encrypted-connections">getting started instructions</a>.</li>
<li><b>Machine Learning Services enhancements – </b>In RC1, we add more model management capabilities for R Services on Windows Server, including External Library Management. The new release also supports Native Scoring<i>.</i></li>
<li><b>SQL Server Analysis Services (SSAS) </b><b>–</b> In addition to the enhancements to SSAS from previous CTPs of SQL Server 2017, RC1 adds additional Dynamic Management Views, enabling dependency analysis and reporting. See the <a href="https://blogs.msdn.microsoft.com/analysisservices/">Analysis Services blog</a> for more information.</li>
<li><b>SQL Server Integration Services (SSIS) on Linux</b> <b>–</b> The <a href="https://blogs.msdn.microsoft.com/ssis/">preview of SQL Server Integration Services on Linux now adds support for any Unicode ODBC driver</a>, if it follows ODBC specifications. (ANSI ODBC driver is not supported.)</li>
<li><b>SQL Server Integration Services (SSIS) on Windows Server </b><b>–</b> RC1 adds support for SSIS scale out in highly available environments. Customers can now enable Always On for SSIS, setting up Windows Server failover clustering for the scale out master.</li>
</ul>
<h2>SQL Server 2017 for faster performance</h2>
<p>SQL Server 2017 has several new benchmarks demonstrating faster performance than competitive databases, and against older versions of SQL Server:</p>
<ul>
<li>The <a href="http://www.tpc.org/3327">world record TPC-H 1TB nonclustered data warehousing benchmark</a>, achieved in April 2017 using SQL Server 2017 on Red Hat Enterprise Linux and HPE Proliant DL380 Gen9 hardware.</li>
<li>A <a href="http://www.tpc.org/3328">new, nonclustered TPC-H 10TB data warehousing workload benchmark</a> achieved using SQL Server 2017 on Windows Server 2016 and Lenovo ThinkSystem SR950 hardware. At 1,336,109 QppH, this <b>newly published benchmark is a world record</b>.</li>
<li>A <a href="http://www.tpc.org/4080">new TPC-E benchmark</a> achieved with SQL Server 2017 running on Windows Server 2016 on a Lenovo ThinkSystem SR650, a <b>world record for 2 socket TPC-E results</b>.</li>
</ul>
<h2>Streamline your DevOps using SQL Server 2017</h2>
<p>In SQL Server 2017, we have introduced support for SQL Server on Linux-based containers, a benefit for customers using containers in development or production. We’re also working to help developers <a href="https://www.microsoft.com/en-us/sql-server/developer-get-started/">get started developing an app for SQL Server</a> as fast as possible with installation instructions, code snippets, and other handy information.</p>
<p>On our new microsite <a href="https://www.microsoft.com/en-us/sql-server/developer-get-started/sql-devops/">DevOps using SQL Server</a>, which launched today, developers and development managers can learn how to integrate SQL Server in their DevOps tasks. Find demos, documentation, and blogs, as well as videos and conference presentations. Or, join the DevOps conversation at our Gitter channels.</p>
<h2>Customers are already benefitting from SQL Server 2017</h2>
<p>In fact, with our Early Adoption Program, customers can develop new applications for SQL Server 2017 or add Linux support to existing applications, and get the support and end-user license agreement that they need to go into production on SQL Server right now. Here are some customers already benefitting from SQL Server 2017 on Linux:</p>
<ul>
<li><b>Convergent Computing</b> <b>–</b> A system integrator and longtime Microsoft partner, <a href="http://customers.microsoft.com/en-US/story/convergentcomputing">Convergent Computing</a> was able to achieve a much faster return on server and storage hardware investments than usual by moving some tier-2 applications to inexpensive, white box servers running SQL Server 2017 on Linux.</li>
<li><b>dv01</b> – Financial technology startup <a href="http://customers.microsoft.com/en-US/story/convergentcomputinghttp:/customers.microsoft.com/en-US/story/convergentcomputing">dv01</a> started out with an open source database on a competitor cloud. But when it ran into performance and scale problems, SQL Server was able to give it 15X faster performance, plus in-database advanced analytics. And by moving to SQL Server 2017, dv01 could standardize its operating systems on Linux—all with an easy migration.</li>
</ul>
<h2>Get started with SQL Server 2017 RC1 today!</h2>
<p>Try the release candidate of the SQL Server 2017 today! Get started with <a href="http://www.microsoft.com/sql-server/developer-get-started">our updated developer tutorials</a> that show you how to install and use SQL Server 2017 on macOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice. For more ways to get started, try the following:</p>
<ul>
<li><strong>Watch our recent </strong><a href="https://info.microsoft.com/sql-server-on-linux-town-hall-security-register.html">Security</a> and <a href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Finfo.microsoft.com%2Fsql-server-on-linux-town-hall-monitoring.html&data=02%7C01%7Cdelyons%40microsoft.com%7Cb5c7284f464d4b74452808d490dfa483%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636292737754593275&sdata=YPGbSnkVidyLV5Yrc5WosFeXZcHGFJbsvjkELqMMXbw%3D&reserved=0">Monitoring</a>, <a href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Finfo.microsoft.com%2Fsql-server-on-linux-town-hall-client-tools.html&data=02%7C01%7Cdelyons%40microsoft.com%7Cb5c7284f464d4b74452808d490dfa483%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636292737754593275&sdata=Fwz0FQ%2FgqT9WgqlYKN2tD7BMmD9xH28NTxMmpR1a0Ak%3D&reserved=0">Client Tools</a><strong>, </strong><a href="https://info.microsoft.com/sql-server-on-linux-town-hall-sql-server-agent-register.html">SQL Server Agent</a>,<strong> or </strong><a href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Finfo.microsoft.com%2Fsql-server-on-linux-town-hall-backup.html&data=02%7C01%7Cdelyons%40microsoft.com%7Cb5c7284f464d4b74452808d490dfa483%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636292737754593275&sdata=9A9Ls1iXdUh546IXxMtomQ8lFw579KiHZ4tV5huSR70%3D&reserved=0">Backup</a> engineering town halls on demand</li>
<li><a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-red-hat">Install on Red Hat Enterprise Linux</a></li>
<li><a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ubuntu">Install on Ubuntu Linux</a></li>
<li><a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-suse-linux-enterprise-server">Install on SUSE Linux Enterprise Server</a></li>
<li><a href="https://docs.microsoft.com/en-us/sql/linux/">Pull and run a Linux Docker container on Linux, Windows, or macOS</a></li>
<li><a href="https://www.microsoft.com/evalcenter/evaluate-sql-server-vnext-ctp">Download the preview for Windows</a></li>
<li><a href="https://azure.microsoft.com/en-us/marketplace/?term=%22SQL+Server+vNext%22">Create a SQL Server on Linux virtual machine in Azure</a></li>
<li><a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-active-directory-authentication">Active Directory Authentication with SQL Server on Linux</a></li>
<li><a href="https://aka.ms/eapsignup">Sign up for the Early Adoption Program (EAP)</a> – The Early Adoption Program is designed to help customers and partners evaluate new features in SQL Server 2017, and to build and deploy applications for SQL Server 2017 on Windows and Linux.</li>
</ul>
<p>Have questions? Join the discussion of SQL Server 2017 at <a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home">MSDN</a>. If you run into an issue or would like to make a suggestion, you can let us know through <a href="https://connect.microsoft.com/SQLServer">Connect</a>. We look forward to hearing from you!</p>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/17/first-release-candidate-of-sql-server-2017-now-available/feed/</wfw:commentRss>
<slash:comments>3</slash:comments>
</item>
<item>
<title>Microsoft JDBC Driver 6.2 for SQL Server released</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/05/microsoft-jdbc-driver-6-2-for-sql-server-released/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/05/microsoft-jdbc-driver-6-2-for-sql-server-released/#comments</comments>
<pubDate>Wed, 05 Jul 2017 17:00:00 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20505</guid>
<description><![CDATA[This post was authored by Andrea Lam, Program Manager, SQL Server We are happy to announce the full release of the Microsoft JDBC Driver 6.2 for SQL Server. The JDBC Driver provides Java database connectivity from any Java application, application server or Java-enabled applet to Microsoft SQL Server, Azure SQL Database and Azure SQL Data... <a aria-label="read more about Microsoft JDBC Driver 6.2 for SQL Server released" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/05/microsoft-jdbc-driver-6-2-for-sql-server-released/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p><span>This post was authored by Andrea Lam, Program Manager, SQL Server</span></p>
<p>We are happy to announce the full release of the <a href="https://go.microsoft.com/fwlink/?linkid=852460">Microsoft JDBC Driver 6.2 for SQL Server</a>. The JDBC Driver provides Java database connectivity from any Java application, application server or Java-enabled applet to Microsoft SQL Server, Azure SQL Database and Azure SQL Data Warehouse. The driver is <a href="https://github.com/microsoft/mssql-jdbc">open source</a> and available at no additional charge.</p>
<h2>What’s new</h2>
<p><strong>Azure Active Directory (AAD) support for Linux</strong><br />
Connect your Linux applications to Azure SQL Database using AAD authentication via username/password and access token methods.</p>
<p><strong>Federal Information Processing Standard (FIPS) enabled Java virtual machines</strong><br />
The JDBC Driver can now be used on Java virtual machines (JVMs) that run in FIPS 140 compliance mode to meet federal standards and compliance.</p>
<p><strong>Kerberos Authentication Improvements </strong><br />
The JDBC Driver now has support for:</p>
<ul>
<li>Principal/Password method for applications where the Kerberos configuration cannot be modified or is unable to retrieve a new token or keytab. This method can be used for authenticating to a SQL Server that only allows Kerberos authentication.</li>
<li>Cross-realm authentication using Kerberos integrated authentication without explicitly setting the server service principal name (SPN). The driver now automatically computes the REALM even when it has not been provided.</li>
<li>Kerberos constrained delegation by accepting impersonated user credentials as a GSS credential object via data source. This impersonated credential is then used to establish a Kerberos connection.</li>
</ul>
<p><strong>Added Timeouts</strong><br />
The JDBC driver now supports the following configurable timeouts you can change based on your application’s needs:</p>
<ul>
<li>Query Timeout to control the number of seconds to wait before a timeout occurs when running a query</li>
<li>Socket Timeout to specify the number of milliseconds to wait before a timeout occurs on a socket read or accept</li>
</ul>
<h2>Get the latest JDBC jars</h2>
<p><strong>Note:</strong> Due to an issue found in the 6.2.0 release, some improvements were rolled back and new jars were uploaded to Maven and the Microsoft Download Center. Please use the 6.2.1 release jars instead.</p>
<p>Add the JDBC driver to your Maven project by adding the following code to your POM file:</p>
<p><span style="font-family: 'Courier New'"><dependency> </span><br />
<span style="font-family: 'Courier New'"> <groupId>com.microsoft.sqlserver</groupId> </span><br />
<span style="font-family: 'Courier New'"> <artifactId>mssql-jdbc</artifactId> </span><br />
<span style="font-family: 'Courier New'"> <version>6.2.1.jre8</version> </span><br />
<span style="font-family: 'Courier New'"></dependency></span></p>
<p>You can also download the JDBC driver 6.2 jars directly from:</p>
<ul>
<li><a href="http://search.maven.org/#search%7Cga%7C1%7Cg%3A%22com.microsoft.sqlserver%22%20AND%20a%3A%22mssql-jdbc%22">Maven Central Repository</a></li>
<li><a href="https://aka.ms/mssqljdbc62">Microsoft Download Center</a></li>
<li><a href="https://github.com/Microsoft/mssql-jdbc/releases/tag/v6.2.1">GitHub</a></li>
</ul>
<p>Help us improve the JDBC Driver by <a href="https://github.com/Microsoft/mssql-jdbc/issues">filing issues</a> on GitHub or contributing to the project.</p>
<h2>Resources</h2>
<p>Get started quickly with Java and SQL Server on your platform of choice with our <a href="https://www.microsoft.com/en-us/sql-server/developer-get-started/?utm_medium=Referral&utm_source=https://blogs.technet.microsoft.com/dataplatforminsider/">tutorials</a>.</p>
<p>For more detailed documentation, check out the JDBC documentation <a href="https://aka.ms/jdbcdocs">here</a>.</p>
<p>Stay tuned for upcoming releases that will have additional feature support. This applies to our wide range of client drivers including:</p>
<ul>
<li><a href="http://github.com/Azure/msphpsql/releases">PHP 7.0</a></li>
<li><a href="http://blogs.technet.com/b/dataplatforminsider/archive/2016/01/11/preview-the-newest-odbc-sql-server-driver-for-windows-and-linux.aspx">ODBC</a></li>
<li><a href="https://www.microsoft.com/net/download/framework">.NET Framework</a> (for Windows)</li>
<li><a href="https://www.microsoft.com/net/download/core">.NET Core</a> (for cross-platform)</li>
</ul>
<p>Be sure to also check out other open sourced community developed drivers including:</p>
<ul>
<li><a href="https://github.com/tediousjs/tedious">Tedious</a> for Node.js</li>
<li><a href="https://github.com/rails-sqlserver/tiny_tds">TinyTDS</a> for Ruby</li>
<li><a href="https://github.com/mkleehammer/pyodbc">pyODBC</a> for Python</li>
</ul>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/05/microsoft-jdbc-driver-6-2-for-sql-server-released/feed/</wfw:commentRss>
<slash:comments>1</slash:comments>
</item>
<item>
<title>Webcast: Intro to Microsoft SQL Server on Linux with containers</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/05/webcast-intro-to-microsoft-sql-server-on-linux-with-containers/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/05/webcast-intro-to-microsoft-sql-server-on-linux-with-containers/#comments</comments>
<pubDate>Wed, 05 Jul 2017 16:00:00 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20515</guid>
<description><![CDATA[With our community technology previews of SQL Server 2017, Microsoft is bringing the industry-leading performance and security of SQL Server to Linux and containers for the first time. SQL Server running on Red Hat Enterprise Linux and Red Hat OpenShift Container Platform has advantages for both the SQL Server and Red Hat Linux communities. Join... <a aria-label="read more about Webcast: Intro to Microsoft SQL Server on Linux with containers" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/05/webcast-intro-to-microsoft-sql-server-on-linux-with-containers/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p>With our community technology previews of <a href="https://www.microsoft.com/en-US/sql-server/sql-server-2017">SQL Server 2017</a>, Microsoft is bringing the industry-leading performance and security of SQL Server to Linux and containers for the first time. SQL Server running on Red Hat Enterprise Linux and Red Hat OpenShift Container Platform has advantages for both the SQL Server and Red Hat Linux communities.</p>
<p>Join this webinar by experts from Red Hat and Microsoft as we cover:</p>
<ul>
<li>The capabilities of Microsoft SQL Server on Red Hat Enterprise Linux and Red Hat OpenShift Container Platform</li>
<li>Advantage of running Red Hat OpenShift Container Platform on-premises and in Microsoft Azure</li>
<li>A demo of application compatibility between SQL Server on Windows and SQL Server on Red Hat Enterprise Linux</li>
</ul>
<p><a href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fvts.inxpo.com%2FLaunch%2FQReg.htm%3FShowKey%3D41182%26AffiliateData%3D70160000000gzy9AAA&data=02%7C01%7Cdelyons%40microsoft.com%7C9eb640c897e94a52b6f708d4b763ef35%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636335088137249420&sdata=u%2FawuDOxi4URVA2c1oy1wIbXRsTbyIN%2FElMYAtw12Jc%3D&reserved=0">Register now</a> to attend. <b>The webcast takes place Tuesday, July 11, 2017 at noon EDT / 9 a.m.</b> <b>PDT.</b></p>
<p><strong>Speakers</strong></p>
<p>Don Schenck<br />
<i>Director, Developer Experience</i>, <i>Red Hat<br />
</i>Don Schenck, Red Hat director of Developer Experience, focuses on Microsoft .NET on Linux. His mission is to bring .NET developers into the Linux and open source communities. Before joining Red Hat, Don was a developer advocate at Rackspace. He is the author of “Transitioning to .NET Core on Linux,” an O’Reilly book.</p>
<p>Vin Yu<br />
<i>Program manager</i>, <i>Microsoft<br />
</i>Vin Yu, Microsoft program manager, is on the SQL Server team, where he works with developers and companies adopting SQL Server on Linux. Vin is also interested in improving developer experiences, database monitoring, and tools.</p>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/07/05/webcast-intro-to-microsoft-sql-server-on-linux-with-containers/feed/</wfw:commentRss>
<slash:comments>1</slash:comments>
</item>
<item>
<title>Try new SQL Server command line tools to generate T-SQL scripts and monitor Dynamic Management Views</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/05/17/try-new-sql-server-command-line-tools-to-generate-t-sql-scripts-and-monitor-dynamic-management-views/</link>
<comments>https://blogs.technet.microsoft.com/dataplatforminsider/2017/05/17/try-new-sql-server-command-line-tools-to-generate-t-sql-scripts-and-monitor-dynamic-management-views/#comments</comments>
<pubDate>Wed, 17 May 2017 18:00:00 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20465</guid>
<description><![CDATA[This post was authored by Tara Raj and Vinson Yu, Program Managers – SQL Server Team We are excited to announce the public preview availability of two new command line tools for SQL Server: The mssql-scripter tool enables developers, DBAs, and sysadmins to generate CREATE and INSERT T-SQL scripts for database objects in SQL Server,... <a aria-label="read more about Try new SQL Server command line tools to generate T-SQL scripts and monitor Dynamic Management Views" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/05/17/try-new-sql-server-command-line-tools-to-generate-t-sql-scripts-and-monitor-dynamic-management-views/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p><i>This post was authored by Tara Raj and Vinson Yu, Program Managers – SQL Server Team</i></p>
<p>We are excited to announce the public preview availability of two new command line tools for SQL Server:</p>
<ul>
<li>The mssql-scripter tool enables developers, DBAs, and sysadmins to generate CREATE and INSERT T-SQL scripts for database objects in SQL Server, Azure SQL DB, and Azure SQL DW from the command line.</li>
<li>The DBFS tool enables DBAs and sysadmins to monitor SQL Server more easily by exposing live data from SQL Server Dynamic Management Views (DMVs) as virtual files in a virtual directory on Linux operating systems.</li>
</ul>
<p>Read on for detailed usage examples, try out these new command line tools, and give us your feedback.</p>
<h2>mssql-scripter</h2>
<p>Mssql-scripter is the multiplatform command line equivalent of the widely used <a href="https://docs.microsoft.com/en-us/sql/relational-databases/scripting/generate-and-publish-scripts-wizard">Generate Scripts Wizard</a> experience in SSMS.</p>
<p>You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse. You can save the generated T-SQL script to a .sql file or pipe it to standard *nix utilities (for example, sed, awk, grep) for further transformations. You can edit the generated script or check it into source control and subsequently execute the script in your existing SQL database deployment processes and DevOps pipelines with standard multiplatform SQL command line tools such as sqlcmd.</p>
<p>Mssql-scripter is built using Python and incorporates the usability principles of the new Azure CLI 2.0 tools. The source code can be found on Github at <a href="https://github.com/Microsoft/sql-xplat-cli">https://github.com/Microsoft/sql-xplat-cli</a>, and we welcome your contributions and pull requests!</p>
<h2>Get started with mssql-scripter</h2>
<p><b>Install</b><br />
$pip install mssql-scripter<br />
For additional installation tips, visit <a href="https://github.com/Microsoft/sql-xplat-cli/blob/dev/doc/installation_guide.md">https://github.com/Microsoft/sql-xplat-cli/blob/dev/doc/installation_guide.md</a>.</p>
<p><b>Script Your First Database Objects</b><br />
For usage and help content, pass in the -h parameter, which will also show all options:<br />
<a href="https://github.com/Microsoft/sql-xplat-cli#options">mssql-scripter -h</a></p>
<p><b>Here are some example commands</b><br />
# Generate DDL scripts for all database objects (default) in the Adventureworks database and output to stdout<br />
<span style="font-family: 'Courier New'">$ mssql-scripter -S localhost -d AdventureWorks -U sa</span></p>
<p># Generate DDL scripts for all database objects and DML scripts (INSERT statements) for all tables in the Adventureworks database and save the script to a file<br />
<span style="font-family: 'Courier New'">$ mssql-scripter -S localhost -d AdventureWorks -U sa ––schema-and-data > ./adventureworks.sql</span></p>
<p># generate DDL scripts for objects that contain “Employee” in their name to stdout<br />
<span style="font-family: 'Courier New'">$ mssql-scripter -S localhost -d AdventureWorks -U sa ––include-objects Employee</span></p>
<p>Get our<a href="https://github.com/Microsoft/sql-xplat-cli/blob/dev/doc/usage_guide.md"> GitHub usage guide</a>.</p>
<h2>DBFS</h2>
<p>A big part of operationalizing SQL Server is to monitor to ensure that SQL Server is performant, highly available, and secure for your applications. With SQL Server 2017, Dynamic Management Views (DMVs) on Windows are also accessible on Linux, allowing your existing scripts and tools that rely on DMVs to continue to work. Traditionally, to get this information, you would use GUI admin tools such as SSMS or command line tools such as SQLCMD to run queries.</p>
<p>Today, <b>we are also introducing a new experimental Linux tool</b>, <a href="https://github.com/Microsoft/dbfs">DBFS,</a> which enables you to access live DMVS mounted to a virtual filesystem using FUSE. All you need to do is view the contents of the virtual files in the mounted virtual directory to see the same data you would see as if you ran a SQL query to view the DMV data. There is no need to log in to the SQL Server using a GUI or command line tool or run SQL queries. DBFS can also be used in scenarios where you want to access DMV data from the context of a script with CLI tools such as grep, awk, and sed.</p>
<p>DBFS uses the FUSE file system module to create two zero byte files for each DMV—one for showing the data in CSV format and one for showing the data in JSON format. When a file is “read,” the relevant information from the corresponding DMV is queried from SQL Server and displayed just like the contents of any CSV or JSON text file.</p>
<p><b>Features</b></p>
<ul>
<li>Access data in .json format if you are connected to SQL Server 2016 or later</li>
<li>Compatible with Bash tools such as grep, sed, and awk</li>
<li>Live DMV data at time of access</li>
<li>Works with both SQL Server on Windows and SQL Server on Linux</li>
</ul>
<p>Notes</p>
<ul>
<li>This tool is currently only available for Ubuntu, Red Hat, and CentOS (SUSE coming soon!).</li>
</ul>
<p><b>Next Steps:</b><br />
See more usage examples and read more about mssql-scripter at <a href="https://github.com/Microsoft/sql-xplat-cli">https://github.com/Microsoft/sql-xplat-cli</a> and get started with the DBFS today at <a href="https://github.com/Microsoft/dbfs">https://github.com/Microsoft/dbfs</a>.</p>
<p>We are open to suggestions, feedback, questions, and of course contributions to the project itself.</p>
]]></content:encoded>
<wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2017/05/17/try-new-sql-server-command-line-tools-to-generate-t-sql-scripts-and-monitor-dynamic-management-views/feed/</wfw:commentRss>
<slash:comments>2</slash:comments>
</item>
<item>
<title>SQL Server 2017 CTP 2.1 now available</title>
<link>https://blogs.technet.microsoft.com/dataplatforminsider/2017/05/17/sql-server-2017-ctp-2-1-now-available/</link>
<pubDate>Wed, 17 May 2017 16:00:00 +0000</pubDate>
<dc:creator><![CDATA[SQL Server Team]]></dc:creator>
<category><![CDATA[Uncategorized]]></category>
<guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=20495</guid>
<description><![CDATA[Microsoft is excited to announce a new preview for the next version of SQL Server (SQL Server 2017). Community Technology Preview (CTP) 2.1 is available on both Windows and Linux. In this preview, we added manageability features to make it easier to configure SQL Server in Docker containers. We’re also introducing some new command line... <a aria-label="read more about SQL Server 2017 CTP 2.1 now available" href="https://blogs.technet.microsoft.com/dataplatforminsider/2017/05/17/sql-server-2017-ctp-2-1-now-available/" class="read-more">Read more</a>]]></description>
<content:encoded><![CDATA[<p>Microsoft is excited to announce a new preview for the next version of SQL Server (SQL Server 2017). Community Technology Preview (CTP) 2.1 is available on both Windows and Linux. In this preview, we added manageability features to make it easier to configure SQL Server in Docker containers. We’re also introducing some new command line tools for managing SQL Server in our GitHub repo. And, there’s a preview of SQL Server Integration Services on Linux to try! You can try the SQL Server 2017 preview in your choice of development and test environments now: <a href="http://www.microsoft.com/sqlserver2017">www.microsoft.com/sqlserver2017</a>.</p>
<h2>Key CTP 2.1 enhancements</h2>
<p>The primary enhancement to SQL Server 2017 in this release is the ability to configure SQL Server configuration settings through environment variables passed in as parameters to <strong>docker run</strong>. This enables many of the SQL Server configuration scenarios in Docker containers such as setting the collation.</p>
<p>For additional detail on CTP 2.1, please visit <a href="https://msdn.microsoft.com/en-US/library/mt788653(SQL.130).aspx">What’s New in SQL Server 2017</a>, <a href="https://msdn.microsoft.com/en-US/library/mt788652(SQL.130).aspx">Release Notes</a> and <a href="https://docs.microsoft.com/en-us/sql/linux/">Linux documentation</a>.</p>
<h2>SQL Server Integration Services on Linux</h2>
<p>SQL Server Integration Services now supports Linux for the first time! Today we are also releasing a preview of SQL Server Integration Services for Ubuntu. The preview enables you to run SSIS packages on the Linux OS, extract data from and load it to most common sources and targets, and perform common transformations. It has a simple command line installation. For more information, see our <a href="https://blogs.msdn.microsoft.com/ssis/2017/05/17/ssis-helsinki-is-available-in-sql-server-vnext-ctp2-1/">SSIS blog</a>.</p>
<h2>Updated SQL Server Tooling</h2>
<p><strong>The </strong><a href="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms">latest release of SQL Server Management Studio</a><strong> is out! It features improvements to how it works with SQL Server on Linux so make sure you have the latest.</strong> In addition, we are excited to announce the public preview availability of two new command line tools for SQL Server:</p>
<ul>
<li>The <a href="https://github.com/Microsoft/sql-xplat-cli">mssql-scripter tool</a> enables developers, DBAs, and sysadmins to generate CREATE and INSERT T-SQL scripts for database objects in SQL Server, Azure SQL DB, and Azure SQL DW from the command line.</li>
<li>The <a href="https://github.com/Microsoft/dbfs">DBFS tool</a> enables DBAs and sysadmins to monitor SQL Server more easily by exposing live data from SQL Server Dynamic Management Views (DMVs) as virtual files in a virtual directory on Linux operating systems.</li>
</ul>
<h2>New lightweight installer for SQL Server Reporting Services (SSRS)</h2>
<p>In CTP 2.1, we moved Reporting Services installation from the SQL Server installer to a separate installer. This is a packaging change, not a product change; access to SQL Server Reporting Services is still included with your SQL Server license. The new installation process keeps our packages lean and enables customers to deploy and update Reporting Services with zero impact on your SQL Server deployments and databases.</p>
<p>To learn more about what’s new in SQL Server 2017 Reporting Services preview, read our<a href="https://docs.microsoft.com/en-us/sql/reporting-services/what-s-new-in-sql-server-reporting-services-ssrs"> Reporting Services Release Notes</a>. To download the latest preview in the new lightweight installer, go to <a href="https://aka.ms/ssrs2017download">https://aka.ms/ssrs2017download</a></p>
<p>To learn more about the recent announcement of a Power BI Report Server preview, which includes the capabilities of SQL Server 2017 Reporting Services <em>and</em> support for Power BI reports, you can <a href="https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/03/introducing-power-bi-report-server-for-on-premises-power-bi-report-publishing/">read this blog article</a>.</p>
<h2>Get SQL Server 2017 CTP 2.1 today!</h2>
<p>Try the preview of the SQL Server 2017 today! Get started with the preview of SQL Server with <a href="http://www.microsoft.com/sql-server/developer-get-started">our updated developer tutorials</a> that show you how to install and use SQL Server 2017 on macOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice.</p>
<ul>
<li><strong> </strong>Register to attend an Engineering Town Hall about <a href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Finfo.microsoft.com%2Fsql-server-on-linux-town-hall-client-tools.html&data=02%7C01%7Cdelyons%40microsoft.com%7Cb5c7284f464d4b74452808d490dfa483%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636292737754593275&sdata=Fwz0FQ%2FgqT9WgqlYKN2tD7BMmD9xH28NTxMmpR1a0Ak%3D&reserved=0">Client Tools</a><strong> (May 25) or </strong><a href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Finfo.microsoft.com%2Fsql-server-on-linux-town-hall-backup.html&data=02%7C01%7Cdelyons%40microsoft.com%7Cb5c7284f464d4b74452808d490dfa483%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636292737754593275&sdata=9A9Ls1iXdUh546IXxMtomQ8lFw579KiHZ4tV5huSR70%3D&reserved=0">Backup</a><strong> (June 8)</strong></li>
<li><strong>Watch our recent </strong><a href="https://info.microsoft.com/sql-server-on-linux-town-hall-security-register.html">Security</a> and <a href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Finfo.microsoft.com%2Fsql-server-on-linux-town-hall-monitoring.html&data=02%7C01%7Cdelyons%40microsoft.com%7Cb5c7284f464d4b74452808d490dfa483%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636292737754593275&sdata=YPGbSnkVidyLV5Yrc5WosFeXZcHGFJbsvjkELqMMXbw%3D&reserved=0">Monitoring</a> town halls on-demand</li>
<li><a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-red-hat">Install on Red Hat Enterprise Linux</a></li>
<li><a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ubuntu">Install on Ubuntu Linux</a></li>
<li><a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-suse-linux-enterprise-server">Install on SUSE Linux Enterprise Server</a></li>
<li><a href="https://docs.microsoft.com/en-us/sql/linux/">Pull and run a Linux Docker container on Linux, Windows, or macOS</a></li>
<li><a href="https://www.microsoft.com/evalcenter/evaluate-sql-server-vnext-ctp">Download the preview for Windows</a></li>
<li><a href="https://azure.microsoft.com/en-us/marketplace/?term=%22SQL+Server+vNext%22">Create a SQL Server on Linux virtual machine in Azure</a></li>
<li><a href="https://aka.ms/eapsignup">Sign up for the Early Adoption Program (EAP)</a>, designed to help customers and partners evaluate new features in SQL Server 2017, and to build and deploy applications for SQL Server 2017 on Windows and Linux.</li>
</ul>
<p>Have questions? Join the discussion of SQL Server 2017 at <a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home">MSDN</a>. If you run into an issue or would like to make a suggestion, you can let us know through <a href="https://connect.microsoft.com/SQLServer">Connect</a>. We look forward to hearing from you!</p>
]]></content:encoded>
</item>
</channel>
</rss>
