ADconnect on Windows Server 2016 DC
Hi, I have a Windows server 2016 as DC. On this server I have ADconnect installed to synchronize users in Ou's against AzureAD. I want to de-promote this server from DC to member server. If I do this de-promotion: Will it keep the ADconnect…
Get-QuarantineMessage only returns results for 1 day
When running any of the cmdlets below in Exchange Online, I receive results for no more than a few days. This is the primary cmdlet which only returns results for 1 day in spite of the request for the last 30 days. I don't believe it has anything to do…
Recursive delete activity in Azure data factory
I'm going through ADF and was exploring about delete activity. There if we pass folder and set resurively then it will delete everything inside the folder. Now I thought to do some experiment and build logic where I have some folder names inside an array…
App Services / Access Restrictions - ipSecurityRestrictions
Hello, I want to retrieve information that App Services has an "access restriction" for I write this KQL : resources | where type == "microsoft.web/sites" | project name, properties.siteConfig.ipSecurityRestrictions All rows return…
pyspark dataframe methods: count, show ... duration?
Hi, I am testing some pyspark methods over a dataframe that I have created from a table, from the dedicated pool and it about 32 million rows length When running for example: "df1.show()" or "df1.count()" both commands last for about…
facing problem during my lab session Perform Data Analysis in Power BI learning path in connection the lab is not responding only
lab sessions are not working properly, only two labs worked properly rest all are not responding properly please do the needfull . This question is related to the following Learning Module
Failed to connect to the existing server farm located at the specified database server and database name. The database name is not a valid configuration.
I have a two server SharePoint 2016 farm. PROD1 which contain SharePoint and SQL1 which contain database. Now I am trying to join another SharePoint server called PROD2 to the farm. Both PROD1 and PROD2 are Windows 2019. Installation is done but when I…
Not able to connect Azure - Web App using FTP
Hello Not able to connect Azure - Web App using FTP - Winscp or FileZilla. Have enabled Web App->Configuration -> General Settings -> FTP Basic publishing credentials. Set Configuration -> FTP state = FTPS only Pls tell me if some more…
Assigning contributor role for subscription to new user (with company email address) fails
I want to add a new team member to my Microsoft Azure Sponsorship subscription as a Contributor. On portal.azure.com, I clicked on Subscriptions Selected the Microsoft Azure Sponsorship Clicked Access control (IAM) By clicking on View My Access,…
How to get phone number of teams user
We have MS Teams with few users in it with Phone Number Configured for each users. (https://admin.teams.microsoft.com/) These users are also available on the Active Directory. We want to get the user's teams Phone Number using the MS Graph…
Why does my OneDrive only have 5gb of storage when I have a business account
My business OneDrive account only has 5 gb of storage and I have a Microsoft 365 business plan . This question is related to the following Learning Module
Cannot remove app from Teams
I have an app attached to a tab on a Teams team that I cannot remove. It was installed directly from the add-ins store in Teams, and the app has been removed, but the tab is still there and when I go to select "remove" it presents an empty…
How to edit replication time between local AD and O365
How to edit replication time between local AD to O365. What is the default replication time.
How to make search text in ASP.NET dropdown controls
I have been developing ASP.NET application. some of the place i want searchable dropdown controls. the dropdown should search both numbers and name. How to do this...? example data as below. Cust.Name | Cust.Number Alfred K AXN29109 …
REST API Filter by Modified date ThrottledException
Good day, We have a SharePoint document library that has more than 5000 items. We are trying to retrieve a small set of files that we have calculated are less than 5000 based on a Modified date of earlier than September 17, 2023. We are using this API…
Dataset format needed for azure blob storage
How do I select what format is right for me while moving documents from SQL Server to Azure blob storage using Azure Data Factory pipeline? The existing documents in the Blob storage show the type as Block Blob, but it doesn't show the format. I need to…
CI/CD Azure Synapse Workspace with Azure Devops
Dear all, I am working on CI/CD between Azure Synapse Workspace with Azure Devops. I have source code from someone else who work on this project before and it works well and I try to understand it and create my own project on it. right now, I have…
Polybase s3 not working on SQL Server 2022 Linux
Trying to connect to parquet files on S3 from SQL server 2022 Linux fails with the following error: CREATE EXTERNAL DATA SOURCE myds WITH ( LOCATION = 's3://mybucket' , CREDENTIAL = mycreds ); GO 111631;The specified…
Should all active services in my account be visible from Home-->List All?
I've used Azure portal a few time for AI-201 training. I've just started DP-203 training and was attempting to run a beginners MS Learn script that requested Azure Synapse Analytics and related services for exploration purposes. After about 30 minutes,…
bit null ,0
Hey Team, have column1 datatype (bit,null) so it only takes values like 0 and 1 but i want true , false as well...how to get that in same datatype or in different one