Query store STALE_QUERY_THRESHOLD_DAYS and SIZE_BASED_CLEANUP_MODE
If I have a query store setting STALE_QUERY_THRESHOLD_DAYS 30 days SIZE_BASED_CLEANUP_MODE 100MB suppose there are 30 days query already inside the query store and used up 50MB only , and after 10 days the size reach to 60MB , will…
SQLServer2022-x64-ENU installation error in windows 10
SQLServer2022-x64-ENU
SQLServer2022-x64-ENU installation error in windows 10
SQLServer2022-x64-ENU
how to change tabular mode to multidimensional model?
Hi there, I am trying to deploy multidimensional project to sql server and get an error. I was installed a tabular database. How to change tabular to multidimensional? Or I need to reinstall SSAS?
how to slove this problem??
what is this problem? How to slove this problem. so i can't unistall this pogram .give me solution.
Create JSON file and import as a table
Hi, This should be simple, but I tried various options and can not get it to work. I'm trying the following: SELECT TOP (100) ADMIN_AUDIT.admin_audit_id AS [id] , ADMIN_AUDIT.admin_audit_dttm AS [time] , ADMIN_AUDIT.process_txt AS…
i am getting this error
please give me some solution for SqlConnection, SqlCommand and Clear ()
Azure Backup install fails with a SQL Server installation failed.
Exit error message: The /IACKNOWLEDGEENTCALLIMITS command line parameter is missing or has not been set to true. An Enterprise Server/CAL license product key (as opposed to Enterprise Core) was entered, and this computer has greater than 20 physical…
SQL SERVER unable to install error code Decimal: -2068052377
Hey there, I am having a hard time with installing SQL server. I had it installed on my computer previously, however I couldn't get the program to do what I needed it to do. I chalked it up to installation error. I uninstalled the program and tried to…
Install Sql Server 2019/2022 in Amazon Linux 2023 server.
Hello, I was trying to install mssql in Amazon Linux 2023 server, unfortunately while installing itself getting some exception. Seems like sql 2019 has a dependency with python2 and compat-openssl10 packages. But Amazon Linus 2023 images removed python2…
SQL DB Backup issue
I am using FortiClient VPN for accessing SQL DB. When trying to back up an Azure SQL Database using SQL Server Management Studio (SSMS) the backup option is not showing. So, I have used Export Data-tier Application option in the Tasks menu. Now getting…
SQL server instance by Azure ARC
Hi, I installed azure arc on Windows server on prem. I used the script generated by AZURE ARC RESOURCES - ADD MACHINE. The purpose is to install AMA for monitoring and create DCR on my workspace Sentinel. The questione Is: On azure arc resources in…
RDS 2016 Connection broker SQL DB - Transaction log growth
Hi, Every so often (still unsure what triggers it) we start to see huge growth in the transaction log size on the SQL (Always on Availability Group) DB for the RDS Connection brokers. Has anyone come across this before? Rebooting the brokers seems to…
My SQL Server resource on Azure Portal is disabled
I wanted to login into my SQL Server using SSMS and the connection completely failed, I checked the Azure Portal and I found out on my SQL Server resource that in Overview tab is a Header orange high alert, called Disabled. I connected with success on…
SQL server doesn't implicitly cast from VARCHAR to FLOAT in some scenarios
Update: I have pasted the actual image here instead of the link. --This works fine DECLARE @sampleVar FLOAT = '123.034'; SELECT @sampleVar ; --This throws error SELECT '123.034'*-1; When I try to do the above, I notice that the implicit CAST is…
Corrupted Source Data Issue in SSIS 4.6 with Excel Source via Data Flows in VS 2019
Using SSIS 4.6 on VS 2019, with an Excel (Prof Plus 2016) Data Source, and I have a Package with 6 Data Flows that run consecutively, each one will access a different sheet from the same Excel Workbook. The Destination is a SQL Server 2022. If we use…
Embed SSRS rdl Reports to an existing ASP.NET application
I have a project scenario that requires embedding SSRS rdl Reports to an existing ASP.NET Core application. I have made some research prior to posting here and I came across a library called ReportViewer, was able to get some results but only showed one…
Embed SSRS rdl Reports to an existing ASP.NET application
I have a project scenario that requires embedding SSRS rdl Reports to an existing ASP.NET Core application. I have made some research prior to posting here and I came across a library called ReportViewer, was able to get some results but only showed one…
The study of SQL Server began from the documentation and its correct order
Hello, I wanted to learn SQL Server from the documents, but when I entered to start, I did not know when I entered a specific arrangement at the beginning that explains things to me that I did not begin with. So please tell me whether it is from the…
Is it possible to connect Azure Search Service to Local "OnPrem" SQL database
I've been trying to find information on how to connect Azure Search Service to a local SQL database, but I'm still not finding what I need. As the title says, I want to connect Azure Search directly to my local database so I can search the information in…