Svchost Issue - user profile service - Server 2022 high memory usage
Recently I have install 3 windows server 2022 with mssql 2019. Every two days the system stuck, and I find user profile service consume all the free memory. it's not happens on servers without sql. Btw: I'm not sure if it have something to do but we are…
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
How to solve the error 2068052377?
error while installing ms sql 2022 express edition basic installation Oops... Unable to install SQL Server (setup.exe). Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed…
how to export stored procedure data with headers into a xls file in sql server?
Hi every MS Sql server user . I have a stored procedure in my server that make a lot of join and in the result shows them. Now I want to make a job in the server and this job should run this SP and copy the results into a xls file.I have seen a lot of…
Bug on dbo.SP_DeleteOldJobs (HPC pack 2019U1)
problem: Project filter on Job Manager or Cluster Manager doesn't clean up. So, after digging into a bit, I found out the delete query is a bit wrong written as null entries are inside ProjectId column on Job and JobHistory table. So, delete query on…
Pivot query result (column name will change)
Hi there, Have been working on a huge database task and one part of it is the below. How do i pivot this 1 row with dynamic columns (column names will change) Query: select top 1 * from INFORMATION_SCHEMA.columns Output should be ColumnName |…
SQLServerException: An item with the same key has already been added.
Running the query: SELECT name FROM [" + catalog + "].sys.schemas ORDER BY name I got exception: 10:05:26 [com.microsoft].sqlserver.jdbc.SQLServerException: An item with the same key has already been added. RequestId:…
How to add 100 plus source link in ADF pipeline to transfer data to single destintion.
I need to transfer data from multiple source sql servers( almost 100 plus) to a single destination using ADF, Is there is any way to add these much servers to ADF as source
Cannot connect to SQL Database. Please contact SQL server team for further support.
Hello support from time to time i get an error that username/password is invalid for database. However database is up and running and in use. below are the infromation activityid 701ef079-7056-4d6b-b941-c2e2f011e57a
Comparison of actual database schemas against each other (within one database)
Hi all, for a small project I created a database within Azure and one schema for dev and one for prod (to save run cost). I would like to compare these two schemas now with Azure Data Studio, but it looks like, that I can only compare databases with one…
How to pass in clause values via SSIS paramter
Hi, I have created SSIS package based on the query( big query),In query in clause is there. I have created parameter in ssis level and trying to pass multiple values(a,b) to in clause ,It is not working how i can achieve. Can you please suggest…
How to fix "error:1C80006B:Provider routines::wrong final block length" in SQL Server ODBC client (Linux)
I'm trying to write C++ ODBC driver code to execute SQL statements from a Linux server. I keep running into errors such as: DIAG [08S01] [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1C80006B:Provider routines::wrong final block…
How to extract lineage from on-prem sql server ?
I want to scan store procedure from on-prem sql server as well as extract the lineage, Is there any way to achieve it either using Mircosoft Purview or using Apache Atlas API? I'm not using any ADF pipeline to transform the data, data is moving and…
Azure SQL database restore to Synapse
we need to do restore sql server database from restore point to dedicated sql pool on synapse on same resource group we are trying to do restore azure sql server db on same restore group where we have synapse but it ends up with error ERROR1.JPG Command…
Does SSIS and SSDT require additional licenses for SQL Server 2019 Developer Edition?
Does SSIS and SSDT require additional licenses for SQL Server 2019 Developer Edition? Here is my SQL Server details SQL Server Management Studio 20.2.30.0 SQL Server Management Objects…
How to get a date of day in current week
Hi, I have table that stores configurations like In my sql code, I need to take currentDateTime and get current week date for Execution Day which is Wednesday. So, for this week, it will be 10-02-2024. Get following week wednesday date. Here it…
How to get a date of day in current week
Hi, I have table that stores configurations like In my sql code, I need to take currentDateTime and get current week date for Execution Day which is Wednesday. So, for this week, it will be 10-02-2024. Get following week wednesday date. Here it…
Error while running .dtsx package in development server
Hi Team, I have six .dtsx packages. The packages read flat files and insert the data from the flat files into the database tables. I reset the password of the DB account(account name , say VISH) in the DB server. After resetting, I cloned the MyAppETL…
Api-Web app (webjobs) connection to On-Premise SQL Connection
Hi , I am having trouble establishing connection from azure webapp to on-premise sql server. we have virtual network gateway and site-site vpn to sql server. allowed port 1433 in on-premise firewall and in azure firewall as well. webapp have private…
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…