433,091 questions

Sort by: Updated
Updated Created Answers
2 answers

Can a column name used as part of a CTE be used in the SELECT query that creates the CTE?

When converting a SQL script from SQL Anywhere to SQL Server, my code generated an error for the following CTE code sample; the error says that the column name used in the ROW_NUMBER function is invalid. Any suggestions on how to fix this would be…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
181 questions
asked 2025-05-09T13:15:11.4133333+00:00
Gil Robinson 0 Reputation points
answered 2025-05-09T20:39:36.6966667+00:00
Erland Sommarskog 120.4K Reputation points MVP Moderator
1 answer

Are there any scalable VMs in East US region?

Are there any D4 servers (v4, v5, v6) available at all in East US? I have tried multiple server types (SKUs) and multiple (single) Zone locations without success - adding a new Node Pool. Is there an issue provisioning AKS Nodes in East US? Or is the…

Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
2,392 questions
asked 2025-05-05T23:21:12.06+00:00
Pete Raleigh 30 Reputation points
commented 2025-05-09T20:37:51.99+00:00
Anusree Nashetty 3,345 Reputation points Microsoft External Staff Moderator
1 answer

Converting "Federated user accounts" to "Managed user accounts"

Hello I am using "Microsoft Entra ID Free Subscription." I want to convert "Federated user accounts" to "Managed user accounts." I tried to follow these instructions in Power Shell to no Avail: Install-Module MSOnline…

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
24,487 questions
asked 2025-04-16T15:47:22.9466667+00:00
Oatlhotse Gaborone 0 Reputation points
commented 2025-05-09T20:37:48.2566667+00:00
Oatlhotse Gaborone 0 Reputation points
2 answers

Do Azure virtual machines located behind a Network Virtual Appliance require a NAT Gateway or Public IP to maintain default outbound internet access ?

Hi, For Azure virtual machines behind a Network Virtual Appliance (such as Azure Firewall or a third-party firewall running on a virtual machine), will a NAT Gateway or Public IP still be required to maintain outbound internet connectivity, given the…

Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,726 questions
asked 2025-05-05T19:25:46.8466667+00:00
$@chin 150 Reputation points
commented 2025-05-09T20:36:35.32+00:00
Praveen Bandaru 3,145 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

When using the Jira Connector in Azure ADF, how can I save the table list in the dataset?

Hi ... I'm using the Jira Connector linked service in a dataset. The connection is successful, and I can see a list of available tables in the "Table" dataset field. Is there a way to extract this list of tables (to save for looping via…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,485 questions
asked 2025-05-02T20:59:47.8866667+00:00
Gue, David 50 Reputation points
accepted 2025-05-09T20:36:04.1366667+00:00
Gue, David 50 Reputation points
1 answer

How to Migrate SQL Server from One Tenant to Azure SQL VM with Minimum Downtime

we have a scenario where we have a sql server on 1 tenant that needs to be transitioned to Azure SQL Virtual Machine. Scenario: 1, Minimum down time migrate from 2016 SQL on windows 2019 to SQL 2022 on windows 2022 Integration services need to be…

SQL Server Database Engine
asked 2025-05-09T17:05:32.98+00:00
Perera, Priyantha 0 Reputation points
answered 2025-05-09T20:32:55.45+00:00
Erland Sommarskog 120.4K Reputation points MVP Moderator
1 answer

How to script views by a pattern

Hi, I'm wondering if there is a simple way to script views definitions by some pattern, e.g. views in a particular schema and named using 'ndb' in the name? Thanks in advance.

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
181 questions
asked 2025-05-09T14:14:17.4433333+00:00
Naomi Nosonovsky 8,351 Reputation points
edited the question 2025-05-09T20:30:08.58+00:00
Naomi Nosonovsky 8,351 Reputation points
0 answers

Why is my App Service for Linux container not responding on port 8000 and showing "Operation was canceled" in logs?

I'm deploying a custom Python 3.11 container with Flask and Gunicorn to Azure App Service for Linux using GitHub Actions. The app binds to 0.0.0.0:8000 and works fine locally and in another Azure App Service instance. However, in this instance: …

Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,730 questions
asked 2025-05-09T20:29:36.45+00:00
Javier 40 Reputation points
0 answers

MySQL stuck restarting - now resolved.

MySQL stuck restarting, the issue is now resolved.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
955 questions
asked 2025-05-09T18:18:50.8933333+00:00
Brad Ashton 0 Reputation points
edited the question 2025-05-09T20:28:55.18+00:00
Erland Sommarskog 120.4K Reputation points MVP Moderator
0 answers

AssigningReplicaFailed

This started happening out of the blue. Support increased the max cores to 500 but I don't think that's the issue. I've tried created new revision and new containers but the issue persists. I'm stumped. Is there something I can do do resolve this?…

Azure Container Apps
Azure Container Apps
An Azure service that provides a general-purpose, serverless container platform.
633 questions
asked 2025-05-09T19:31:06.99+00:00
DT 20 Reputation points
commented 2025-05-09T20:28:35.2466667+00:00
Praveen Kumar Gudipudi 265 Reputation points Microsoft External Staff Moderator
1 answer

