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 Blog
Options
3,174

Announcing General Availability of Azure Portal Experience to Deploy Multi-Subnet Availability Group

TarynPratt on Aug 29 2023 08:31 AM
Today, we are excited to announce general availability (GA) of the end-to-end experience to deploy a multi-subnet Availa...
3,806

Announcing public preview of enhanced patching for SQL Server on Azure VM with Azure Update Manager

TarynPratt on Aug 28 2023 12:04 PM
Today, we are pleased to announce the ability to patch your SQL Server on Azure VMs registered with the SQL Server IaaS ...
1,955

Delegating permission management using Roles vs WITH GRANT OPTION

AndreasWolter on Aug 22 2023 03:31 PM
Comparing 2 methods for delegating permission management with T-SQL
2,746

Cumulative Update #22 for SQL Server 2019 RTM

HristinaSQL on Aug 14 2023 03:59 PM
The 22nd cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site...
2,281

Cumulative Update #7 for SQL Server 2022 RTM

SrinivasSQL on Aug 10 2023 05:11 PM
The 7th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft Downloads site....
5,460

I/O optimizations for tempdb in SQL Server and Azure SQL

bobward on Aug 08 2023 08:24 AM
Tempdb optimizes log flushes and disk writes in Microsoft SQL.
3,121

Azure Data Studio 1.45 Release and Hotfix

erinstellato on Aug 07 2023 12:06 PM
The release of Azure Data Studio 1.45 includes the GA of the long-requested functionality of Filtering in OE, as well as...
3,361

ODBC Driver 18.3 for SQL Server Released

DavidEngelMS on Aug 03 2023 09:00 AM
Version 18.3 of the Microsoft ODBC Driver for SQL Server has been released. Version 18.3 includes new features and fixes...
2,478

JDBC Driver 12.4 for SQL Server Released

DavidEngelMS on Aug 03 2023 09:00 AM
JDBC Driver 12.4 for SQL Server has been released, adding official support for Java 20 and several other improvements.
2,805

Released: Microsoft.Data.SqlClient 5.2 Preview 3

DavidEngelMS on Jul 21 2023 09:15 AM
Microsoft.Data.SqlClient 5.2 Preview 3 has been released. This release contains improvements and updates to the Microsof...
1,974

Cumulative Update #6 for SQL Server 2022 RTM

HarveyMoraSQL on Jul 13 2023 02:56 PM
The 6th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft Downloads site....
2,504

Released: SCOM Management Packs for SQL Server, RS, AS (7.2.0.0)

EbruErsan on Jul 10 2023 05:07 AM
Updates to SQL Server, SQL Server Dashboards, Reporting Services, and Analysis Services Management Packs are available (...
5,029

Use sqlcmd to create and query a SQL Server container for development

jes_schultz on Jul 05 2023 10:51 AM
Learn how easy it is to create and query a SQL Server container in your local environment using sqlcmd.
11.6K

SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 3

erinstellato on Jun 19 2023 07:21 AM
In this final post in a series of three, new features in SSMS 19.1 are covered, along with upcoming plans for the next r...
2,470

Cumulative Update #5 for SQL Server 2022 RTM

HarveyMoraSQL on Jun 15 2023 03:59 PM
The 5th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft Downloads site....
3,139

Cumulative Update #21 for SQL Server 2019 RTM

HristinaSQL on Jun 15 2023 03:29 PM
The 21st cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site...
126K

Update: Hotfixes released for ODBC and OLE DB drivers for SQL Server

DavidEngelMS on Jun 15 2023 11:13 AM
A few important security issues prompted us to release updates to the ODBC and OLE DB drivers.
9,074

SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 2

erinstellato on Jun 12 2023 09:13 AM
In this second post in a series, we'll cover recent changes in SSMS 19 related to the Vulnerability Assessment, startup ...
3,664

Released: Microsoft.Data.SqlClient 5.2 Preview 2

DavidEngelMS on Jun 09 2023 09:00 AM
Microsoft.Data.SqlClient 5.2 Preview 2 has been released. This release contains improvements and updates to the Microsof...
9,766

SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 1

erinstellato on Jun 08 2023 12:55 PM
In this first post in a series, we'll cover recent changes in SSMS 19 related to underlying drivers and authentication.
2,352

Early technical preview of JDBC Driver 12.3.1 for SQL Server released

DavidEngelMS on Jun 08 2023 10:45 AM
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and ch...
2,258

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

DavidEngelMS on Jun 08 2023 09:00 AM
We have released version 1.3 of the SQL Server 3rd Party Backend for Django. This release contains support for the relea...
2,386

Private preview announcement of native JSON type & JSON aggregates in Azure SQL Database

uc-msft on May 25 2023 09:14 AM
Private preview announcement of native JSON type & JSON aggregates in Azure SQL Database
4,618

Announcing Azure Data Studio 1.44

erinstellato on May 25 2023 08:31 AM
We are excited to announce the release of Azure Data Studio 1.44 with the community, which introduces support for the Gi...
3,010

Cumulative Update #4 for SQL Server 2022 RTM

SrinivasSQL on May 11 2023 02:59 PM
The 4th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft Downloads site....

Latest Comments

erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 11:54 AM
@DavidYorkshire Following up on your statement that WSUS isn't consistently for updates, with the example that new versions of Windows OS have been available through WSUS for years. Correct. You can update from Windows 8 -> 8.1 ->10 -> 11, or Windows Server 2016 -> 2019 -> 2022 and presumably -> 202...
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 07:13 AM
@sgtmango333 We don't overwrite settings with any upgrade (minor or major). You have to import settings from a previous version to update them. We understand there is additional effort related to connection settings with SSMS 20 - that is why we shared information about the release in advance and no...
0 Likes
sgtmango333
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 06:48 AM
I understand the intent, but that makes life a difficult for those using a Central Management Server with hundreds of instances. That means that every one on my team must now connnect to every server and update this setting just to maintain functionality after installing version 20. So next question...
0 Likes
SivertSolem
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 17 2024 04:16 AM
@TarynPratt wrote:At this point, patching SQL Server on Azure VMs through Azure Update Manager or Automated Patching via the SQL IaaS extension is not aware if the SQL Server is a part of an Always On availability group. It is important to keep this in mind when scheduling your updates with an autom...
1 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 16 2024 06:15 PM
@sgtmango333 I missed your question, apologies. It is not possible to set the default value for the Encryption property to optional. With SSMS 20 we upgraded to MDS 5.x, which sets Encryption to Mandatory (true) by default. We intentionally decided to stay with the default, to encourage folks toward...
1 Likes