Azure SQL Database
An Azure relational database service.
5,624 questions
0 answers
Convert Julian dates in Normal date
How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates
asked 2024-09-19T18:36:21.3566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
770
Reputation points
commented 2024-09-19T21:27:08.1166667+00:00
Erland Sommarskog
110.4K
Reputation points MVP
0 answers
Convert Julian dates in Normal date
How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates
asked 2024-09-19T18:36:21.3566667+00:00
Vineet S
770
Reputation points
commented 2024-09-19T21:27:08.1166667+00:00
Erland Sommarskog
110.4K
Reputation points MVP
0 answers
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…
asked 2024-09-18T20:12:32.37+00:00
Yogendra Dwivedi
20
Reputation points
edited the question 2024-09-19T21:22:26.9833333+00:00
Erland Sommarskog
110.4K
Reputation points MVP
1 answer
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…
asked 2023-11-29T18:31:31.6633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 27%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Deepak Kumar
5
Reputation points
commented 2024-09-19T21:10:02.2266667+00:00
Erland Sommarskog
110.4K
Reputation points MVP
3 answers
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
asked 2024-09-05T05:55:42.31+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 75%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Radhai Krish
191
Reputation points
commented 2024-09-19T21:06:59.7133333+00:00
Erland Sommarskog
110.4K
Reputation points MVP
2 answers
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…
asked 2022-11-30T14:46:06.567+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 97%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Curt Boone
1
Reputation point
commented 2024-09-19T20:20:00.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 21%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Schickedanz, Andrew
0
Reputation points
0 answers
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…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,567 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
528 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,858 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 72%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
1 answer
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…
asked 2024-09-19T13:19:37.65+00:00
M ZUNAIR TARIQ
20
Reputation points
answered 2024-09-19T18:04:11.1766667+00:00
Olaf Helper
44,311
Reputation points
3 answers
One of the answers was accepted by the question author.
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…
asked 2024-09-13T13:56:24.9266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 55.00000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFV%3C/text%3E%3C/svg%3E)
Filip Veselý
0
Reputation points
accepted 2024-09-19T17:24:09.98+00:00
Filip Veselý
0
Reputation points
1 answer
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. …
asked 2024-09-16T19:03:20.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Devanshi Patel
0
Reputation points Microsoft Employee
commented 2024-09-19T16:33:08.28+00:00
Devanshi Patel
0
Reputation points Microsoft Employee
1 answer
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 {…
asked 2024-08-31T12:35:35.5666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 45%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shreyan Shukla
0
Reputation points
commented 2024-09-19T15:56:26.81+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
150
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
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…
asked 2024-09-18T14:52:20.88+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 74%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Leonardo Bruno Pereira de Araujo
20
Reputation points
commented 2024-09-19T11:29:24.41+00:00
Leonardo Bruno Pereira de Araujo
20
Reputation points
0 answers
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…
asked 2024-09-19T10:53:17.7133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 76%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
greg lipman
61
Reputation points
asked 2024-09-19T10:53:17.7133333+00:00
greg lipman
61
Reputation points
2 answers
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?
asked 2024-09-18T13:04:27.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 71%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
mm
0
Reputation points
answered 2024-09-19T09:46:45.8766667+00:00
MikeyQiaoMSFT-0444
2,790
Reputation points
0 answers
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…
asked 2024-09-17T01:27:08.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 40%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESI%3C/text%3E%3C/svg%3E)
Sean I
0
Reputation points
commented 2024-09-19T09:31:50.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
15,131
Reputation points
1 answer
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…
asked 2024-09-17T05:53:47.2933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 40%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
binrip
0
Reputation points
edited a comment 2024-09-19T09:19:37.8433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
5
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
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…
asked 2024-09-18T06:26:14.5033333+00:00
Tharun Reddy K
20
Reputation points
accepted 2024-09-19T07:20:30.2466667+00:00
Tharun Reddy K
20
Reputation points
1 answer
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…
asked 2024-09-17T14:13:58.2966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 69%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Pein David
0
Reputation points
commented 2024-09-19T07:12:46.22+00:00
Pein David
0
Reputation points
1 answer
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…
asked 2024-09-19T04:19:40.1633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 26%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
zequion
401
Reputation points
edited an answer 2024-09-19T06:55:48.8466667+00:00
LiHongMSFT-4306
26,791
Reputation points
2 answers
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…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,059 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,690 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
112 questions
asked 2024-09-18T06:08:31.24+00:00
Radhai Krish
191
Reputation points
edited a comment 2024-09-19T05:53:49.63+00:00
LucyChenMSFT-4874
4,430
Reputation points