Content
SSMS 16.0.1050.5 unable to connect to Integration Services 1.1
I installed SSMS 16.0.1050.5 (X64) version and SSIS version 1.1. When I try to connect to the Integration services through SSMS I get the following error: Connecting to the Integration Services service on the computer "Computer Name" failed…
Which is the Best Fit RDBMS for my Case
i have a database currently with 220 Tables, complex relationship and a lot of triggers and stored procedures. I am building this database only to be use by a single person offline, What is the best RDBMS fit for me? SQLServer or SQLite?
How to ignore the escape character in oracle query?
I am facing one issue where I want to copy data from an oracle select query to Azure Data Lake, my select query contains some column details from an oracle view, for example below is my oracle select query (below is formed inside of a for each…
"Could not find the Database Engine startup handle" while trying to install SQL server 2022 Express Edition
Hi, Since yesterday, I was trying to install SQL Server 2022 Express edition on my Windows 10 laptop but it is getting failed due to the mentioned error. I tried to uninstall/reinstall, trying the ''troubleshoot errors related to system disk sector size…
Asking about payments - sql server high payments, i didint used it much. StudentSubscription
Hello, I am a student in Poland, studying at an IT university. We have access to Azure for Students, and I've started working on a mobile app with an API service in C# and a SQL Server database. I wanted to use Azure to host my API along with the SQL…
Best online course for SQL
Hello everyone, I just completed advanced Microsoft Excel and planning to start learning SQL. I am fortunte enough to learn Excel from a great mentor , Kyle Pew . Now, i am searching for a mentor who is best for SQL course. I agree to the fact that a…
Better than ssis there is a different (faster time)approach we can move active data from different databases source server to target server with schedule job.in sql servers.
Better than ssis there is a different (faster time)approach we can move active data from different databases source server to target server with schedule job.in sql servers.
Spatial SQL (in SSMS - using T-SQL) - STIntersect and STContains doesn't return the correct result
Trying to find All the routes that pass through a buffer of 5km around a random point. Background: I have multiple routes stored as linestring of type geography using the following query. The linestring is valid. INSERT INTO routes (route_id,…
What is user starting S-1-5-21-1687699058... ?
In the Role Manager section: I see a user added that has name S- 1 -5-21 -1687699058-... What is this user? can I safely delete it? (is there any documentation regarding this?) THanks,
Linked server error
Hi, I created the Linked server in ServerA using the command : EXEC sp_addlinkedserver @server=N'TestLink', @srvproduct=N'', @provider=N'MSOLEDBSQL', @datasrc=N'ServerB; I am able to get the output using through linked server query - select * from…
After changing for Windows 11, my application cannot create a user instance SQL Server due to a failure to start the process for the instance user
Hello, I already post my question at the tag SQL Server; after 2 weeks of work, they thing that the problem is due to the fact that my old application Visual Studio uses User Instances, which, for them is an old feature. The message delivered is And…
0x80004005 error when connecting to SQL Server 2019
Hello I have installed Windows 11 a month ago; everything works fine except for an application that I developed using Visual Studio and SQL Server Express. I uninstalled everything that concerns SQL, deleted the directories and registry keys. I…
can dax be used as an ssrs dataset query
hi, years ago mdx was automatically generated by ssrs even on tabular model cubes. In fact i think folks would get ssrs to generate mdx over multi dimensional cubes even if they had no intention of ultimately using the query from ssrs. I vaguely…
Do I need to update my SQL Server API's to a newer version?
Hello All, I received an email from MS Azure stipulating that I need to update my Azure SQL Server API's to a newer version. Here is what was stated in the email: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 You're receiving…
CREATE DATABASE SCOPED CREDENTIAL on APS database fails
I have been trying to follow the instructions on this APS to Azure Synapse Migration - 5.DeployScriptsToSynapse video https://www.youtube.com/watch?v=oorsuHHs7Ls&list=PLTPqkIPx9Hx8-dxWWv9Wyup2RQMMa6lHx&index=9 but when trying to create a database…
SQL - Select Statement taking time to execute - No Blocking/No High Utilization
I am having Dynamic CRM product, where one select statement is always taking time to execute from the application. select new_OrderNo, new_LineNumber, new_ProductNumber from [CRM Sales History Table] where CreatedOn >= DATEADD(Day, -30,…
SQL 2014 Maintenance Plan Rebuild Indexes
I have one DB on my server that is failing on a full backup, but succeeds with a Diff backup. When I dug into the error further, it pointed towards index fragmentation. When I checked the DB, all indexes were at 99% fragmentation. I would like to setup a…
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2147467259
Hi, I'm receiving error "Unable to install SQL Server (setup.exe). Exit code (Decimal): -2147467259" when attempting install of SQL Server 2022 Express. Is my firewall the issue? Hoping someone could help me ID the issue. Thanks in…
Re-Register Microsoft Runtime Configuration Manager
Hello Team, Previously it was Register Microsoft Runtime Configuration Manager was configured.Now we need to re-reister the different Azure Integration run time.But i am facing the below screenshot How it can be re-register the new integration run…
Access SQL Database in Synapse Notebook and getting MSI Token failure
Hello Everyone, I have a piece of code and I don't know what are the required steps to run the code given below. Every time I run this code it give me error as "MSI Token failure: Failed to acquire access token from IMDS". The thing I want to…