How to connect my c# application to my phpmyadmin database from my NAS?
Good day, I want to try to connect to my database in my NAS. Please take a look the image below. As you can see at the image, I want to access my database outside in my home network. I already installed phpmyadmin in my NAS, but the problem is I don't…
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…
sql server, mailserver send error
어제까지 mssql 메일서버를 이용한 메일전송이 정상적으로 진행되었으나 금일 이후로 아래와 같이 에러가 발생합니다. 메일 서버 오류로 인해 받는 사람에게 메일을 보낼 수 없습니다. (계정 1(2023-02-13T16:03:37)을(를) 사용하여 메일을 보내고 있습니다. 예외 메시지: 메일 서버로 메일을 보낼 수 없습니다. (지정한 키가 사전에 없습니다.). 계정 2(2023-02-13T16:03:37)을(를) 사용하여 메일을 보내고 있습니다. 예외…
جلب الحبيب العنيد🕌𝟬𝟬𝟮𝟬.𝟭𝟬𝟮𝟳𝟬𝟯𝟵.𝟮𝟱𝟰- جلب الحبيب المتكبر net
قم بمشاركة تفاصيل كافية حول المشكلة حتى يتمكن أعضاء المجتمع من إعادة إنتاج مشكلتك أو فهمها بشكل صحيح.?
How to parse SOAP XML in SQL Server and show as table
DECLARE @xml XML ='<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Header /> soapenv:Body <ns0:GetListResponse xmlns:ns0="urn:Consultaurartmasiva1"…
What is the function difference between MS SQL Standard and Express
What is the function difference between MS SQL Standard and Express in MS SQL 2017
Removing database from AG
I have an AG. On secondary replica, if we remove database from AG, what will be the database status on primary replica
How do I copy all columns properties with copy activity in data factory
Hi, I'm copying data from one DB to another DB with copy activity and auto create table. I noticed that when the table is creating on the target side it is creating with the column size and type but all the other properties are lost, for example…
SQL error during install
Getting the following error when installing SQL express 2022: The file SQLEXPR_x64_ENU.exe version 16.0.1000.6 must be in the same directory as this installer. Place the file in this directory and try again.
Is it correct to make connection string dynamic?
Hi, I'm currently working on a project which need data from other databases. The database where I'll get the datas are depends on users. Now I want to make my connectionString dynamic. Is it correct to make connection strnig dynamic. The user will enter…
How to fix this error in Microsoft SQL: SQL job is failing. OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query timeout expired...
Hello, Kindly advise how to solve below issue: we have one job that's failing is Microsoft SQL. This issue is affecting the Power BI reports as well. Below error is found: SQL job is failing. OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query…
Why isn't code working as an expression for parameters in SQL Server Reporting with connection to Databricks SQL Warehouse using Simba Spark
Error: For more information about this error navigate to the report server on the local server machine, or enable remote errors ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)…
Unable to connect to private linked SQL server from azure web apps
I have a group of linux web apps with VNet Integration enabled on a subnet called web-tier and an azure server with private link configured on another subnet called data-tier. I have also added nsg rules to the data-tier subnet nsg to allow inbound…
Can a deadlock issue be raise while running two select queries in sql server
Do we get a deadlock issue while running two select statements of two different table in sql server
sql data store is causing errors on sql server 2022
We have recently upgraded our servers to SQL Server 2022, and are currently hosting three Microsoft SQL servers running version 16.0.4015.1. We have enabled the query store on all of our databases, with between 5 to 9 databases hosted per server. Since…
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…
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
Dataset format needed for azure blob storage
How do I select what format is right for me while moving documents from SQL Server to Azure blob storage using Azure Data Factory pipeline? The existing documents in the Blob storage show the type as Block Blob, but it doesn't show the format. I need to…
SSMS not flagging basic errors after IIF statement
DMF_SSMS_SQL_IIF_Err.pdf I just wanted to notify Microsoft of an error I believe I found with SSMS error notification. Going thru some scripts, I came across one that had a CASE and IIF in it. I accidently did a typo, no errors, but failed. I then…
SSRS Report Subscription Windows Share File Option Failed
We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…