SQL Server Blog articles https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/bg-p/SQLServer SQL Server Blog articles Tue, 05 Jul 2022 23:05:07 GMT SQLServer 2022-07-05T23:05:07Z Released: SCOM Management Packs for SQL Server, RS, AS (7.0.38.0) https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/released-scom-management-packs-for-sql-server-rs-as-7-0-38-0/ba-p/3563336 <P><FONT size="4">Updates to SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.38.0). You can download the MPs from the links below. Majority of the changes are based on your direct feedback. Thank you. These management packs can be used to monitor the public preview of SQL Server 2022.</FONT></P> <P>&nbsp;</P> <P><FONT size="4"><A href="#" target="_blank" rel="noopener nofollow noreferrer">Download Microsoft System Center Management Pack for SQL Server from Official Microsoft Download Cen...</A></FONT></P> <P><FONT size="4"><A href="#" target="_blank" rel="noopener nofollow noreferrer">Download Microsoft System Center Management Pack for SQL Server Analysis Services from Official Micr...</A></FONT></P> <P><FONT size="4"><A href="#" target="_blank" rel="noopener nofollow noreferrer">Download Microsoft System Center Management Pack for SQL Server Reporting Services from Official Mic...</A></FONT></P> <P>&nbsp;</P> <P><FONT size="4">Another change we've done recently is to move operations guides for all SQL Server family of management packs from download center to docs.microsoft.com. This unifies the content viewing experience for the user as the rest of the SCOM and SQL Server documentation is already there. Furthermore, it allows us to present you with the most up to date and accurate content online. The link to the operation guide for each MP can be found on the MP download page. Here are the links that show what's new in these MPs:</FONT></P> <P><FONT size="4"><A href="#" target="_blank" rel="noopener noreferrer">Features and Enhancements in Management Pack for SQL Server</A></FONT></P> <P><FONT size="4"><A href="#" target="_blank" rel="noopener noreferrer">Features and Enhancements in Management Pack for SQL Server Analysis Services</A></FONT></P> <P><FONT size="4"><A href="#" target="_blank" rel="noopener noreferrer">Features and Enhancements in Management Pack for SQL Server Reporting Services</A></FONT></P> <P>&nbsp;</P> Fri, 01 Jul 2022 08:25:42 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/released-scom-management-packs-for-sql-server-rs-as-7-0-38-0/ba-p/3563336 EbruErsan 2022-07-01T08:25:42Z Early technical preview of JDBC Driver 11.1.2 for SQL Server released https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/early-technical-preview-of-jdbc-driver-11-1-2-for-sql-server/ba-p/3535697 <P><SPAN>We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and changes.</SPAN></P> <P>&nbsp;</P> <P><SPAN>Precompiled binaries are available on&nbsp;<A href="#" target="_blank" rel="noopener noreferrer noreferrer">GitHub</A>&nbsp;and also on&nbsp;<A href="#" target="_blank" rel="nofollow noopener noreferrer noopener noreferrer">Maven Central</A>.<BR /></SPAN></P> <P>&nbsp;</P> <P><SPAN>Below is a summary of the changes in 11.1.2 over version 11.1.1.</SPAN></P> <P>&nbsp;</P> <H3 id="added" class="code-line" dir="auto" data-line="44">Added</H3> <UL class="code-line" dir="auto" data-line="45"> <LI class="code-line" dir="auto" data-line="45">Added support for caching managed identity tokens<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-href="#">1825</A></LI> <LI class="code-line" dir="auto" data-line="46">Added support for caching Always Encrypted parameter metadata<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-href="#">1845</A></LI> </UL> <H3 id="changed" class="code-line" dir="auto" data-line="47">Changed</H3> <UL class="code-line" dir="auto" data-line="48"> <LI class="code-line" dir="auto" data-line="48">Switched from strings to char arrays for secure string use<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-href="#">1813</A></LI> <LI class="code-line" dir="auto" data-line="49">Added check for negotiated ALPN<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-href="#">1818</A></LI> </UL> <H3 id="fixed-issues" class="code-line" dir="auto" data-line="50">Fixed</H3> <UL class="code-line" dir="auto" data-line="51"> <LI class="code-line" dir="auto" data-line="51"> <P class="code-line" data-line="51">Fixed double connection issue when enabling TDS 8.0 and SSL by reusing original socket connection<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-href="#">1817</A></P> </LI> <LI class="code-line" dir="auto" data-line="53"> <P class="code-line" data-line="53">Fixed unknown token error 0xA3 when selectMethod cursor is used with data classification<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-href="#">1821</A></P> </LI> </UL> <P>&nbsp;</P> <P><STRONG>Getting the latest release</STRONG></P> <P>The latest bits are available on our&nbsp;<A href="#" target="_blank" rel="noopener">GitHub repository</A>, and <A href="#" target="_blank" rel="noopener">Maven Central</A>.</P> <P>Add the JDBC preview driver to your Maven project by adding the following code to your POM file to include it as a dependency in your project (choose .jre8, .jre11, .jre17, or .jre18 for your required Java version).</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="applescript">&lt;dependency&gt; &lt;groupId&gt;com.microsoft.sqlserver&lt;/groupId&gt; &lt;artifactId&gt;mssql-jdbc&lt;/artifactId&gt; &lt;version&gt;11.1.2.jre17&lt;/version&gt; &lt;/dependency&gt; </LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN>Help us improve the JDBC Driver by taking our </SPAN><A href="#" target="_blank" rel="noopener">survey</A><SPAN>, </SPAN><A href="#" target="_blank" rel="noopener">filing issues</A><SPAN> on GitHub or contributing to the project.</SPAN></P> <DIV> <DIV> <DIV><BR />Please also check out our <A href="#" target="_blank" rel="noopener">tutorials</A> to get started with developing apps in your programming language of choice and SQL Server. <P><BR />David Engel</P> </DIV> </DIV> </DIV> Thu, 23 Jun 2022 18:00:47 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/early-technical-preview-of-jdbc-driver-11-1-2-for-sql-server/ba-p/3535697 David-Engel 2022-06-23T18:00:47Z Released: Microsoft.Data.SqlClient 5.0 Preview 3 https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/released-microsoft-data-sqlclient-5-0-preview-3/ba-p/3522399 <P>Microsoft.Data.SqlClient 5.0 Preview 3 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server.</P> <P><SPAN>Our plan is to provide GA releases twice a year with two or three preview releases in between. This cadence should provide time for feedback and allow us to deliver features and fixes in a timely manner. This third 5.0 preview includes fixes and changes over the previous preview release.</SPAN></P> <P>&nbsp;</P> <H3 id="toc-hId--1402265086">Breaking changes over v5.0.0-preview2</H3> <UL> <LI>Several classes were removed from the Microsoft.Data.SqlClient.Server namespace. They should now be referenced in the Microsoft.SqlServer.Server namespace and package that is now a dependency of Microsoft.Data.SqlClient when targeting .NET/.NET Core.</LI> <LI>The new dependency on the standalone Microsoft.SqlServer.Server package may cause a duplicate namespace issue if your application is referencing <SPAN>Microsoft.SqlServer.Server and has a dependency (direct or indirect) on</SPAN>&nbsp;System.Data.SqlClient from .NET Core. (<A href="#" target="_self">Read more</A>)</LI> </UL> <H3 dir="auto">Added</H3> <UL dir="auto"> <LI>Added support for<SPAN>&nbsp;</SPAN><CODE>TDS 8</CODE>. To use TDS 8, users should specify Encrypt=Strict in the connection string.<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1608/hovercard">#1608</A><SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener">Read more</A></LI> <LI>Added support for specifying Server SPN and Failover Server SPN on the connection.<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1607/hovercard">#1607</A><SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener">Read more</A></LI> <LI>Added support for aliases when targeting .NET Core on Windows.<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1588/hovercard">#1588</A><SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener">Read more</A></LI> </UL> <H3 dir="auto"><A id="user-content-fixed" class="anchor" href="#" target="_blank" rel="noopener" aria-hidden="true"></A>Fixed</H3> <UL dir="auto"> <LI>Fixed naming, order, and formatting for<SPAN>&nbsp;</SPAN><CODE>SqlDiagnosticsListener</CODE><SPAN>&nbsp;</SPAN>on .NET Core and .NET. [#1637] (<A class="issue-link js-issue-link" href="#" target="_blank" rel="noopener" data-error-text="Failed to load title" data-id="1261055866" data-permission-text="Title is private" data-url="https://github.com/dotnet/SqlClient/issues/1637" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1637/hovercard">#1637</A>)</LI> <LI>Fixed NullReferenceException during Azure Active Directory authentication. [#1625] (<A class="issue-link js-issue-link" href="#" target="_blank" rel="noopener" data-error-text="Failed to load title" data-id="1249005889" data-permission-text="Title is private" data-url="https://github.com/dotnet/SqlClient/issues/1625" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1625/hovercard">#1625</A>)</LI> <LI>Added CommandText length validation when using stored procedure command types.<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1484/hovercard">#1484</A></LI> <LI>Fixed<SPAN>&nbsp;</SPAN><CODE>GetSchema("StructuredTypeMembers")</CODE><SPAN>&nbsp;</SPAN>to return correct schema information. [#1500] (<A class="issue-link js-issue-link" href="#" target="_blank" rel="noopener" data-error-text="Failed to load title" data-id="1121311243" data-permission-text="Title is private" data-url="https://github.com/dotnet/SqlClient/issues/1500" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1500/hovercard">#1500</A>),<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1639/hovercard">#1639</A></LI> <LI>Fixed NullReferenceException when using<SPAN>&nbsp;</SPAN><CODE>SqlDependency.Start</CODE><SPAN>&nbsp;</SPAN>against an Azure SQL Database.[#1294] (<A class="issue-link js-issue-link" href="#" target="_blank" rel="noopener" data-error-text="Failed to load title" data-id="1008548683" data-permission-text="Title is private" data-url="https://github.com/dotnet/SqlClient/issues/1294" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1294/hovercard">#1294</A>)</LI> <LI>Send the correct retained transaction descriptor in the MARS TDS Header when there is no current transaction on .NET 5+ and .NET Core. [#1624] (<A class="issue-link js-issue-link" href="#" target="_blank" rel="noopener" data-error-text="Failed to load title" data-id="1246876526" data-permission-text="Title is private" data-url="https://github.com/dotnet/SqlClient/issues/1624" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1624/hovercard">#1624</A>)</LI> <LI>Parallelize SSRP requests on Linux and macOS when MultiSubNetFailover is specified. [#1578] (<A class="issue-link js-issue-link" href="#" target="_blank" rel="noopener" data-error-text="Failed to load title" data-id="1196711115" data-permission-text="Title is private" data-url="https://github.com/dotnet/SqlClient/issues/1578" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1578/hovercard">#1578</A>)</LI> <LI>Adjust the default ConnectRetryCount against Azure Synapse OnDemand endpoints [#1626] (<A class="issue-link js-issue-link" href="#" target="_blank" rel="noopener" data-error-text="Failed to load title" data-id="1249839293" data-permission-text="Title is private" data-url="https://github.com/dotnet/SqlClient/issues/1626" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1626/hovercard">#1626</A>)</LI> </UL> <H3 dir="auto"><A id="user-content-changed" class="anchor" href="#" target="_blank" rel="noopener" aria-hidden="true"></A>Changed</H3> <UL dir="auto"> <LI>Code health improvements<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1353/hovercard">#1353</A><SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1354/hovercard">#1354</A><SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1525/hovercard">#1525</A><SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1186/hovercard">#1186</A></LI> <LI>Update Azure Identity dependency from 1.5.0 to 1.6.0.<A href="#" target="_blank" rel="noopener" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1611/hovercard">#1611</A></LI> <LI>Improved Regex for SqlCommandSet [#1548] (<A class="issue-link js-issue-link" href="#" target="_blank" rel="noopener" data-error-text="Failed to load title" data-id="1172617694" data-permission-text="Title is private" data-url="https://github.com/dotnet/SqlClient/issues/1548" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1548/hovercard">#1548</A>)</LI> <LI>Rework on<SPAN>&nbsp;</SPAN><CODE>TdsParserStateObjectManaged</CODE><SPAN>&nbsp;</SPAN>with nullable annotations. [#1555] (<A class="issue-link js-issue-link" href="#" target="_blank" rel="noopener" data-error-text="Failed to load title" data-id="1174728082" data-permission-text="Title is private" data-url="https://github.com/dotnet/SqlClient/issues/1555" data-hovercard-type="pull_request" data-hovercard-url="/dotnet/SqlClient/pull/1555/hovercard">#1555</A>)</LI> </UL> <P>&nbsp;</P> <P>For the full list of changes in Microsoft.Data.SqlClient 5.0 Preview 3, please see the <A href="#" target="_self">Release Notes</A>.</P> <P>&nbsp;</P> <P>To try out the new package, add a <A href="#" target="_self">NuGet reference to Microsoft.Data.SqlClient</A>&nbsp;in your application and pick the 5.0 preview 3 version.</P> <P>&nbsp;</P> <P>We appreciate the time and effort you spend checking out our previews. It makes the final product that much better. If you encounter any issues or have any feedback, head over to the <A href="#" target="_self">SqlClient GitHub repository</A> and submit an <A href="#" target="_self">issue</A>.</P> <P>&nbsp;</P> <P>David Engel</P> Fri, 17 Jun 2022 22:58:51 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/released-microsoft-data-sqlclient-5-0-preview-3/ba-p/3522399 David-Engel 2022-06-17T22:58:51Z Hotfix: Microsoft Drivers 5.10.1 for PHP for SQL Server Released https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/hotfix-microsoft-drivers-5-10-1-for-php-for-sql-server-released/ba-p/3518997 <P><SPAN>We recently released an update to Microsoft Drivers for PHP for SQL Server, version 5.10.1. The update addresses&nbsp;a couple issues in the 5.10 release.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><STRONG>Fixed issues</STRONG></FONT></P> <UL> <LI>Fixed User-Assigned Managed Identity (ActiveDirectoryMsi) Authentication when specifying a UID</LI> <LI>Removed block on ActiveDirectoryIntegrated authentication</LI> </UL> <P>&nbsp;</P> <P><STRONG>Install</STRONG></P> <UL> <LI>On Linux and macOS run the commands below:</LI> </UL> <P>&nbsp;</P> <LI-CODE lang="markup">sudo pecl install sqlsrv sudo pecl install pdo_sqlsrv</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <UL> <LI>Windows DLLs for PHP 7.4 or above can be downloaded as a package from <A href="#" target="_self">Microsoft</A>, or from the PECL repository for&nbsp;<A href="#" target="_blank" rel="noopener">SQLSRV</A> or <A href="#" target="_blank" rel="noopener">PDO_SQLSRV</A>.</LI> <LI>Direct downloads for released binaries can also be found at the <A href="#" target="_blank" rel="noopener noreferrer">Github release tag</A>.</LI> </UL> <P>&nbsp;</P> <P>David Engel</P> Fri, 17 Jun 2022 16:00:00 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/hotfix-microsoft-drivers-5-10-1-for-php-for-sql-server-released/ba-p/3518997 David-Engel 2022-06-17T16:00:00Z Security Update for SQL Server 2019 RTM CU16 https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2019-rtm-cu16/ba-p/3508246 <P>The Security Update for SQL Server 2019 RTM CU16 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous SQL Server 2019 fixes through CU16, plus it includes a new security fix for SQL Server Engine.</P> <P>&nbsp;</P> <UL> <LI>Security Bulletin:&nbsp;<A href="#" target="_blank">https://msrc.microsoft.com/update-guide/vulnerability/CVE-2022-29143</A>&nbsp;</LI> <LI>Security Update of SQL Server 2019 RTM CU16 KB Article:&nbsp;<A href="#" target="_blank">http://support.microsoft.com/help/5014353</A>&nbsp;</LI> <UL> <LI>Microsoft Download Center:&nbsp;<A href="#" target="_blank">https://www.microsoft.com/download/details.aspx?familyid=785174ce-14ff-4506-aa52-07e21a8aa629</A>&nbsp;</LI> <LI>Microsoft Update Catalog:&nbsp;<A href="#" target="_blank">http://www.catalog.update.microsoft.com/Search.aspx?q=5014353</A>&nbsp;</LI> </UL> <LI>Latest Updates for Microsoft SQL Server: <A href="#" target="_blank">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server</A></LI> </UL> Wed, 15 Jun 2022 00:29:57 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2019-rtm-cu16/ba-p/3508246 HarveyMoraSQL 2022-06-15T00:29:57Z Security Update for SQL Server 2019 RTM GDR https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2019-rtm-gdr/ba-p/3508228 <P>The Security Update for SQL Server 2019 RTM GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2019 RTM, plus it includes a new security fix for SQL Server Engine.</P> <P>&nbsp;</P> <UL> <LI>Security Bulletin: <A href="#" target="_blank">https://msrc.microsoft.com/update-guide/vulnerability/CVE-2022-29143</A>&nbsp;</LI> <LI>Security Update of SQL Server 2019 RTM GDR KB Article:&nbsp;<A href="#" target="_blank">http://support.microsoft.com/help/5014356</A>&nbsp;</LI> <UL> <LI>Microsoft Download Center:&nbsp;<A href="#" target="_blank">https://www.microsoft.com/download/details.aspx?familyid=244a6097-8d01-47f3-be6f-5198618a2a46</A>&nbsp;</LI> <LI>Microsoft Update Catalog:&nbsp;<A href="#" target="_blank">http://www.catalog.update.microsoft.com/Search.aspx?q=5014356</A>&nbsp;</LI> </UL> <LI>Latest Updates for Microsoft SQL Server: <A href="#" target="_blank">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server</A></LI> </UL> Wed, 15 Jun 2022 00:27:47 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2019-rtm-gdr/ba-p/3508228 HarveyMoraSQL 2022-06-15T00:27:47Z Security Update for SQL Server 2017 RTM CU29 https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2017-rtm-cu29/ba-p/3508211 <P>The Security Update for SQL Server 2017 RTM CU29 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous SQL Server 2017 fixes through CU29, plus it includes a new security fix for SQL Server Engine.</P> <P>&nbsp;</P> <UL> <LI>Security Bulletin:&nbsp;<A href="#" target="_blank">https://msrc.microsoft.com/update-guide/vulnerability/CVE-2022-29143</A>&nbsp;</LI> <LI>Security Update of SQL Server 2017 RTM CU29 KB Article:&nbsp;<A href="#" target="_blank">http://support.microsoft.com/help/5014553</A>&nbsp;</LI> <UL> <LI>Microsoft Download Center:&nbsp;<A href="#" target="_blank">https://www.microsoft.com/download/details.aspx?familyid=0557136b-dbfd-4bc5-814f-79a5472ffb27</A>&nbsp;</LI> <LI>Microsoft Update Catalog:&nbsp;<A href="#" target="_blank">http://www.catalog.update.microsoft.com/Search.aspx?q=5014553</A>&nbsp;</LI> </UL> <LI>Latest Updates for Microsoft SQL Server: <A href="#" target="_blank">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server</A></LI> </UL> Wed, 15 Jun 2022 00:25:16 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2017-rtm-cu29/ba-p/3508211 HarveyMoraSQL 2022-06-15T00:25:16Z Security Update for SQL Server 2017 RTM GDR https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2017-rtm-gdr/ba-p/3508192 <P>The Security Update for SQL Server 2017 RTM GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2017 RTM, plus it includes a new security fix for SQL Server Engine.</P> <P>&nbsp;</P> <UL> <LI>Security Bulletin:&nbsp;<A href="#" target="_blank">https://msrc.microsoft.com/update-guide/vulnerability/CVE-2022-29143</A></LI> <LI>Security Update of SQL Server 2017 RTM GDR KB Article:&nbsp;<A href="#" target="_blank">http://support.microsoft.com/help/5014354</A>&nbsp;</LI> <UL> <LI>Microsoft Download Center:&nbsp;<A href="#" target="_blank">https://www.microsoft.com/download/details.aspx?familyid=1366347a-8d45-41fa-bf1b-711ddfce8163</A>&nbsp;</LI> <LI>Microsoft Update Catalog:&nbsp;<A href="#" target="_blank">http://www.catalog.update.microsoft.com/Search.aspx?q=5014354</A>&nbsp;</LI> </UL> <LI>Latest Updates for Microsoft SQL Server: <A href="#" target="_blank">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server</A></LI> </UL> Wed, 15 Jun 2022 00:21:55 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2017-rtm-gdr/ba-p/3508192 HarveyMoraSQL 2022-06-15T00:21:55Z Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack GDR https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp3-azure-connect-feature/ba-p/3508169 <P>The Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes a new security fix for SQL Server Engine.</P> <P>&nbsp;</P> <UL> <LI>Security Bulletin:&nbsp;<A href="#" target="_blank" rel="noopener">https://msrc.microsoft.com/update-guide/vulnerability/CVE-2022-29143</A>&nbsp;</LI> <LI>Security Update of SQL Server 2016 SP3 Azure Connect Feature Pack GDR KB Article:&nbsp;<A href="#" target="_blank" rel="noopener">http://support.microsoft.com/help/5015371</A>&nbsp;</LI> <UL> <LI>Microsoft Download Center: <A href="#" target="_blank" rel="noopener">https://www.microsoft.com/download/details.aspx?familyid=1e5a86da-2342-4a5e-bca1-be9d082d0c25</A></LI> <LI>Microsoft Update Catalog:&nbsp;<A href="#" target="_blank" rel="noopener">http://www.catalog.update.microsoft.com/Search.aspx?q=5015371</A>&nbsp;</LI> </UL> <LI>Latest Updates for Microsoft SQL Server: <A href="#" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server</A></LI> </UL> Wed, 15 Jun 2022 00:19:06 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp3-azure-connect-feature/ba-p/3508169 HarveyMoraSQL 2022-06-15T00:19:06Z Security Update for SQL Server 2016 SP3 GDR https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp3-gdr/ba-p/3508125 <P>The Security Update for SQL Server 2016 SP3 GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2016 SP3, plus it includes a new security fix for SQL Server Engine.</P> <P>&nbsp;</P> <UL> <LI>Security Bulletin:&nbsp;<A href="#" target="_blank">https://msrc.microsoft.com/update-guide/vulnerability/CVE-2022-29143</A>&nbsp;</LI> <LI>Security Update of SQL Server 2016 SP3 GDR KB Article:&nbsp;<A href="#" target="_blank">http://support.microsoft.com/help/5014355</A>&nbsp;</LI> <UL> <LI>Microsoft Download Center:&nbsp;<A href="#" target="_blank">https://www.microsoft.com/download/details.aspx?familyid=7e5ec6a1-d93e-4630-9fa2-edaaa2c759ab</A>&nbsp;</LI> <LI>Microsoft Update Catalog:&nbsp;<A href="#" target="_blank">http://www.catalog.update.microsoft.com/Search.aspx?q=5014355</A>&nbsp;</LI> </UL> <LI>Latest Updates for Microsoft SQL Server: <A href="#" target="_blank">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server</A></LI> </UL> Tue, 14 Jun 2022 23:54:00 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp3-gdr/ba-p/3508125 HarveyMoraSQL 2022-06-14T23:54:00Z Security Update for SQL Server 2016 SP2 CU17 https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp2-cu17/ba-p/3508091 <P>The Security Update for SQL Server 2016 SP2 CU17 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous SQL Server 2016 SP2 fixes through CU17, plus it includes a new security fix for SQL Server Engine.</P> <P>&nbsp;</P> <UL> <LI>Security Bulletin:&nbsp;<A href="#" target="_blank">https://msrc.microsoft.com/update-guide/vulnerability/CVE-2022-29143</A>&nbsp;</LI> <LI>Security Update of SQL Server 2016 SP2 CU17 KB Article:&nbsp;<A href="#" target="_blank">http://support.microsoft.com/help/5014351</A>&nbsp;</LI> <UL> <LI>Microsoft Download Center:&nbsp;<A href="#" target="_blank">https://www.microsoft.com/download/details.aspx?familyid=33991cbd-3a76-4bda-bc11-6c586ffa4664</A>&nbsp;</LI> <LI>Microsoft Update Catalog:&nbsp;<A href="#" target="_blank">http://www.catalog.update.microsoft.com/Search.aspx?q=5014351</A>&nbsp;</LI> </UL> <LI>Latest Updates for Microsoft SQL Server: <A href="#" target="_blank">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server</A></LI> </UL> Tue, 14 Jun 2022 23:49:49 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp2-cu17/ba-p/3508091 HarveyMoraSQL 2022-06-14T23:49:49Z Security Update for SQL Server 2016 SP2 GDR https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp2-gdr/ba-p/3508070 <P>The Security Update for SQL Server 2016 SP2 GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2016 SP2, plus it includes a new security fix for SQL Server Engine.</P> <P>&nbsp;</P> <UL> <LI>Security Bulletin:&nbsp;<A href="#" target="_blank">https://msrc.microsoft.com/update-guide/vulnerability/CVE-2022-29143</A>&nbsp;</LI> <LI>Security Update of SQL Server 2016 SP2 GDR KB Article:&nbsp;<A href="#" target="_blank">http://support.microsoft.com/help/5014365</A>&nbsp;</LI> <UL> <LI>Microsoft Download Center:&nbsp;<A href="#" target="_blank">https://www.microsoft.com/download/details.aspx?familyid=8fc4928c-6957-4d19-8e57-e91a7137927d</A>&nbsp;</LI> <LI>Microsoft Update Catalog:&nbsp;<A href="#" target="_blank">http://www.catalog.update.microsoft.com/Search.aspx?q=5014365</A>&nbsp;</LI> </UL> <LI>Latest Updates for Microsoft SQL Server: <A href="#" target="_blank">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server</A></LI> </UL> Tue, 14 Jun 2022 23:45:02 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp2-gdr/ba-p/3508070 HarveyMoraSQL 2022-06-14T23:45:02Z Security Update for SQL Server 2014 SP3 CU4 https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2014-sp3-cu4/ba-p/3508051 <P>The Security Update for SQL Server 2014 SP3 CU4 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous SQL Server 2014 SP3 fixes through CU4, plus it includes a new security fix for SQL Server Engine.</P> <P>&nbsp;</P> <UL> <LI>Security Bulletin:&nbsp;<A href="#" target="_blank">https://msrc.microsoft.com/update-guide/vulnerability/CVE-2022-29143</A>&nbsp;</LI> <LI>Security Update of SQL Server 2014 SP3 CU4 KB Article:&nbsp;<A href="#" target="_blank">http://support.microsoft.com/help/5014164</A>&nbsp;</LI> <UL> <LI>Microsoft Download Center:&nbsp;<A href="#" target="_blank">https://www.microsoft.com/download/details.aspx?familyid=ad5a91e0-85cd-468d-9d76-4570dee43432</A>&nbsp;</LI> <LI>Microsoft Update Catalog:&nbsp;<A href="#" target="_blank">http://www.catalog.update.microsoft.com/Search.aspx?q=5014164</A>&nbsp;</LI> </UL> <LI>Latest Updates for Microsoft SQL Server: <A href="#" target="_blank">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server</A></LI> </UL> Tue, 14 Jun 2022 23:41:40 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2014-sp3-cu4/ba-p/3508051 HarveyMoraSQL 2022-06-14T23:41:40Z Security Update for SQL Server 2014 SP3 GDR https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2014-sp3-gdr/ba-p/3508029 <P>The Security Update for SQL Server 2014 SP3 GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2014 SP3, plus it includes a new security fix for SQL Server Engine.</P> <P>&nbsp;</P> <UL> <LI>Security Bulletin:&nbsp;<A href="#" target="_blank">https://msrc.microsoft.com/update-guide/vulnerability/CVE-2022-29143</A>&nbsp;</LI> <LI>Security Update of SQL Server 2014 SP3 GDR KB Article:&nbsp;<A href="#" target="_blank">http://support.microsoft.com/help/5014165</A>&nbsp;</LI> <UL> <LI>Microsoft Download Center:&nbsp;<A href="#" target="_blank">https://www.microsoft.com/download/details.aspx?familyid=024ac33f-82ae-441c-8138-88b1c53b2449</A>&nbsp;</LI> <LI>Microsoft Update Catalog:&nbsp;<A href="#" target="_blank">http://www.catalog.update.microsoft.com/Search.aspx?q=5014165</A>&nbsp;</LI> </UL> <LI>Latest Updates for Microsoft SQL Server: <A href="#" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server</A></LI> </UL> Tue, 14 Jun 2022 23:22:31 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2014-sp3-gdr/ba-p/3508029 HarveyMoraSQL 2022-06-14T23:22:31Z Temporal: Encountering Error 13535 Data modification failed on system-versioned table... https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/temporal-encountering-error-13535-data-modification-failed-on/ba-p/3500970 <P>When 2 or more workers are modifying the same row, it is possible to encounter 13535.&nbsp; The time of the begin transaction and the modification are the defining properties.&nbsp; When the transaction begin time is before the latest row modification, error 13535 is encountered.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BobDorr_0-1655140843700.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/379858i435BE57C39755A84/image-size/medium?v=v2&amp;px=400" role="button" title="BobDorr_0-1655140843700.png" alt="BobDorr_0-1655140843700.png" /></span></P> <P>&nbsp;</P> <OL> <LI>T1 starts a transaction<BR />T1 is context switched or client has not submitted the modification request<BR /><BR /></LI> <LI>T2 starts a transaction, just after T1<BR />T2 updates the row in the table<BR /><BR /></LI> <LI>T1 attempts to update row and is blocked by T2 or T2 commits transaction before T1 issues the modification<BR /><BR /></LI> <LI>T2 commits the transaction<BR /><BR /></LI> <LI>T1 is assigned the lock<BR />T1 detects the temporal update for the row was at 12:00:01 but T1 started its transaction before 12:00:01 and the error is raised.</LI> </OL> <P>For such an issue the application needs to determine the desired behavior.&nbsp; If T1 must complete before T2 then the application must sequence and complete the T1 query before the T2 query.&nbsp; If serialization is not required, the application can perform a retry.</P> <P>&nbsp;</P> <P><STRONG><U>DEMO</U></STRONG></P> <P>&nbsp;</P> <P>set nocount on</P> <P>go</P> <P>&nbsp;</P> <P>use master</P> <P>go</P> <P>&nbsp;</P> <P>drop database temporalTest</P> <P>go</P> <P>create database temporalTest</P> <P>go</P> <P>&nbsp;</P> <P>use temporalTest</P> <P>go</P> <P>&nbsp;</P> <P>create schema Test</P> <P>go</P> <P>&nbsp;</P> <P>CREATE TABLE [Temporal](</P> <P>&nbsp;&nbsp;&nbsp; [TemporalId] [bigint] IDENTITY(1,1) NOT NULL,</P> <P>&nbsp;&nbsp;&nbsp; [DateModified] [datetime2](7) NOT NULL,</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [SysStartTime] [datetime2](7) GENERATED ALWAYS AS ROW START NOT NULL,</P> <P>&nbsp;&nbsp;&nbsp; [SysEndTime] [datetime2](7) GENERATED ALWAYS AS ROW END NOT NULL,</P> <P>&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONSTRAINT [TemporalId] PRIMARY KEY CLUSTERED ([TemporalId] ASC)</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON),</P> <P>&nbsp;&nbsp;&nbsp; PERIOD FOR SYSTEM_TIME ([SysStartTime], [SysEndTime])</P> <P>&nbsp;&nbsp;&nbsp; )WITH(</P> <P>&nbsp;&nbsp;&nbsp; SYSTEM_VERSIONING = ON ( HISTORY_TABLE = [Test].[TemporalHistory] )</P> <P>&nbsp;&nbsp;&nbsp; )</P> <P>go</P> <P>&nbsp;</P> <P>create PROCEDURE mysp</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;@ID bigint</P> <P>AS</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UPDATE</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Temporal</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DateModified =&nbsp; GETUTCDATE()</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TemporalId = @Id</P> <P>go</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>INSERT INTO Temporal</P> <P>&nbsp;&nbsp;&nbsp; (DateModified) &nbsp;VALUES (GETUTCDATE())&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</P> <P>go</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>select * from Temporal</P> <P>go</P> <P>&nbsp;</P> <P>select * from Test.TemporalHistory</P> <P>go</P> <P>&nbsp;</P> <P>-- ostress -E -S.\sql19 -Q"temporalTest..mysp 1" -r999999999 -n4 -q</P> <P>&nbsp;</P> Mon, 13 Jun 2022 17:22:36 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/temporal-encountering-error-13535-data-modification-failed-on/ba-p/3500970 BobDorr 2022-06-13T17:22:36Z Common Criteria EAL4 Certification for SQL19 https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/common-criteria-eal4-certification-for-sql19/ba-p/3488142 <P style="font-weight: 400;"><SPAN>In May 2022, representatives of the Spanish certification body CCN (Centro Cryptológico National), the Spanish evaluation facility DEKRA Testing and Certification, S.A.U., and Microsoft met at Microsoft for the official handover of </SPAN><SPAN>the </SPAN><A href="#" target="_blank" rel="noopener"><SPAN>Microsoft SQL Server 2019 Database Engine (EAL4+) </SPAN><SPAN>certificate</SPAN></A><SPAN> and to share their views on IT product certifications in cloud environments.</SPAN></P> <P style="font-weight: 400;"><SPAN>&nbsp;</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="IMG_2782.JPG" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/378981iFB45C89049BC86FD/image-size/large?v=v2&amp;px=999" role="button" title="IMG_2782.JPG" alt="IMG_2782.JPG" /></span></P> <P style="font-weight: 400;">From left to right:</P> <P style="font-weight: 400;">- Pablo Franco, Head of Certification Body, CCN</P> <P style="font-weight: 400;">- Wolfgang Peter, Principal Security Program Manager, Database Platform Security Fundamentals &amp; Compliance, Microsoft</P> <P style="font-weight: 400;">- Yolanda Muñoz Muñoz, Support Engineering Manager, Spain-Site Lead, Microsoft</P> <P style="font-weight: 400;">- Jose Emilio Rico, Cybersecurity Division Director, DEKRA Testing and Certification S.A.U.</P> <P style="font-weight: 400;">- Alejandro Torrecilla Torregrosa, Managing Director, DEKRA Testing and Certification S.A.U.</P> <P style="font-weight: 400;">&nbsp;</P> <P style="font-weight: 400;"><SPAN>The SQL Server 2019 (SQL19) Common Criteria (CC) certification consisted of a comprehensive examination conducted by the evaluation facility, based on document reviews for various design representations, independent functional and penetration testing, code analysis, site audits for development sites, data centers and support sites, and a vulnerability assessment. S</SPAN><SPAN>cope and rigor of this investigation were defined by the security assurance requirements compiled in the Evaluation Assurance Level 4 (EAL4) and the applied&nbsp;</SPAN><A href="#" target="_blank" rel="noopener"><SPAN>DBMS PP</SPAN></A><SPAN>. The results obtained by the evaluation facility were continuously monitored by the certification body to confirm their accuracy and to ensure comparability with other independent evaluations of the same product type.</SPAN></P> <P style="font-weight: 400;"><SPAN>Compared to previous version, the SQL19 CC process included "Systematic Flaw Remediation". </SPAN><SPAN>Specifically, this means that user communication pertaining to flaws, flaw status communication, and the timeliness of updates and reports issued for SQL19 were assessed and confirmed as compliant to the highest eligible assurance component within the CC.</SPAN></P> <P style="font-weight: 400;"><SPAN>To see an extract of the extensive CC history of SQL Server, please refer to the </SPAN><A href="#" target="_blank" rel="noopener"><SPAN>SQL Server security page&nbsp;</SPAN></A><SPAN>(Click on “View our Common Criteria certification”). Additionally, this document provides important information for understanding and using SQL19 as evaluated and certified according to the CC.</SPAN></P> <P style="font-weight: 400;"><SPAN>&nbsp;</SPAN></P> <P style="font-weight: 400;"><STRONG><SPAN>About the CC</SPAN></STRONG></P> <P style="font-weight: 400;">CC is an international program which is broadly used as a (cyber) security standard (ISO 15408) to test and improve the IT security measures of commercial products for use in National Security Systems (see e.g.&nbsp;<A href="#" target="_blank" rel="noopener">EUCSA</A><SPAN>,&nbsp;</SPAN><A href="#" target="_blank" rel="noopener">NIAP</A>).&nbsp;As such it serves as a world-wide compliance obligation across regulated industries and authorities and&nbsp;can be applied to almost any type of IT product implemented in hardware, firmware, or software.</P> <P style="font-weight: 400;">IT security measures in the context of the CC are usually a means to protect information (or in other words ‘assets’) from unauthorized disclosure, modification, or loss of use, covering, for example, areas such as identification and authentication, access control, accountability, audit, object re-use, error recovery. Appropriate confidence in the correct and effective implementation of those measures (expressed in terms of assurance requirements and typically specified in an EAL) is needed to help determine whether IT products fulfill their security needs. A competence-tested and authorized (i.e., accredited) evaluation facility therefore evaluates an IT product against a pre-defined security specification, called (collaborative) Protection Profile (PP). A (collaborative) PP represents the security functional and assurance requirements for technology classes and is recently developed and maintained by an international Technical Community (iTC), made up of CC and technology area experts such as vendors, certification bodies, evaluation facilities, and consultants (see e.g.&nbsp;<A href="#" target="_blank" rel="noopener">DBMS-iTC</A>). Under the international&nbsp;<A href="#" target="_blank" rel="noopener">Common Criteria Recognition Arrangement (CCRA)</A> and the European <A href="#" target="_blank" rel="noopener">Senior Officials Group Information Systems Security (SOG-IS) agreement</A>, all signatories agree to recognize the CC certificates produced by any certificate-authorizing participant. Each participating country in the CC operates a certification body that oversees evaluations conducted by accredited commercial evaluation facilities.</P> <P style="font-weight: 400;"><SPAN>&nbsp;</SPAN></P> <P style="font-weight: 400;"><SPAN><STRONG>Learn more about the CC</STRONG></SPAN></P> <P style="font-weight: 400;"><SPAN>Please </SPAN><SPAN>visit the </SPAN><A href="#" target="_blank" rel="noopener"><SPAN>Common Criteria Portal</SPAN></A><SPAN>.</SPAN></P> <P style="font-weight: 400;"><SPAN>&nbsp;</SPAN></P> <P style="font-weight: 400;"><STRONG><SPAN>Looking forward</SPAN></STRONG></P> <P style="font-weight: 400;"><SPAN>The CC certification of the upcoming release of SQL Server 2022 will include an Azure Arc-enabled server configuration as another step towards the cloud and to support users to deploy their products as tested and certified. </SPAN></P> Thu, 09 Jun 2022 16:34:54 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/common-criteria-eal4-certification-for-sql19/ba-p/3488142 Wolfgang-Peter 2022-06-09T16:34:54Z How It Works: Workers, Tasks, Failed Logins - What is my SQL Server Doing? https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/how-it-works-workers-tasks-failed-logins-what-is-my-sql-server/ba-p/3478749 <P><STRONG>From Customer<BR /><BR /></STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BobDorr_0-1654626634577.png" style="width: 553px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/378284iDAF502AC46A44A68/image-dimensions/553x152?v=v2" width="553" height="152" role="button" title="BobDorr_0-1654626634577.png" alt="BobDorr_0-1654626634577.png" /></span></P> <P class="xxmsonormal" style="margin-left: .5in;"><I><SPAN>Interesting point here is, current_workers_count is ~10X compared to active_workers_count; means no tasks assigned to 10X threads. </SPAN></I></P> <P class="xxmsonormal" style="margin-left: .5in;"><I><SPAN>How did threads land with no tasks? Is there orphaned threads not getting cleaned up? </SPAN></I></P> <P>&nbsp;</P> <P><STRONG>My Notes</STRONG></P> <UL> <LI>The total workers are divided evenly among the visible schedulers (schedulers that accept incoming query requests.)&nbsp; For example, a max worker setting of 1000 on a 4-scheduler system is 250 per scheduler.</LI> <LI>Each scheduler maintains a minimum level of workers, so workers don’t have to be created when new work arrives.&nbsp; You can think of them as hot workers.</LI> <LI>Depending on the installation workers greater than minimum are trimmed at different intervals.&nbsp; See <EM>Trimming Behavior</EM> below.</LI> <LI>Tasks can be transactional or permanent.&nbsp; Requests to the server are transactional.&nbsp; Acquire a task, bind to worker, perform the query request, unbind the worker, and release the task.&nbsp;&nbsp; Requests which are permanent are things like checkpoint, lazy writer, etc.&nbsp; They are bound to worker for the lifetime of the instance.</LI> <LI>Hidden schedulers are used to handle activities such as backup, create and maintain workers.</LI> <LI>The task count includes the transactional and permanent task requests.</LI> <LI>The runnable_tasks_count are those tasks no longer waiting on a resource and available to be scheduled.&nbsp; Scheduling occurs when the current running worker performs a context switch (yields.)</LI> </UL> <P>In the output above I see:&nbsp; (<A href="#" target="_blank" rel="noopener">sys.dm_os_schedulers (Transact-SQL) - SQL Server | Microsoft Docs</A>)</P> <UL> <LI>current_tasks_count (this includes transactional and permanent tasks)</LI> <LI>runnable_tasks_count (value is low so likely blocking taking place, preemptive workers, waiting dispatchers, or system timer tasks that are not runnable at time of the capture)</LI> <LI>current_workers_count (number of workers created to handle tasks)</LI> <LI>active_workers_count (workers that are bound to tasks in non-preeemptive mode.&nbsp; The difference in current_tasks_count and active_workers_count is likely the preemptive workers)</LI> </UL> <P>Here is my takeaway from just this data point.</P> <UL> <LI>You have some preemptive activity to handle things like network completion ports, handling network IO for worker, XEvent outputs, etc.&nbsp;&nbsp; Looking at the sys.dm_exec_requests and joining to sys.dm_os_tasks, sys.dm_os_workers and sys.dm_os_schedulers provides a better picture of the ongoing preemptive work.</LI> <LI>The same data from dm_exec_requests and SQL OS DMVs helps point out the permanent tasks (Checkpoint, LW, Version Store Cleanup, Ghost Cleanup, …)</LI> <LI>There are dispatcher tasks that are maintained by the various dispatchers and are returned (called fading) based on the dispatcher fading timeouts.&nbsp; The dispatcher times out, unbinds the task from the worker and the worker becomes idle. Now the configured SOS idle trimming is applied.</LI> <LI>Some features, such as HADR, maintain their own worker pool on top SOS (much like a dispatcher pool.)&nbsp; These queues and associated tasks have separate idle timeouts.&nbsp; The same DMV queries can point to such tasks.&nbsp; For example, a task could be bound to a worker and assigned to the HADR worker pool for handling HADR requests.&nbsp; If there is no HADR work to perform, then the task is waiting on the HADR queue event. &nbsp;The task is not runnable and the idle timeout for the HADR queue is being applied.</LI> <LI>The dm_os_waits, dm_os_waiting_tasks and such DMVs are helpful in understanding the wait behaviors.</LI> </UL> <P><STRONG><U>Failed Logins</U></STRONG></P> <P>The reason the above data was captured was in response to failed loging.&nbsp; When I add failed logins as a outcome can fill in a bit more information.</P> <P>&nbsp;</P> <P>Yes, logins can be impacted when reaching max worker threads.&nbsp;&nbsp; The IO completion port accepts the new connection request and enqueues a task to process the login.&nbsp; This login task is assigned to a visible scheduler.&nbsp; If a worker cannot be bound and process the task before the login timeout is exceeded the login fails.&nbsp;&nbsp; You can reproduce this with a simple test, say max workers is set to 1000.&nbsp; Make 1000 connections (ostress -E -SMyServer -Q”wait for delay ’10:00:00’” -n1000“) which will hold the worker (remember a task is bound to a worker until it completes the task request.)&nbsp;&nbsp; You can reproduce the same outcome with a long blocking chain, etc.&nbsp; Now new connection requests timeout.</P> <P>&nbsp;</P> <P>There are some additional issues that can lead to login timeout.&nbsp; For example, to combat Denial Of Service (DOS) the SSL responses are often limited to 5 or 10 seconds.&nbsp; If these timeouts occur then the login fails but the task and worker binding was in effect for the login attempt and secondary login attempts would be creating and using additional workers.</P> <P>&nbsp;</P> <UL> <LI>Using the DMVs to understand what the workers are associated with is a great place to start.</LI> <LI>The connectivity ring buffer (sys.dm_os_ring_buffers) is another excellent source of information.&nbsp; The error state and the additional login timing information shows where the time was spent attempting to process the login.</LI> </UL> <P>Once we can see the worker assignments and ring buffer information the pattern is commonly easy to see, troubleshoot and resolve.<BR /><BR /></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BobDorr_0-1654626725420.png" style="width: 600px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/378285i98CA3E1FECC15AC1/image-dimensions/600x468?v=v2" width="600" height="468" role="button" title="BobDorr_0-1654626725420.png" alt="BobDorr_0-1654626725420.png" /></span></P> <P>nocount on<BR />go</P> <P>use tempdb<BR />go</P> <P>drop table if exists captureTables<BR />go</P> <P>create table captureTables(target sysname NOT NULL, source sysname NOT NULL)<BR />go</P> <P>insert into captureTables values<BR />('cap_dm_os_sys_info', 'sys.dm_os_sys_info'),<BR />('cap_dm_os_schedulers', 'sys.dm_os_schedulers'),<BR />('cap_dm_os_threads', 'sys.dm_os_threads'),<BR />('cap_dm_os_tasks', 'sys.dm_os_tasks'),<BR />('cap_dm_os_workers', 'sys.dm_os_workers'),<BR />('cap_dm_os_dispatchers', 'sys.dm_os_dispatchers'),<BR />('cap_dm_os_dispatcher_pools', 'sys.dm_os_dispatcher_pools'),<BR />('cap_dm_exec_requests', 'sys.dm_exec_requests'),<BR />('cap_dm_exec_sessions', 'sys.dm_exec_sessions')<BR />go</P> <P>------------------------------------------------<BR />-- Cleanup previous execution<BR />------------------------------------------------<BR />drop procedure if exists spCleanup<BR />go</P> <P>create procedure spCleanup<BR />as<BR />begin<BR />set nocount on<BR />declare <LI-USER uid="430686"></LI-USER> sysname</P> <P>select \* into #captureTables from captureTables&nbsp;</P> <P>select TOP 1 <LI-USER uid="430686"></LI-USER> = target from #captureTables&nbsp;</P> <P>&nbsp;</P> <P>while (@target is not null)&nbsp;</P> <P>begin&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;exec('drop table if exists ' + <LI-USER uid="430686"></LI-USER>)&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;delete from #captureTables where target = <LI-USER uid="430686"></LI-USER>&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;set <LI-USER uid="430686"></LI-USER> = null&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;select TOP 1 <LI-USER uid="430686"></LI-USER> = target from #captureTables&nbsp;</P> <P>end&nbsp;</P> <P>end<BR />go</P> <P>------------------------------------------------<BR />-- Capture data<BR />------------------------------------------------<BR />drop procedure if exists spCapture<BR />go</P> <P>create procedure spCapture<BR />as<BR />begin<BR />set nocount on<BR />declare @captureTime sysname= convert(sysname, GetUTCDate(), 109)<BR />declare <LI-USER uid="430686"></LI-USER> sysname<BR />declare @source sysname</P> <P>-- Avoid cursor overhead&nbsp;</P> <P>--&nbsp;</P> <P>select \* into #captureTables from captureTables&nbsp;</P> <P>select TOP 1 <LI-USER uid="430686"></LI-USER> = target,&nbsp; @source = source&nbsp; from #captureTables</P> <P>&nbsp;</P> <P>while (@target is not null)&nbsp;</P> <P>begin&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;print 'Processing ' + <LI-USER uid="430686"></LI-USER>&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;if (object\_id(@target) is null)&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;begin&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;exec('select cast(''' + @captureTime + ''' as datetime) as \[CaptureTime\], \* into ' + <LI-USER uid="430686"></LI-USER> + '&nbsp; from ' + @source)&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;end&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;else&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;begin&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;exec('insert into ' + <LI-USER uid="430686"></LI-USER> + ' select cast(''' + @captureTime + ''' as datetime) as \[CaptureTime\], \* from ' + @source)&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;end</P> <P>&nbsp;</P> <P>&nbsp;&nbsp;&nbsp; -- exec('select \* from ' + <LI-USER uid="430686"></LI-USER>)&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;delete from #captureTables where target = <LI-USER uid="430686"></LI-USER>&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;set <LI-USER uid="430686"></LI-USER> = null&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;select TOP 1 <LI-USER uid="430686"></LI-USER> = target,&nbsp;&nbsp; @source = source&nbsp; from #captureTables</P> <P>&nbsp;</P> <P>end&nbsp;</P> <P>end<BR />go</P> <P>exec spCleanup<BR />go</P> <P>exec spCapture<BR />waitfor delay '00:00:05'<BR />exec spCapture<BR />go</P> <P>------------------------------------------------<BR />-- Report outs<BR />------------------------------------------------<BR />print 'System Info'<BR />go</P> <P>select<BR />CaptureTime,<BR />cpu_ticks - LAG(cpu_ticks,1) OVER (ORDER BY CaptureTime) as cpu_ticks_delta,<BR />ms_ticks - LAG(ms_ticks,1) OVER (ORDER BY CaptureTime) as ms_ticks_delta,<BR />committed_kb - LAG(committed_kb,1) OVER (ORDER BY CaptureTime) as committed_kb_delta,<BR />max_workers_count - LAG(max_workers_count,1) OVER (ORDER BY CaptureTime) as max_workers_count_delta,<BR />process_kernel_time_ms - LAG(process_kernel_time_ms,1) OVER (ORDER BY CaptureTime) as process_kernel_time_ms_delta,<BR />process_user_time_ms - LAG(process_user_time_ms,1) OVER (ORDER BY CaptureTime) as process_user_ms_delta<BR />, *<BR />from cap_dm_os_sys_info<BR />go</P> <P>print 'Scheduler Info'<BR />go</P> <P>select<BR />CaptureTime,<BR />scheduler_address,<BR />context_switches_count - LAG(context_switches_count,1) OVER (PARTITION BY scheduler_address ORDER BY CaptureTime) as context_switch_delta,<BR />preemptive_switches_count - LAG(preemptive_switches_count,1) OVER (PARTITION BY scheduler_address ORDER BY CaptureTime) as preemptive_switch_delta,<BR />current_tasks_count - LAG(current_tasks_count,1) OVER (PARTITION BY scheduler_address ORDER BY CaptureTime) as current_tasks_count_delta,<BR />runnable_tasks_count - LAG(runnable_tasks_count,1) OVER (PARTITION BY scheduler_address ORDER BY CaptureTime) as runnable_tasks_count_delta,<BR />yield_count - LAG(yield_count,1) OVER (PARTITION BY scheduler_address ORDER BY CaptureTime) as yield_count_delta,<BR />total_cpu_usage_ms - LAG(total_cpu_usage_ms,1) OVER (PARTITION BY scheduler_address ORDER BY CaptureTime) as total_cpu_usage_ms_delta,<BR />*<BR />from cap_dm_os_schedulers<BR />order by 8 desc<BR />go</P> <P>print 'Thread Info'<BR />go</P> <P>select<BR />CaptureTime,<BR />os_thread_id,<BR />kernel_time - LAG(kernel_time,1) OVER (PARTITION BY os_thread_id ORDER BY CaptureTime) as kernel_time_delta,<BR />usermode_time - LAG(usermode_time,1) OVER (PARTITION BY os_thread_id ORDER BY CaptureTime) as user_time_delta,<BR />*<BR />from cap_dm_os_threads<BR />order by 4 desc<BR />go</P> <P>print 'Task Info'<BR />go</P> <P>select<BR />CaptureTime,<BR />task_address,<BR />context_switches_count - LAG(context_switches_count,1) OVER (PARTITION BY task_address ORDER BY CaptureTime) as context_switch_delta,<BR />*<BR />from cap_dm_os_tasks<BR />order by 3 desc<BR />go</P> <P>print 'Worker Info'<BR />go</P> <P>select<BR />CaptureTime,<BR />worker_address,<BR />context_switch_count - LAG(context_switch_count,1) OVER (PARTITION BY worker_address ORDER BY CaptureTime) as context_switch_delta,<BR />quantum_used - LAG(quantum_used,1) OVER (PARTITION BY worker_address ORDER BY CaptureTime) as quantum_used_delta,<BR />*<BR />from cap_dm_os_workers<BR />order by 4 desc<BR />go</P> <P>print 'Requests Info'<BR />go</P> <P>select<BR />CaptureTime,<BR />session_id,<BR />request_id,<BR />reads - LAG(reads,1) OVER (PARTITION BY session_id, request_id ORDER BY CaptureTime) as reads_delta,<BR />logical_reads - LAG(logical_reads,1) OVER (PARTITION BY session_id, request_id ORDER BY CaptureTime) as logical_reads_delta,<BR />writes - LAG(writes,1) OVER (PARTITION BY session_id, request_id ORDER BY CaptureTime) as writes_delta,<BR />cpu_time - LAG(cpu_time,1) OVER (PARTITION BY session_id, request_id ORDER BY CaptureTime) as cpu_time_delta,<BR />*<BR />from cap_dm_exec_requests<BR />order by 7 desc<BR />go</P> <P>print 'Sessions Info'<BR />go</P> <P>select<BR />CaptureTime,<BR />session_id,<BR />cpu_time - LAG(cpu_time,1) OVER (PARTITION BY session_id ORDER BY CaptureTime) as cpu_time_delta,<BR />total_scheduled_time - LAG(total_scheduled_time,1) OVER (PARTITION BY session_id ORDER BY CaptureTime) as total_scheduled_time_delta,<BR />reads - LAG(reads,1) OVER (PARTITION BY session_id ORDER BY CaptureTime) as reads_delta,<BR />logical_reads - LAG(logical_reads,1) OVER (PARTITION BY session_id ORDER BY CaptureTime) as logical_reads_delta,<BR />writes - LAG(writes,1) OVER (PARTITION BY session_id ORDER BY CaptureTime) as writes_delta,<BR />*<BR />from cap_dm_exec_sessions<BR />order by 4 desc<BR />go</P> <P>print 'Dispatcher Info'<BR />go</P> <P>select<BR />d.CaptureTime,<BR />dispatcher_pool_address,<BR />d.task_address,<BR />items_processed - LAG(items_processed,1) OVER (PARTITION BY dispatcher_pool_address, d.task_address ORDER BY d.CaptureTime) as items_processed_delta,<BR />w.quantum_used - LAG(w.quantum_used,1) OVER (PARTITION BY dispatcher_pool_address, d.task_address ORDER BY d.CaptureTime) as quantum_used_delta,<BR />tt.kernel_time - LAG(tt.kernel_time,1) OVER (PARTITION BY dispatcher_pool_address, d.task_address ORDER BY d.CaptureTime) as kernel_time_delta,<BR />tt.usermode_time - LAG(tt.usermode_time,1) OVER (PARTITION BY dispatcher_pool_address, d.task_address ORDER BY d.CaptureTime) as usermode_time_delta,<BR />*<BR />from cap_dm_os_dispatchers d<BR />inner join cap_dm_os_tasks t on t.task_address = d.task_address and t.CaptureTime = d.CaptureTime<BR />inner join cap_dm_os_workers w on w.task_address = t.task_address and w.CaptureTime = t.CaptureTime<BR />inner join cap_dm_os_threads tt on tt.thread_address = w.thread_address and w.CaptureTime = tt.CaptureTime<BR />order by 7 desc<BR />go</P> <P>print 'Dispatcher Pool Info'<BR />go</P> <P>select<BR />CaptureTime,<BR />dispatcher_pool_address,<BR />dispatcher_count - LAG(dispatcher_count,1) OVER (PARTITION BY dispatcher_pool_address ORDER BY CaptureTime) as dispatcher_count_delta,<BR />dispatcher_waiting_count - LAG(dispatcher_waiting_count,1) OVER (PARTITION BY dispatcher_pool_address ORDER BY CaptureTime) as dispatcher_waiting_count_delta,<BR />queue_length - LAG(queue_length,1) OVER (PARTITION BY dispatcher_pool_address ORDER BY CaptureTime) as queue_length_delta,<BR />*<BR />from cap_dm_os_dispatcher_pools<BR />order by 5 desc<BR />go</P> <P>print 'Mappings'</P> <P>select<BR />ss.*, r.*, w.*, ts.*, t.*, s.*<BR />from cap_dm_os_schedulers s<BR />inner join cap_dm_os_workers w on w.scheduler_address = s.scheduler_address and s.CaptureTime = w.CaptureTime<BR />inner join cap_dm_os_threads t on t.thread_address = w.thread_address and t.CaptureTime = w.CaptureTime<BR />inner join cap_dm_os_tasks ts on ts.task_address = w.task_address and ts.CaptureTime = w.CaptureTime<BR />inner join cap_dm_exec_requests r on r.task_address = ts.task_address and r.CaptureTime = ts.CaptureTime<BR />inner join cap_dm_exec_sessions ss on ss.session_id = r.session_id and ss.CaptureTime = r.CaptureTime<BR />order by ss.session_id, r.request_id, ss.CaptureTime<BR />go</P> <P>&nbsp;</P> <P><STRONG><U>Trimming Behavior</U></STRONG></P> <P>The default idle worker timeout is 1500 seconds (BOX, SQLVM.)&nbsp; However, various deployments may adjust the timeout threshold.</P> <P>&nbsp;</P> <P>Sub-Core set to 120 seconds</P> <P>Data Warehouse DMS set to 120 seconds<BR />Data Warehouse Engine set to 120 seconds<BR />SQLDB instance set to 900 sec</P> <P>...</P> Tue, 07 Jun 2022 18:34:04 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/how-it-works-workers-tasks-failed-logins-what-is-my-sql-server/ba-p/3478749 BobDorr 2022-06-07T18:34:04Z SQL Server 2022 public preview is now available on Linux. https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/sql-server-2022-public-preview-is-now-available-on-linux/ba-p/3460686 <P>In continuation of last week's <A href="#" target="_self">announcement of SQL Server 2022 public preview</A>, we are pleased to announce availability of SQL Server 2022 on Linux/Containers for public preview. Here are the details for getting started with the SQL Server 2022 public preview packages on Linux/Containers.</P> <P>&nbsp;</P> <P>The following are the container images for SQL Server 2022 on Linux, as well as installation instructions:</P> <UL> <LI>For RHEL based SQL Server 2022 images refer: <A href="#" target="_blank" rel="noopener">mssql/rhel/server - Certified Container Image - Red Hat Ecosystem Catalog</A> <UL> <LI>To pull and run the SQL Server 2022 RHEL based container image<LI-CODE lang="bash">podman pull mcr.microsoft.com/mssql/rhel/server:2022-latest podman run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=yourStrong(!)Password' --name sql22 --hostname sql22 -p 1433:1433 -d mcr.microsoft.com/mssql/rhel/server:2022-latest</LI-CODE></LI> </UL> </LI> <LI>For Ubuntu based SQL Server 2022 images refer: <A href="#" target="_blank" rel="noopener">Microsoft SQL Server by Microsoft | Docker Hub</A> <UL> <LI>To pull and run the SQL Server 2022 Ubuntu based container image:<LI-CODE lang="bash">docker pull mcr.microsoft.com/mssql/server:2022-latest docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=yourStrong(!)Password' --name sql22 --hostname sql22 -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest</LI-CODE></LI> </UL> </LI> </UL> <P>To learn more about the platforms and distributions on which the SQL Server 2022 on Linux public preview can be installed, visit: <A href="#" target="_blank" rel="noopener">Release notes for SQL Server 2022 Preview on Linux - SQL Server | Microsoft Docs.</A></P> <P>&nbsp;</P> <H4>Quick installation instructions:</H4> <P>Please register the '<STRONG>mssql-server-preview</STRONG>' repository to install the SQL Server 2022 public preview. Here's a quick tutorial for installing and getting started with SQL Server 2022 public preview.</P> <P>&nbsp;</P> <H5>For RHEL 8 based distributions:</H5> <OL> <LI>Download the Microsoft SQL Server preview repository configuration file:<LI-CODE lang="bash">sudo curl -o /etc/yum.repos.d/mssql-server-preview.repo https://packages.microsoft.com/config/rhel/8/mssql-server-preview.repo​​</LI-CODE></LI> <LI>Run the following command to install SQL Server:<LI-CODE lang="bash">sudo yum install -y mssql-server​</LI-CODE></LI> <LI>After the package installation finishes, run <STRONG>mssql-conf setup</STRONG> and follow the prompts to set the SA password and choose your edition.<LI-CODE lang="bash">sudo /opt/mssql/bin/mssql-conf setup​</LI-CODE></LI> <LI>Once the configuration is done, verify that the service is running:<LI-CODE lang="bash">systemctl status mssql-server​</LI-CODE></LI> </OL> <H5>For Ubuntu 20.04 based distributions:</H5> <OL> <LI>Import the public repository GPG keys.<LI-CODE lang="bash">curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –​</LI-CODE></LI> <LI>Register the Microsoft SQL server preview Ubuntu repository<LI-CODE lang="bash">sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-preview.list)"​</LI-CODE></LI> <LI>Run the following commands to install SQL Server:<LI-CODE lang="bash">sudo apt-get update sudo apt-get install -y mssql-server​</LI-CODE></LI> <LI>After the package installation finishes, run&nbsp;<STRONG>mssql-conf setup</STRONG>&nbsp;and follow the prompts to set the SA password and choose your edition.<LI-CODE lang="bash">sudo /opt/mssql/bin/mssql-conf setup​</LI-CODE></LI> <LI>Once the configuration is done, verify that the service is running:<LI-CODE lang="bash">systemctl status mssql-server --no-pager​</LI-CODE></LI> </OL> <P>That's all! SQL Server 2022 public preview is installed, and you can begin using/testing the new features right away!</P> <P>&nbsp;</P> <P>Please see: <A href="#" target="_blank" rel="noopener">Installation guidance for SQL Server 2022 Preview on Linux - SQL Server | Microsoft Docs</A> for more information on installation.</P> <P>&nbsp;</P> <P>To install the SQL Server command-line tools for RHEL based distribution please refer <A href="#" target="_blank" rel="noopener">RHEL: Install SQL Server on Linux - SQL Server | Microsoft Docs</A> and for Ubuntu based distribution refer: <A href="#" target="_blank" rel="noopener">Ubuntu: Install SQL Server on Linux - SQL Server | Microsoft Docs.</A></P> <P>&nbsp;</P> <P>For more information on the features supported, see : <A href="#" target="_blank" rel="noopener">Editions and supported features of SQL Server 2022 Preview - Linux - SQL Server | Microsoft Docs</A>, and for release notes, see &nbsp;<A href="#" target="_blank" rel="noopener">Release notes for SQL Server 2022 Preview on Linux - SQL Server | Microsoft Docs.</A></P> Thu, 02 Jun 2022 16:24:17 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/sql-server-2022-public-preview-is-now-available-on-linux/ba-p/3460686 amvin87 2022-06-02T16:24:17Z New server roles for SQL Server 2022 and Azure SQL Database in Public Preview https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/new-server-roles-for-sql-server-2022-and-azure-sql-database-in/ba-p/3428549 <P><SPAN>The article is published here on the Azure SQL Blog:&nbsp;<A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/more-new-server-roles-for-azure-sql-database-and-sql-server-2022/ba-p/3428433" target="_self">New server roles for Azure SQL Database and SQL Server 2022 in Public Preview: Database Management without admin-access</A>&nbsp;</SPAN></P> <P>&nbsp;</P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="server roles in combination" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/374974i89D6EAB6CE10AAE8/image-size/large?v=v2&amp;px=999" role="button" title="AndreasWolter_0-1653491527164.png" alt="server roles in combination" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">server roles in combination</span></span></SPAN></P> Wed, 25 May 2022 15:59:55 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/new-server-roles-for-sql-server-2022-and-azure-sql-database-in/ba-p/3428549 AndreasWolter 2022-05-25T15:59:55Z Hotfix: JDBC Driver 10.2.1 for SQL Server Released https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/hotfix-jdbc-driver-10-2-1-for-sql-server-released/ba-p/3367916 <P><SPAN>We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.1. The update addresses&nbsp;a few issues in the 10.2.0 release.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><STRONG>Fixed issues</STRONG></FONT></P> <UL> <LI>Changed Idle Connection Resiliency timeout to use existing the SharedTimer<SPAN>&nbsp;</SPAN><A href="#" data-hovercard-type="pull_request" data-hovercard-url="/microsoft/mssql-jdbc/pull/1794/hovercard" target="_blank">1794</A></LI> <LI>Fixed Managed Identity authentication's retry interval to exponentially back off properly<SPAN>&nbsp;</SPAN><A href="#" data-hovercard-type="pull_request" data-hovercard-url="/microsoft/mssql-jdbc/pull/1770/hovercard" target="_blank">1770</A></LI> <LI>Removed an extraneous call to executeCommand() within connectionCommand()<SPAN>&nbsp;</SPAN><A href="#" data-hovercard-type="pull_request" data-hovercard-url="/microsoft/mssql-jdbc/pull/1754/hovercard" target="_blank">1754</A></LI> </UL> <P><FONT size="5"><STRONG>Getting the latest release</STRONG></FONT></P> <P>The latest bits are available to<SPAN>&nbsp;</SPAN><A title="download Microsoft JDBC Driver for SQL Server" href="#" target="_self" rel="noreferrer">download from Microsoft</A>, from the&nbsp;<A href="#" target="_blank" rel="noopener">GitHub repository</A>, and via&nbsp;<A href="#" target="_blank" rel="noopener">Maven Central</A>.</P> <P>Add the JDBC 10.2.1 RTW driver to your Maven project by adding the following code to your POM file to include it as a dependency in your project (choose .jre8, .jre11, or .jre17 for your required Java version).</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="applescript">&lt;dependency&gt; &lt;groupId&gt;com.microsoft.sqlserver&lt;/groupId&gt; &lt;artifactId&gt;mssql-jdbc&lt;/artifactId&gt; &lt;version&gt;10.2.1.jre17&lt;/version&gt; &lt;/dependency&gt; </LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN>Help us improve the JDBC Driver by taking our </SPAN><A href="#" target="_blank" rel="noopener">survey</A><SPAN>, </SPAN><A href="#" target="_blank" rel="noopener">filing issues</A><SPAN> on GitHub or contributing to the project.</SPAN></P> <DIV> <DIV> <DIV><BR />Please also check out our <A href="#" target="_blank" rel="noopener">tutorials</A> to get started with developing apps in your programming language of choice and SQL Server. <P><BR />David Engel</P> </DIV> </DIV> </DIV> Fri, 13 May 2022 17:47:54 GMT https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/hotfix-jdbc-driver-10-2-1-for-sql-server-released/ba-p/3367916 David-Engel 2022-05-13T17:47:54Z