Azure SQL Database
An Azure relational database service.
5,672 questions
4 answers
One of the answers was accepted by the question author.
Sql backup into Azure Blob fails: 1117(The request could not be performed because of an I/0 device error.)
I am trying to run a backup from our sql server to a blob azure container. I went ahead and did the setup exactly as suggested by…
asked 2024-02-21T09:29:58.56+00:00
Andreas Niedermann
20
Reputation points
answered 2024-10-04T11:53:17.8133333+00:00
Joby Mathew
5
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL query left Join
I have sample data like this DECLARE @TBL TABLE(col1 VARCHAR(100),col2 varchar(100)) INSERT INTO @TBL VALUES ('server-1','11111') INSERT INTO @TBL VALUES ('server-2','22222') INSERT INTO @TBL VALUES ('server-3','33333') INSERT INTO @TBL VALUES…
asked 2024-10-04T01:08:24.86+00:00
Handian Sudianto
4,976
Reputation points
accepted 2024-10-04T06:43:46.64+00:00
Handian Sudianto
4,976
Reputation points
5 answers
One of the answers was accepted by the question author.
Exit code (Decimal): -2068052377Error Invalid command line argument. Consult Windows Installer SDK..please help me fixing this
Log folder path C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220218_192800
asked 2022-02-18T14:25:57.053+00:00
Raman R
51
Reputation points
commented 2024-10-04T00:03:48.6166667+00:00
Farhan Sarang
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Suggest a way to replicate data from on premise sql server 2019 to azure synaspe analytics directly
Im using an sql server in my on premise with version 2019, I need to transfer or replicate real time data to azure synapse database, so which azure service will be more effective and flexible for large data transfer
asked 2024-09-26T14:30:15.38+00:00
AGP
40
Reputation points
commented 2024-10-03T21:15:47.0133333+00:00
Erland Sommarskog
111.1K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
How to add 100 plus source link in ADF pipeline to transfer data to single destintion.
I need to transfer data from multiple source sql servers( almost 100 plus) to a single destination using ADF, Is there is any way to add these much servers to ADF as source
2 answers
One of the answers was accepted by the question author.
Comparison of actual database schemas against each other (within one database)
Hi all, for a small project I created a database within Azure and one schema for dev and one for prod (to save run cost). I would like to compare these two schemas now with Azure Data Studio, but it looks like, that I can only compare databases with one…
asked 2024-08-17T10:10:18.3266667+00:00
Maximilian Ksoll
20
Reputation points
commented 2024-10-03T18:06:47.1133333+00:00
Oury Ba-MSFT
19,101
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Allocated vs. Used Memory in SQL Server Elastic Pool
Hello! I’m seeking help regarding the reduction of allocated space in databases within an SQL Server elastic pool. The allocated space in the elastic pool I'm using is significantly larger than the actual used space (due to recent deletions of deprecated…
asked 2024-10-01T00:41:03.21+00:00
Sinara Medeiros
20
Reputation points
accepted 2024-10-02T19:54:25.6133333+00:00
Sinara Medeiros
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Which recommended included columns to really include in indexes?
Greetings. I just ran sql logScout and sql nexus against a heavily used reporting server during a peak time of day for 10 minutes just to see what it comes back with. About 20 indexes were recommended for the same table. Over the years Ive come to use…
1 answer
One of the answers was accepted by the question author.
What ports are required for running SSIS?
What ports are required for running SSIS services? Is port 1856 needed? If so, why?
asked 2024-10-02T13:36:33.2866667+00:00
Effie Lewis
20
Reputation points
accepted 2024-10-02T14:27:26.09+00:00
Effie Lewis
20
Reputation points
1 answer
One of the answers was accepted by the question author.
What ports are required for running SSIS?
What ports are required for running SSIS services? Is port 1856 needed? If so, why?
asked 2024-10-02T13:36:33.2866667+00:00
Effie Lewis
20
Reputation points
accepted 2024-10-02T14:27:26.09+00:00
Effie Lewis
20
Reputation points
1 answer
One of the answers was accepted by the question author.
OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
Hi, I am encountering an issue while trying to connect to an SQL database using a Python script in my Jupyter notebook. The connection attempt results in the following error message: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL…
1 answer
One of the answers was accepted by the question author.
Max value of each column in a table
Hi there, I have 500+ Azure SQL tables with total of 25000+ columns. Most of the tables have varchar (max), or nvarchar(max) but to contain a value which could only be 3 , 5 or 20 characters long. --for characters select max(**len(**columnname)) from…
1 answer
One of the answers was accepted by the question author.
System.ArgumentException: 'Keyword not supported: 'trust server certificate'.'
When I try to add new data into the SQL table I get this error message. System.ArgumentException: 'Keyword not supported: 'trust server certificate'.' SqlConnection con = new SqlConnection("Data Source=JERRY-P720\JW_SQLEXPRESS;Initial…
2 answers
One of the answers was accepted by the question author.
Is my Resource Governor set up correctly?
Greetings. I have a particular server configured as follows: DB1 -- this guy is the Subscriber of a transaction replication topology. DB2 -- this guy is a Data Warehouse (using that term loosely). If queries data from DB1, as well as other sources…
1 answer
One of the answers was accepted by the question author.
better query for select results based on date.
What is the best way to write this code to get the date results? I have the time throughout the day in the datetime field. SELECT * FROM Reconciliation.Documents D Inner Join Reconciliation.DocumentsTransaction T ON D.DocumentPKey = T.DocumentPKey WHERE…
asked 2024-09-30T19:03:37.35+00:00
Jonathan Brotto
420
Reputation points
accepted 2024-10-01T14:47:10.7333333+00:00
Jonathan Brotto
420
Reputation points
1 answer
One of the answers was accepted by the question author.
better query for select results based on date.
What is the best way to write this code to get the date results? I have the time throughout the day in the datetime field. SELECT * FROM Reconciliation.Documents D Inner Join Reconciliation.DocumentsTransaction T ON D.DocumentPKey = T.DocumentPKey WHERE…
asked 2024-09-30T19:03:37.35+00:00
Jonathan Brotto
420
Reputation points
accepted 2024-10-01T14:47:10.7333333+00:00
Jonathan Brotto
420
Reputation points
2 answers
One of the answers was accepted by the question author.
rdlc files donot compile or validate in VS 2022
I am trying to upgrade and compile a project in VS 2022 with some rdlc files, it does not show any errors when we try to build or rebuild. It was working on VS2013 before. It showed any compile errors in the files and does not complete the build until…
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,918 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.
10,913 questions
1 answer
One of the answers was accepted by the question author.
asked 2024-09-28T11:08:59.5566667+00:00
Ngô Thành Quang
20
Reputation points
commented 2024-10-01T05:52:08.5+00:00
Ngô Thành Quang
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Problem with open SSIS folder by SSMS on clustered node
Hi Expert, I'd being installed SSIS service on each clustered nodes, only SQL Server engine that installed as FCI Resource, but I succesfully opened SSIS folder (MSDB folder) by SSMS at only one of nodes NOT both.. if any missed setting or configuration,…
2 answers
One of the answers was accepted by the question author.
Using IDENTITY_INSERT with FK_ChildTable_ParentTable?
Hello, Wrapping SaveChanges with ON and OFF works fine with individual tables. But not in case of a parent-child relationship where a foreign key exists. Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert explicit value for identity column…
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
741 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,553 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.
13,785 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.
10,913 questions