Microsoft SQL Server Bulk Insert NOT failing when inserting bigint values into int column
We recently had an identifier column move from int values to bigint values. An ETL process which loads these values was not updated. That process is using SQL bulk insert, and we are seeing incorrect values in the destination table. I would have…
How to prevent eventual "An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_net_changes_" in Synapse?
I have a Data Flow that takes various tables from an Azure SQL Database source. All of these tables have CDC enabled at the Database level as well as having CDC enabled on the Source Connector (set to "Full on the first run, then…
DB connectivity issues after installing the AIP Scanner tool
"Get-AIPScannerConfiguration : Failed to access scanner database. Verify the database is up and running and can be accessed by scanner service account and by the currently logged in user that executes the command. At line:1 char:1 …
Retirement of Azure SQL Database APIs 2014-04-01
The Azure SQL Database API version 2014-04-01 is retiring, I would like to understand the following things: How can we check the resources effected using the resource graph explorer? How to make the changes using code? Any prerequisite or…
How to recover deleted teams channels and where to see it if its deleted by user?
How to recover deleted teams channels and where to see it if its deleted by user?
Is there any AI application or tool in Microsoft which can be used in elementary classes?
any virtual reality or augmented reality application which can be introduced in elementary classes.
Unable to join Windows Server 2022 to domain using Microsoft Entra domain services
I am trying to join my Windows Server 2022 to my domain using Microsoft Entra domain services. However, I am unable to find the correct DNS server addresses to join my device to the domain. I have searched online extensively but have not found any useful…
Can you virtualize all domain controllers in your organization?
Can you have all of your domain controllers in your environment virtualized. Once upon a time I recall it was recommended at least 1 DC be physical, is that still the case or has Azure changed how that works?
How to get data for single item in recycleBin for Sharepoint using Msft Graph API
I am using Microsoft Graph API to access details about files in Sharepoint. I can get the list of deleted items using - https://graph.microsoft.com/beta/sites/{siteId}/recycleBin/items/ But when I try to retrieve data about a single item using …
How do I create a rule that starts with "after I send a message, cc me", It is no longer an option
This is no longer available on the new outlook, I need it
Locked out of Azure
I think I've made a silly mistake. I was trying to join the Partner program at Microsoft and it kept telling me I was using my personal account. I went to the Entra page and noted that my user was setup as external. I saw an option to turn it into an…
Azure Machine Learning Notebooks not showing due to workspace storage account access
When I try and access the notebooks in my Azure ML workspace I get this: I am the owner of both the Azure Machine Learning workspace and the storage account linked to this workspace: The Notebooks were initially visible this morning but after I added a…
Query on Group policy
Hi All, I want to capture Scheduled Task Event logs, i.e., when a scheduled task is created, updated, modified, or deleted. Can I achieve this using the below GPO? Computer Configuration --> Policies --> Windows Settings --> Security Settings…
removing Sidebar apps from edge from intune or powershell
Hi all, I would like to remove the ability for users to use Side bar apps / add ons How do I do this?
From where can i download sales data Microsoft SQL server?
"Hello Microsoft Team, I'm currently working on the Tailwind Traders lab. Do you happen to possess the "Sales Data Microsoft SQL Server" database? If so, kindly inform me, as I'm eager to utilize it for learning and implementation…
External Tables and Polybase in Synapse and Sql Server
So, I thought I knew external tables well in azure but I was reading about external tables with Sql Server: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=sql-server-ver16&tabs=dedicated and it seems…
Design two containers in Azure Cosmos DB for anonymous and sign-in users
We want to store the user's click on website into Azure Cosmos DB. We want to design two containers in a single Azure database, SampleDB. One container is to store the documents for anonymous user clicks on product detail page, one container is to store…
Tracking file access time in Azure Storage
All, I will be providing storage access (Account Kind - StorageV2, general purpose v2) to an external vendor using an SAS Token. I want to track and capture when the files are accessed by the external vendor. Is there a way to achieve this, either…
How to add attendees to event without sending notifications to existing attendees?
I am trying to use the graph api through Zapier (third party automation flow tool). I am trying to update an existing outlook event with new attendees. The current outlook part of my pipeline looks like this: GET event body from outlook using API…
Why am I limited to what VM size is available to me on my new pay-as-you-go Azure subscription?
I created a new Azure pay-as-you-go subscription using my credit card last week and today I went to create a new Vm and many of the VM sizes are unavailable to me (ie. sizes 'A', 'B', 'D', 'E') None of these VM sizes are available to me. They all have…