14,837 questions

Sort by: Updated
2 answers

Baseline SQL performance on server with stacked instances

My question is what approach to take to baseline performance with multiple SQL Server instances on a server. We are building a Always On availability group cluster (SQL 2022) for a consolidation project. The cluster is as yet unused. We plan to stack…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-11-12T20:17:44.18+00:00
answered 2026-11-12T20:50:50.9233333+00:00
Erland Sommarskog 138.7K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

Hello, I'm planning to install SQL Express 2025 in mixed mode at my company. Is this version free to use?

Hello, I'm planning to install SQL Express 2025 at my company. Is this version free to use?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-11-10T03:00:12.67+00:00
Taehyoen Hwang 40 Reputation points
accepted 2026-11-12T01:04:39.8633333+00:00
Taehyoen Hwang 40 Reputation points
2 answers One of the answers was accepted by the question author.

How do I check for updates to SSMS

I was instructed my our IT person to update SQL Server or SSMS by opening SSMS > Help > Check for Updates. But I can't find the "Check for Updates" prompt. Do I have to sign into SSMS in order to see the "Check for Updates"?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-11-11T18:51:29.72+00:00
Loretta Berardi 20 Reputation points
commented 2026-11-11T19:37:01.6033333+00:00
Loretta Berardi 20 Reputation points
3 answers

Error message in Merge replication "Call sp_MSensure_single_instance"

In replication monitor, I read an error message from a merge replication " Command attempted: {call sp_MSensure_single_instance (N'IZT4N73LFYS1BMZ\FLAG2-flagdata-Flag Data Tables-WIN-5PNEMH7B8TU-642', 4)} Error messages: The…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2022-12-27T03:04:53.163+00:00
Gao Peng 26 Reputation points
answered 2026-11-11T18:43:52.2133333+00:00
Neil 0 Reputation points
2 answers

Write-SqlTableData : A parameter cannot be found that matches parameter name 'TrustServerCertificate'.

Import-module sqlserver -MinimumVersion 22.2.0 $ConfigInfo = Import-CSV 'C:\ConfigStuffToImportOnSQLServer.txt' Write-SqlTableData -ServerInstance myinstance -DatabaseName 'master' -SchemaName 'dbo' -TableName 'GoodStuff' -Force -ConnectionTimeout 0…

Windows for business | Windows Server | User experience | PowerShell
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2024-03-05T16:39:18.87+00:00
Greg Lee 0 Reputation points
answered 2026-11-11T18:14:54.94+00:00
Randy Kroeger 0 Reputation points
1 answer

SQL Server Enterprise – Physical Core Licensing on Smaller Production Host with Passive HA/DR VMs on Larger Unlicensed Hosts

Hello, We have 8 SQL Server Enterprise core licenses with active Software Assurance (SA) and intend to license our production host by physical cores. We would like to confirm whether the following configuration is fully licensed for HA/DR: Production:…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-11-10T23:33:55.87+00:00
peefee 0 Reputation points
answered 2026-11-11T07:47:03.0966667+00:00
Erland Sommarskog 138.7K Reputation points MVP Volunteer Moderator
2 answers

SQL Server 2025 Installation Fails – Error 0x851A001A, NVMe 32KB Sector Size Despite Registry Workaround

Hello Microsoft Support Community, I'm experiencing a persistent SQL Server 2025 installation failure on my Lenovo Legion Pro 5 laptop running Windows 11 Home. I have attempted to install both SQL Server 2025 Developer Edition and Express Edition. Both…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-11-08T10:04:03.7666667+00:00
dor shaked 0 Reputation points
answered 2026-11-09T16:20:35.38+00:00
Erland Sommarskog 138.7K Reputation points MVP Volunteer Moderator
3 answers

In SQL server 2025 version dump files are created after reboot, After checking its showing bug in the software

***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\LOG\SQLDump0027.txt                                                                             SqlDumpExceptionHandler: Process 13 generated fatal exception…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-10-29T06:47:27.0866667+00:00
Marugalla, Naresh (Ext) 0 Reputation points
edited an answer 2026-11-09T04:38:25.7266667+00:00
Paul Thomas 160 Reputation points
2 answers

Sql Express install failure

Getting SQL express 2022 install failure: azure extension - turned off Features: PolyBase off all others on (including localdb sharing) only windows authentication on Error: TITLE: Microsoft SQL Server 2022 Setup The following error has occurred: The…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-11-07T03:06:47.72+00:00
mark levy 0 Reputation points
answered 2026-11-07T12:32:00.2266667+00:00
Erland Sommarskog 138.7K Reputation points MVP Volunteer Moderator
2 answers

Get-AzDataMigrationAssessment Generates Inconsistent JSON Formats and an Additional HTML File.

Hello Microsoft Team, I am using the Get-AzDataMigrationAssessment PowerShell cmdlet from the Az.DataMigration module to generate SQL Server migration assessment reports. The assessment covers the following three scenarios: …

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-10-15T13:29:15.21+00:00
Shivam Singh 0 Reputation points
commented 2026-11-06T17:00:05.86+00:00
Deepesh Dhake 1,325 Reputation points
2 answers

