Data-driven insights right from your database

<?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>Tue, 20 Dec 2016 23:00:22 +0000</lastBuildDate> <language>en-US</language> <sy:updatePeriod>hourly</sy:updatePeriod> <sy:updateFrequency>1</sy:updateFrequency> <item> <title>SQL Server next version Community Technology Preview 1.1 now available</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/16/sql-server-next-version-community-technology-preview-1-1-now-available/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/16/sql-server-next-version-community-technology-preview-1-1-now-available/#comments</comments> <pubDate>Fri, 16 Dec 2016 20: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=18365</guid> <description><![CDATA[Microsoft is excited to announce that the next version of SQL Server (SQL Server v.Next) Community Technology Preview (CTP) 1.1 is now available for download on both Windows and Linux. In SQL Server v.Next CTP 1.1, part of our rapid preview model, we made enhancements to several database engine and Business Intelligence (BI) capabilities which... <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/16/sql-server-next-version-community-technology-preview-1-1-now-available/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p>Microsoft is excited to announce that the next version of SQL Server (SQL Server v.Next) Community Technology Preview (CTP) 1.1 is now available for download on both Windows and Linux. In SQL Server v.Next CTP 1.1, part of our rapid preview model, we made enhancements to several database engine and Business Intelligence (BI) capabilities which you can try in your development and test environments.</p> <h2>Key enhancements in SQL Server v.Next on Windows CTP 1.1 for Analysis Services tabular models include:</h2> <ul> <li>New infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This infrastructure enables: <ul> <li>Support for additional data sources, such as MySQL. Additional data sources are planned in upcoming CTPs.</li> <li>Data transformation and data mashup capabilities.</li> </ul> </li> <li>Support for BI tools such as Microsoft Excel enable 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>Support for ragged hierarchies in reports, such as organizational and account charts.</li> <li>Enhanced security for tabular models, including the ability to set permissions to help secure individual tables.</li> </ul> <p>For more detailed information about Analysis Services in SQL Server v.Next CTP 1.1, see the <a href="https://go.microsoft.com/fwlink/?linkid=837760">Analysis Services Team Blog</a>.</p> <h2>Key SQL Server v.Next on Windows and Linux CTP 1.1 database engine enhancements include:</h2> <ul> <li>Language and performance enhancements to natively compiled T-SQL modules, including support for OPENJSON, FOR JSON, JSON built ins as well as memory-optimized tables support for computed columns.</li> <li>Improved the performance of updates to non-clustered columnstore indexes in the case when the row is in the delta store.</li> <li>Batch mode queries now support &#8220;memory grant feedback loops,” which learn from memory used during query execution and adjusts on subsequent query executions; this can allow more queries to run on systems that are otherwise blocking on memory.</li> <li>New T-SQL language features: <ul> <li>Introducing three new string functions: TRIM, CONCAT_WS, and TRANSLATE</li> <li>BULK IMPORT supports CSV format and Azure Blob Storage as file source</li> <li>STRING_AGG supports WITHIN GROUP (ORDER BY)s</li> </ul> </li> </ul> <p>In addition, we have added support for Red Hat 7.3 and Ubuntu 16.10 to <b>SQL Server on Linux</b>.</p> <p>For additional detail, please visit <a href="https://msdn.microsoft.com/en-US/library/mt788653(SQL.130).aspx">What’s New in SQL Server v.Next</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>Download SQL Server v.Next CTP 1.1 preview today!</h2> <p>SQL Server v.Next brings the power of SQL Server to both Windows – and for the first time ever – Linux.  SQL Server enables developers and organizations to build intelligent applications with industry-leading performance and security technologies using their preferred language and environment.</p> <p>Try the preview of the next release of SQL Server today! Get started with the preview of SQL Server on Linux, macOS (via Docker) and Windows with <a href="http://www.microsoft.com/sql-server/developer-get-started">our developer tutorials</a> that show you how to install and use SQL Server v.Next on macOS, Docker, Windows, RHEL and Ubuntu and quickly build an app in a programming language of your choice.</p> <ul> <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/">Pull and run a 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>Install on SUSE Linux Enterprise Server (coming soon)</li> </ul> <p>Visit the <a href="http://www.sqlserveronlinux.com/">SQL Server v.Next webpage</a> to learn more.  To experience the new, exciting features in SQL Server v.Next and our rapid release model, download the preview on Linux and Windows and start evaluating the impact these new innovations can have for your business. Have questions? Join the discussion of the new SQL Server v.Next capabilities 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 at <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/2016/12/16/sql-server-next-version-community-technology-preview-1-1-now-available/feed/</wfw:commentRss> <slash:comments>2</slash:comments> </item> <item> <title>SQL Server on Linux: How? Introduction</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/16/sql-server-on-linux-how-introduction/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/16/sql-server-on-linux-how-introduction/#comments</comments> <pubDate>Fri, 16 Dec 2016 18:00:21 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=18105</guid> <description><![CDATA[This post was authored by Scott Konersmann, Partner Engineering Manager, SQL Server, Slava Oks, Partner Group Engineering Manager, SQL Server, and Tobias Ternstrom, Principal Program Manager, SQL Server Introduction We first announced SQL Server on Linux in March, and recently released the first public preview of SQL Server on Linux (SQL Server v.Next CTP1) at... <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/16/sql-server-on-linux-how-introduction/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p>This post was authored by Scott Konersmann, Partner Engineering Manager, SQL Server, Slava Oks, Partner Group Engineering Manager, SQL Server, and Tobias Ternstrom, Principal Program Manager, SQL Server</p> <h4><a><span style="color: #000000">Introduction</span></a></h4> <p>We <a href="http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/#sm.00000g5feswlpncs5vljgonb8xzu0">first announced</a> SQL Server on Linux in March, and recently released the <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/announcing-sql-server-on-linux-public-preview-first-preview-of-next-release-of-sql-server/">first public preview of SQL Server on Linux</a> (SQL Server v.Next CTP1) at the Microsoft Connect(); conference. We’ve been pleased to see the positive reaction from our customers and the community; in the two weeks following the release, there were more than 21,000 downloads of the preview. A lot of you are curious to hear more about how we made SQL Server run on Linux (and some of you have already figured out and posted interesting articles about part of the story with “Drawbridge”). We decided to kick off a blog series to share technical details about this very topic starting with an introduction to the journey of offering SQL Server on Linux. Hopefully you will find it as interesting as we do! J</p> <h4>Summary</h4> <p>Making SQL Server run on Linux involves introducing what is known as a Platform Abstraction Layer (“PAL”) into SQL Server. This layer is used to align all operating system or platform specific code in one place and allow the rest of the codebase to stay operating system agnostic. Because of SQL Server’s long history on a single operating system, Windows, it never needed a PAL. In fact, the SQL Server database engine codebase has many references to libraries that are popular on Windows to provide various functionality. In bringing SQL Server to Linux, we set strict requirements for ourselves to bring the full functional, performance, and scale value of the SQL Server RDBMS to Linux. This includes the ability for an application that works great on SQL Server on Windows to work equally great against SQL Server on Linux. Given these requirements and the fact that the existing SQL Server OS dependencies would make it very hard to provide a highly capable version of SQL Server outside of Windows in reasonable time it was decided to marry parts of the Microsoft Research (MSR) project <a href="https://www.microsoft.com/en-us/research/project/drawbridge/">Drawbridge</a> with SQL Server’s existing platform layer <a href="https://blogs.msdn.microsoft.com/slavao/2005/07/20/platform-layer-for-sql-server/">SQL Server Operating System</a> (SOS) to create what we call the SQLPAL. The Drawbridge project provided an abstraction between the underlying operating system and the application for the purposes of secure containers and SOS provided robust memory management, thread scheduling, and IO services. Creating SQLPAL enabled the existing Windows dependencies to be used on Linux with the help of parts of the Drawbridge design focused on OS abstraction while leaving the key OS services to SOS. We are also changing the SQL Server database engine code to by-pass the Windows libraries and call directly into SQLPAL for resource intensive functionality.</p> <h4><a><span style="color: #000000">Requirements for supporting Linux</span></a></h4> <p>SQL Server is Microsoft’s flagship database product which with close to 30 years of development behind it. At a high level, the list below represents our requirements as we designed the solution to make the SQL Server RDBMS available on multiple platforms:</p> <ol> <li>Quality and security must meet the same high bar we set for SQL Server on Windows</li> <li>Provide the same value, both in terms of functionality, performance, and scale</li> <li>Application compatibility between SQL Server on Windows and Linux</li> <li>Enable a continued fast pace of innovation in the SQL Server code base and make sure new features and fixes appear immediately across platforms</li> <li>Put in place a foundation for future SQL Server suite services (such as Integration Services) to come to Linux</li> </ol> <p>To make SQL Server support multiple platforms, the engineering task is essentially to remove or abstract away its dependencies on Windows. As you can imagine, after decades of development against a single operating system, there are plenty of OS-specific dependencies across the code base. In addition, the code base is huge. There are tens of millions of lines of code in SQL Server.</p> <p>SQL Server depends on various libraries and their functions and semantics commonly used in Windows development that fall into three categories:</p> <ul> <li>“Win32” (ex. user32.dll)</li> <li>NT Kernel (ntdll.dll)</li> <li>Windows application libraries (such as MSXML)</li> </ul> <p>You can think of these as core library functions, most of them have nothing to do with the operating system kernel and only execute in user mode.</p> <p>While SQL Server has dependencies on both Win32 and the Windows kernel, the most complex dependency is that of Windows application libraries that have been added over the years in order to provide new functionality.  Here are some examples:</p> <ul> <li>SQL Server’s XML support uses <a href="https://en.wikipedia.org/wiki/MSXML">MSXML</a> which is used to parse and process XML documents within SQL Server.</li> <li>SQLCLR hosts the Common Language Runtime (<a href="https://en.wikipedia.org/wiki/Common_Language_Runtime">CLR</a>) for both system types as well as user defined types and CLR stored procedures.</li> <li>SQL Server has some components written in <a href="https://en.wikipedia.org/wiki/Component_Object_Model">COM</a> like the <a href="https://www.microsoft.com/en-us/download/details.aspx?id=17282">VDI</a> interface for backups.</li> <li>Heterogeneous distributed transactions are controlled through Microsoft Distributed Transaction Coordinator (MS <a href="https://en.wikipedia.org/wiki/Microsoft_Distributed_Transaction_Coordinator">DTC</a>)</li> <li>SQL Server Agent integrates with many Windows subsystems (shell execution, Windows Event Log, SMTP Mail, etc.).</li> </ul> <p>These dependencies are the biggest challenge for us to overcome to meet our goals of bringing the same value and having a very high level compatibility between SQL Server on Windows and Linux. As an example, to re-implement something like SQLXML would take a significant amount of time and would run a high risk of not providing the same semantics as before, and could potentially break applications. The option of completely removing these dependencies would mean we must also remove the functionality they provide from SQL Server on Linux. If the dependencies were edge cases and only impacting very few customer visible features, we could have considered it. As it turns out, removing them would cause us to have to remove tons of features from SQL Server on Linux which would go against our goals around compatibility and value across operating systems.</p> <p>We could take the approach of doing this re-implementation piecemeal, bringing value little by little. While this would be possible, it would also go against the requirements because it would mean that there would be a significant gap between SQL Server on Linux and Windows for years. The resolution lies in the right platform abstraction layer.</p> <h2>Building a PAL</h2> <p>Software that is supported across multiple operating systems always has an implementation of some sort of Platform Abstraction Layer (PAL). The PAL layer is responsible for abstraction of the calls and semantics of the underlying operating system and its libraries from the software itself. The next couple of sections consider some of the technology that we investigated as solutions to building a PAL for SQL Server.</p> <h4>SQL Operating System (SOS or SQLOS)</h4> <p>In the SQL Server 2005 release, a platform layer was created between the SQL Server engine and Windows called the SQL Operating System (SOS). This layer was responsible for user mode thread scheduling, memory management, and synchronization (see <a href="https://blogs.msdn.microsoft.com/slavao/2005/07/20/platform-layer-for-sql-server/">SQLOS</a> for reference).  A key reason for the creation of SOS was that it allowed for a centralized set of low level management and diagnostics functionality to be provided to customers and support (subset of Dynamic Management Views/DMVs and Extended Events/XEvents).  This layer allowed us to minimize the number of system calls involved in scheduling execution by running non-preemptively and letting SQL Server do its own resource management.  While SOS improved performance and greatly helped supportability and debugging, it did not provide a proper abstraction layer from the OS dependencies described above, i.e. Windows semantics were carried through SOS and exposed to the database engine.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2016/12/012.jpg"><img title="01" style="float: none;padding-top: 0px;padding-left: 0px;margin-left: auto;padding-right: 0px;margin-right: auto;border: 0px" border="0" alt="01" src="https://msdnshared.blob.core.windows.net/media/2016/12/01_thumb.jpg" width="939" height="630" class="aligncenter" /></a></p> <p>In the scenario where we would completely remove the dependencies on the underlying operating system from the database engine, the best option was to grow SOS into a proper Platform Abstraction Layer (PAL).  <b>All</b> the calls to Windows APIs would be routed through a new set of equivalent APIs in SOS and a new host extension layer would be added on the bottom of SOS that would interact with the operating system. While this would resolve the system call dependencies, it would not help with the dependencies on the higher-level libraries.</p> <h4><a><span style="color: #000000">Drawbridge</span></a></h4> <p>Drawbridge was an Microsoft Research project (see <a href="https://www.microsoft.com/en-us/research/project/drawbridge/">Drawbridge</a> for reference) that focused on drastically reducing the virtualization resource overhead incurred when hosting many Virtual Machines on the same hardware.  The research involved two ideas.  The first idea was a “picoprocess” which consists of an empty address space, a monitor process that interacts with the host operating system on behalf of the picoprocess, and a kernel driver that allows a driver to populate the address space at startup and implements a host Application Binary Interface (ABI) that allows the picoprocess to interact with the host.  The second idea was a user mode Library OS, sometimes referred to as LibOS.  Drawbridge provided a working Windows Library OS that could be used to run Windows programs on a Windows host.  This Library OS implements a subset of the 1500+ Win32 and NT ABIs and stubs the rest to either succeed or fail depending on the type of call.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2016/12/021.png"><img title="02" style="float: none;padding-top: 0px;padding-left: 0px;margin-left: auto;padding-right: 0px;margin-right: auto;border: 0px" border="0" alt="02" src="https://msdnshared.blob.core.windows.net/media/2016/12/02_thumb.png" width="700" height="930" class="aligncenter" /></a></p> <p>Our needs didn’t align with the original goals of the Drawbridge research.  For instance, the picoprocess idea isn’t something needed for moving SQL Server to other platforms.  However, there were a couple of synergies that stood out:</p> <ol> <li>Library OS implemented most of the 1500+ Windows ABIs in user mode and only 45-50 ABIs were needed to interact with the host.  These ABIs were for address space and memory management, host synchronization, and IO (network and disk).  This made for a very small surface area that needs to be implemented to interact with a host.  That is extremely attractive from a platform abstraction perspective.</li> <li>Library OS was capable of hosting other Windows components.  Enough of the Win32 and NT layers were implemented to host CLR, MSXML, and other APIs that the SQL suite depends on. This meant that we could get more functionality to work without rewriting whole features.</li> </ol> <p>There were also some risk and reward tradeoffs:</p> <ol> <li>The Microsoft Research project was complete and there was no support for Drawbridge. Therefore, we needed to take a source snapshot and modify the code for our purposes.  The risks were around the costs to ramp up a team on the Library OS, modify it to be suitable for SQL Server, and make it perform comparably with Windows.  On the positive side, this would mean everything is in user mode and we would own all the code within the stack.  Performance critical code can be optimized because we can modify all layers of the stack including SQL Server, the Library OS, and the host interface as needed to make SQL Server perform.  Since there are no real boundaries in the process, it is possible for SQL Server to call Linux.</li> <li>The original Drawbridge project was built on Windows and used a kernel driver and monitor process.  This would need to be dropped in favor of a user mode only architecture.  In the new architecture, the host extension (referred to as PAL in the Drawbridge design) on Windows would move from a kernel driver to just a user mode program.  Interestingly enough, one of the researchers had developed a rough prototype for Linux that proved it could be done.</li> <li>Because the technologies were created independently there was a large amount of overlapping functionality.  SOS had subsystems for object management, memory management, threading/scheduling, synchronization, and IO (disk and network). The Library OS and Host Extension also had similar functionality.  These systems would need to be rationalized down to a single implementation.</li> </ol> <table align="center" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr> <td valign="top" width="161"><b>Technologies</b></td> <td valign="top" width="144"> <p align="center"><b>SOS</b></p> </td> <td valign="top" width="156"> <p align="center"><b>Library OS</b></p> </td> <td valign="top" width="160"> <p align="center"><b>Host Extension</b></p> </td> </tr> <tr> <td valign="top" width="161"> <p align="left">Object Management</p> </td> <td valign="top" width="144"> <p align="center">✔</p> </td> <td valign="top" width="156"> <p align="center">✔</p> </td> <td valign="top" width="160"> <p align="center">✔</p> </td> </tr> <tr> <td valign="top" width="161"> <p align="left">Memory Management</p> </td> <td valign="top" width="144"> <p align="center">✔</p> </td> <td valign="top" width="156"> <p align="center">✔</p> </td> <td valign="top" width="160"> <p align="center">✔</p> </td> </tr> <tr> <td valign="top" width="161"> <p align="left">Threading/Scheduling</p> </td> <td valign="top" width="144"> <p align="center">✔</p> </td> <td valign="top" width="156"> <p align="center">✔</p> </td> <td valign="top" width="160"> <p align="center">✔</p> </td> </tr> <tr> <td valign="top" width="161"> <p align="left">Synchronization</p> </td> <td valign="top" width="144"> <p align="center">✔</p> </td> <td valign="top" width="156"> <p align="center">✔</p> </td> <td valign="top" width="160"> <p align="center">✔</p> </td> </tr> <tr> <td valign="top" width="161"> <p align="left">I/O (Disk, Network)</p> </td> <td valign="top" width="144"> <p align="center">✔</p> </td> <td valign="top" width="156"> <p align="center">✔</p> </td> <td valign="top" width="160"> <p align="center">✔</p> </td> </tr> </tbody> </table> <p>&nbsp;</p> <h4><a></a><a><span style="color: #000000">Meet </span></a><span style="color: #000000">SQLPAL</span></h4> <p>As a result of the investigation, we decided on a hybrid strategy.  We would merge SOS and Library OS from Drawbridge to create the SQL PAL (SQL Platform Abstraction Layer). For areas of Library OS that SQL Server does not need, we would remove them. To merge these architectures, changes were needed in all layers of the stack.</p> <p>The new architecture consists of a set of SOS direct APIs which don’t go through any Win32 or NT syscalls.  For code without SOS direct APIs they will either go through a hosted Windows API (like MSXML) or NTUM (NT User Mode API – this is the 1500+ Win32 and NT syscalls). All the subsystems like storage, network, or resource management will be based on SOS and will be shared between SOS direct and NTUM APIs.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2016/12/031.png"><img title="03" style="float: none;padding-top: 0px;padding-left: 0px;margin-left: auto;padding-right: 0px;margin-right: auto;border: 0px" border="0" alt="03" src="https://msdnshared.blob.core.windows.net/media/2016/12/03_thumb.png" width="1141" height="545" class="aligncenter" /></a></p> <p>This architecture provides some interesting characteristics:</p> <ul> <li>Everything running in process boils down to the same platform assembly code.  The CPU can’t tell the difference between the code that is providing Win32 functionality to SQL Server or native Linux code.</li> <li>Even though the architecture shows layering, there are no real boundaries within the process (<a href="https://en.wikipedia.org/wiki/The_Matrix">There is no spoon!</a>).  If code running in SQL Server which is performance critical needs to call Linux it can do that directly with a very small amount of assembler via the SOS direct APIs to setup the stack correctly and process the result.  An example where this has been done is the disk IO path.  There is a small amount of conversion code left to convert from Windows scatter/gather input structure to Linux vectored IO structure.  Other disk IO types don’t require any conversions or allocations.</li> <li>All resources in the process can be managed by SQLPAL.  In SQL Server, before SQLPAL, most resources such as memory and threads were controlled, but there were some things outside it’s control.  Some libraries and Win32/NT APIs would create threads on their own and do memory allocations without using the SOS APIs.  With this new architecture, even the Win32 and NT APIs would be based on SQLPAL so every memory allocation and thread would be controlled by SQL PAL. As you can see this also benefits SQL Server on Windows.</li> <li><a><span style="color: #000000">For SQL Server on Linux we are using about 81 MB of uncompressed Windows libraries, so it’s a tiny fraction (less than 1%) of a typical Windows installation. SQLPAL itself is currently around 8 MB.</span></a></li> </ul> <h4>Process Model</h4> <p>The following diagram shows what the address space looks like when running.   The host extension is simply a native Linux application.  When host extension starts it loads and initializes SQLPAL, SQLPAL then brings up SQL Server.  SQLPAL can launch software isolated processes that are simply a collection of threads and allocations running within the same address space.  We use that for things like SQLDumper which is an application that is run when SQL Server encounters a problem to collect an enlightened crash dump.</p> <p>One point to reiterate is that even though this might look like a lot of layers there aren’t any hard boundaries between SQL Server and the host.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2016/12/041.png"><img title="04" style="float: none;padding-top: 0px;padding-left: 0px;margin-left: auto;padding-right: 0px;margin-right: auto;border: 0px" border="0" alt="04" src="https://msdnshared.blob.core.windows.net/media/2016/12/04_thumb.png" width="467" height="712" class="aligncenter" /></a></p> <h4><a><span style="color: #000000">Evolution of SQLPAL</span></a></h4> <p>At the start of the project, SQL Server was built on SOS and Library OS was independent.  The eventual goal is to have a merged SOS and Library OS as the core of SQL PAL.  For public preview, this merge wasn’t fully completed, but the heart of SQLPAL had been replaced with SOS.  For example, threads and memory already use SOS functionality instead of the original Drawbridge implementations.</p> <p>The result is that there are two instances of SOS running inside the CTP1 release: one in SQL Server and one in SQLPAL .  This works fine because the SOS instance in SQL Server is still using Win32 APIs which call down into the SQLPAL.  The SQLPAL instance of the SOS code has been changed to call the host extension ABIs (i.e. the native Linux code) instead of Win32.</p> <p>Now we are working on removing the SOS instance from SQL Server.  We are exposing the SOS APIs from the SQLPAL.  Once this is completed everything will flow through the single SQLPAL SOS instance.</p> <h2>More posts</h2> <p>We are planning more of these posts to share to tell you about our journey, which we believe has been amazing and a ton of fun worth sharing. Please provide comments if there are specific areas you are interested in us covering!</p> <p>Thanks!</p> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/16/sql-server-on-linux-how-introduction/feed/</wfw:commentRss> <slash:comments>7</slash:comments> </item> <item> <title>SQL Server + C#: What&#8217;s new</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/15/sql-server-c-whats-new/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/15/sql-server-c-whats-new/#respond</comments> <pubDate>Thu, 15 Dec 2016 17:00:11 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=18355</guid> <description><![CDATA[This post was authored by Andrea Lam, Program Manager, SQL Server With the release of SQL Server v.Next public preview on Linux and Windows, the ability to connect to SQL Server on Linux, Windows, Docker or macOS (via Docker) makes cross-platform support for all connectors, including .NET Framework and .NET Core SqlClient, even more important.... <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/15/sql-server-c-whats-new/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p>This post was authored by Andrea Lam, Program Manager, SQL Server</p> <p><iframe width="960" height="540" src="https://channel9.msdn.com/Events/Connect/2016/151/player" frameborder="0" allowfullscreen="allowfullscreen"></iframe></p> <p>With the release of <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/announcing-sql-server-on-linux-public-preview-first-preview-of-next-release-of-sql-server/">SQL Server v.Next public preview on Linux and Windows</a>, the ability to connect to SQL Server on Linux, Windows, Docker or macOS (via Docker) makes cross-platform support for all connectors, including .NET Framework and .NET Core SqlClient, even more important. To enable C# developers to use the newest SQL Server features, we have been updating SqlClient with client-side support for new features.</p> <p>In .NET Framework, we have provided client-side support for Always Encrypted and added Azure Active Directory as an authentication method. We’ve also added a new connection string parameter called “Pool Blocking Period.” It can be used to select the behavior of the <a href="https://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.110).aspx">blocking period</a> when connecting to Azure SQL Database and SQL Server. Many applications that connect to Azure SQL Database need to render quickly, and the exponential blocking period can be problematic, especially when throwing errors. By adding the Pool Blocking Period parameter, we aim to improve the experience for connections to Azure SQL Database. Learn more about the new parameter <a href="https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.poolblockingperiod(v=vs.110).aspx">here</a>.</p> <p><a href="https://github.com/dotnet/core">.NET Core</a> is the cross-platform, open-source implementation of the .NET Framework. The project includes <a href="https://github.com/dotnet/corefx">CoreFX</a>, the foundational libraries of .NET Core. Cross-platform support allows developers to seamlessly run applications on their operating system of choice, regardless of the platform it was developed on. For example, an app developed on Windows can be deployed to macOS and Linux, without ever having to port any code. To connect apps written in .NET Core to SQL Server (hosted anywhere), developers can use System.Data.SqlClient available in CoreFX. By developing in .NET Core on GitHub, we have been able to get feedback quickly and are actively working to enable the breadth of application scenarios and workloads.</p> <h4>Get started today</h4> <ul> <li>Check out <a href="https://github.com/dotnet/corefx">CoreFX on GitHub</a>! Make pull requests and let us know what you think.</li> <li>Try the new <a href="http://aka.ms/sqldev?utm_medium=Referral&amp;utm_source=https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/14/sql-server-c-whats-new/">getting started tutorials</a> that show you how to: <ul> <li>Install SQL Server on Linux/macOS/Docker/Windows</li> <li>Create a simple app using C# and other popular programming languages with SQL Server</li> <li>Create a simple app using popular web frameworks and Object Relational Mapping (ORM) frameworks with SQL Server</li> <li>Try out some cool SQL Server features that can make your apps shine</li> </ul> </li> </ul> <h4>Connect with us</h4> <ul> <li>Join the conversation at <a href="https://gitter.im/mssqldev/Lobby">https://gitter.im/mssqldev</a>.</li> <li><a href="https://helsinki.catalysis.com/registration.aspx">Sign up to stay informed</a> about new SQL Server on Linux developments.</li> </ul> <h4>Learn more</h4> <ul> <li>Visit the <a href="https://channel9.msdn.com/Events/Connect/2016">Connect(); webpage</a> to watch overview, security, high-availability and developer tools videos about SQL Server on Linux on demand.</li> <li>Visit the <a href="http://www.sqlserveronlinux.com/">webpage for the next release of SQL Server</a>.</li> </ul> <h4>Other videos in this series</h4> <ul> <li><a href="https://channel9.msdn.com/events/connect/2016/160">SQL Server + Node.js: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/152">SQL Server + Java: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/182">SQL Server + PHP: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/189">SQL Server + Python: what’s new</a></li> <li>Watch the <a href="https://www.youtube.com/watch?v=oEpJB87Xg9U&amp;feature=youtu.be">Microsoft Mechanics video</a> to see how to get started with SQL Server on Linux in less than a minute.</li> <li><a href="https://channel9.msdn.com/Events/Connect/2016/173/">SQL Server on Linux: use SQL Tools with SQL Server</a></li> </ul> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/15/sql-server-c-whats-new/feed/</wfw:commentRss> <slash:comments>0</slash:comments> </item> <item> <title>SQL Server + PHP &#8211; What&#8217;s new</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/13/sql-server-php-whats-new/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/13/sql-server-php-whats-new/#respond</comments> <pubDate>Tue, 13 Dec 2016 16:00:23 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=18095</guid> <description><![CDATA[This post is authored by Meet Bhagdev, Program Manager, Microsfoft PHP is one of the most widely used programming languages for web developers today. The Microsoft PHP Connector for SQL Server is used to connect PHP applications to SQL Server, whether SQL Server is hosted in the cloud, on-premises or provided as a platform as... <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/13/sql-server-php-whats-new/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p>This post is authored by Meet Bhagdev, Program Manager, Microsfoft</p> <p><iframe width="960" height="540" src="https://channel9.msdn.com/Events/Connect/2016/182/player" frameborder="0" allowfullscreen="allowfullscreen"></iframe></p> <p>PHP is one of the most widely used programming languages for web developers today. The <a href="https://github.com/Microsoft/msphpsql">Microsoft PHP Connector</a> for SQL Server is used to connect PHP applications to SQL Server, whether SQL Server is hosted in the cloud, on-premises or provided as a platform as a service.</p> <p>We recently announced <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/announcing-sql-server-on-linux-public-preview-first-preview-of-next-release-of-sql-server/">SQL Server v.Next CTP1 on Linux and Windows</a>, which brings the power of SQL Server to both Windows and — for the first time ever — Linux. Developers can now create applications with SQL Server on Linux, Windows, Docker or macOS (via Docker) and then deploy to Linux, Windows, or Docker, on-premises or in the cloud.</p> <p>As part of this announcement, we have made some improvements to our PHP connector:</p> <ul> <li><b>SQL Server v.Next Support: </b>You can now use the PHP connectors to connect to SQL Server v.Next CTP1 of SQL Server running anywhere, including SQL Server on Linux, Windows or Docker.</li> <li><b>Linux support: </b>We’ve created Linux-native versions of sqlsrv and pdo_sqlsrv modules of the PHP SQL Server Connector. Now you can use the PHP Connector to connect to SQL Server on Ubuntu 15.04, 15.10, 16.04, Red Hat 6 and Red Hat 7.<b></b></li> <li><b>PHP 7.0 and 7.1 support: </b>We have added support for the latest PHP runtimes for Windows and Linux with our <a href="https://github.com/Microsoft/msphpsql/releases">releases on GitHub</a>.<b> </b></li> <li><b>PECL Install Experience for Linux: </b>We have created native PECL packages for Linux. This enables developers to install, upgrade and uninstall the PHP SQL Server connector using the PECL package repository. This is explained in detail in our <a href="http://aka.ms/sqldev?utm_medium=Referral&amp;utm_source=https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/13/sql-server-php-whats-new/">Getting Started tutorials</a>. <b></b></li> <li><b>Community input for prioritization:</b> We have also started using surveys on GitHub to guide our prioritization for features and improvements. Check our <a href="https://www.surveymonkey.com/r/2C7N8BY">latest survey</a> and let us know what you think. <b></b></li> </ul> <h4>Get started today</h4> <ul> <li>Check out the <a href="https://github.com/Microsoft/msphpsql">PHP connector source code on GitHub</a> and our packages (<a href="https://pecl.php.net/package/sqlsrv">sqlsrv,</a> <a href="https://pecl.php.net/package/pdo_sqlsrv">pdo_sqlsrv</a>) on PECL. Make pull requests and let us know what you think.</li> <li>Try the new <a href="http://aka.ms/sqldev?utm_medium=Referral&amp;utm_source=https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/13/sql-server-php-whats-new/">getting started tutorials</a> that show you how to: <ul> <li>Install SQL Server on Linux or Windows or run on Docker in multiple platforms.</li> <li>Create a simple app using C#, Java, Node.js, PHP and Python with SQL Server.</li> <li>Create a simple app using popular web frameworks and Laravel with SQL Server.</li> <li>Try out some cool SQL Server features that can make your apps shine.</li> </ul> </li> <li>Get the latest v17.0 RC1 versions of <a href="https://msdn.microsoft.com/en-us/library/mt238290.aspx">SQL Server Management Studio (SSMS)</a> and <a href="https://msdn.microsoft.com/en-us/library/mt204009.aspx">SQL Server Data Tools (SSDT)</a>.</li> <li><a href="https://aka.ms/mssql-marketplace">Get the <b>mssql</b> extension</a> for Visual Studio Code and develop apps with SQL Server on Linux/macOS/Windows.</li> </ul> <h4>Connect with us</h4> <ul> <li>Join the conversation at <a href="https://gitter.im/mssqldev/Lobby">https://gitter.im/mssqldev</a>.</li> <li><a href="https://helsinki.catalysis.com/registration.aspx">Sign up to stay informed</a> about new SQL Server on Linux developments.</li> </ul> <h4>Learn more</h4> <ul> <li>Visit <a href="https://channel9.msdn.com/Events/Connect/2016">Connect();</a> to watch overview, security, high-availability and developer tools videos about SQL Server on Linux on demand.</li> </ul> <h4>Learn more</h4> <ul> <li>Go to the <a href="http://www.sqlserveronlinux.com/">next release of SQL Server webpage</a> to get started with interactive SQL Server on Linux hands-on labs for <a href="https://aka.ms/sqlserveronredhatlab4linuxadmins">Linux administrators new to SQL Server</a> and for <a href="https://aka.ms/sqlserveronredhatlab4sqladmins">existing SQL Server database administrators new to Linux</a>.</li> <li>Visit <a href="https://connectevent.microsoft.com/">Connect();</a> to watch overview, security, high-availability and developer tools videos about SQL Server on Linux on demand.</li> </ul> <h4>Other videos in this series</h4> <ul> <li>Watch the <a href="https://www.youtube.com/watch?v=oEpJB87Xg9U&amp;feature=youtu.be">Microsoft Mechanics video</a> to see how to get started with SQL Server on Linux in less than a minute.</li> <li><a href="https://channel9.msdn.com/Events/Connect/2016/173/">SQL Server on Linux: use SQL Tools with SQL Server</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/160">SQL Server + Node.js: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/152">SQL Server + Java: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/151">SQL Server + C#: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/189">SQL Server + Python: what’s new</a></li> </ul> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/13/sql-server-php-whats-new/feed/</wfw:commentRss> <slash:comments>0</slash:comments> </item> <item> <title>SQL Server + Python &#8212; What&#8217;s new</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/09/sql-server-python-whats-new/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/09/sql-server-python-whats-new/#comments</comments> <pubDate>Fri, 09 Dec 2016 16:00:06 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=18056</guid> <description><![CDATA[Python is one of the most popular and fastest-growing languages used today. Pyodbc (Python-SQL Server Connector) is an open source Python module maintained by Michael Kleehammer that uses ODBC Drivers to connect to SQL Server. It allows you to connect from the platform of your choice to SQL Server on-premises and in the cloud. Pyodbc... <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/09/sql-server-python-whats-new/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p><iframe width="960" height="540" src="https://channel9.msdn.com/Events/Connect/2016/189/player" frameborder="0" allowfullscreen="allowfullscreen"></iframe></p> <p>Python is one of the most popular and fastest-growing languages used today. <a href="https://mkleehammer.github.io/pyodbc/">Pyodbc</a> (Python-SQL Server Connector) is an open source Python module maintained by <a href="https://github.com/mkleehammer">Michael Kleehammer</a> that uses ODBC Drivers to connect to SQL Server. It allows you to connect from the platform of your choice to SQL Server on-premises and in the cloud. Pyodbc is also cross platform and can be installed using <a href="https://pypi.python.org/pypi/pyodbc/3.1.1">pip</a>.</p> <p>We recently announced <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/announcing-sql-server-on-linux-public-preview-first-preview-of-next-release-of-sql-server/">SQL Server v.Next CTP1 on Linux and Windows</a>, which brings the power of SQL Server to both Windows and — for the first time ever — Linux. You can now connect your applications to SQL Server running on Linux, Windows and macOS (with Docker).</p> <p>For our Python developers, we have a few updates that will improve Python connectivity with SQL Server. Pyodbc is now:</p> <ul> <li><b>Officially supported:</b> You can contact Microsoft Customer Service and Support (CSS) via phone, email, Twitter, forums, etc., to report and get help with any issue.</li> <li><b>Available in Jupyter Notebooks for SQL Server: </b><a href="https://notebooks.azure.com/">The Jupyter Notebook</a> is a web application that allows you to create and share documents that contain live code, equations and visualizations.<b> </b>Pyodbc and its dependencies ship out of the box with Juypter notebooks on Azure. To get started, go to <a href="https://notebooks.azure.com">notebooks.azure.com</a> and create a new Python 2 notebook or follow the instructions <a href="https://docs.microsoft.com/en-us/azure/virtual-machines/virtual-machines-linux-jupyter-notebook">here</a>. Check out the <a href="https://raw.githubusercontent.com/Microsoft/sql-server-samples/master/samples/tutorials/python/jupyter/sample_python_jupyter.py">code sample</a> and paste it in your notebook’s interactive prompt to get started.</li> <li><b>Compatible with </b><a href="https://pypi.python.org/pypi/pyodbc/3.1.1"><b>Python 3.5</b></a><b> and Django 1.10 through </b><a href="https://github.com/michiya/django-pyodbc-azure"><b>Django-pyodbc-azure</b></a><b>. </b></li> </ul> <h4>Get started today</h4> <ul> <li>Try the new <a href="http://aka.ms/sqldev?utm_medium=Referral&amp;utm_source=https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/09/sql-server-python-whats-new/">getting started tutorials</a> that show you how to: <ul> <li>Install SQL Server on Linux or Windows or run on Docker in multiple platforms.</li> <li>Create a simple app using C#, Java, Node.js, PHP and Python with SQL Server.</li> <li>Create a simple app using popular web frameworks like Django with SQL Server.</li> <li>Try out some cool SQL Server features that can make your apps shine.</li> </ul> </li> <li>Get the latest v17.0 RC1 versions of <a href="https://msdn.microsoft.com/en-us/library/mt238290.aspx">SQL Server Management Studio (SSMS)</a> and <a href="https://msdn.microsoft.com/en-us/library/mt204009.aspx">SQL Server Data Tools (SSDT)</a>.</li> <li><a href="https://aka.ms/mssql-marketplace">Get the <b>mssql</b> extension</a> for Visual Studio Code and develop apps with SQL Server on Linux/macOS/Windows.</li> </ul> <h4>Connect with us</h4> <ul> <li>Join the conversation at <a href="https://gitter.im/mssqldev/Lobby">https://gitter.im/mssqldev</a>.</li> <li><a href="https://helsinki.catalysis.com/registration.aspx">Sign up to stay informed</a> about new SQL Server on Linux developments.</li> </ul> <h4>Learn more</h4> <ul> <li>Visit <a href="https://channel9.msdn.com/Events/Connect/2016">Connect();</a> to watch overview, security, high-availability and developer tools videos about SQL Server on Linux on demand.</li> </ul> <h4>Learn more</h4> <ul> <li>Go to the <a href="http://www.sqlserveronlinux.com/">next release of SQL Server webpage</a> to get started with interactive SQL Server on Linux hands-on labs for <a href="https://aka.ms/sqlserveronredhatlab4linuxadmins">Linux administrators new to SQL Server</a> and for <a href="https://aka.ms/sqlserveronredhatlab4sqladmins">existing SQL Server database administrators new to Linux</a>.</li> <li>Visit <a href="https://connectevent.microsoft.com/">Connect();</a> to watch overview, security, high-availability and developer tools videos about SQL Server on Linux on demand.</li> </ul> <h4>Other videos in this series</h4> <ul> <li>Watch the <a href="https://www.youtube.com/watch?v=oEpJB87Xg9U&amp;feature=youtu.be">Microsoft Mechanics video</a> to see how to get started with SQL Server on Linux in less than a minute.</li> <li><a href="https://channel9.msdn.com/Events/Connect/2016/173/">SQL Server on Linux: use SQL Tools with SQL Server</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/160">SQL Server + Node.js: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/152">SQL Server + Java: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/151">SQL Server + C#: what’s new</a></li> <li><a href="https://channel9.msdn.com/Events/Connect/2016/182">SQL Server + PHP: what’s new</a></li> </ul> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/09/sql-server-python-whats-new/feed/</wfw:commentRss> <slash:comments>1</slash:comments> </item> <item> <title>Introducing SQL Server Premium Assurance</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/08/introducing-sql-server-premium-assurance/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/08/introducing-sql-server-premium-assurance/#respond</comments> <pubDate>Thu, 08 Dec 2016 17:00:19 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=18025</guid> <description><![CDATA[IT departments are in a fundamental state of change, with the drive for digital transformation creating many net new applications and moving others to the cloud. At the same time, companies must also maintain stable and secure operation of their existing applications databases. To provide better flexibility in managing these diverse priorities, Microsoft is announcing... <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/08/introducing-sql-server-premium-assurance/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p>IT departments are in a fundamental state of change, with the drive for digital transformation creating many net new applications and moving others to the cloud. At the same time, companies must also maintain stable and secure operation of their existing applications databases. To provide better flexibility in managing these diverse priorities, Microsoft is announcing two new offerings to help you run applications longer without disruption: <a href="http://aka.ms/premiumassurance">Windows Server Premium Assurance and SQL Server Premium Assurance</a>. These offerings add six more years of product support for Windows Server and SQL Server versions 2008 and newer&#8211;for up to 16 years of total product support. The additional support minimizes the risk and costs associated with upgrading critical application databases, and helps to secure data and maintain regulatory compliance for six additional years.</p> <p>To learn more about how Premium Assurance extends the product lifecycles for Windows Server and SQL Server, read the full <a href="https://blogs.technet.microsoft.com/hybridcloud/2016/12/08/introducing-windows-server-premium-assurance-and-sql-server-premium-assurance/">Premium Assurance article on the Hybrid Cloud blog</a>.</p> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/08/introducing-sql-server-premium-assurance/feed/</wfw:commentRss> <slash:comments>0</slash:comments> </item> <item> <title>SQL Server + Node.js &#8211; What&#8217;s new?</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/08/sql-server-node-js-whats-new/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/08/sql-server-node-js-whats-new/#respond</comments> <pubDate>Thu, 08 Dec 2016 13:16:13 +0000</pubDate> <dc:creator><![CDATA[Saloni Sonpal]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=18055</guid> <description><![CDATA[JavaScript is the most popular and active programming language among developers across various industries. Tedious Node.js connector is a JavaScript implementation of the Tabular Data Stream (TDS) protocol. This Node.js connector allows you to connect from platform of your choice to SQL Server on premise and in the cloud. Tedious is a native JavaScript connector... <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/08/sql-server-node-js-whats-new/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p><iframe width="960" height="540" src="https://channel9.msdn.com/Events/Connect/2016/160/player" frameborder="0" allowfullscreen="allowfullscreen"></iframe></p> <p>JavaScript is the most <a href="http://stackoverflow.com/research/developer-survey-2016#technology-most-popular-technologies">popular</a> and <a href="http://githut.info/">active</a> programming language among developers across various industries. <a href="http://tediousjs.github.io/tedious/">Tedious</a> Node.js connector is a JavaScript implementation of the <a href="https://msdn.microsoft.com/en-us/library/dd304523.aspx">Tabular Data Stream (TDS) protocol</a>. This Node.js connector allows you to connect from platform of your choice to SQL Server on premise and in the cloud. Tedious is a native JavaScript connector that provides the <a href="https://www.npmjs.com/package/tedious">npm</a> install experience.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2016/12/Capture2.png"><img title="Capture" style="padding-top: 0px; padding-left: 0px; padding-right: 0px; border: 0px;" border="0" alt="Capture" src="https://msdnshared.blob.core.windows.net/media/2016/12/Capture_thumb1.png" width="185" height="240" class="aligncenter" /></a></p> <p>I’m pleased to share that Microsoft is now a collaborator for <a href="https://github.com/tediousjs/tedious/">Tedious on GitHub</a> and contributes actively to this community-initiated effort. The Tedious Node.js connector is:</p> <ul> <li><b>Cross-platform:</b> You can connect to SQL Server anywhere from node.js from platform of your choice – be it Windows, macOS, or Linux.</li> <li><b>Open-source:</b> As a matter of fact, it is a project initiated by the open-source community and continues to be driven by the community. This allows us to engage with developers on GitHub, develop transparently and gather feedback quickly.</li> <li><b>Officially supported:</b> You can contact Microsoft Customer Service and Support (CSS) via phone, email, twitter, forums, etc. to report and get help with any issue.</li> </ul> <p>We are fixing bugs found via issues reported on GitHub and are partnering with developers to make Tedious better. We are planning on adding support for advanced SQL Server features like <a href="https://msdn.microsoft.com/en-us/library/ff878716.aspx">Multi-Subnet Failover</a>, <a href="https://msdn.microsoft.com/en-us/library/hh510230.aspx">Always On Availability Groups</a>, <a href="https://msdn.microsoft.com/en-us/library/mt163865.aspx">Always Encrypted</a>, <a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication">Azure Active Directory (AAD)</a>, etc.</p> <p>Windows Integrated Authentication is the most common <a href="https://github.com/tediousjs/tedious/issues/415">issue</a> reported by developers on GitHub and the top request from customers. In response to customer feedback we are working on adding support for it in the next release of Tedious.</p> <h4>Get started today</h4> <ul> <li>Check out <a href="https://github.com/tediousjs/tedious/">GitHub repo for Tedious</a> and contribute.</li> <li>File issues for bugs, feature requests, questions, etc. on GitHub and help us prioritize.</li> <li>Follow the <a href="https://groups.google.com/forum/#!forum/node-tedious">Google Group</a> for discussions on Tedious.</li> <li>Try the new <a href="http://aka.ms/sqldev?utm_medium=Referral&amp;utm_source=%7bTODO%7d">getting started tutorials</a> that show you how to: <ul> <li>Install SQL Server on Linux/macOS/Docker/Windows</li> <li>Create a simple app using languages such as C#, Java, Node.js, PHP and Python with SQL Server.</li> <li>Create a simple app using popular web frameworks and Object Relational Mapping (ORM) frameworks with SQL Server.</li> <li>Try out some cool SQL Server features that can make your apps shine.</li> </ul> </li> </ul> <h4>Connect with us</h4> <ul> <li>Join the conversation at: <a href="https://gitter.im/mssqldev/Lobby">https://gitter.im/mssqldev</a></li> <li><a href="https://helsinki.catalysis.com/registration.aspx">Sign up to stay informed</a> about new SQL Server on Linux developments.</li> </ul> <h4>Learn more</h4> <ul> <li>We recently announced <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/announcing-sql-server-on-linux-public-preview-first-preview-of-next-release-of-sql-server/">public preview of the next release of SQL Server on Linux and Windows</a> which brings the power of SQL Server to both Windows – and for the first time ever – Linux.</li> <li>Visit the <a href="https://channel9.msdn.com/Events/Connect/2016">Connect(); webpage</a> to watch videos on overview, security, high availability, and developer tools for SQL Server on Linux on-demand.</li> <li>Go to the <a href="http://www.sqlserveronlinux.com/">next release of SQL Server webpage</a></li> </ul> <h4>Other videos in this series</h4> <ul> <li>Watch the <a href="https://channel9.msdn.com/events/Connect/2016/101">SQL Server on Linux: overview</a> and <a href="https://www.youtube.com/watch?v=oEpJB87Xg9U&amp;feature=youtu.be">Microsoft Mechanics video</a> to see how to get started with SQL Server on Linux in less than a minute</li> <li><a href="https://channel9.msdn.com/Events/Connect/2016/173/">SQL Server on Linux: use SQL Tools with SQL Server</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/152">SQL Server + Java: what’s new</a></li> <li><a href="https://channel9.msdn.com/Events/Connect/2016/182">SQL Server + PHP: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/151">SQL Server + C#: what&#8217;s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/189">SQL Server + Python: what’s new</a></li> </ul> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/08/sql-server-node-js-whats-new/feed/</wfw:commentRss> <slash:comments>0</slash:comments> </item> <item> <title>SQL Server + Java: What&#8217;s new</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/06/sql-server-java-whats-new/</link> <pubDate>Tue, 06 Dec 2016 17:00:26 +0000</pubDate> <dc:creator><![CDATA[SQL Server Team]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=18006</guid> <description><![CDATA[Java continues to be one of the most widely used programming languages for a variety of application scenarios and industries. The Microsoft JDBC Driver for SQL Server is used to connect Java applications to SQL Server, whether SQL Server is hosted in the cloud or on-premises, or provided as a platform-as-a-service. With the release of... <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/06/sql-server-java-whats-new/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p><iframe width="960" height="540" src="https://channel9.msdn.com/Events/Connect/2016/152/player" allowfullscreen="allowfullscreen" frameborder="0"></iframe></p> <p>Java continues to be one of the most widely used programming languages for a variety of application scenarios and industries. The Microsoft JDBC Driver for SQL Server is used to connect Java applications to SQL Server, whether SQL Server is hosted in the cloud or on-premises, or provided as a platform-as-a-service.</p> <p>With the release of <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/announcing-sql-server-on-linux-public-preview-first-preview-of-next-release-of-sql-server/">SQL Server v.Next public preview on Linux and Windows</a>, the ability to connect to SQL Server on Linux, Windows, Docker or macOS (via Docker) makes cross-platform support for all connectors, including the JDBC driver, even more important. To enable Java developers to use the newest SQL Server features, we have been updating the JDBC driver with client-side support for new features, including Always Encrypted and Azure Active Directory Authentication.</p> <p>We recently open sourced the Microsoft JDBC Driver for SQL Server. In doing so, we included the <a href="https://github.com/Microsoft/mssql-jdbc">Java source code on GitHub</a> (under MIT License). By making the project available on GitHub, we hope to facilitate a quicker feedback loop for Java developers. This feedback will be used to inform the prioritization of the developed features to support the variety of Java applications that connect to SQL Server. We want to get the community involved as much as possible in the design and implementation of features and welcome pull requests. We’ve also included build scripts if you’d like to build the jars on your own.</p> <p>We have also made the connector available on the <a href="http://search.maven.org/#search%7Cgav%7C1%7Cg%3A%22com.microsoft.sqlserver%22%20AND%20a%3A%22mssql-jdbc%22">Maven Central Repository</a>. Maven is popularly used by Java developers to build projects and manage dependencies. Maven support has been one of the most popular requests for the JDBC driver, and we hope that its availability on the Central Repository will make it easier to obtain and use the JDBC driver in new and existing projects. It’s as simple as adding the JDBC driver to your Maven project’s POM file.</p> <p>This connector can be used to connect Java applications to Azure SQL Database, Azure SQL Data Warehouse and SQL Server (including SQL Server v.Next public preview). We have two jars available to support JRE 7 and 8. To start using the JDBC driver or upgrade your existing JDBC driver to the newest version, you can use one of the methods below:</p> <ul> <li>Add the corresponding JDBC jar (version <i>6.1.0.jre8</i> or <i>6.1.0.jre7</i>) to your Maven project by adding it as a dependency using the code below:</li> </ul> <p><span style="margin-left: 45px;font-family: 'Courier New'">&lt;dependency&gt;</span><br /> <span style="margin-left: 60px;font-family: 'Courier New'">&lt;groupId&gt;com.microsoft.sqlserver&lt;/groupId&gt;</span><br /> <span style="margin-left: 60px;font-family: 'Courier New'">&lt;artifactId&gt;mssql-jdbc&lt;/artifactId&gt;</span><br /> <span style="margin-left: 60px;font-family: 'Courier New'">&lt;version&gt;6.1.0.jre8&lt;/version&gt;</span><br /> <span style="margin-left: 45px;font-family: 'Courier New'">&lt;/dependency&gt;</span></p> <ul> <li>Build the corresponding jar for your JRE version (7 or 8) on your own through Maven or Ant build scripts available on GitHub and reference it in your application.</li> <li>Download the corresponding jar for your JRE version from <a href="http://search.maven.org/#search%7Cgav%7C1%7Cg%3A%22com.microsoft.sqlserver%22%20AND%20a%3A%22mssql-jdbc%22">Maven</a>.</li> </ul> <p>You can learn more about open sourcing the JDBC driver and support for Maven in this <a href="https://blogs.msdn.microsoft.com/jdbcteam/2016/11/17/open-source-jdbc-maven/">blog</a>. We look forward to working more closely with the community to continue to bring the best support for Java applications connecting to SQL Server.</p> <h4>Get started today</h4> <ul> <li>Check out the <a href="https://github.com/Microsoft/mssql-jdbc">JDBC driver source code on GitHub</a>! Make pull requests and let us know what you think.</li> <li>Add the <a href="http://search.maven.org/#search%7Cga%7C1%7Cmssql-jdbc">JDBC driver from the Central Repository</a> to your POM file in your Maven project.</li> <li>Try the new <a href="http://aka.ms/sqldev?utm_medium=Referral&amp;utm_source=https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/06/sql-server-java-whats-new/">getting started tutorials</a> that show you how to: <ul> <li>Install SQL Server on Linux/macOS/Docker/Windows</li> <li>Create a simple app using Java and other popular programming languages with SQL Server</li> <li>Create a simple app using popular web frameworks and Object Relational Mapping (ORM) frameworks with SQL Server</li> <li>Use cool SQL Server features that can make your apps shine</li> </ul> </li> </ul> <h4>Connect with us</h4> <ul> <li>Join the conversation at <a href="https://gitter.im/mssqldev/Lobby">https://gitter.im/mssqldev</a>.</li> <li><a href="https://helsinki.catalysis.com/registration.aspx">Sign up to stay informed</a> about new SQL Server on Linux developments.</li> </ul> <h4>Learn more</h4> <ul> <li>Visit the <a href="https://channel9.msdn.com/Events/Connect/2016">Connect(); webpage</a> to watch overview, security, high-availability and developer tools on-demand videos about SQL Server on Linux.</li> <li>Visit the <a href="http://www.sqlserveronlinux.com/">webpage for the next release of SQL Server</a>.</li> </ul> <h4>Other videos in this series</h4> <ul> <li><a href="https://channel9.msdn.com/events/connect/2016/160">SQL Server + Node.js: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/151">SQL Server + C#: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/182">SQL Server + PHP: what’s new</a></li> <li><a href="https://channel9.msdn.com/events/connect/2016/189">SQL Server + Python: what’s new</a></li> <li>Watch the <a href="https://www.youtube.com/watch?v=oEpJB87Xg9U&amp;feature=youtu.be">Microsoft Mechanics video</a> to see how to get started with SQL Server on Linux in less than a minute</li> <li><a href="https://channel9.msdn.com/Events/Connect/2016/173/">SQL Server on Linux: use SQL Tools with SQL Server</a></li> </ul> ]]></content:encoded> </item> <item> <title>Using SQL Tools with SQL Server on Linux</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/01/using-sql-tools-with-sql-server-on-linux/</link> <comments>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/01/using-sql-tools-with-sql-server-on-linux/#comments</comments> <pubDate>Thu, 01 Dec 2016 18:00:21 +0000</pubDate> <dc:creator><![CDATA[Sanjay Nagamangalam [MSFT]]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=17935</guid> <description><![CDATA[Today, developers can use SQL Server in a variety of environments including on-premises, in datacenters, in virtual machines, in clouds such as Azure, AWS and Google, and also as a Platform as a Service (PaaS) offering with Azure SQL Database and Azure SQL Data Warehouse. We recently announced SQL Server v.Next CTP1 on Linux and... <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/01/using-sql-tools-with-sql-server-on-linux/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p><iframe height="540" src="https://channel9.msdn.com/Events/Connect/2016/173/player" frameborder="0" width="960" allowfullscreen="allowfullscreen"></iframe></p> <p>Today, developers can use SQL Server in a variety of environments including on-premises, in datacenters, in virtual machines, in clouds such as Azure, AWS and Google, and also as a Platform as a Service (PaaS) offering with Azure SQL Database and Azure SQL Data Warehouse.</p> <p>We recently announced <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/announcing-sql-server-on-linux-public-preview-first-preview-of-next-release-of-sql-server/">SQL Server v.Next CTP1 on Linux and Windows</a>, which brings the power of SQL Server to both Windows — and for the first time ever — Linux. Developers can now create applications with SQL Server on Linux, Windows, Docker, or macOS (via Docker) and then deploy to Linux, Windows, or Docker, on-premises or in the cloud.</p> <p>As part of this announcement, we have released new SQL tools and also updated existing SQL tools. Developers can use these tools to connect to and work with SQL running anywhere, including SQL Server on Linux, Windows or Docker.</p> <ul> <li><b>New mssql extension for Visual Studio Code:</b> <a href="https://aka.ms/mssql-marketplace">Get the free <b>mssql</b> extension</a> from the VS Code marketplace and connect to SQL running anywhere, get IntelliSense and keyword completion while typing T-SQL queries, and run your queries to see results — all within Visual Studio Code and on Linux/macOS/Windows!<br><a href="https://msdnshared.blob.core.windows.net/media/2016/11/161201sqlServerBlog_011.png"><img title="161201sqlServerBlog_01" style="border-top: 0px;border-right: 0px;border-bottom: 0px;padding-top: 0px;padding-left: 0px;border-left: 0px;padding-right: 0px" border="0" alt="161201sqlServerBlog_01" src="https://msdnshared.blob.core.windows.net/media/2016/11/161201sqlServerBlog_01_thumb1.png" width="739" height="228"></a> <li><b>New SQL command line tools for Linux: </b>We’ve created Linux-native versions of your favorite SQL command line tools such as <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-connect-and-query-sqlcmd"><b>sqlcmd</b></a> and <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-migrate-bcp"><b>bcp</b></a> and <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-migrate-sqlpackage"><b>sqlpackage</b></a> and also added the new <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf"><b>mssql-conf</b></a> tool that lets you configure various properties for the SQL Server instance on Linux (e.g., SA password, TCP port and collation).<b></b> <li><b>New versions of SSMS, SSDT and SQL PowerShell: </b>We have released updated versions (v17.0 RC1) of our flagship SQL Server tools including <a href="https://msdn.microsoft.com/en-us/library/mt238290.aspx">SQL Server Management Studio (SSMS)</a>, <a href="https://msdn.microsoft.com/en-us/library/mt204009.aspx">Visual Studio SQL Server Data Tools (SSDT)</a> and <a href="https://msdn.microsoft.com/en-us/library/hh245198.aspx">SQL PowerShell</a> with support for the SQL Server v.Next on Windows and Linux. </li> </ul> <p>The picture below summarizes the expanded SQL tools portfolio with these announcements. Going forward, we plan to continue our close collaboration with customers and the broader SQL community to enhance our SQL tools portfolio and incrementally create multiplatform SQL tools for developers and database administrators.</p> <p><a href="https://msdnshared.blob.core.windows.net/media/2016/11/161201sqlServerBlog_02.jpg"><img title="161201sqlServerBlog_02" style="border-top: 0px;border-right: 0px;border-bottom: 0px;padding-top: 0px;padding-left: 0px;border-left: 0px;padding-right: 0px" border="0" alt="161201sqlServerBlog_02" src="https://msdnshared.blob.core.windows.net/media/2016/11/161201sqlServerBlog_02_thumb.jpg" width="1124" height="585"></a></p> <h4>Get started today</h4> <ul> <li>Try the new <a></a><a href="http://aka.ms/sqldev?utm_medium=Referral&amp;utm_source=https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/01/using-sql-tools-with-sql-server-on-linux/">getting started tutorials</a> that show you how to: <ul> <li>Install SQL Server on Linux/macOS/Docker/Windows <li>Create a simple app using languages such as C#, Java, Node.js, PHP and Python with SQL Server <li>Create a simple app using popular web frameworks and Object Relational Mapping (ORM) frameworks with SQL Server <li>Try out some cool SQL Server features that can make your apps shine </li> </ul> <li>Get the latest v17.0 RC1 versions of <a href="https://msdn.microsoft.com/en-us/library/mt238290.aspx">SQL Server Management Studio (SSMS)</a> and <a href="https://msdn.microsoft.com/en-us/library/mt204009.aspx">SQL Server Data Tools (SSDT)</a> <li><a href="https://aka.ms/mssql-marketplace">Get the <b>mssql</b> extension</a> for Visual Studio Code, and develop apps with SQL Server on Linux/macOS/Windows <li>Take a look at the source code for the <a href="https://github.com/Microsoft/vscode-mssql">mssql extension on github</a> and submit your ideas and pull requests! </li> </ul> <h4>Connect with us</h4> <ul> <li>Ask questions about SQL tools and share your feedback on Twitter: <a href="https://twitter.com/sqltoolsguy">@sqltoolsguy</a> and <a href="https://twitter.com/sqldatatools">@sqldatatools</a> <li>Join the conversation at <a href="https://gitter.im/mssqldev/Lobby">https://gitter.im/mssqldev</a> and <a href="https://gitter.im/Microsoft/mssql">https://gitter.im/Microsoft/mssql</a> <li><a href="https://helsinki.catalysis.com/registration.aspx">Sign up to stay informed</a> about new SQL Server on Linux developments </li> </ul> <h4>Learn more</h4> <ul> <li>Read the <a href="https://docs.microsoft.com/en-us/sql/linux/">detailed documentation</a> <li>Go to the <a href="http://www.sqlserveronlinux.com/">next release of SQL Server webpage</a> to get started with interactive SQL Server on Linux hands-on labs for <a href="https://aka.ms/sqlserveronredhatlab4linuxadmins">Linux administrators new to SQL Server</a> and for <a href="https://aka.ms/sqlserveronredhatlab4sqladmins">existing SQL Server database administrators new to Linux</a> <li>Visit the <a href="https://connectevent.microsoft.com/">Connect();</a> to watch overview, security, high availability and developer tools videos about SQL Server on Linux on demand </li> </ul> <h4>Other videos in this series</h4> <ul> <li>Watch the <a href="https://www.youtube.com/watch?v=oEpJB87Xg9U&amp;feature=youtu.be">Microsoft Mechanics video</a> to see how to get started with SQL Server on Linux in less than a minute <li><a href="https://channel9.msdn.com/events/connect/2016/101">SQL Server on Linux: overview</a> <li><a href="https://channel9.msdn.com/events/connect/2016/136">SQL Server on Linux: high availability and security on Linux</a> <li><a href="https://channel9.msdn.com/events/connect/2016/160">SQL Server + Node.js: what’s new</a> <li><a href="https://channel9.msdn.com/events/connect/2016/152">SQL Server + Java: what’s new</a> <li><a href="https://channel9.msdn.com/events/connect/2016/151">SQL Server + C#: what&#8217;s new</a> <li><a href="https://channel9.msdn.com/events/connect/2016/182">SQL Server + PHP: what’s new</a> <li><a href="https://channel9.msdn.com/events/connect/2016/189">SQL Server + Python: what’s new</a> </li> </ul> ]]></content:encoded> <wfw:commentRss>https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/01/using-sql-tools-with-sql-server-on-linux/feed/</wfw:commentRss> <slash:comments>1</slash:comments> </item> <item> <title>SQL Server on Linux: High availability and security</title> <link>https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/30/sql-server-on-linux-high-availability-and-security/</link> <pubDate>Wed, 30 Nov 2016 18:00:56 +0000</pubDate> <dc:creator><![CDATA[MihaelaBlendea]]></dc:creator> <category><![CDATA[Uncategorized]]></category> <guid isPermaLink="false">https://blogs.technet.microsoft.com/dataplatforminsider/?p=17905</guid> <description><![CDATA[With SQL Server on Linux, Microsoft brings SQL Server’s core relational database engine to the growing enterprise Linux ecosystem. Both High Availability and Disaster Recovery (HADR) and security are aspects of SQL Server that are critically important for enterprises. This article highlights the HADR and security solutions for SQL Server on Linux that are available... <a href="https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/30/sql-server-on-linux-high-availability-and-security/" class="read-more">Read more</a>]]></description> <content:encoded><![CDATA[<p><iframe width="960" height="540" src="https://channel9.msdn.com/Events/Connect/2016/136/player" allowfullscreen="allowfullscreen" frameborder="0"></iframe></p> <p>With SQL Server on Linux, Microsoft brings SQL Server’s core relational database engine to the growing enterprise Linux ecosystem. Both High Availability and Disaster Recovery (HADR) and security are aspects of SQL Server that are critically important for enterprises. This article highlights the HADR and security solutions for SQL Server on Linux that are available today, as well as the roadmap for what’s coming soon.</p> <h2>HADR landscape</h2> <p>SQL Server offers solutions for various HADR scenarios and it comes with a set of features and capabilities that can help organizations achieve a wide range of availability SLAs goals. From Simple HADR solutions like VM failover with durable storage, to shared disk failover clustering and log shipping (Standard DR) or Always On Availability Groups for <strong>mission-critical</strong> workloads, these solutions offer different Recovery Point Objective (RPO*), Recovery Time Objective (RTO**), failover and workload load balancing capabilities, enabling customers to choose the optimal solution depending on their business needs:</p> <p><strong><a href="https://msdnshared.blob.core.windows.net/media/2016/11/SQL-Server-Linux-HADR-Solutions.png"><img title="SQL Server Linux HADR Solutions" style="float: none;padding-top: 0px;padding-left: 0px;margin-left: auto;padding-right: 0px;margin-right: auto;border: 0px" border="0" alt="SQL Server Linux HADR Solutions" src="https://msdnshared.blob.core.windows.net/media/2016/11/SQL-Server-Linux-HADR-Solutions_thumb.png" width="1024" height="552" /></a></strong></p> <hr /> <p><span style="font-size: xx-small"><em>*RPO &#8211; the maximum time frame your organization is willing to lose data for, in the event of an outage<br /> *RTO – the maximum downtime that your organization can endure in the event of an outage</em></span></p> <p>For SQL Server running on Linux, our goal is to preserve the capabilities framed in the diagram above. We are starting to enable support for some of these solutions starting with the SQL Server v.Next Community Technology Preview (CTP) 1 release.</p> <p>In Windows, SQL Server relies upon Windows Server Failover Clustering to provide the infrastructure features supporting the HADR scenarios. Similarly, on Linux platforms, SQL Server is natively integrated with popular clustering solutions like Pacemaker, so it can benefit from the health monitoring, failure detection or failover coordination of the clustering layer. Please visit our <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-business-continuity-dr">reference documentation on business continuity</a> for SQL Server on Linux for more details about supported platforms and clustering solutions and end-to-end functional samples.</p> <h2>Security solutions</h2> <p>According to the National Institute of Standards and Technology (NIST) public security board, SQL Server has the lowest number of reported security vulnerabilities across the major database vendors (NIST, February 2016). With SQL Server 2016, security was further enhanced by additional security features such as <strong>Always Encrypted, Row-Level Security</strong> and <strong>Dynamic Data Masking</strong>.</p> <p>SQL Server on Linux will support the same advanced, security functionality that enterprises depend on to protect,  control, and monitor access to their data. These capabilities are all built- in:</p> <p><strong><a href="https://msdnshared.blob.core.windows.net/media/2016/11/SQL-Server-on-Linux-Security.png"><img title="SQL Server on Linux Security" style="float: none;padding-top: 0px;padding-left: 0px;margin-left: auto;padding-right: 0px;margin-right: auto;border: 0px" border="0" alt="SQL Server on Linux Security" src="https://msdnshared.blob.core.windows.net/media/2016/11/SQL-Server-on-Linux-Security_thumb.png" width="1024" height="435" /></a></strong></p> <p>This layered approach to data security, in addition to Microsoft’s overall commitment to advancing security and privacy protection, enables enterprises to secure their data and achieve regulatory compliance more easily than ever before.</p> <p>You can find out more about these enterprise-grade security capabilities as well as HADR solutions planned for SQL Server on Linux by watching the video above. The clip also includes a demo on how to register a SQL Server instance to be part of a Linux cluster setup using Pacemaker, as well as a demo on how to migrate an encrypted database from Windows to an instance of SQL Server running on Linux.</p> <h2><a href="http://aka.ms/sqldev">Get started</a></h2> <p>You can get started with many of these capabilities today:</p> <ul> <li><a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-business-continuity-dr">Business Continuity for SQL Server on Linux guide</a></li> <li><a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-security-get-started">SQL Server on Linux security guide</a></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/">Pull and run a Docker container on Linux, Windows, or macOS</a></li> </ul> <h2><a href="https://channel9.msdn.com/Events/Connect/2016">Learn more</a></h2> <ul> <li>Visit the <a href="https://channel9.msdn.com/Events/Connect/2016">Connect(); webpage</a> to watch overview, security, high availability, and developer tools videos about SQL Server on Linux on-demand</li> <li><a href="https://www.youtube.com/watch?v=oEpJB87Xg9U&amp;feature=youtu.be">Watch the Microsoft Mechanics video</a> to see how to get started in under one minute</li> <li>Go to the <a href="http://www.sqlserveronlinux.com/">next release of SQL Server webpage</a> to get started with interactive SQL Server on Linux hands on labs for <a href="https://aka.ms/sqlserveronredhatlab4linuxadmins">Linux administrators new to SQL Server</a> and for <a href="https://aka.ms/sqlserveronredhatlab4sqladmins">existing SQL Server database administrators new to Linux</a></li> <li>Read <a href="https://docs.microsoft.com/en-us/sql/linux/">detailed documentation</a></li> <li><a href="https://helsinki.catalysis.com/registration.aspx">Sign up to stay informed</a> about new SQL Server on Linux developments.</li> </ul> <p>Stay tuned for additional SQL Server Blog posts in the coming weeks, including connectors, and developer tools on Linux!</p> ]]></content:encoded> </item> </channel> </rss>