Core component of SQL Server for storing, processing, and securing data
Access + ODBC driver 18 + SQL Server 2025: 150-250 ms per request when bound forms are open
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025 through ODBC driver 18? In several existing Access application (currently none of them connecting to a SQL Server 2025), a simple DAO test on a SQL Server…
SQL Server Database Engine
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
Additional SQL Server features and topics not covered by specific categories
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
Additional SQL Server features and topics not covered by specific categories
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
Additional SQL Server features and topics not covered by specific categories
SQL Server 3-node cluster can't see remote DR node
Hello All. I'm setting up a typical SQL 2022 3-node availability group cluster with two HA nodes in primary data center and DR node in remote data center. This is my first attempt at dedicating interfaces to replication traffic The two HA nodes have a…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
PC|Access Issue|Access Denied – Unable to Load Folder Contents in Web Portal|AWS|UAI|PROD
I am trying to access a folder through the web portal, It is SQL Reporting Services. but I am getting the following error: “Could not load folder contents. You are not allowed to view this folder. Contact your administrator to obtain the necessary…
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
SSRS retains old Windows username after account rename
Environment Details SQL Server Reporting Services: SQL Server 2022 SSRS Version: 16.0.1118.33 Operating System: Windows 11 Home Single Language SSRS Mode: Native Mode Authentication: RSWindowsNTLM Report Server URL: http://karesuneel/ReportServer Web…
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
SQL Server 2025 severe T-SQL WHILE loop performance regression
SQL Server 2025 - Severe T-SQL WHILE Loop Performance Regression We are experiencing severe performance degradation when executing basic procedural T-SQL code on SQL Server 2025. To isolate the issue from application logic, indexing, disk I/O, and query…
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
PBIRS Scheduled Refresh displays incorrect timestamp – one-hour discrepancy in LastRunTimeDescription
Product:Power BI Report Server (On-premises) Issue type: Technical / Break-fix Description: Following our recent server timezone configuration changes to use British Columbia local time, we noticed an inconsistency in the Scheduled Refresh timestamp…
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
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
Additional SQL Server features and topics not covered by specific categories
How can we reduce cross-region write latency in a legacy .NET 4.8 application with row-by-row SQL operations?
We have a legacy .NET Framework 4.8 application using C#, ADO.NET and SQL Server 2019/2022, deployed across multiple regions. We are evaluating SQL Server 2025 and other possible improvements to our application architecture. Our architecture consists…
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
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
Additional SQL Server features and topics not covered by specific categories
SQL Server 2022 — How can SHARED_TRANSACTION_WORKSPACE lock ownership be independently verified? We're valida
Subject: SQL Server 2022 — How can SHARED_TRANSACTION_WORKSPACE lock ownership be independently verified? We're validating an isolated synthetic database with a multi-session concurrency test. SQL Server reports a granted database shared lock with these…
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
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
Additional SQL Server features and topics not covered by specific categories
copy activity from sql server to adls gen2 parquet format , getting below error
ErrorCode=Unknown,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=An unknown error occurred.,Source=Microsoft.DataTransfer.Common,''Type=JNI.JavaExceptionCheckException,Message=Exception of type…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
AI answer
How to prevent auto-update of SQL Server 2025 Engine?
Hi. I am convinced of a JSON bug introduced somewhere between CU4 and CU6. I want to reinstall my instances so I can troubleshoot and then post the bug if it exists. I have repeatedly uninstalled my SQL Server 2025 instances. I have reinstalled 3 RTM…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
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
Additional SQL Server features and topics not covered by specific categories
How to install transactional replication when publisher is 2022, distributor is 2022, and subscriber is 2019.
How to install transactional replication when publisher is 2022, distributor is 2022, and subscriber is 2019. Publisher uses Always On Distributor uses Always On Subscriber uses Always On SQL Server service_account is different for publisher,…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQLCLR scalar function spins on DIAG_OBJECT at high DOP: CPU per call 36 times higher at DOP 24 than at DOP 4
On SQL Server 2025 CU10 (17.0.5035.5, KB5125471, also seen on CU4), on Linux with 24 schedulers, a trivial SQLCLR scalar function called once per row in a parallel plan costs far more CPU per call as DOP rises, and the query is slower at DOP 24 than at…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Backup table gets extra ID from source table after SELECT INTO, no concurrent DML, RCSI enabled
SQL Server 2016 RTM (13.0.1601.5), RCSI enabled. When doing `INSERT INTO backup_table SELECT * FROM source_table`, the backup table contains an extra data that no longer exists in the source table. I have confirmed: - No open transactions at the time. -…
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.