SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,866 questions
1 answer
One of the answers was accepted by the question author.
Problem reading xml nodes to a table
Hi, I'm having issue reading all the ModelID's with respect to the Model. How do I get all ModelID's into the table w.r.t the CompanyCode DECLARE @XmlData XML SET @XmlData = '<Product> <Model CompanyCode="3020"> …
asked 2021-01-22T20:49:51.893+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(41.6, 39%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Brian collins
141
Reputation points
accepted 2021-01-22T21:34:36.413+00:00
Brian collins
141
Reputation points
0 answers
unable to create azure resource
Though I have subscription unable to create resources.
asked 2021-01-22T12:19:53.817+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(124.80000000000001, 0%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
R, Divya
1
Reputation point
commented 2021-01-22T21:33:57.32+00:00
JamesTran-MSFT
36,631
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
openrowset-bulk insert only reading the first Json object and not parsing correctly
I'm having problems importing my data from local file originally copied from our Azure Blob container. What I'm seeing so far is that I'm only getting the first JSON object, and the OPENJSON is not paring that object correctly (I'm getting nulls). …
asked 2021-01-20T17:00:33.08+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
accepted 2021-01-22T21:24:39.87+00:00
Anonymous
1 answer
ThreatIntelligenceIndicator correlation and False Positive removal
Hi community, My ThreatIntelligenceIndicator table was fed from an external feed via Graph Security API. I use it to query against CommonSecurityLog with a query like so: let QueryTime=ago(4h) CommonSecurityLog | where…
asked 2021-01-22T00:11:01.407+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(9.6, 33%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SentinelNoob
191
Reputation points
commented 2021-01-22T21:13:34.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(214.4, 81%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Marilee Turscak-MSFT
36,856
Reputation points Microsoft Employee
1 answer
received email Start using Conditional Access in Azure Active Directory by 30 January 2021
I received this email: Start using Conditional Access in Azure Active Directory by 30 January 2021 Directory by 30 January 2021 You're receiving this email because you use the preview of configurable token lifetimes in Azure Active Directory (Azure…
asked 2021-01-22T20:38:35.68+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(92.8, 30%, 18%)' 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)
sachin sontakke
1
Reputation point
answered 2021-01-22T21:01:31.737+00:00
Marilee Turscak-MSFT
36,856
Reputation points Microsoft Employee
1 answer
Get MS Forms response and fill PDF template
I am trying to create a flow that gets response from an MS Forms and matched the answers into an editable PDF file. I can't seem to find a way to do that without using 3rd party licenses. Any ideas? I have tried using OneDrive create file,…
asked 2021-01-22T20:51:49.143+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(185.6, 21%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Samantha Deakin
1
Reputation point
answered 2021-01-22T20:54:31.993+00:00
Anonymous
3 answers
Help to change INF file for install drivers in windows 10
Hi everyone. I have an USB wireless adapter, ID MQ4WUG2400, and the update driver stopped on windows XP version. I used it until windows 7 but I cannot in windows 10. I would like help to change the INF file to enable the installation in windows 10. …
![](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(179.20000000000002, 56.00000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
Intranet for non-365 users
We have had SharePoint since SharePoint 2003. Several years ago we made the jump to SharePoint Online/Office 365 from SharePoint 2016 on premise. At the time, we had just migrated to SharePoint 2016 Server the year before so my supervisor did not want…
asked 2021-01-08T18:25:49.24+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(201.6, 35%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFN%3C/text%3E%3C/svg%3E)
Forbes, Nancy
21
Reputation points
accepted 2021-01-22T20:40:02.613+00:00
Forbes, Nancy
21
Reputation points
3 answers
Injest xml from blob into Azure Data Explorer
I have some test xml files stored as azure storage blobs that I would like to injest into Azure Data Explorer. I created a table with a single raw column. I'm having issues injesting the blob because there is no RAW format in the One Click wizard. Is…
asked 2021-01-19T14:38:34.7+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(41.6, 4%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Michael Koerner
1
Reputation point
answered 2021-01-22T20:35:22.99+00:00
Michael Koerner
1
Reputation point
1 answer
MS Flow - Approvals - Timeout and Escalation
I want to know if there is a way to configure/trigger an approval to automatically reassign after a predefined amount of time is reached Scenario - Approval sits for x time waiting on an approval. If approval doesnt happen with x Amt of time, it…
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,113 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
3,295 questions
asked 2021-01-13T15:02:51.017+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(265.6, 2%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michael Straub (CE CEN)
1
Reputation point
answered 2021-01-22T20:32:57.163+00:00
Deva-MSFT
2,266
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Best method to check a computer can be successfully reached using WINRM
I am using PowerShell scripts to do various tasks on remote computers. PS Remoting is enabled on all computers but sometimes I still get some issues with some where I can't connect- these are normally easily solved by checking computer is not on a…
asked 2021-01-22T17:24:55.67+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(73.60000000000001, 32%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Darren Rose
496
Reputation points
commented 2021-01-22T20:22:16.69+00:00
Darren Rose
496
Reputation points
2 answers
One of the answers was accepted by the question author.
Max data IOPs Serverless Azure SQL database
I am new to Azure. We setup a General purpose, serverless Gen5 Azure SQL Database. Under General it says the IOPS range is 500 - 20,000. So we can can have 1 to 40 vCores. So if you do the math that should mean that you get 500 IOPS per core. So one core…
![](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(16, 90%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
1 answer
How to maximize CPU usage
I wrote some program that doind a longtime calculations. When i open a task manager, i see that my exe uses only 2% of CPU. How shoult i write my code in c# to obtain a maximum CPU time to speed up my calculation? I try to start a several copies …
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,962 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,163 questions
asked 2021-01-22T19:13:01.087+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(105.60000000000001, 93%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Vittorio Rosso
1
Reputation point
answered 2021-01-22T20:05:14.177+00:00
MotoX80
33,996
Reputation points
0 answers
Project Server Permissions: Project Team Read/Write Own Project and Read Other Projects
Hello, We are in the process of configuring our Project Server PWA permissions. We currently have the Project Server permissions enabled. There have been many references on Technet referring to the website below, but it returns a "403…
asked 2021-01-21T13:38:33.783+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, 43%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mike_ProjNewb
1
Reputation point
commented 2021-01-22T19:58:57.873+00:00
Mike_ProjNewb
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Search Error issue in SharePoint Server 2016
When we search with Server Name, the search is working. However with Alternative Access Mapping name, showing the below error and there is no log info in the correlation ID Full crawl is configured using Server Name and not with the AAM.
asked 2021-01-12T07:46:43.927+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(153.6, 26%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sajith Gopalakrishnan Hema
1,036
Reputation points
accepted 2021-01-22T19:51:56.777+00:00
Sajith Gopalakrishnan Hema
1,036
Reputation points
1 answer
How to allocate the required memory?
Error : cannot allocate vector of size 20.5 Gb Error I am calling multiple notebooks within one notebook that trains my model and saves the results. dbutils.notebook.run("../path/to_model_file", timeout_seconds = 48000, arguments =…
asked 2021-01-11T11:23:18.757+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, 12%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Siddhesh Bhurke
46
Reputation points
commented 2021-01-22T19:49:06.697+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(204.8, 44%, 29%)' 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)
Saurabh Sharma
23,821
Reputation points Microsoft Employee
1 answer
Microsoft To Do app
Is the Microsoft To Do app compatible with Mac OS 11.1 Big Sur? Will Microsoft To Do work if I upgrade from Catalina to Big Sur Mac OS?
asked 2021-01-21T22:39:06.827+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(259.20000000000005, 92%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWW%3C/text%3E%3C/svg%3E)
Wendy Woodrow
1
Reputation point
answered 2021-01-22T19:48:41.477+00:00
Deva-MSFT
2,266
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
SVG images disappear after navigating from flyout menu
I recorded a sample video and uploaded it to YouTube: https://youtu.be/iMfJxWkljeE To briefly explain my issue, I have some images that I am getting from SVG. I am declaring them like this: <Grid> <Path…
![](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(195.2, 67%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Do expired budgets disappear in the view?
A customer of mine had budgets defined in 2020 with the expiration date on the December 31st 2020. Now as today we looked in the Cost Management and the budgets were not visible anymore. Is this normal, that they disappear after the expiration date? …
asked 2021-01-14T18:41:48.96+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(6.4, 54%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Christoph Dambacher
86
Reputation points
commented 2021-01-22T19:10:53.777+00:00
olufemia-MSFT
2,861
Reputation points
2 answers
One of the answers was accepted by the question author.
ExpressRoute connectivity Requirements for AVS
Hello Experts, Is there a strict requirements for using Azure ExpressRoute Global Reach for AVS connectivity in hybrid set up.
asked 2021-01-05T16:09:06.617+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(134.4, 84%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Shola Lawani
531
Reputation points Microsoft Employee
accepted 2021-01-22T19:08:09.187+00:00
Shola Lawani
531
Reputation points Microsoft Employee