SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,977 questions
4 answers
One of the answers was accepted by the question author.
Retrieve multiple status into one row based on multiple conditions SQL 2008
I need to retrieve multiple statuses into one row based on the closest status before + previous day if the day of the week in(Tuesday, Wednesday, Thursday, Friday, and Saturday), if the query runs on Monday it should include the closest status before +…
![](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, 15%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%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(240, 3%, 33%)' 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
Always on 2012 on windows 2012 on azure vm
Hi support May I know windows 2012R2 sql 2012 always on support on azure vm? Can use azure shared disk as fsw(cloud witness is not support in windows 2012)?
asked 2020-09-26T06:19:33.373+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(137.6, 40%, 23%)' 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)
sakuraime
2,326
Reputation points
commented 2020-09-29T15:09:06.307+00:00
Shashank Singh
6,251
Reputation points
2 answers
One of the answers was accepted by the question author.
OperationsManager Module on PowerShell Core (Linux)
I'm trying to install the OperationsManager module onto Linux Powershell core, It seems to install correctly but only a very limited number of cmdlets are available to use, not anywhere close to all of them. Is the full extent of the OperationsManager…
asked 2020-09-29T02:15:49.403+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, 45%, 11%)' 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)
Micah Kuan
21
Reputation points
accepted 2020-09-29T14:34:08.263+00:00
Micah Kuan
21
Reputation points
2 answers
Guidance on file share to sharepoint online migration
Hi I need to migrate a windows server file share to SharePoint online. We would also be migrating Exchange on-premises to Exchange online under same account. What would be the SharePoint online structure corresponding to the file share? Do I…
![](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(25.6, 47%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
health probe for load balancer
Hi, We are configuring a second Alwayson group Azure VM and need to determine which health probe port to be used at load balancer side for this new Alwayson group listener. Please advise which port can be used. There is already an existing Alwayson…
asked 2020-09-24T11:17:34.803+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(80, 17%, 17%)' 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)
vinayprasadv
96
Reputation points
accepted 2020-09-29T14:22:53.46+00:00
vinayprasadv
96
Reputation points
4 answers
One of the answers was accepted by the question author.
How to restore system image onto a bitlocker drive
Wndows10Pro build 2004 I have created a system image of the system. It alerts me that he drive is bitlocker encoded. The system image is not encoded. If I have to restore the system with this image, will it Work? or is there something else I have to…
1 answer
One of the answers was accepted by the question author.
SCCM ADR not removing expired or superseded updates from deployment pacakge
Hi We have an ADR for deploying windows defender updates on daily basis. Our settings is to "create a new software update group" and criteria of filter the updates by Product (Defender) and Supreseded (No). Noticed that the ADR is not…
![](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(137.6, 48%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Reduce DEM (Device Enrollment Manager) count and also show current count
Does assigning the Primary User of a device lower the device limit count (1000) on a DEM account? Also is there a page that displays the current count of a DEM account? or is it just filter devices and input the enrolled account name?
asked 2020-09-28T16:12:54.64+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, 52%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Austin Healy
21
Reputation points
accepted 2020-09-29T13:47:44.253+00:00
Austin Healy
21
Reputation points
4 answers
One of the answers was accepted by the question author.
WSUS log file name.
Hi everyone! I installed the WSUS service on the W2K19 core but I cannot find this log file. May someone help me?
1 answer
All Diagnostics and Admin jobs Failed To Run but application can submit Job normally on HPC Pack 2012 R2 Cluster Manager.
Hi All, We are using HPC Pack 2012 R2 Update 3 on Failover Cluster. Recently HPC Cluster Manager cannot run diagnostics and admin jobs like using run command in Cluster Manager. But weirdly Cluster Manager can submit job normally. Below is the…
asked 2020-09-28T01:14:49.457+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(227.2, 9%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
junmin park
81
Reputation points
commented 2020-09-29T13:23:52.823+00:00
Leon Laude
85,816
Reputation points
6 answers
server2016 very slow after upgrades
about a year ago i updated the CPU from i3->i7 and added 16GB of memory everything seemed OK since then the server is very slow i.e. click browser (or attempt to start any app) - takes ~60s to open server backups take >24hr to local disk, so…
asked 2020-09-28T12:09:45.777+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, 28.000000000000004%, 16%)' 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)
mark kaye
1
Reputation point
answered 2020-09-29T13:18:12.16+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
2 answers
MariaDB 10.3 created with a "-log" version
Hi, I have created a MariaDB server in the West Europe region. I have selected version 10.3 Performance Configuration: General Purpose, 2 vCore(s), 5 GB The server has been created using the version 10.3.23-MariaDB-log. show global variables…
asked 2020-09-21T13:31: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(230.39999999999998, 19%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
luispinedamx
1
Reputation point
commented 2020-09-29T13:03:10.48+00:00
luispinedamx
1
Reputation point
1 answer
Private DNS with Custom DNS Server
Hi, probably not a valid question but I can't find any documentation where it says it is not possible. If I have a virtual network with a custom DNS server already. Is it possible to link this Virtual Network to Private DNS as well?
asked 2020-09-29T10:27:13.527+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(316.8, 40%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Piyush Gupta
1
Reputation point
commented 2020-09-29T12:53:25.83+00:00
Piyush Gupta
1
Reputation point
1 answer
Why does OS get response while pinging itself?
Hello everyone, Could anyone explain me the case as follows. For example, OS (Win10) its ethernet network has IP-address say, 100.1.1.100. Two questions: I'm curious why does the OS get a response while pinging its own address 100.1.1.100. …
asked 2020-09-18T17:34:56.623+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, 28.999999999999996%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
cron kropjc
41
Reputation points
commented 2020-09-29T12:47:18.623+00:00
Karl Ivar Svane
1
Reputation point
1 answer
Azure DevOps across multiple tenant
Hello Experts, Can an Azure DevOps pipeline support the deployment of ARM to multiple subscriptions that have different Azure AD tenant? Regards,
asked 2020-09-29T12:45:01.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(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
answered 2020-09-29T12:46:29.063+00:00
Leon Laude
85,816
Reputation points
3 answers
One of the answers was accepted by the question author.
deny login to users mailbox
Hi All i am using exchange hybrid environment, we create the users in onprem and migrate to cloud, i have a requirement for one of my office365 user where the user should not login to his mailbox for 6 months temporarily, i.e after 6 months he can…
asked 2020-09-07T05:19:03.713+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(179.20000000000002, 7.000000000000001%, 27%)' 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)
Glenn Maxwell
11,496
Reputation points
accepted 2020-09-29T12:44:35.333+00:00
Glenn Maxwell
11,496
Reputation points
1 answer
One of the answers was accepted by the question author.
Permissions(Add/remove) to a sharepoint site
Hi All i have share point site to an office 365 unified group, how do i export the users from the below groups to a csv file. Office 365 group owners Additional Admins Site Owners Site members if i need to add or remove a user from Site…
asked 2020-09-09T20:38:04.433+00:00
Glenn Maxwell
11,496
Reputation points
accepted 2020-09-29T12:44:22.743+00:00
Glenn Maxwell
11,496
Reputation points
2 answers
One of the answers was accepted by the question author.
OneDrive/Sharepoint
Hi All i have a requirement to create one drive for a team who just wants to store data but i prefer to create unified group. and i am trying to understand the features, Below are the difference i see please correct me One Drive: OneDrive is…
SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,373 questions
Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
647 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,814 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,173 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,961 questions
asked 2020-09-16T19:36:59.24+00:00
Glenn Maxwell
11,496
Reputation points
accepted 2020-09-29T12:42:42.99+00:00
Glenn Maxwell
11,496
Reputation points
2 answers
One of the answers was accepted by the question author.
Regarding AZ 900 exam
Hi , For AZ900 Exam we have to submit Government ID , I think there is only two option one is Driving license and another is passport. so my Question is any other government ID are valid or not valid for this Exam ?
asked 2020-09-29T10:07:33.31+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(16, 78%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Rohit Baviskar
21
Reputation points
commented 2020-09-29T12:42:40.897+00:00
Rohit Baviskar
21
Reputation points
1 answer
My account for certifications can't access dashboards thats why i can't take online exam, is there anything I need to do?
My account for certifications can't access dashboards that's why I can't take online exam, is there anything I need to do? I rescheduled my exam because of this issue.
asked 2020-09-29T03:43:21.763+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(32, 67%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
John Christopher Santos
1
Reputation point
answered 2020-09-29T12:41:55.26+00:00
Anonymous