SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
762 questions
1 answer
AG instance not in sync
We have 8 databases in an instance. All 8 databases are members of Availability Group. On the secondary replica, the whole instance is not synchronizing . Could you please advise how to bring the secondary instance as synchronized Thanks, Chaitanya
SQL Server Database Engine
asked 2026-07-23T11:50:51.2733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
841
Reputation points
answered 2026-08-21T00:13:15.9866667+00:00
Ben Miller-(DBADuck)
280
Reputation points MVP
2 answers
Clarification on SQL Server License Compliance during FCI Migration (VMware to Hyper-V)
Hello everyone, I am currently executing an internal infrastructure migration project moving our environment from VMware to Microsoft Hyper-V, and I need some clarification on SQL Server licensing compliance during the transition phase. Current…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
762 questions
asked 2026-07-30T16:48:14.3766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Sang. Truong Tan
0
Reputation points
answered 2026-08-21T00:09:28.4666667+00:00
Ben Miller-(DBADuck)
280
Reputation points MVP
3 answers
Database refresh from Production to Dev
We want to restore some databases from Production server to Dev server. We want to create a job that automatically restores a fresh copy of these databases to Dev server on 10th of each month. Could you please advise on how to do this.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
762 questions
asked 2026-08-06T19:39:45.92+00:00
Chaitanya Kiran
841
Reputation points
answered 2026-08-20T23:59:01.75+00:00
Ben Miller-(DBADuck)
280
Reputation points MVP
1 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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
762 questions
asked 2026-08-20T16:21:39.5566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jeff Foushee
96
Reputation points
answered 2026-08-20T21:05:09.9766667+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
2 answers
SQL serve Management Studio cannot connect to my server
I am tryng to download SSMS on my laptop to study SQL I have downloaded SQL Server 2019 express I have downloaded the visual studio installer to install SQL server management studio 22 It wont connect to the server I am getting the below error…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
asked 2026-08-20T03:32:59.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 83%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Lorraine Barron
0
Reputation points
commented 2026-08-20T08:56:48.3666667+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
1 answer
stored procedure FillTimesheetListTempTable Pass Through SQL
See attached error. User goes to her Home Page, clicks on the Procurement section and onto Timesheets and immediately gets the attached error. The stored procedure FillTimesheetsListTempTable. Pass Through SQL, returned the following results: DBMS:…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 61%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
2 answers
On-prem SQL server needs a Trust certificate
Hello Team, We have on-prem SQL Server which is running from Azure VM. From same Azure VM, we have Gateway running as well. However, we are facing an issue while connecting SQL server with PowerBI desktop and Services. For this issue, PowerBI team has…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
762 questions
asked 2026-08-19T18:34:42.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 34%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hemant
61
Reputation points Microsoft External Staff
answered 2026-08-19T19:35:18.43+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
4 answers
What are the best practices for improving SQL Server database performance?
I’m learning SQL Server and would like to understand the most important practices for keeping a database performant . Which areas should I focus on first, such as indexing, query optimization, statistics, execution plans, and database configuration?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
762 questions
asked 2026-08-19T09:46:58.73+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 40%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Steve John
0
Reputation points
edited the question 2026-08-19T16:28:16.4666667+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
4 answers
Clarification on MSOLEDBSQL19 Behavior with TrustServerCertificate=True
Hello Team, We are currently using the MSOLEDBSQL19 driver on Windows systems and would like to better understand its connection behavior related to encryption and certificate validation. While testing SQL Server connectivity, we observed that a…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
762 questions
asked 2026-07-13T09:22:07.6666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 77%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek Modi (amodi)
20
Reputation points
answered 2026-08-19T13:31:03.5966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
sudhir kumar
0
Reputation points
2 answers
Deleting mysql server 2019 instance configuration and things of that matter.
For one of my college classes I was told to download a sql server 2019 and the ssms 19.3 after I finished that classes I asked my teacher how to uninstall everything but he didn't respond back so I decided to try and delete the stuff myself I didn't…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
asked 2026-08-14T15:50:17.15+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 52%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jordan Willingham
0
Reputation points
answered 2026-08-19T13:08:28.5966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deepesh Dhake
820
Reputation points
2 answers
Alternatives to Crystal Reports for .NET compatible paginated reporting tools?
We're looking at tools for creating paginated reports. We have a couple of parameters: There needs to be up-to-date .NET libraries so we can have run the reports via C# wrappers in our code. Allows for pulling data from SQL Server We're…
SQL Server Reporting Services
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.
3,175 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 44%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 5%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How to auto-detect dead-lock condition
Some time SQL server hang-out due to in sufficient memory or dead lock. How to auto-detect dead-lock condition in SQL server, and I also want a notification email from SQL Agent.
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
288 questions
asked 2026-08-16T09:52:00.07+00:00
Avnish Kumar Mishra
20
Reputation points
accepted 2026-08-19T06:03:13.4366667+00:00
Avnish Kumar Mishra
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Does Microsoft JDBC Driver 12.10 support MSSQL 2025?
Hi All, Does Microsoft JDBC Driver 12.10 for SQL Server support SQL Server 2025 ? Does Microsoft JDBC Driver 12.4 for SQL Server support SQL Server 2025 ? Specific support for SQL Server versions, including MSSQL 2025, is not explicitly mentioned…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
asked 2026-08-18T03:41:18.2766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 82%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jessy Chen[陳慧臻]
20
Reputation points
accepted 2026-08-19T01:58:14.3766667+00:00
Jessy Chen[陳慧臻]
20
Reputation points
2 answers
One of the answers was accepted by the question author.
SSMS 22 Restore Database Timeline throws XamlParseException when using Dark Theme
Cannot access Freezable 'System.Windows.Media.Effects.DropShadowEffect' across threads because it cannot be frozen. Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseGeneralView.buttonTimeline_Click
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
asked 2026-08-13T20:20:22.54+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Luis Diego Castro - TRISAN
20
Reputation points
commented 2026-08-18T19:43:05.73+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
1 answer
SSIS job scheduled failed to connect to Azure Data Warehouse
Previously, we are able to run SSIS jobs to retrieve data from Azure Data Warehouse. We are migrating to a New Server. It is fine to connect through SSMS or run the SSIS package in Visual Studio on this new server. However, running the SSIS jobs failed…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,804 questions
asked 2026-08-18T06:54:12.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 92%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aurnorakarnkij, Sanit
0
Reputation points
answered 2026-08-18T18:34:59.5833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
27,196
Reputation points
2 answers
new ssms installation took so much space
Why new SQL Server Management Studio (22) using visual studio installation took more space than SQL Server Management Studio 20? Is there a lightweigth offline installation package?
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
asked 2026-08-11T01:18:49.45+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 98%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Longsheng Hu
0
Reputation points
answered 2026-08-14T20:53:42.9766667+00:00
Deepesh Dhake
820
Reputation points
2 answers
services.exe D:\MSSQL\MSSQL17.MSSQLSERVER\MSSQL\Binn\SQLAGENT.EXE ACCESS DENIED
I've been getting failed installs with SQL Server Developer Standard Edition on Windows 2025 Standard edition, error has been: services.exe 1000 QueryOpen D:\MSSQL\MSSQL17.MSSQLSERVER\MSSQL\Binn\sqlceip.exe ACCESS…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
762 questions
asked 2026-07-26T15:48:06.9966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIB%3C/text%3E%3C/svg%3E)
Iain Barnetson
106
Reputation points
commented 2026-08-13T20:56:16.0866667+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
2 answers
2022 express edition and i have 2025 license
We currently have SQL Server 2022 Express installed on our server while waiting for the SQL Server Standard license. Our application only supports up to SQL Server 2022, and the license provided is also for SQL Server 2022. However, when we performed an…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
762 questions
asked 2026-08-13T07:50:47.6733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 47%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E)
Kenneth Lapuz
0
Reputation points
answered 2026-08-13T14:51:35.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
84,946
Reputation points
2 answers
how to create analytical dashboard based from powerapps data
how to create analytical dashboard based from powerapps data
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,377 questions
asked 2026-08-13T12:35:47.88+00:00
MEHUL DADIA
0
Reputation points
answered 2026-08-13T12:52:18.5+00:00
Erland Sommarskog
136.4K
Reputation points MVP
Volunteer Moderator
2 answers
Migrating varbinary data from onprem SQL table to Azure blob storage.
Hi, I need to move the varbinary data in one of my on Prem SQL data table column Column(binary_data) which needs to be uploaded to azure blob storage. We have 2 million rows in the table and every row should create one file in the blob storage for…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,221 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,804 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,796 questions
asked 2024-10-21T14:22:23.4666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2026-08-12T14:26:21.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
manish verma
516
Reputation points