Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,717 questions
2 answers
One of the answers was accepted by the question author.
Sql Server not releasing memory even after closing .net application in which we are doing sql operations
Hi, we are facing some issue related to sql server memory release. We are using sql server 2017 and above. We have a .net application which is performing a lot of transactions on Sql server in specific use case, issue is while we are using application…
Developer technologies | Transact-SQL
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,749 questions
asked 2020-11-03T11:59:22.583+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 81%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Muhammad Usman
41
Reputation points
commented 2020-11-03T15:26:44.97+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips
17,786
Reputation points
3 answers
ADF - cosmos upsert question
Hi I have a file that has a million rows - which i upload into cosmos db, I let cosmos db generate the id as a guid next day i get a new complete file which has some deltas and new records - there are two fields I can check to see if the record…
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
2,141 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,169 questions
asked 2020-10-13T21:00:29.88+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 31%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Stuart Porter
1
Reputation point
answered 2020-11-03T15:05:19.317+00:00
Stuart Porter
1
Reputation point
1 answer
One of the answers was accepted by the question author.
excel absolute range, keyboard short cut
When I was doing absolute or locking a range in EXECEL, I used to use the F4 key instead of $a1 etc. Noe the F4 key does not work. is there another way to lock the range quickly or do I have do $a$1 etc Thanks!
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
20,642 questions
asked 2020-11-02T15:43:31.263+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2020-11-03T15:02:58.54+00:00
Anonymous
2 answers
Budget Monitoring
Can you set up a budget and use amortized costs instead of actuals to monitor?
Cost Management
Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
4,826 questions
asked 2020-10-13T17:38:19.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 92%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Cody Cleveland
1
Reputation point
commented 2020-11-03T14:51:42.397+00:00
olufemia-MSFT
2,866
Reputation points
0 answers
Why i cant delete resource group and resources inside of the group -Terraform
I try do remove this in many ways : az group delete -n rg-terraexample Are you sure you want to perform this operation? (y/n): y Deployment failed. Correlation ID: 45329dc5-27e0-4c7e-86ed-4a05bbb27ba2. Operation failed with status: 'Conflict'.…
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,509 questions
asked 2020-10-13T17:30:36.813+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 50%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Regina Gialbas
1
Reputation point
commented 2020-11-03T14:47:25.4+00:00
olufemia-MSFT
2,866
Reputation points
1 answer
One of the answers was accepted by the question author.
Netsuite ERP roles and Azure SSO
Hello, We are planning to do SSO with Oracle Netsuite ERP and Azure AD that the users could login to Netsuite using their Azure AD credentials. My question here is that can I assign roles inside of Netsuite to users using the Azure console in the…
Microsoft Security | Microsoft Entra | Microsoft Entra ID
Microsoft Security | Microsoft Entra | Microsoft Entra ID
A cloud-based identity and access management service for securing user authentication and resource access
30,712 questions
asked 2020-10-28T13:26:30.89+00:00
Anonymous
accepted 2020-11-03T14:45:12.123+00:00
Anonymous
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services: Columns vs. Rows
What causes a larger performance hit for AAS, having lots of columns or having lots of rows? For example, my client wants an AAS model that could potentially have 2,000+ columns. Would that cause a large performance hit on AAS?
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
506 questions
asked 2020-10-27T22:05:38.907+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
James H. Robinson
181
Reputation points
accepted 2020-11-03T14:29:41.573+00:00
James H. Robinson
181
Reputation points
1 answer
Unable to list subscription under a management group
I am trying to list all subscriptions under a specific Management group, and i need to exclude these subscriptions from my activity targeting all subscriptions under my Azure Tenant. I can't find any documentation about it but its really important to…
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,509 questions
asked 2020-10-07T12:16:40.397+00:00
Abhishek Mittal
1
Reputation point Microsoft Employee
answered 2020-11-03T14:23:28.557+00:00
olufemia-MSFT
2,866
Reputation points
1 answer
Can't publish plain vanilla Helloworld function using VS2019
Add new project-->Azure Functions Http trigger Try to publish to see below error Any clue why I'am getting this error?
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
6,480 questions
asked 2020-11-02T22:57:23.637+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Porsche Me
136
Reputation points
answered 2020-11-03T14:09:37.587+00:00
sadomovalex
3,636
Reputation points
1 answer
One of the answers was accepted by the question author.
Microsoft Graph Security API results
Hello, With the Graph Security API /alerts endpoint url, I receive alerts info but some fields are not filled in the response. As an example, in the screenshot there is no value for the field "privateIpAddress". Is there a reason why…
Microsoft Security | Microsoft Defender | Microsoft Defender for Cloud
Microsoft Security | Microsoft Defender | Microsoft Defender for Cloud
A cloud-native solution that protects workloads across hybrid and multi-cloud environments with threat detection and security recommendations
1,737 questions
asked 2020-10-02T11:27:41.413+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 11%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Panayiotis Mousarris
21
Reputation points
accepted 2020-11-03T14:04:01.877+00:00
Panayiotis Mousarris
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Can we audit the File Share by using the Hybrid solution?
Hi, So we know that technically we can't audit the Azure File Shares, look at who read/modified the file. What if we use the hybrid solution in which we enable the cache on Windows Server. Then OS uses HTTPS protocol to transfer the files and the…
Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,511 questions
asked 2020-10-30T15:51:13.253+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 44%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Michał Pawlicki
91
Reputation points
commented 2020-11-03T13:58:23.013+00:00
Michał Pawlicki
91
Reputation points
1 answer
I am unable to reschedule my exam az-900
Hello, I was unable to reschedule my exam and person veu said that they have restored the voucher. I get an error saying : "We can’t access your Microsoft profile to schedule your exam. To resolve the issue, try these steps in this order and…
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
54,811 questions
asked 2020-11-02T13:40:03.063+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 28.999999999999996%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saswati sahu
1
Reputation point
commented 2020-11-03T13:55:09.363+00:00
Anonymous
1 answer
One of the answers was accepted by the question author.
JSON to JSON liquid transform
I want to convert this: { "firstName": "John", "lastName": "Smith", "fullName": "John Smith", "age": "32", "emailAddress":…
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,808 questions
asked 2020-06-10T11:15:47.29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 98%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Ashwin Chakravarthy Kuruvidi
20
Reputation points
accepted 2020-11-03T13:30:44.58+00:00
Ashwin Chakravarthy Kuruvidi
20
Reputation points
2 answers
One of the answers was accepted by the question author.
exchange ndr
dears, i am experiencing this error with a newly created user: Generating server: exchange.domain.com …
Exchange | Exchange Server | Management
Exchange | Exchange Server | Management
The administration and maintenance of Microsoft Exchange Server to ensure secure, reliable, and efficient email and collaboration services across an organization.
8,174 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 26%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
Invoke-AzVMRunCommand returns a string output i want to have list of objects , is there anyway to get that
Invoke-AzVMRunCommand returns a string output i want to have list of objects , is there anyway to get that . I am using below cmdlets to fetch the output : $out = Invoke-AzVMRunCommand -ResourceGroupName "Test" -VMName…
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
10,170 questions
Windows for business | Windows Server | User experience | PowerShell
asked 2020-11-02T12:44:28.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 16%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Praveen Mittapalli
36
Reputation points
commented 2020-11-03T13:29:54.417+00:00
Viktor Dronov
146
Reputation points
1 answer
Suggestion for SharePoint based document management system
Hey all, I work in a manufacturing company. My company is thinking of expanding the business soon. The company started small, so the company used traditional methods for the documentation process. As the business is going well the company needs more…
Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft 365 and Office | SharePoint | For business | Windows
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
29,967 questions
asked 2020-10-28T16:04:21.073+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Amanda M Conroy
1
Reputation point
answered 2020-11-03T13:15:38+00:00
Anupam Shrivastava
176
Reputation points
1 answer
Sharepoint and LTI (Learning Tools Interpoerability)
Is it possible to integrate a 3rd party such as Libguides CMS LTI into SharePoint?
Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft 365 and Office | SharePoint | For business | Windows
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
29,967 questions
asked 2020-10-28T21:58:47.423+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 35%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Beulah Greaves
1
Reputation point
answered 2020-11-03T13:12:25.79+00:00
Anupam Shrivastava
176
Reputation points
0 answers
How to retrieve SCOM on boarded Entities and performance metric values against entities through SCOM REST APIs?
Hi, I'm trying to retrieve SCOM on boarded Entities as well as performance metric values against entities through SCOM REST APIs Ex: Windows server 1 : Cpu utilization is 10% Windows server 1 : Disk utilization is 20% In that scenario We have found…
System Center Operations Manager
System Center Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,638 questions
asked 2020-11-03T13:08:04.903+00:00
Anonymous
asked 2020-11-03T13:08:04.903+00:00
Anonymous
0 answers
OpenEventLog rc = 1783 on Windows Server 2019
Hello. I am creating a program that reads the Windows Event log, but when I run it on Windows Server 2019, there are always cases where it fails with OpenEventLog rc = 1783. (This occurs when acquiring the event log of another Windows machine from…
Windows development | Windows API - Win32
2,972 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 61%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How to have administrator reset password for ADB2C user?
I'm trying to reset passwords for user's inside of the Azure ADB2C blade but when trying the temporary password I always get "The password has expired" error message.
Microsoft Security | Microsoft Entra | Microsoft Entra External ID
Microsoft Security | Microsoft Entra | Microsoft Entra External ID
Managing external identities to enable secure access for partners, customers, and other non-employees
3,987 questions
asked 2020-11-03T11:35:03.067+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 70%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Sean Thorne
21
Reputation points
accepted 2020-11-03T12:45:31.493+00:00
Sean Thorne
21
Reputation points