Suggest a way to replicate data from on premise sql server 2019 to azure synaspe analytics directly
Im using an sql server in my on premise with version 2019, I need to transfer or replicate real time data to azure synapse database, so which azure service will be more effective and flexible for large data transfer
Razor core app connects to DB, but integration test fails with Microsoft.Data.SqlClient.SqlException
I have an app that I've been writing and its working well. When I introduced an integration test, its unable to connect to the DB using the exact same connection string. Microsoft.Data.SqlClient.SqlException: 'A network-related or instance-specific…
SQL server down, I need help!!!
00002044.0000290c::2024/09/24-17:17:04.853 ERR [RES] SQL Server Availability Group <ETL_LST>: [hadrag] Did not find the instance to connect in SqlInstToNodeMap key. 00002044.0000290c::2024/09/24-17:17:04.853 WARN [RHS] Online for resource…
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
SSMS : 18.12.1 and 18.6 : clicking New Query button crashes SSMS; 'SQL Server Agent' service doesn't start at all.
Hello All ! SSMS : 18.12.1 and 18.6 : clicking New Query button crashes SSMS; 'SQL Server Agent' service doesn't start at all. ============================================= OS: Windows 10 pro : version: 10.0.19044 steps: Installed SQL…
Hi, I always facing DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ProductColor'. this issue, I checked all my data binding, its correct, how to fix this?
Below is my code for cs using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; //Step 1: using System.Xml.Linq; using Razorpay.Api; using…
Msg 319, Level 15, State 1, Line 88 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Create Table #percentpopulationvaccination ( continent nvarchar(255), location nvarchar(255), date numeric, population numeric, New_vaccinations numeric, rollingpeoplevaccinated numeric, ); Insert Into #percentpopulationvaccination select dea.continent,…
Msg 319, Level 15, State 1, Line 88 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Create Table #percentpopulationvaccination ( continent nvarchar(255), location nvarchar(255), date numeric, population numeric, New_vaccinations numeric, rollingpeoplevaccinated numeric, ); Insert Into #percentpopulationvaccination select dea.continent,…
Failed to authenticate the user NT Authority\Anonymous Logon in Active Directory (Authentication=ActiveDirectoryIntegrated).
I'm working on configuring Azure SQL Server authentication using Microsoft Entra Integrated. Here’s my setup: I have an Azure SQL Server with an active database. My laptop is connected to Azure AD. I’ve opened SQL Server Management Studio (SSMS),…
A SQL2005 query worked before but not now.
select name, EDI_code, perdose, perday, howlongday, count(*) AS frequencies from prescriptions_pharmacy group by name, EDI_code, perdose, perday, howlongday When I execute above query in Server Management Studio Express, Incorrect syntax near '' error is…
DQS DATA QUALITY AGENT
I GOT THIS ERROR
SQL Express Setup (SQLEXPR_x64_ENU) failed with 2068052310 error code
I was installing SQL Express 2019 (SQLEXPR_x64_ENU) at Windows 10 64 bit machine, but getting 2068052310 error code. Pre-Installed: SQL Express 2012 SP4 64 bit.
SQL Table Performance
I have a table in my SQL Server that is not performing well. When I looked closely at it, I found that it had 40+ indexes and about 20 of them were never used. I removed those 20 indexes, thinking that would help with performance. Unfortunately, that…
How to open multiple .sql files in only one SSMS instance
Hello everyone, I have a problem on SQL Server Management Studio (SSMS) version 20.2.30.0. Since i upgraded my SSMS, when i wanna open my sql file, instead of open it on one window and new tab on there, it'll open in multiple window. It should be…
What does ADF SSIS Error "Disk Full Exception Caught" mean
Hi, we are running an Azure-SSIS Type Integration Runtime in Azure Data Factory. This morning this IR suddenly got Unavailable for some reason. Fortunately we hat the Diagnostic Settings ADFSSISIntegrationRuntimeLogs enabled and I found the following…
OLE DB provider "MSDASQL" for linked server Can't connect to MySQL server, connection issue
I have setup SQL Server 2014 linked server to connect to MySQL 8 instance and when I run a single openquery insert statement like below it works fine. However, when I run multiple insert statement to insert data to multiple tables like below openquery…
Problem with open SSIS folder by SSMS on clustered node
Hi Expert, I'd being installed SSIS service on each clustered nodes, only SQL Server engine that installed as FCI Resource, but I succesfully opened SSIS folder (MSDB folder) by SSMS at only one of nodes NOT both.. if any missed setting or configuration,…
System.ArgumentException: 'Keyword not supported: 'trust server certificate'.'
When I try to add new data into the SQL table I get this error message. System.ArgumentException: 'Keyword not supported: 'trust server certificate'.' SqlConnection con = new SqlConnection("Data Source=JERRY-P720\JW_SQLEXPRESS;Initial…
OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
Hi, I am encountering an issue while trying to connect to an SQL database using a Python script in my Jupyter notebook. The connection attempt results in the following error message: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL…