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
2,057

Hotfix: JDBC Driver 12.4.1 for SQL Server Released

DavidEngelMS on Sep 05 2023 09:12 AM
We recently released an update to Microsoft JDBC Driver for SQL Server, version 12.4.1. The update addresses a few issue...
3,208

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,845

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,972

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,769

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,293

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,586

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,166

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,566

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,586

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,833

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,991

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,518

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,194

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.
12K

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,482

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,179

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...
130K

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,534

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,699

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,979

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,370

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,273

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,403

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,654

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...

Latest Comments

Karl_Wester-Ebbinghaus
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 30 2024 11:11 AM
You're welcome. Will do @TarynPratt.
0 Likes
TarynPratt
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 30 2024 07:03 AM
@Karl_Wester-Ebbinghaus I appreciate the feedback on this and thanks for reporting what you are seeing. My suggestion would be to open a support request for the issue as they should be able to help and then raise it with the proper team.
1 Likes
amvin87
in Deploy Always On Availability Groups (AG) on SQL Server RHEL based Azure VMs - The Ansible Way! on Apr 30 2024 05:19 AM
Hi @vivek19852225, you need to create the database separately on the primary server add it to the AG and then to perform failover you should do it outside of SSMS as documented here: Manage availability group failover - SQL Server on Linux - SQL Server | Microsoft Learn.
0 Likes
Karl_Wester-Ebbinghaus
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 29 2024 11:23 PM
@TarynPratt I have checked it and there is no good way to exclude SQL updates in a maintenance plan. Except one really checks the pending update list in AUM and exclude SQL CU or GDR Update IDs. As I assumed SQL updates will be mostly in security updates or updates category. Unselecting the whole up...
0 Likes
mbourgon_optum
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 23 2024 07:24 AM
Yeah, double+ agree on the whole "without AG awareness, both are pretty useless". Sounds amazing, but practically I can't use it. Dammit.
2 Likes