349,970 questions

Sort by: Updated
Updated Created Answers
1 answer

How to connect from Azure to a kafka in a Confluent cloud

I have one Azure cloud subscription. I want to subscribe to a Kafka topic (for read and write) which is inside a confluent Cloud that is hosted in another Azure subscription. How to subscribe and publish the data into the destination kafka topic? …

Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
573 questions
asked 2022-02-27T13:10:44.153+00:00
Raja 1 Reputation point
commented 2022-03-08T07:48:27.883+00:00
ShaikMaheer-MSFT 38,286 Reputation points Microsoft Employee
1 answer

Remote disk disconnected- Virtual Machine Linux Unavailable

Good Evenning for all There was a reboot of a virtual machine hosted on azure, and according to the "resource health" monitor the remote disk was disconnected. This virtual machine is running a linux server that could not have…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,306 questions
asked 2022-03-02T21:19:23.083+00:00
Jairo Batanero Campos 1 Reputation point
answered 2022-03-08T07:44:49.627+00:00
vipullag-MSFT 25,121 Reputation points
1 answer

Failed connection from AS400 in Synapse

Hi When I try to connect to AS400 database to extract data into Synapse, I face this error. But I can connect to the database successfully in Dbeaver. Any one know reasons?Thanks

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.
4,500 questions
asked 2022-02-21T08:36:44.91+00:00
LIN YITONG 1 Reputation point
commented 2022-03-08T07:44:42.363+00:00
ShaikMaheer-MSFT 38,286 Reputation points Microsoft Employee
3 answers

Genarate Months Column in SQL

I am using sql compact database SDF and I have table Sales below is structure [SALES_ID] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [Sales_Date] datetime, [Sales_Time] nvarchar(50), [User_ID] bigint NOT NULL, [customer_id] bigint NOT NULL, [Payment]…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,937 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 questions
asked 2022-02-21T22:36:25.463+00:00
Devos2022 21 Reputation points
commented 2022-03-08T07:44:07.127+00:00
LiHong-MSFT 10,046 Reputation points
2 answers

Getting current year in a Sub query

SELECT year( getdate() ) returns the current year however do we need to use "select" before the same statement in a where clause?? Your thoughts pls

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,937 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 questions
asked 2022-02-12T05:49:48.533+00:00
PAVAN SALADI 1 Reputation point
commented 2022-03-08T07:42:52.123+00:00
LiHong-MSFT 10,046 Reputation points
1 answer

Getting all automainton account names of a tenant

Hello, Is there any way that i could get all automation account names of our tenant by a script? I am a global admin of the tenant. Regards Shahab

Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,146 questions
asked 2022-02-26T09:25:25.877+00:00
Jafari, shahab 1 Reputation point
commented 2022-03-08T07:42:03.807+00:00
Andreas Baumgarten 98,626 Reputation points MVP
1 answer

Adding SharePoint group to Doc library having unique permission and sub folders and sub sub folders having unique permissions.

Hi Team, I need to Add a group (Having users in that) in to all the Doc library having unique permission and sub folders and sub sub folders having unique permissions in a SPO site classic. That document library having structure like below: First…

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,733 questions
asked 2022-02-16T13:55:14.203+00:00
Ganesh 46 Reputation points
commented 2022-03-08T07:41:46.47+00:00
Yi Lu_MSFT 17,466 Reputation points
2 answers

ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW on sum column

