SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,818 questions
1 answer
One of the answers was accepted by the question author.
SQL Max(Date) query could return multiple rows
Having a devil of a time trying to find a query to return what I need. I have a table as above. I am trying to use max(eff_date) to return the last record(s). Most of the time, only 1 record will be returned for the max(eff_date), but sometimes, more…
asked 2024-05-13T14:12:50.9366667+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, 24%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Joseph Mancini
41
Reputation points
accepted 2024-05-13T15:00:42.3133333+00:00
Joseph Mancini
41
Reputation points
2 answers
can not start sql server2012.the request failed or ther service did not respond in a timely fashion.
This error will be reported after starting sql server 2012, check the log，Please refer to the following picture to view the log. How to solve it? The description for Event ID 17836 from source MSSQL$MSSQL2012 cannot be found. Either the component that…
![](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, 89%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHY%3C/text%3E%3C/svg%3E)
1 answer
Creating ActionRule from an ARM template results date format error for effectiveFrom field
This is the excerpt from my ARM template I try to deploy, but getting the following error: Status Message: Invalid input parameters: Wrong DateTime format of the parameter: 'effectiveFrom', with value: '2022-03-08T00:00:00Z'. Expected date time format…
asked 2022-03-08T15:36:52.337+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(163.2, 69%, 25%)' 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)
KaziNad
51
Reputation points
commented 2024-05-13T14:57:14.8866667+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(3.2, 17%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shiva Kumar K Y
0
Reputation points
1 answer
Azure python runbook import_py3package_from_pypi : Exception: Error importing package cryptography into Automation account. Error code is 400. from p
hi all, on Azure Automations I am receiving this Exception when I try to run import_py3package_from_pypi runbook on module msgraph-sdk -v 1.2.0. I only require the functionality from the runbook to access the microsoft graph using certificate…
asked 2024-05-08T03:56:09.8433333+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, 65%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGF%3C/text%3E%3C/svg%3E)
Grant Fullston
20
Reputation points
answered 2024-05-13T14:56:35.7266667+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, 70%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Phillip Krall
0
Reputation points
4 answers
Why is there no way to sort the SharePoint pages I am following?
I have to "follow" many pages on SharePoint - why is there no way to sort or pin the pages listed in the Following section? Additionally, why do they need to appear in Card format. with a text list at least they would take up less room on the…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,330 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,755 questions
asked 2023-05-23T16:54:52.14+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(172.8, 50%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Gehman, Marie (she/her/hers)
20
Reputation points
commented 2024-05-13T14:56:10.5933333+00:00
Gehman, Marie (she/her/hers)
20
Reputation points
2 answers
One of the answers was accepted by the question author.
Can a single Entra P1 license be used to collect account configuration data within a tenant without requiring P1 licenses for every user?
I am trying to evaluate a tenant's user accounts for proper configuration of conditional access policies, MFA registration, and more. I've found that a single service account with a P1 license can query the graph API for this information, but I'm unsure…
asked 2024-04-30T00:02:14.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(278.4, 24%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVT%3C/text%3E%3C/svg%3E)
Vincent Tran
20
Reputation points
accepted 2024-05-13T14:49:09.0966667+00:00
Vincent Tran
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Migrating from VNET (Classic) to ARM has interruption on the resources?
Have a good day, Migrating from VNET (Classic) to ARM has interruption on the resources (apparentaly not) ?, Also in case something goes wrong there's a rollback for this change ? we don't want to have issues with the services. the following link is what…
asked 2024-05-10T20:06:42.5266667+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(198.4, 82%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHR%3C/text%3E%3C/svg%3E)
Herbert Rodriguez
20
Reputation points
commented 2024-05-13T14:48:47.1+00:00
KapilAnanth-MSFT
35,986
Reputation points Microsoft Employee
2 answers
A random file started popping up in my desktop named SZCCID
Hello i don't know from where did this file started popping up named SZCCID i deleted it every time but it create its self every time i reset my pc if any one have similar problem or found solution pls tell me . Thanks for the future help and sorry for…
asked 2024-05-12T14:29:52.9833333+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, 57.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Biser Krapchev
0
Reputation points
answered 2024-05-13T14:47:16.2866667+00:00
MotoX80
32,081
Reputation points
1 answer
Connecting the log analysis workspace to the Azure update manager.
Is it possible to integrate azure update manager with log analytic workspace? If the answer is in the affirmative, could you please provide me with a high-level guide?
![](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(236.8, 37%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
1 answer
Delta Column in Application Insights Performance
I would like to know what is the use of Delta Column in Application insights performance when zoomed in, I mean there is an information stated above but could u guys please elaborate?
asked 2020-12-23T11:18:28.937+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(307.2, 10%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Ralph Jomar Lumang
6
Reputation points
commented 2024-05-13T14:40:17.9966667+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(38.4, 3%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Roland Christensen
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Set ACLs on Storage Container using Powershell - Authorization Mismatch
Hi all, I am having trouble using Powershell to set ACLs on a storage account container using: Update-AzDataLakeGen2AclRecursive The error suggests that I do not have permissions, however I can set ACLs through the Azure Portal, and can set and…
asked 2024-05-02T22:16:47.8533333+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(28.799999999999997, 57.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
John Aherne
141
Reputation points
commented 2024-05-13T14:39:58.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(297.6, 81%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Amrinder Singh
2,590
Reputation points Microsoft Employee
12 answers
One of the answers was accepted by the question author.
Unable to drag and drop outlook attachments to file explorer after new outlook preview turned on
Hi Everyone, Out organisation is now being prompted to try the new outlook version in preview. We have noticed that in this new version you cannot drag and drop attached files in an email to file explorer (downloads, OneDrive etc) you have to actually…
asked 2023-05-26T02:53:24.7633333+00:00
Elie K
545
Reputation points
answered 2024-05-13T14:36:59.7933333+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(131.20000000000002, 93%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV5%3C/text%3E%3C/svg%3E)
VirginieMaury-5437
0
Reputation points
1 answer
Azure Synapse Analytics Workspace connector in power bi is not connecting, are there system issues? It was working fine yesterday.
I am unable to view data in power bi using the "azure synapse analytics workspace" connector, the navigator view just spins forever. IS there an issue with the service? It was working yesterday and there have been no changes to our…
asked 2024-05-08T12:48:44.5133333+00:00
Seth Coleman
6
Reputation points
commented 2024-05-13T14:36:26.49+00:00
Seth Coleman
6
Reputation points
2 answers
One of the answers was accepted by the question author.
EDI cross reference table
Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?
asked 2024-04-19T19:37:38.3733333+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, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
60
Reputation points
accepted 2024-05-13T14:34:58.0033333+00:00
Jonathan Brotto
60
Reputation points
1 answer
One of the answers was accepted by the question author.
Timeout and Connection Issues in ADF with Azure Managed Postgres: Npgsql Exception
I’m currently engaged with ADF and Azure Managed Postgres, and I’ve been encountering a persistent issue where look-ups and query-sourced copy activities consistently time out around the 35-second mark. Failures happened on 'Source' side.…
asked 2023-11-02T19:52:13.55+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(44.800000000000004, 75%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
ClarissaJacquline
200
Reputation points
commented 2024-05-13T14:34:46.0366667+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(288, 88%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Emmanuel KLEIN
0
Reputation points
1 answer
HyperV Virtaul Machine live migration Failed
I am getting quite strange issue with HyperV as some of virtual machines able to migrate between hosts in cluster without any issue but others are failing with error. "The virtual machine is using processor-specific features not supported on…
asked 2023-03-11T14:40:54.8033333+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(51.2, 81%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Deepak Kumar
6
Reputation points
commented 2024-05-13T14:34:45.5733333+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(240, 28.000000000000004%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PhilD
0
Reputation points
2 answers
SQL2022-SSEI-Expr setup file is not opening
I downloaded the express edition file from here :https://www.microsoft.com/en-us/sql-server/sql-server-downloads When I try to open it , the file dont open . dont know whats wrong with it. Need Help with the installation. TIA
asked 2024-04-24T12:17:54.3266667+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, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
sakib rahman
0
Reputation points
commented 2024-05-13T14:33:14.44+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, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOE%3C/text%3E%3C/svg%3E)
Oba Eze
0
Reputation points
3 answers
Failed to Initialize Registry Root Hive
I recently have Visual Studio 2022 installed and had used it for approximately 2 weeks. Today in all of a sudden when I tried to start Visual Studio, it showed up a error and told me to go look at the ActivityLog.xml: <?xml version="1.0"…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,649 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(310.4, 26%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
![](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, 81%, 15%)' 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)
6 answers
Put Blob REST API Content-Length error
I'm trying to write the XML response obtained from a REST API GET request to a file in Azure Blob Storage, using Azure Data Factory. I'd prefer to use the Copy activity to achieve this, but it doesn't support XML sinks. I've therefore been forced into…
asked 2024-05-07T10:06:05.8133333+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, 64%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jez Walters
20
Reputation points
edited an answer 2024-05-13T14:31:36.36+00:00
Jez Walters
20
Reputation points
1 answer
excel file doesnt not load up
excel file does not load up from my pc. Failed to read metadata from file source. Response from the end service is : Bad Request clientRequestId: 44b6fe67-83f0-4bfb-9cd7-c8939fd9eb9f serviceRequestId:…
asked 2024-05-09T13:36:29.9266667+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(60.8, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jan Begala
0
Reputation points
edited the question 2024-05-13T14:29:08.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(153.6, 16%, 24%)' 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)
Rakesh Gurram
3,410
Reputation points Microsoft Vendor