Microsoft Q&A

SQL Server

17,468 questions

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

17,468 questions with SQL Server-related tags

Sort by: Updated
4 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,199 questions
asked 2023-09-03T09:08:25.2+00:00
Michael 0 Reputation points
edited an answer 2023-09-03T15:56:29.3+00:00
Yitzhak Khabinsky 23,046 Reputation points
3 answers One of the answers was accepted by the question author.

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?

Windows Presentation Foundation
Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,450 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
8,805 questions
asked 2023-08-29T09:25:13.19+00:00
Mesh Ka 120 Reputation points
commented 2023-09-03T10:04:54.8433333+00:00
Erland Sommarskog 85,581 Reputation points
4 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,850 questions
asked 2023-08-08T12:47:12.5866667+00:00
Anmol Ganju 136 Reputation points
commented 2023-09-03T09:56:40.05+00:00
Erland Sommarskog 85,581 Reputation points
1 answer

"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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-09-02T20:43:53.7733333+00:00
Jimmy M 0 Reputation points
commented 2023-09-03T09:49:22.98+00:00
Erland Sommarskog 85,581 Reputation points
2 answers One of the answers was accepted by the question author.

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…

Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
531 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-09-02T12:39:19.0633333+00:00
Kamil 0 Reputation points
accepted 2023-09-03T08:53:38.42+00:00
Kamil 0 Reputation points
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
Azure Database for PostgreSQL
asked 2023-09-03T06:40:19.1733333+00:00
Ehtsham Cheema 0 Reputation points
edited the question 2023-09-03T06:41:36.84+00:00
Ehtsham Cheema 0 Reputation points
0 answers

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-09-03T06:12:37.0733333+00:00
NN 0 Reputation points
2 answers One of the answers was accepted by the question author.

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,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-09-02T17:57:10.7533333+00:00
Sunraj sharma 0 Reputation points
commented 2023-09-02T22:41:36.8066667+00:00
Sunraj sharma 0 Reputation points
3 answers

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,

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,153 questions
asked 2021-06-01T08:15:20.747+00:00
ovonemty 41 Reputation points
commented 2023-09-02T22:15:30.9233333+00:00
Sonia Fonseca 0 Reputation points
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-09-02T19:30:31.47+00:00
Pol 86 Reputation points
answered 2023-09-02T19:51:55.9066667+00:00
Erland Sommarskog 85,581 Reputation points
0 answers

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…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
3,661 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
5,703 questions
asked 2023-09-02T17:58:13.3533333+00:00
Marcel Duboué 20 Reputation points
commented 2023-09-02T18:39:41.18+00:00
Erland Sommarskog 85,581 Reputation points
5 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
5,703 questions
asked 2023-08-25T14:28:32.6866667+00:00
Marcel Duboué 20 Reputation points
commented 2023-09-02T17:35:21.95+00:00
Erland Sommarskog 85,581 Reputation points
0 answers

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…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,502 questions
asked 2023-09-02T16:34:47.63+00:00
db042190 41 Reputation points
edited the question 2023-09-02T17:00:43.61+00:00
db042190 41 Reputation points
2 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-09-02T13:26:23.79+00:00
sachin kanadia 0 Reputation points
commented 2023-09-02T15:05:14.1566667+00:00
sachin kanadia 0 Reputation points
0 answers

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…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,464 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-08-23T14:41:12.7+00:00
Debasish Lala 0 Reputation points
commented 2023-09-02T13:05:45.8733333+00:00
Vinodh247 4,646 Reputation points
2 answers

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 Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-08-25T13:37:05.9533333+00:00
Yogesh Bhadauriya 1 Reputation point
commented 2023-09-02T10:35:01.79+00:00
Erland Sommarskog 85,581 Reputation points
2 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-08-29T12:56:58.63+00:00
rr-4098 826 Reputation points
commented 2023-09-02T08:57:07.96+00:00
Erland Sommarskog 85,581 Reputation points
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-08-31T05:14:12.6566667+00:00
Kelly 0 Reputation points
commented 2023-09-02T08:54:29.16+00:00
Erland Sommarskog 85,581 Reputation points
0 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,199 questions
asked 2023-09-02T08:51:25.5933333+00:00
Rohit Kulkarni 676 Reputation points
0 answers

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…

Microsoft Identity Manager
Microsoft Identity Manager
A family of Microsoft products that manage a user's digital identity using identity synchronization, certificate management, and user provisioning.
472 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,464 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,710 questions
asked 2023-08-17T07:13:47.46+00:00
Mritunjay Daiya 0 Reputation points
commented 2023-09-02T07:57:27.4933333+00:00
Mritunjay Daiya 0 Reputation points