SSRS 2019 installation
I need to install and run SSRS 2019 from Azure VM. Database Engine is a SQL Managed Instance for ReportServer and ReportServer_Tempdb. VM and SQL MI are located in same region on same Vnet. Where do I get the product key from SQL MI to complete a…
Which dot net frame is used by SQL server 2016 SSIS packages
Which dot net frame is used by SQL server 2016 SSIS packages
IDbConnection error on process SASS database caused by Windows updates
Hello, At some point, our developer instance of Analysis Services started to give an error: Errors in the high-level relational engine. . The exception was raised by the IDbConnection interface. It does not contain any on what is wrong with it. It…
Defender for SQL Servers - DCRs, LAW and settings
Hello all, we have activated Defender for SQL Servers in a customer environments. When we have enabled Defender for SQL, it automatically created some resources (as documented by MS) specifically: DCR: MicrosoftDefenderForSQL--dcr DCRA:…
![](https://techprofile.blob.core.windows.net/images/84eXqZh4KEGayKJ9OOltlQ.png?8DBCF1)
Cannot insert duplicate key row in object with index ncix_id with non-unique index
Hello! Microsoft SQL Server 2019 (RTM-CU20) (KB5024276) on Linux (CentOS Linux 7 (Core)) <X64> We have a table with 3 indexes: FIX_ActionSerial - nonclustered, unique located on PRIMARY - ActionSerial ncix_planID - nonclustered located on…
Retrieve connection string from PowerBI reports
Hi All, I need to retrieve the connection string of the PowerBI reports. Could you help to get the query for it. As I have seen in Catalog, Datasource and Extended Datasource, but unable to get the data related to PowerBI reports dashboards, their type…
What are best security best practices to connect AKS with SQL Server?
Hi, I have an AKS cluster on Azure and one of the pod is connecting to the SQL server, the SQL server is also being consumed by a function app. I dont want my SQL server to be exposed publicly, and I know private endpoint can be used between function app…
Error while loading image - MySQL Workbench
When I am opening a local connection in MySQL, an error occurring while loading image search_sidebar.png.How can I solve this problem in MySQL? I have attached a screenshot of error showing I am using MySQL Server 5.7 and MySQL Workbench 6.3 version…
Error while loading image - MySQL Workbench
When I am opening a local connection in MySQL, an error occurring while loading image search_sidebar.png.How can I solve this problem in MySQL? I have attached a screenshot of error showing I am using MySQL Server 5.7 and MySQL Workbench 6.3 version…
Azure SQL data encryption
I want to confirm that Azure SQL connections are encrypted or that this Azure space does not allow unencrypted connections.
What would be the best asp.net option that allows a SQL database and communicates with a .NET MAUI frontend?
I am currently working on designing a cross platform application with .NET MAUI. I've decided to migrate my previous database to a SQL database. Looking at the Microsoft documentation, it showed the asp.net core web MVC project as the standard for using…
Quickest way to restore remote Azure SQL Database from the cloud to local
Working with Azure SQL Database on elastic pool I often need to pull entire database locally mainly for performance reasons on intensive tasks. Currently, whenever I need to bring a cloud database to my local (Sql Server on Docker) I do the following: …
Azure Blob Download Task error
Greetings!!! I am using the Azure Blob Download task to copy files from Azure Data Lake Storage Gen2 on to a local directory on-premise. But, when I do this I run into error. Error Message: [Azure Blob Download Task] Error: Download task has stopped with…
SSRS report are getting stuck in executing mode
Hi Team, SSRS reports in Microsoft Dynamics AX 2012 are frequently becoming stuck in execution mode. This issue occurs across all reports, not just specific ones. To resolve this, we must manually stop and restart the SSRS Reporting Service on the report…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
SSRS report are getting stuck in executing mode
Hi Team, SSRS reports in Microsoft Dynamics AX 2012 are frequently becoming stuck in execution mode. This issue occurs across all reports, not just specific ones. To resolve this, we must manually stop and restart the SSRS Reporting Service on the report…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
How to write/read comma-separated data from an SQL table and load them into a datagridview column?
I want to write comma-separated string values entered in a text box to an SQL table and later fetch them from the table and load them into a data grid view column.
How to write/read comma-separated data from an SQL table and load them into a datagridview column?
I want to write comma-separated string values entered in a text box to an SQL table and later fetch them from the table and load them into a data grid view column.
How can i generate a personal unique number for user?
Hello. i am creating a website for a courier in my local area and i want to be able to implement a feature. Once the users' registers, they will be given a personal unique id which can be used for one user only to keep track of their data from the…
What is difference between VCore of SQL Database and Vcore of General Purpose
Hi! I am doing this training: Prepare to maintain SQL databases on Azure And it says the below which really confuses me. It makes a difference between VCore of SQL Database and Vcores of General Purpose, and in the Standard Edition it does not include a…
![](https://techprofile.blob.core.windows.net/images/ctcyKX4BnU-r4fRclNq-Ww.png?8D9AB2)