cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server

  • 1,429 Blog Articles
Options
4,279

Replication Enhancements in the SQL Server 2019 CU13 Release

Kevin Farlee on Oct 05 2021 01:21 PM
Read about some exciting enhancements to SQL Server Replication in CU13 of SQL Server 2019, including Write-Write replic...
1,187

Cumulative Update #13 for SQL Server 2019 RTM

SrinivasSQL on Oct 05 2021 01:11 PM
The 13th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site...
1,721

Announcing GA of adutil-A tool to ease configuration of AD authentication for SQL on Linux/Container

amvin87 on Oct 01 2021 09:18 AM
Announcing General Availability of adutil - A tool to ease the process of configuring AD authentication for SQL On Linux...
1,812

Released: Microsoft.Data.SqlClient 3.0.1

David-Engel on Sep 24 2021 03:26 PM
We have released an update to Microsoft.Data.SqlClient, version 3.0.1. The update addresses several issues that are impo...
738

Released: Microsoft.Data.SqlClient 4.0 Preview 2

David-Engel on Sep 21 2021 03:08 PM
Microsoft.Data.SqlClient 4.0 Preview 2 has been released. This release contains improvements and updates to the Microsof...
1,025

Released: Microsoft.Data.SqlClient 2.1.4

David-Engel on Sep 20 2021 06:58 PM
We have released an update to Microsoft.Data.SqlClient, version 2.1.4. The update addresses a couple of issues that are ...
4,148

SQL Server 2016 SP3: Last Service Pack for SQL Server

Pedro Lopes on Sep 15 2021 05:20 PM
The 3rd and final Service Pack release for SQL Server 2016 is now available for download at the Microsoft Downloads site...
1,241

Cumulative Update #26 for SQL Server 2017 RTM

HristinaSQL on Sep 14 2021 03:38 PM
The 26th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site...
934

Microsoft Drivers 5.10.0 Beta 1 for PHP for SQL Server Released

David-Engel on Sep 08 2021 02:19 PM
We recently released the next beta of the Microsoft Drivers for PHP for SQL Server, version 5.10.0-beta1. This beta rele...
2,346

Released: Microsoft.Data.SqlClient 4.0 Preview 1

David-Engel on Aug 25 2021 01:56 PM
Microsoft.Data.SqlClient 4.0 Preview 1 has been released. This release contains improvements and updates to the Microsof...
1,649

SQL Server 3rd Party Backend for Django v1.0 Released

vwarchu on Aug 17 2021 09:00 AM
We're officially announcing the release of mssql-django v1.0 as an open source project!
1,839

JDBC Driver 9.4 for SQL Server Released

David-Engel on Aug 05 2021 11:41 AM
JDBC Driver 9.4 for SQL Server has been released, adding official support for Java 16 and several other improvements.
2,435

Cumulative Update #12 for SQL Server 2019 RTM

SrinivasSQL on Aug 04 2021 05:02 PM
The 12th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site...
2,946

ODBC Driver 17.8 for SQL Server Released

David-Engel on Jul 30 2021 01:52 PM
Version 17.8 of the Microsoft ODBC Driver for SQL Server has been released. Version 17.8 includes several new features a...
4,497

Deploy SQL Server – The Ansible way!

amvin87 on Jul 28 2021 08:15 AM
Automate SQL Server deployment on Linux using Ansible based system roles.
4,069

Azure Defender for SQL is now available on the SQL Virtual Machine blade.

Aditya_Badramraju on Jul 27 2021 09:40 AM
Now, customers can configure Azure defender for SQL Server on Azure Virtual Machines from SQL VM blade. This addresses t...
1,950

Cumulative Update #25 for SQL Server 2017 RTM

HristinaSQL on Jul 12 2021 05:34 PM
The 25th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site...
2,064

Released: SCOM Management Packs for SQL Server, Reporting Services, Analysis Services (7.0.32.0)

EbruErsan on Jun 29 2021 02:16 AM
Updates to SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.32.0). We also rele...
1,748

Released: Update to Microsoft OLE DB Driver 18 for SQL Server

David-Engel on Jun 21 2021 01:38 PM
OLE DB Driver 18.6 for SQL Server is released, bringing support for Idle Connection Resiliency to the driver.
5,316

SQL Server 2016 Service Pack 3 release schedule update

HristinaSQL on Jun 16 2021 05:12 PM
SQL Server 2016 mainstream support is scheduled to end 7/13/2021 as defined by the lifecycle policy. With the crossover ...
2,058

Cumulative Update #11 for SQL Server 2019 RTM

SrinivasSQL on Jun 10 2021 05:42 PM
The 11th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site...
6,052

Released: General Availability of Microsoft.Data.SqlClient 3.0

David-Engel on Jun 09 2021 12:35 PM
We have released for general availability Microsoft.Data.SqlClient 3.0. This .NET Data Provider for SQL Server provides ...
1,348

Released: Public Preview for SQL Server Management Packs (7.0.31.0)

EbruErsan on Jun 08 2021 06:33 AM
Updates to Management Packs for SQL Server, Reporting Services, and Analysis Services (7.0.31.0) are available for publi...
1,631

Released: Microsoft.Data.SqlClient 2.1.3

David-Engel on May 21 2021 02:29 PM
We have released an update to Microsoft.Data.SqlClient, version 2.1.3. The update addresses a couple of issues that are ...
1,753

Released: Microsoft.Data.SqlClient 3.0 Preview 3

David-Engel on May 21 2021 11:40 AM
Microsoft.Data.SqlClient 3.0 Preview 3 has been released. This release contains improvements and updates to the Microsof...
1,464

Cumulative Update #24 for SQL Server 2017 RTM

HristinaSQL on May 10 2021 04:22 PM
The 24th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site...

Latest Comments

Lawrence_Smith
in SQL Server 2016 SP3: Last Service Pack for SQL Server on Oct 14 2021 03:02 PM
I'm going to answer my own question for those who may follow. After some experimentation, it appears that "cleanup_version" is related to the version number from change tracking itself, like the number you might get from callingselect CHANGE_TRACKING_CURRENT_VERSION()So, if your change tracking vers...
0 Likes
Lawrence_Smith
in SQL Server 2016 SP3: Last Service Pack for SQL Server on Oct 12 2021 10:40 AM
I guess I still have a question on the finer points of this integer version number. Is this counter reset to zero when cleanup occurs? Based on your comment it sounds like that's the case, and If so then it really is an edge case and we'll have no issue with it. Thank you for your replies though! Th...
1 Likes
CodeBill
in Upsert JSON documents in SQL Server 2016 on Oct 12 2021 09:42 AM
Thanks for posting this article, I'm surprised this user case hasn't been mentioned more on the tech community and MSDN bulletins considering pretty much everyone is working with JSON data these days!Anyway it saved me some time in trying to figure out the syntax when using OPENJSON with MERGE state...
0 Likes
Pedro Lopes
in SQL Server 2016 SP3: Last Service Pack for SQL Server on Oct 11 2021 04:37 PM
@Lawrence_Smith and @petervee This is the number of outstanding versions to cleanup. So only systems that generate a number of versions > positive integer limit would encounter this, as stated in the Cause section of KB5007039 - FIX: You encounter error messages 8114 or 22122 when performing change ...
0 Likes
petervee
in SQL Server 2016 SP3: Last Service Pack for SQL Server on Oct 11 2021 03:53 PM
What is meant by "busy system"? "After a busy system that uses change tracking is enabled, the cleanup version can cross a range of INT in a given interval." What is this given interval?
1 Likes