Queries are limited to 4000 characters.
I am working on a semantic search engine and I need to be able to search for synonyms and inflections of the words in the phrase that the user enters. I have encountered the problem that the parameter “contains_search_condition” of the Contains or…
Convert Julian dates in Normal date
How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates
Convert Julian dates in Normal date
How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates
Has anyone resolved the "Database Engine recovery handle failed" and "firewall warrnig" error during SQL Server installation on Windows 11?
I am encountering critical issues with installing both SQL Server 2017 or SQL Server 2022 on my Windows 11 Home (x64) machine. Below is a summary of the problems and the steps I have taken to resolve them: Issue Summary: Warning: Firewall warning…
How to fix sql server agent job failure while extracting data from a excel file and storing in a sql db using a ssis .dtsx package?
I am getting following error when running ssis .dtsx package from sql server agent job. This package is extracting data from a excel file and storing in a sql DB. please find following error: The step did not generate any output. The return value was…
Autogrowth option for Log File (Image files)
Data Migration Assistant (DMA) suggested below recommendation, But the DB Properties don't have option for Autogrowth to ImageFiles How to make it autogrow? The DB is currently in CL100, soon to be upgraded to CL160
SSRS fails sending O365 email [Authentication failed because the remote party has closed the transport stream]
Our report server stopped emailing reports due to authentication errors with the Office365 email account we are using. I'm able to send StartTLS email from powershell with the O365 account. And I am able to use a non-MS account to send mail in the report…
Number of query values and destination fields are not the same
Hello friends, I received text (.txt) files from our external vendor every morning. My objective is to convert this text files to excel (.xlsx) per our customer's request. I am using SSIS Package, and I am using Script Task to do my conversion from text…
In SSRS, I need to display only one record on each page
In SSRS, I need to display only one record on each page, with the next record appearing on the second page, and so on. Currently, I have two tables, two text boxes, and one matrix per page. I've tried rows grouping, but it's affected the first table…
How to Update-Database in PM console when getting "Could not load assembly..." error?
Hello, I cannot apply migrations to database by Package Manager Console command Update-Database. On every attempt I get error: Could not load assembly "My_Project". Ensure it is referenced by the startup project 'My_Project'. Before mentioned…
Failover for secondary read-only endpoint in SQL failover group
Usecase My team has a SQL failover group set up where we use primary region for read-write workloads. We use secondary region to serve read only workloads. I am exploring options for ensuring data availability when secondary server/region is down. …
How do i connect Azure SQL database to my Next TS codebase?
So I have been making a form in Next TS, that when filled by the user will directly save the data into my azure sql database. Im using prisma ORM along with it to connect it better: //this is my API route to connect my code to my database import {…
SQL Server Integration Services and Azure Data Lake Store Connection Manager
Is it possible a SQL Server Integration Services (SSIS) package can use the Azure Data Lake Store Connection Manager to connect to an Azure Data Lake Storage Gen2 ?? From what I read the article below refers only for Gen 1 but and about the Gen 2? Link…
how to get max min date from a tuple
suppose i have a bunch of people (with dimension) they have a bunch of claims (dimension) and in each claim there is a bunch of records with amount and date! those records/transactions form a cube with measures like amounts paid Ultimately i need to get…
Prevent access from excel
I am looking to prevent access from Excel to my SSAS... I have 10 cubes, and several PowerBI that consume from it... But I have some users that connect from excel and I want to prohibit that access. How can I prevent people accessing from excel?
Azue Arc SqlAgent Extension Status Failed or stuck as Creating
Many of the Azure Arc Enabled SQL Servers were no longer reporting SQL BPA as being enabled. After some investigation I found that all the servers with issues had the SqlAgent Extension with a Status of failed. I would like to know how that could have…
Linkedserver connection to MySQL database with ODBC driver failed
Hi I am attempting to use a SQL Server 2014 linked server to connect to a MySQL 8 instance. My single openquery insert statement works fine, but when I try to run multiple insert statements to insert data to multiple tables, I receive a generic error…
Persistent SQL Server Service Termination with Port Configuration Errors Despite Firewall and TCP/IP Adjustments and basic troubleshooting
Hello, I am using an enterprise application on one of my servers (Server 2019) and recently migrated its database to MSSQL 2022 on another server. Initially, it was slow, but now SQL Server is repeatedly stopping right after starting. Here’s what I’ve…
unable to save SQL-Query in SQL Server Management Studio 18 on company's sharepoint
Use case: I uploaded a .sql file on the company's SharePoint in order to share it with my colleagues / collaborate on the query with them. when opening it in SQL Server Management Studio 18 i can edit it, but cannot re-safe it, as it is "locked by…
Errors during build of SQL Server 2022 Projects with VS2019 Professional & AzureDataStudio
Stuck with this issue for longer time. I am trying to create SQL Server Projects for a DB being in SQLServer2022 using VS2019 Professional. DB is old running/being in use since 2009. How much ever I try I face the following warnings & errors, but…