Running specific pipelines from an Orchestration pipeline
How can I run individual pipelines from an Orchestration pipeline that has multiple pipelines running in parallel? I want to be able to choose which pipeline to run separately from the rest.
Jobs are running slow in sqlserver that was upgraded from 2012 to 2019
Set the max memory to 34076MB for 4 core and 38GB RAM. what other sql adjustment can be made so that the jobs run fast. 94% of memory is used.
Synapse Integration Runtime high availability
I have a question with the Self-Hosted Integration Runtime configuration in a high availability scenario. As per this documentation…
How to connect to Fabric Datawarehouse or Fabric DataLake using C#
We've a Data ware house present inside our Azure Fabric environment. We want to do crud operation on top of this. How can we connect to Fabric Data warehouse or Fabric DataLake using C#.
how troubleshoot SqlDumpExceptionHandler: Process 113 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process
We use Cumulative Update 21 for SQL Server 2019, Always on with 1 Primary plus 2 secondary replicas. Recently we noticed our SQL Server had some dumps, like below. Can anyone pls help advise how troubleshoot it? Thanks SqlDumpExceptionHandler: Process…
SQL Licensing for SQL Always ON Availability group
Hello Guys, I need to understand how many licenses i need to buy for SQL always on availability group, below is my requirement. As per my understanding only active cores should be licensed SQL always on cluster Primary site: Server 1 : Active copy …
Can Azure AD Connect and Azure Cloud Sync exist and function in parallel
We already have the Azure environment setup for Windows Windows Hybrid Joined Devices and it's functioning as expected. We now wish to sync Azure AD Cloud Security groups to on-premise AD. During my research, I discovered that Cloud Sync is the…
Do ODBC Linked Servers (MariaDB) support XA Transactions?
My setup involves 3 servers, 2 MariaDB servers -- one under my control, the other not -- and an MSSQL server. I have the two MariaDB servers linked via the Spider Engine and I have my internal MariaDB server set up as a linked server in Sql Server with…
Error description: The system cannot find the path specified while installing SQL server management studio
I am facing an error while installing Microsoft SQL Server 2022, In the log file the error says : Component name: SQL Server Database Engine Services Instance Features Component error code: 0x80004005 Error description: …
How to sql dump generation on sql server 2008 ?
Good morning, I use SQL SERVER 2008 R2 and for a few days now I have had disk C filling up due to the generation of SQLDUMP files in the log directory. Can you give me the procedure to disable the generation of these files please. Thanks in advance.
How to restore SQL server 2019 database backup (.bak) to SQL server 2017.
Hi, In one of our legacy project we are using SQL Server 2017 database, and in this we need to restore backup (.bak) taken from SQL Server 2019 database. While database restore (taken from 2019) in SQL server 2017 we are getting incompatibility error. …
"Remove Unused References" unavailable for UWP projects
I have enabled "Remove Unused References" but the context menu of a UWP app project does not have the option: Could anyone shed some light on this?
Custom skill integration Azure AI Search
0 I have a requirement to crawl an Azure SQL server from Azure AI search. The SQL server exists in different VNET and I have created a Shared Private Link to connect. The Indexer works fine without any problem. As soon as I add a custom webapi skill the…
How to fix build errors that I am getting currently when I convert my .NET MAUI [ sdk 6 version] to .NET 8 version?
I am currently in a process of converting my MAUI project which is in .NET 6 version to .NET 8 version. I have used Microsoft's .NET upgrade assistant extension tool for the same. After successful upgrade, when I try to build/rebuild my project, I am…
How can I sync data from a source database table without primary key to the destination database table with primary key
Hi all, If the source MS SQL SERVER 2017 database table does not have primary key but destination MS SQL SERVER 2019 database table has primary key, what is the best way or method to make both tables data in sync? Please take into consideration that…
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
Is there a tier for a Flat Monthly Fee for an Azure VPN?
Since it seems we will have to constantly create a VPN, then delete it, then recreate it again when needed since there is no way to just disable when not needed. Is there a tier for a flat fee for an Azure VPN??
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
Troubleshooting SQL Server Replication Error During Version Upgrade
How can we resolve a Replication error that occurs when trying to include certain tables in a Publication after migrating from SQL Server 2012 to SQL Server 2019? Removing the affected articles is a temporary solution, but the issue persists for 10…
Bidirectional replication between on prem SQL server and Azure sql with no primary key exist
Can you suggest possible solution for bidirectional real time sync between on prem SQL (2016) and Azure SQL with no primary key exist