how can i add ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW on sum column? because the lead/lag function dont work used the cod : select year (orderdate),month (orderdate),sum (SubTotal), lead ( sum (SubTotal),0) OVER ( PARTITION BY…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,937 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 questions
asked 2022-02-10T18:29:18.2+00:00
stasv85 1 Reputation point
commented 2022-03-08T07:41:40.667+00:00
LiHong-MSFT 10,046 Reputation points
4 answers

sql login for ssms

need to create an sql login that needs to be used for applicaiton only but it should not used SSMS login

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,937 questions
asked 2022-03-07T06:51:35.54+00:00
k muthus 41 Reputation points
commented 2022-03-08T07:41:34.253+00:00
AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
5 answers

Sum, upgrade and delete

Hello, I need help to significantly reduce the size of a sql Db. I have a table with some millions of record in this format: user | amount | datetime | john | 245 | 2021-12-1 20:21:00 | john …

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 questions
asked 2022-02-07T09:01:39.653+00:00
Gianluca a 1 Reputation point
commented 2022-03-08T07:35:37.503+00:00
LiHong-MSFT 10,046 Reputation points
1 answer

Use System.IO.Directory.GetFiles () with your Hololens UWP app

I used System.IO.Directory.GetFiles () to browse the 3D Objects folder in Hololens with the Hololens UWP app, but I didn't get any results as shown in the image below. Can I use System.IO.Directory.GetFiles () in a UWP app?

HoloLens Development
HoloLens Development
HoloLens: A family of Microsoft self-contained, holographic devices that enable engagement with digital content and interaction with holograms in the surrounding environment.Development: The process of researching, productizing, and refining new or existing technologies.
387 questions
asked 2022-03-07T05:57:32.503+00:00
t-kita 61 Reputation points
answered 2022-03-08T07:34:45.773+00:00
Hernando Ren 2,166 Reputation points
3 answers One of the answers was accepted by the question author.

enable shared disk with Azure linux VM accross zones

I have created 2 Linux VM's . Linux VM1 and Linuxvm2 . Tests that i implemented are below : Test 1 : Both linux Vm1 and linux vm2 were created in same region as EAST US . While creating Linux VM1 i created and attached enabled shared disk with max…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,306 questions
Azure Disk Storage
Azure Disk Storage
A high-performance, durable block storage designed to be used with Azure Virtual Machines and Azure VMware Solution.
583 questions
asked 2022-02-25T10:28:59.633+00:00
kumar kaushal 176 Reputation points
commented 2022-03-08T07:31:37.947+00:00
kumar kaushal 176 Reputation points
5 answers

Unable to install Microsoft SQL Server Data Tools

Hello, I've searched the internet and tried several fixes for this but I am not able to install SSDT release 15.9.6. I am installing it on MS Windows Server 2016 Datacenter, AWS instance. It keeps erroring out: Setup Failed Incorrect Function…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,937 questions
asked 2020-10-27T19:47:16.84+00:00
Jason Heaney 1 Reputation point
commented 2022-03-08T07:27:38.71+00:00
samar ahmed 1 Reputation point
2 answers

Exchange server 2016 authenticate with Kerberos require Outlook 2016 input password when connect mailbox

Hello everyone, Currently, our organization run Exchange Hybrid mode, we deploy Windows Hello for Business, user with on-premise mailbox will connect to Exchange Server using Kerberos. After complete deployment, we encounter issues when user with…

Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
7,408 questions
Microsoft Exchange Hybrid Management
Microsoft Exchange Hybrid Management
Microsoft Exchange: Microsoft messaging and collaboration software.Hybrid Management: Organizing, handling, directing or controlling hybrid deployments.
1,927 questions
asked 2022-02-12T06:56:14.08+00:00
hiennv10 1 Reputation point
answered 2022-03-08T07:17:41.52+00:00
hiennv10 1 Reputation point
1 answer One of the answers was accepted by the question author.

Weird error when deleting Noteooks firebase

Hello I have a colllectionView with notebook, and I can delete my notebooks by swiping. Also every Note in that particular notebook gets deleted. The problem is that when I delete a notebook, I can se for 1 second all the notes, before getting…

Xamarin
Xamarin
A Microsoft open-source app platform for building Android and iOS apps with .NET and C#.
5,305 questions
asked 2022-03-07T15:42:22.74+00:00
Eduardo Gomez 3,416 Reputation points
accepted 2022-03-08T07:15:53.113+00:00
Eduardo Gomez 3,416 Reputation points
1 answer One of the answers was accepted by the question author.

App pool service issue

When we tried to access our SharePoint online site coming up with attached error. Its on and off.. not consistent. is there any way we can do some thing about it proactively to anticipate this error and fix it before? Can we implement any…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,908 questions
asked 2022-02-20T19:15:33.86+00:00
sns 9,226 Reputation points
accepted 2022-03-08T07:11:37.517+00:00
sns 9,226 Reputation points
1 answer One of the answers was accepted by the question author.

Data deleetion issue in SharePoint online site and retnition polcy

We have observed that content have been deleted from SharePoint sites/subsites and found that it is available under system account. Can you please clarify my below questions on this. What does it mean by when it is deleted by system account, is it…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,908 questions
asked 2022-02-27T08:54:21.353+00:00
sns 9,226 Reputation points
accepted 2022-03-08T07:10:44.293+00:00
sns 9,226 Reputation points
1 answer

Azure AD B2C: How to restrict sign-up when using an email that should be used with the social account sign-up option (identity provider is AD)

Hi, We have implemented the following setup with Azure AD B2C: Users can sign-up in two ways: create local account with any email they provide (with confirmation) with an AD account (this external AD is registered as an identity provider) …

Microsoft Entra External ID
Microsoft Entra External ID
A modern identity solution for securing access to customer, citizen and partner-facing apps and services. It is the converged platform of Azure AD External Identities B2B and B2C. Replaces Azure Active Directory External Identities.
2,686 questions
asked 2022-03-01T07:25:55.5+00:00
Petja Belemezova 6 Reputation points
commented 2022-03-08T07:09:13.993+00:00
Petja Belemezova 6 Reputation points
0 answers

User Assigned Managed Identity not working when configuring bewteen 2 Appservices using .Netcore.

User Assigned Managed Identity not working when configuring bewteen 2 Appservices using .Netcore. No proper documentation when working with 2 Appservices, whereas documentation showing connecting with Appservice with Keyvault or Storage account.

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,920 questions
asked 2022-03-01T14:41:35.273+00:00
Jaladi Ramkumar 1 Reputation point
commented 2022-03-08T06:55:20.77+00:00
Jaladi Ramkumar 1 Reputation point
3 answers One of the answers was accepted by the question author.

sqllogin user log in

i need a help, i need to have sql server account where this sql user should not user ssms . ssms should be blocked how to do it

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,937 questions
asked 2022-03-07T11:13:21.19+00:00
k muthus 41 Reputation points
commented 2022-03-08T06:53:08.247+00:00
Viorel 113.3K Reputation points