SQL Server Database Engine

How to remediate hadoop-common-2.6.0.2.2.0.0-2041.jar vulnerabilities in SQL Server path/Program Files/Microsoft SQL Server/130/DTS/Extensions/Common/Jars/hadoop-common-2.6.0.2.2.0.0-2041.jar

How to remediate hadoop-common-2.6.0.2.2.0.0-2041.jar vulnerabilities in SQL Server path/Program Files/Microsoft SQL Server/130/DTS/Extensions/Common/Jars/hadoop-common-2.6.0.2.2.0.0-2041.jar

KB5058713 fails install

KB5058713 fails install regardless of reboots, disabling SQL services, or Safe boot. O/S: Win10 Pro 22H2 x64 Tried: Run WUpdate Troubleshooter - fails to launch due to error 0x80070003 Reboot & Update - install fails Clean boot & Update -…

Best practice with sp_syspolicy_events_reader and ##MS_PolicyEventProcessingLogin##

The SQL Server logs on our primary replica (Microsoft SQL Server 2022 with Always On) has been filling up with this repeated message: The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'SQLAG1_msdb.dbo.syspolicy_event_queue'…

Data Synchronization - Syncing Two Databases in SQL Server

I'm needing to take one database and have it on two separate sql servers (in two different physical locations) and have it stay in sync. Is there a way that I can do this? I've looked into SQL Server Replication ie:…

How do fix Microsoft SQL server installation issue.

I’m facing an issue with SQL Server Agent and SQL Server services. Initially, both services were not starting. After multiple troubleshooting attempts, I managed to start them successfully. However, I am still unable to log in to the database using SSMS…

SQL server express not installing

Hi, I have tried to install this multiple times however this error keeps showing up. I have uninstalled it and then tried to reinstall and it hasn't worked. Is there anything else I can try?

How to fix ODBC test result failed

When we test our ODBC configuration it fails. This use to work fine, but suddenly it stopped. Here is the error message. "Microsoft ODBC Driver for SQL Server Version 17.10.0006 Running connectivity tests... Attempting connection [Microsoft][ODBC…

How to resolve error 1067, unable to start SQL server (sqlexpress) service on local computer

How to index vector fields for semantic search in sql server azure

CREATE VECTOR INDEX idx_OpenAIEmbedding ON dbo.table_name (OpenAIEmbedding) WITH ( VECTOR_DIMENSION = 1536, -- Assuming OpenAI embedding dimension SIMILARITY_FUNCTION = 'COSINE' ); Started executing query at Line 1 Msg 343, Level 15, State 2, Line…

sql server 2022 express persistent installation error

I am trying to instal sql server 2022 express, but I keep getting a persistent error:" Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help." I check…

How to fix the SQL server to start - error logs " Master data"?

HI I just recently download SQL When i connect to sql server it give me error code 1067and try to sql server configuration manager to start sql server but it get me error msg which i attach the file or screenshot. please help me out .. errorlog.pdf

i am unable tonnect my SQL database Engine server

i am unable tonnect my SQL database Engine server i am tried it lots of time by installing and uninstalling the SQL setup i want its solution or online support

.NET GC not reclaiming memory after List<T>.Clear() in SQL CLR UDF under load - leads to memory insufficiency in SQL Server

We're running into memory insufficiency issues on SQL Server when using a SQL CLR UDF written in C# targeting .NET Framework 4.8. The function uses a singleton class to cache user session info using a List<T> of structs. Each struct holds…

How to fix transactional replication latency

Good Morning All, We are facing replication latency issue. I checked for blocking, long running transactions or bulk operations running. I tried re-running the distribution agent job also. But still the latency exists. Could you please tell me what all I…

SQL Server 2022: Memory Leak with context connection=true in SQLCLR vs Stable Behavior Using External SqlConnection

Hi Microsoft team and community, I've been stress testing a SQL Server 2022 Developer Edition installation on Windows Server 2025 Datacenter using SQLCLR UDFs that interact with an unmanaged C DLL via DllImport. The workload involves 400+ concurrent…

Cores Per Socket Best Practices for VMs

Hello, What configuration offers better performance for SQL Server Enterprise Edition Running on virtual machines like VMWare: multiple sockets with one core each (e.g., 8 sockets, 1 core per socket) or a multi-core setup (e.g., 1 socket, 8 cores)?…

Does Alter Table Add Column with Default Value work the same on Standard and on Enterprise

SQL Server 2019 Standard Edition ALTER TABLE CommunicationsRecipient ADD CausedUnsubscribe Bit NOT NULL DEFAULT 0; I had a 3rd party software upgrade that failed on an Alter Table Add column statement on a 45 million row table. The Upgrade has a built-in…

Is there any code difference between SQL Developer edition and Standard edition.

I am planning to migrate our non prod server from SQL Server 2019 standard edition to Developer edition. Our prod servers are all standalone servers. no encryption enabled for any of the databases. Now, I have below questions. Do we face any issues if…

SQL Service not started even SQL installed successfully

Issue Summary for HP Support – SQL Server Stack Overflow on HP EliteBook 👤 User: Laptop: HP EliteBook 640 G11 Notebook PC OS: Windows 10 Enterprise x64, Build 26100 System: Physical machine, no virtualization Memory: 16 GB RAM Disk: Sufficient…

Patching is breaking the Master Database of SQL Server Installed

Hello, I am operating Microsoft SQL Server 2019 Enterprise Edition within our environment. One of our SQL Server instances, which is hosted on a virtual machine (VM), has SQL Server Integration Services (SSIS) installed. We’ve encountered a recurring…