Query hang on single user database

We created a new 24 vcore SQL Azure instance and are getting hangs for 81 minutes with no timeouts on an update which previous took seconds. There is only one user and no blocking session SELECT s.login_name, DB_NAME(r.database_id) AS…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
181 questions
asked 2025-05-09T20:07:38.4233333+00:00
Matt Esterly 0 Reputation points
answered 2025-05-09T20:28:07.7+00:00
Erland Sommarskog 120.4K Reputation points MVP Moderator
0 answers

I did not see the $5000 Azure credits in my Azure subscription account.

Hi! I have logged in with the same email address n.****@gmail.com on both sites and still do not see the subscription https://portal.azure.com/. I have logged a request in February 2025 and the issue was not solved (Ticket 2502190040004514). Please…

Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
728 questions
asked 2025-05-08T14:32:22.51+00:00
Nisha Appanah 0 Reputation points
edited a comment 2025-05-09T20:27:59.4833333+00:00
KarishmaTiwari-MSFT 20,762 Reputation points Microsoft Employee Moderator
1 answer

Setup Project for ClickOnce C# app targetting .net 4.8

Added the "Setup Project" to my ClickOnce .net 4.8 c# app. It does not have publish as an output that I can select. Is there a different installer project I can use to make an installer that reads the ClickOnce published files?

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.
11,450 questions
asked 2025-05-09T19:09:40.6633333+00:00
Lorne Johnson 0 Reputation points
answered 2025-05-09T20:24:54.74+00:00
Michael Taylor 58,866 Reputation points
1 answer

I cannot delete an Azure Virtual Network Gateway

I cannot delete an Azure Virtual Network Gateway. Why?

Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,726 questions
asked 2025-05-05T20:16:33.88+00:00
Rogerio Labanca 0 Reputation points
commented 2025-05-09T20:24:23.9666667+00:00
Praveen Bandaru 3,145 Reputation points Microsoft External Staff Moderator
0 answers

Getting "The resource you are looking for has been removed, had its name changed, or is temporarily unavailable." if url length is more than 4096 chars.

When I hit my app url with query params containing encrypted values (of length more than 4096) it is giving the error: "The resource you are looking for has been removed, had its name changed, or is temporarily unavailable." And in network…

Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
1,151 questions
asked 2025-05-09T17:33:11.55+00:00
Saumay Paul 0 Reputation points
commented 2025-05-09T20:21:50.8266667+00:00
Siva Nair 1,480 Reputation points Microsoft External Staff Moderator
4 answers

Does SQL 2019 support 4096 key length for TDE?

Greetings Doing a project where customer requirements for 4096 key length. So does SQL 2019 support 4096 key length for TDE. SS

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
asked 2021-10-01T06:42:34.863+00:00
Sarbjit Singh Gill 1 Reputation point
answered 2025-05-09T20:21:34.5266667+00:00
Dan Thomas 0 Reputation points
0 answers

Connection to Azure Data Studio and Heroku just failed.

Cannot connect to Azure Data Studio or Heroku anymore. I changed nothing and it just happened out of no where. I can connect to the server just fine in the Azure home page. Failed connections due to invalid authorization specification.

Azure Database for PostgreSQL
asked 2025-05-09T16:21:43.2533333+00:00
ckcDevelopment Admin 0 Reputation points
commented 2025-05-09T20:20:36.43+00:00
ckcDevelopment Admin 0 Reputation points
0 answers

Copilot sign-in issue

I getting a sign-in error whenever I try to sign in to Copilot. I'm already signed in on a browser, which is taking my system login info. This is the error: "Microsoft account requires JavaScript to sign in. This web browser either does not support…

Microsoft Copilot
Microsoft Copilot
Microsoft terminology for a universal copilot interface.
826 questions
asked 2025-04-02T16:37:43.2333333+00:00
Rajneesh kumar Ram 0 Reputation points
commented 2025-05-09T20:19:42.02+00:00
Jeffrey Tews 0 Reputation points
0 answers

Azure Local Upgraded to 23H2 - Missing all *solutionupdate* powershell commands / module.

Running Dell AX-750 clusters that were built last year on Azure Stack HCI 22H2 out of the box. Followed the MS guides to upgrade the OS to 23H2 successfully on all members of the cluster, even running Invoke-AzStackHciUpgradeValidation passes 100% of the…

Windows Server 2022
asked 2025-05-09T20:18:55.89+00:00
Chad Bellis 0 Reputation points
1 answer One of the answers was accepted by the question author.

Looks like you do not have access to the Copilot. Contact your administrator to get access to Copilot

Hi all, We are having a growing issue where our users are suddenly being blocked from accessing our enterprise CoPilot. We have E3 licensing for the entire firm. These are users who previously had copilot access but now are unable to see any Copilot…

Microsoft Copilot
Microsoft Copilot
Microsoft terminology for a universal copilot interface.
826 questions
asked 2025-05-09T13:11:12.3333333+00:00
David Mickelson 0 Reputation points
commented 2025-05-09T20:16:48.4133333+00:00
Gaude, Nathan 25 Reputation points