MS SQL Server Compatibility with Gallagher Command Center

Is MS SQL Server 2025 compatible with Gallagher Command Center version 8.40 and 8.90?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-10-12T12:41:43.96+00:00
Khalid Khan Tareen 0 Reputation points
commented 2026-11-06T16:47:57.3133333+00:00
Deepesh Dhake 1,325 Reputation points
2 answers

Master Data Services web app renders empty after SQL Server CU26 update

Hi everyone, SQL Server 2022 CU26 appears to break Master Data Services web application. After patching to CU26 (16.0.4265.3), the MDS web application loads, but is completely empty. The MDS database and data remain intact and are visible through SQL…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-09-03T11:43:17.93+00:00
Simon Lenk 10 Reputation points
commented 2026-11-04T14:19:20.2033333+00:00
Simon Lenk 10 Reputation points
2 answers

CoPilot inside SSMS (not a Fabric databse)

from inside SSMs, what CoPilot assistance or options do I have Could I for instance, ask for a T-sql snippet to search through the current database table names for a given string?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-10-30T18:46:27.3666667+00:00
Rose, Lance 0 Reputation points
answered 2026-10-30T22:20:52.6533333+00:00
Deepesh Dhake 1,325 Reputation points
1 answer One of the answers was accepted by the question author.

Licencing SQL Server 2025 in a Virtualised Environment

Ref: https://www.microsoft.com/licensing/guidance/SQL#section-56-840 Per your licencing guide in the linked page, you provide conflicting information on licencing SQL Server on a VM. Comparing the sections on virtualising SQL Server with the section on…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-10-30T11:46:01.2133333+00:00
Gavin Harris 20 Reputation points
accepted 2026-10-30T12:43:38.73+00:00
Gavin Harris 20 Reputation points
3 answers One of the answers was accepted by the question author.

what happens if the cloud witness is unreacheble for a two node cluster

Hi, first of all thank for all your incoming aswers. I'm trying to deploy a two node WSFC and then create a SQL Server Availability Group. The scenario is that in a building, there are two Datacenter and I installed a server in each datacenter. So the…

Windows for business | Windows Server | Storage high availability | Clustering and high availability
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2023-05-12T19:06:52.3466667+00:00
Angel Rendiles 20 Reputation points
commented 2026-10-27T15:40:35.0066667+00:00
Erland Sommarskog 138.7K Reputation points MVP Volunteer Moderator
3 answers One of the answers was accepted by the question author.

SPID -5 blocking everything.

SS 2022 CU 13 Greetings. Last weekend we moved to a new SQL server, and last night didnt go so well. When I logged in this morning we had LOTS of blocking from spid -5. I can't find much info on this but did find this link that shares this detail: In…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2025-01-31T15:37:03.4666667+00:00
chrisrdba 471 Reputation points
answered 2026-10-25T16:03:11.5466667+00:00
Tamim Hasib 0 Reputation points
1 answer

How to obtain SQL Server 2016 Patches after subscribing for ESU

We purchased Extended Support for SQL Server 2016. How would I go about getting the updates for SQL Server? We have an on-prem environment. Is there a specific site that I go to download the patches?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-10-23T15:16:49.85+00:00
Michael Palma 0 Reputation points
answered 2026-10-23T15:17:27.3233333+00:00

AI answer

2 answers

Is SQL Server 2025 Standard Developer Edition Licensed for Automated Restore Testing?

Hello everyone, We are planning to set up a dedicated SQL Server instance exclusively for automated backup restore testing. Our production SQL Server databases are backed up regularly. Using dbatools, these production backups will be automatically…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-10-22T06:41:11.02+00:00
Augustin, Christopher 0 Reputation points
answered 2026-10-23T01:22:33.9266667+00:00
Bruce (SqlWork.com) 85,786 Reputation points
2 answers One of the answers was accepted by the question author.

numMsgsRcvd:1 should be less than numMsgsSent:1

I was starting up my Program as the following error occured: E/AndroidRuntime: FATAL EXCEPTION: pool-2-thread-1 Process: de.heffnersoftware.hsproduction, PID: 8295 java.lang.AssertionError: numMsgsRcvd:1 should be less than numMsgsSent:1 at…

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,717 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2021-06-08T16:10:00.403+00:00
Alexander 21 Reputation points
commented 2026-10-21T15:51:33.3066667+00:00
David Engel 0 Reputation points Microsoft Employee
3 answers

Import and Export Data option greyed out in SSMS 22 with SQL Server 2025 Developer

Hello, I am using SQL Server 2025 (RTM) – 17.0.1000.7 (Enterprise Developer Edition, 64-bit) on Windows 10 Pro. I installed: Database Engine Services (Default instance: MSSQLSERVER) Integration Services (added later via “Add features to existing…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,837 questions
asked 2026-02-22T20:30:09.4333333+00:00
Sabyasachi Paul 0 Reputation points
commented 2026-10-20T13:37:39.8866667+00:00
Erland Sommarskog 138.7K Reputation points MVP Volunteer Moderator