SQL Select subquery using exists
I am trying to write a query with a subquery. The subquery returns what is in the attached image below. select top(1) with ties matter_uno, PART_CAT_CODE, EFF_DATE, EMPL_UNO from TBM_CLMAT_PART where MATTER_UNO = 11275 and PART_CAT_CODE = 'BILL' order…
Communication Service phone number for Brazil Subscription
I'm trying to get a number in communcation service, so I can use it for sending sms or whatsApp for customers. Can't I have a phone number if my subscription is located in Brazil? regards, Matheus Santos
Send Emails after Business Trasnaction in Azure
Hi All, We have a requirement to send emails containing business data (and contract file attachments) to external users (outside Org. domains) from applications hosted in Azure. Our backend services are either Az Functions or Services hosted in Azure App…
ADF dataflow activity fails with large record sets
I have dataflow activity that retrieves data from an Azure MySQL database and invokes an address API using external call transformation to update the database with standardized addresses. However, when dealing with a large number of records…
Azure Site Recovery with Storage Account
Hello! I would like to understand how to activate Disaster Recovery on an Azure VM, without the need to leave a managed disk allocated. I would like the data to stay in a Storage Account, the same way it works for replications from Hyper-V to Azure.…
Virtual Network already has a gateway/ Multiple VNET one VPN
Hi , I am in process of creating a VNGW , but I am getting the below error. I have 2 subnets under this Virtual network like below. the back story of what I'm trying to achieve is have one VPN client that the end user can use to connect to machines…
Assistance Needed with Visualising Servers and Implementing Security Policies via Intune
Hello everyone, I'm seeking guidance on how to visualise servers in Intune and apply security policies through it. Here are the steps I've followed thus far: I've onboarded the server to Defender for Endpoint, which has been successful, and I've enabled…
Can I use one Task sequence to Image different hardware models (Dell 5820 & 5860) ?
Hi, I have 2 systems - Dell5820 & Dell5860 and I'm looking to image them using a single task sequence. As you all know both have different driver versions, I'm planning to use 2 inject drivers in the task sequence (1 for 5820 and 1 for 5860 one…
How to add correct exclusion on Azure WAF?
Greetings. Please help in creating an exception to the rule: OWASP_3.2 - Possible Remote File Inclusion (RFI) Attack: Off-Domain Reference/Link. My web application generates requests like: …
Windows Pre-Application installation in MDT
What is Windows Pre-Application installation in MDT ? What all components gets installed during this stage ? There's also Post-application installation after this step, I want to understand why we have a pre-application stage as well. It seems to…
Users with MFA: Enabled, Disabled, Enforced
I manage a Azure AD Does anyone have a PowerShell script that can help me get all users from Azure Active directory with MFA: Enabled, Disabled, Enforced Thanks for the help.
How to Get the Folder and all Sub-Folders GUIDs using Power Shell
I have a request to provide a list of sub-Folder GUIDs. I can generate one Folder GUID from this script, but I need the sub-folders within it. Can you assist with a script that will provide a list of sub-folder GUIDs? Cheri #Variables $SiteURL =…
Why drawing 2 Rectangles on a PictureBox by calling twice a "Function for Drawing" shows only the 2nd Rectangle?
Hi All, Given below is my Function (a Sub) for drawing a "Rectangle" on a "PictureBox". I wanted to draw 2 Rectangles side by side. When I called the function for each Rectangle, only the 2nd Rectangle was drawn, the 1st Rectangle was…
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…
Is the NVadsA10_v5 series impossible to use Stable Diffusion Cuda?
Hello, I recently created a virtual machine with the Standard_NV36adms_A10_v5 product and tried to use Stable Diffusion. However, entering the nvidia-smi command causes a "No devices we found error." And while using the optimized image…
Entra ID Connect and Exchange Hybrid setting checkbox?
I am using Hybrid Azure AD and Entra ID with Password Hash Sync, all objects are synchronized using the Azure AD Connect software. There are 2x Exchange Server 2016 but both have no mailboxes on-premise only used for managing the AD attributes as I…
Intune MDM Enrollment group policy is confusing
I am trying very hard to understand when something will actually get enrolled. I have this group policy to enroll devices. It only works if set to User Credentials. WHY? Why is Device there? Why doesn't device work? What is Device for? The docs…
How can I use my MS365 Business Standard's app benefits, if there is another MS account logged into my Windows?
So my issue is, that there is a Business Basic licensed account logged into my Windows, which doesn't have the desktop applications as my Business Standard licensed account. After downloading Office and logging into it, I am unable to use the apps such…
A user is excluded in conditional access policy but it is still applied
Hi all, I have a conditional access policy that requires MFA. Last week a user called and reported that instead of logging into offie 365 account they get "More information required Your organization needs more information to…
Sentinel Kusto Query todatetime function does not work with dynamic values.
I have a kusto query to calculate MTTR by client. When an incident is resolved, an analyst comments the resolution time in the format R: time where time is when the incident was resolved and R is to make the comment unique. Example R: Friday, May 10,…