Category: Microsoft
Category Archives: Microsoft
windows 11, not found: apps & features
1.) access the Settings menu on your Windows 11 computer
2.) n the Settings menu, navigate to “Apps & Features.” NOT FLOUND
Therefore, I can’t install virtual machine
apps –> apps & features –> optional features –> add a feature, then type “Virtual Machine Platform.”
OS build: 22631.3880, 23H2, win11
1.) access the Settings menu on your Windows 11 computer2.) n the Settings menu, navigate to “Apps & Features.” NOT FLOUNDTherefore, I can’t install virtual machineapps –> apps & features –> optional features –> add a feature, then type “Virtual Machine Platform.” OS build: 22631.3880, 23H2, win11 Read More
“Classic” Outlook works fine, but “New” Outlook cannot find server
This is a work account, so I can’t do much (any) digging around in registries, etc., but even our IT department is stumped.
I can launch “Old”/”Classic” Outlook just fine. Everything loads, and syncs perfectly, but if I hit the toggle to switch to “New” Outlook, I get an error saying that the server cannot be found.
I can log in through the web just fine, as well.
Here’s the kicker: IT guy shows up and tries to log in to New Outlook with HIS credentials, and it works.
Tried so far with no luck (not necessarily in this order):
olk.exe –clearLocalState. (not sure if he ran this as Admin… I’ll check w/ him tomorrow)
Uninstall/Reinstall all of MS Office
Reset Outlook profile
Completely reset my user account on the computer
Set-CASMailbox -Identity <MailboxIdentity> -OneWinNativeOutlookEnabled $true
I’m confused, IT is confused. Everyone is confused.
Anybody have any ideas they could recommend, because we’re getting desperate at this point.
This is a work account, so I can’t do much (any) digging around in registries, etc., but even our IT department is stumped. I can launch “Old”/”Classic” Outlook just fine. Everything loads, and syncs perfectly, but if I hit the toggle to switch to “New” Outlook, I get an error saying that the server cannot be found. I can log in through the web just fine, as well. Here’s the kicker: IT guy shows up and tries to log in to New Outlook with HIS credentials, and it works. Tried so far with no luck (not necessarily in this order):olk.exe –clearLocalState. (not sure if he ran this as Admin… I’ll check w/ him tomorrow)Uninstall/Reinstall all of MS OfficeReset Outlook profileCompletely reset my user account on the computerSet-CASMailbox -Identity <MailboxIdentity> -OneWinNativeOutlookEnabled $trueI’m confused, IT is confused. Everyone is confused. Anybody have any ideas they could recommend, because we’re getting desperate at this point. Read More
Sharepoint Code Snippet – Copy Code button
Hey everyone,
I want to use the organisation SharePoint to create a kind of code repository for the team to use: nothing too complicated, mostly HTML elements for our LMS. I know it’s a minor thing, but non-tech-non-coders will be copy-pasting these elements and they keep missing either a < at the start or a > at the end or often the <div>…
Hey everyone,I want to use the organisation SharePoint to create a kind of code repository for the team to use: nothing too complicated, mostly HTML elements for our LMS. I know it’s a minor thing, but non-tech-non-coders will be copy-pasting these elements and they keep missing either a < at the start or a > at the end or often the <div>… Read More
Recently installed a M2 samsung ssd, but is not showing on windows. Any tips?
So, yeah. A couple of weeks ago the thing did appear, but then one day it did not, and I’ve no idea what happened. In the disk management app the thing shows up, but the only option I get is to “Convert to dynamic disk” and “properties”, not to create new volumes…and for some reason it has less memory than what the thing says it has? Any help would be apprecated you guys
So, yeah. A couple of weeks ago the thing did appear, but then one day it did not, and I’ve no idea what happened. In the disk management app the thing shows up, but the only option I get is to “Convert to dynamic disk” and “properties”, not to create new volumes…and for some reason it has less memory than what the thing says it has? Any help would be apprecated you guys Read More
Team Channel Post Order Concern
My organization uses team channels across multiple office locations. We have consolidated into managing all case files across our region. We manage most communications and shared documents/ spreadsheets through team’s channels related to specific tasks/ roles a staff member may be working in for that day. Due to the rapid turnover (daily task changes) we need clear organization within our teams channels.
We post case tasks in teams in certain channels for follow up. These build up rapidly as we have thousands of case files and a never ending chain of work. Some days channels can have 10-20 action items posted. The problem comes into play when someone actions an item and comments on the post. It then pulls the post to the most recent spot (top or bottom depending on how it set). We are needing the posts to stay in order of date/ time posted as we start to lose items that haven’t been actioned yet. Everyday we are digging through posts trying to make sure all get actioned. It’s very stressful and not efficient. Maybe teams is not the best method but we haven’t sorted out an alternative since this suddenly change in our division.
Is there anyway we can adjust the order settings for posts in channels?
My organization uses team channels across multiple office locations. We have consolidated into managing all case files across our region. We manage most communications and shared documents/ spreadsheets through team’s channels related to specific tasks/ roles a staff member may be working in for that day. Due to the rapid turnover (daily task changes) we need clear organization within our teams channels. We post case tasks in teams in certain channels for follow up. These build up rapidly as we have thousands of case files and a never ending chain of work. Some days channels can have 10-20 action items posted. The problem comes into play when someone actions an item and comments on the post. It then pulls the post to the most recent spot (top or bottom depending on how it set). We are needing the posts to stay in order of date/ time posted as we start to lose items that haven’t been actioned yet. Everyday we are digging through posts trying to make sure all get actioned. It’s very stressful and not efficient. Maybe teams is not the best method but we haven’t sorted out an alternative since this suddenly change in our division. Is there anyway we can adjust the order settings for posts in channels? Read More
Stockhistory data doesnt update for today but using the STOCK.Price function does
Using stockhistory formula on some stocks to pull stock price for 3-months or 1-year historical. However, they never include todays stock price even a few hours after close. I checked (https://support.microsoft.com/en-us/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6)) which states that the delay is 15 mins for US stocks yet it wont show these values in stockhistory formula. It does work if you use STOCKCELL.price but wondering why there is a discrepancy here.
Using stockhistory formula on some stocks to pull stock price for 3-months or 1-year historical. However, they never include todays stock price even a few hours after close. I checked (https://support.microsoft.com/en-us/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6)) which states that the delay is 15 mins for US stocks yet it wont show these values in stockhistory formula. It does work if you use STOCKCELL.price but wondering why there is a discrepancy here. Read More
Fix QuickBook𝘀 Keeps Crashing error says “QuickBook𝘀 Not Responding”
I’ve been using QuickBook𝘀 for my small business for a while now, but recently I’ve been encountering a frustrating issue. Every time I try to open QuickBook𝘀, it crashes and displays a message that says “QuickBook𝘀 is not responding.” This happens right after the program launches, and I’m unable to proceed further.
I’ve been using QuickBook𝘀 for my small business for a while now, but recently I’ve been encountering a frustrating issue. Every time I try to open QuickBook𝘀, it crashes and displays a message that says “QuickBook𝘀 is not responding.” This happens right after the program launches, and I’m unable to proceed further. Read More
Help me Fix QuickBook𝘀 Keeps Freezing issue after update
I’ve been using QuickBook𝘀 for managing my business finances, but I’ve been running into a persistent issue lately. While I’m working in QuickBook𝘀, the application frequently freezes, making it impossible to continue with my tasks.
I’ve been using QuickBook𝘀 for managing my business finances, but I’ve been running into a persistent issue lately. While I’m working in QuickBook𝘀, the application frequently freezes, making it impossible to continue with my tasks. Read More
How to Fix QuickBook𝘀 Crashes on Startup in Windows 11
I’m facing a frustrating issue with QuickBook𝘀 that I hope someone can help me with. Every time I try to launch QuickBook𝘀, it crashes immediately on startup, and I’m unable to access any of my financial data.
I’m facing a frustrating issue with QuickBook𝘀 that I hope someone can help me with. Every time I try to launch QuickBook𝘀, it crashes immediately on startup, and I’m unable to access any of my financial data. Read More
Excel Chess Games Viewer 2.1
Excel Chess Games Viewer 2.1 is a slightly upgraded version of my Excel Chess Games Viewer 2.0, which now includes an option to flip the chessboard, and 77 of the most famous chess games ever.
Can you guess the brilliant move 29 for Black, in the game below?
Happy International Chess Day!
Excel Chess Games Viewer 2.1 is a slightly upgraded version of my Excel Chess Games Viewer 2.0, which now includes an option to flip the chessboard, and 77 of the most famous chess games ever. Can you guess the brilliant move 29 for Black, in the game below? Happy International Chess Day! Read More
New Blog | Leveraging insider risk visibility to strengthen your data security
Recent research reveals that insider risks are surging more each day. Over the past year, an alarming 63%[1] of data breaches were traced back to insiders, whether through inadvertent errors or malicious intent. These internal threats call for innovative solutions that can dynamically adapt to data security risks, instead of the widely available fragmented and one-size-fits-all solutions, where rigid controls can stymie legitimate business activities and lenient policies might leave the door open to data loss.
Striking the right balance between productivity and data security is critical, and that’s where the user visibility of Microsoft Purview Insider Risk Management, combined with the dynamic controls of Adaptive Protection, can help. These solutions enable organizations to tailor data protection strategies by integrating insider risk levels, determined by user activities, with different policy engines, allowing for automatic adjustments of policies as insider risk levels change.
Microsoft Purview Insider Risk Management correlates various signals, such as unusual access patterns and data exfiltration, to identify potential malicious or inadvertent insider risks, including IP theft, data leakage, and security violations. Insider Risk Management enables customers to create data handling policies based on their own internal policies, governance, and organizational requirements. Built with privacy by design, users are pseudonymized by default, and role-based access controls and audit logs are in place to help ensure user-level privacy.
The evolution of dynamic controls with Adaptive Protection within access management
This week we’re thrilled to announce the general availability of the integration between Adaptive Protection in Microsoft Purview and Microsoft Entra Conditional Access. Organizations frequently struggle to implement effective data security and access management because they rely on fragmented and siloed solutions. These disjointed approaches hinder the consistent rollout of new security controls and can create exploitable gaps. Microsoft’s integration of Adaptive Protection and Conditional Access, however, offers a streamlined and integrated solution that seamlessly automates access controls for users based on their insider risk levels, thereby reducing the complexity of managing multiple disparate systems.
Consider a scenario where an employee at an organization is flagged as a potential insider risk; they are working on a sensitive project and they start to demonstrate risky activity detected in Insider Risk Management. With the integration of Adaptive Protection and Conditional Access, the organization can swiftly apply access policies to this employee if needed, and these policy controls can increase as the employee’s activities become riskier. The policy will then automatically ramp up controls and can restrict access to critical applications and systems without manual involvement of the data security admin, thus adding a protective layer against insider risks.
In Conditional Access, admins can now combine insights on insider and sign-in risks, to protect data against both external and internal threats with a comprehensive and multi-layered security strategy against unauthorized access, data leaks, and theft. With Conditional Access now being used to tackle both external and insider threats, your data remains secure, thereby bolstering your organization’s resilience against evolving cyber threats.
Read the full post here: Leveraging insider risk visibility to strengthen your data security
By Nathalia Borges
Recent research reveals that insider risks are surging more each day. Over the past year, an alarming 63%[1] of data breaches were traced back to insiders, whether through inadvertent errors or malicious intent. These internal threats call for innovative solutions that can dynamically adapt to data security risks, instead of the widely available fragmented and one-size-fits-all solutions, where rigid controls can stymie legitimate business activities and lenient policies might leave the door open to data loss.
Striking the right balance between productivity and data security is critical, and that’s where the user visibility of Microsoft Purview Insider Risk Management, combined with the dynamic controls of Adaptive Protection, can help. These solutions enable organizations to tailor data protection strategies by integrating insider risk levels, determined by user activities, with different policy engines, allowing for automatic adjustments of policies as insider risk levels change.
Microsoft Purview Insider Risk Management correlates various signals, such as unusual access patterns and data exfiltration, to identify potential malicious or inadvertent insider risks, including IP theft, data leakage, and security violations. Insider Risk Management enables customers to create data handling policies based on their own internal policies, governance, and organizational requirements. Built with privacy by design, users are pseudonymized by default, and role-based access controls and audit logs are in place to help ensure user-level privacy.
The evolution of dynamic controls with Adaptive Protection within access management
This week we’re thrilled to announce the general availability of the integration between Adaptive Protection in Microsoft Purview and Microsoft Entra Conditional Access. Organizations frequently struggle to implement effective data security and access management because they rely on fragmented and siloed solutions. These disjointed approaches hinder the consistent rollout of new security controls and can create exploitable gaps. Microsoft’s integration of Adaptive Protection and Conditional Access, however, offers a streamlined and integrated solution that seamlessly automates access controls for users based on their insider risk levels, thereby reducing the complexity of managing multiple disparate systems.
Consider a scenario where an employee at an organization is flagged as a potential insider risk; they are working on a sensitive project and they start to demonstrate risky activity detected in Insider Risk Management. With the integration of Adaptive Protection and Conditional Access, the organization can swiftly apply access policies to this employee if needed, and these policy controls can increase as the employee’s activities become riskier. The policy will then automatically ramp up controls and can restrict access to critical applications and systems without manual involvement of the data security admin, thus adding a protective layer against insider risks.
In Conditional Access, admins can now combine insights on insider and sign-in risks, to protect data against both external and internal threats with a comprehensive and multi-layered security strategy against unauthorized access, data leaks, and theft. With Conditional Access now being used to tackle both external and insider threats, your data remains secure, thereby bolstering your organization’s resilience against evolving cyber threats.
Figure 1: New ‘insider risk’ condition in Conditional Access
Read the full post here: Leveraging insider risk visibility to strengthen your data security Read More
Windows Update Error 0x800f0983 Cumulative Update for Windows 11 Insider Preview (10.0.26120.1252)
Hi,
I can’t install the Cumulative Update for Windows 11 Insider Preview (10.0.26120.1252) (KB5038603) on Windows Update, it shows the error 0x800f0983. I’m Brazilian and I’m deaf too… The English language is very hard for me… I have the Insider Preview, Dev Channel, installed on my Windows 11 PRO.
The Diagnostics Tools for Repair the Windows Update doesn’t works, and I already try the REM command to change the CatRoot2 folder name, but its fails due to banned permission rights.
I need help, please…
Hi, I can’t install the Cumulative Update for Windows 11 Insider Preview (10.0.26120.1252) (KB5038603) on Windows Update, it shows the error 0x800f0983. I’m Brazilian and I’m deaf too… The English language is very hard for me… I have the Insider Preview, Dev Channel, installed on my Windows 11 PRO. The Diagnostics Tools for Repair the Windows Update doesn’t works, and I already try the REM command to change the CatRoot2 folder name, but its fails due to banned permission rights. I need help, please… Read More
Project for Web – Project Access issues
Hi, We have all our projects on Project for Web. All of a sudden since a couple of days ago the project managers and also resources are not able to access some of their projects. I am not able to pinpoint a pattern to which projects. It is happening to multiple projects and every person has access limits to one or more projects. For example PM1 has access to his Project1 but not to Project2. The resource1 who is assigned to both of these projects can not open either of them. Also this started last week. So until last week they were all able to access all their projects!
How can I troubleshoot this?
This is the error they get on Microsoft Project Web:
this is the error they get when trying to open the app on Project Model Driven App:
Hi, We have all our projects on Project for Web. All of a sudden since a couple of days ago the project managers and also resources are not able to access some of their projects. I am not able to pinpoint a pattern to which projects. It is happening to multiple projects and every person has access limits to one or more projects. For example PM1 has access to his Project1 but not to Project2. The resource1 who is assigned to both of these projects can not open either of them. Also this started last week. So until last week they were all able to access all their projects! How can I troubleshoot this? This is the error they get on Microsoft Project Web: this is the error they get when trying to open the app on Project Model Driven App: Read More
iOS Personal Not Installing Required Applications
I configured Intune to setup BYOD iOS personal devices.
Everything was working. I retired my phone from Intune so that I could document the process. After documenting the process, I noticed that the required applications were not installing even after several days. While my phone shows Compliant in Intune, I did noticed that the Serial and Phone numbers of the phone were not being populated in the Overview.
Also I check the help & support page. After running my email address, this came up:
Any help would be appreciated.
I configured Intune to setup BYOD iOS personal devices. Everything was working. I retired my phone from Intune so that I could document the process. After documenting the process, I noticed that the required applications were not installing even after several days. While my phone shows Compliant in Intune, I did noticed that the Serial and Phone numbers of the phone were not being populated in the Overview. Also I check the help & support page. After running my email address, this came up: Any help would be appreciated. Read More
Copy rows from one set of sheets to another set of sheets, based on a condition
Hey all!
Newbie, and could use some help, as I am not sure of the best way to achieve what I’m hoping to do :grinning_face:
Effectively, various focus areas for a company have been identified (IT, HR, FINANCE, COMMS, SALES). One sheet for each.
Each focus area has tasks assigned there.
Each of these tasks is assigned to a specific region (South, North, West, East, Central). One sheet per each.
There are five focus areas, and five regions
So, looking at the ‘IT” sheet, I want all the tasks taking place in the SOUTH to be copied to a ‘SOUTH’ sheet
Then, still looking at the ‘ IT’ sheet, I want all the tasks taking place in the “NORTH’ to be copied to NORTH’ sheet.
You’d make your way through all the IT tasks, then HR then finance, then comms, then sales, with tasks for each copied to a new sheet correlating with the region.
Basically, every task that’s assigned to a focus area will be copied to its respective region tab.
I’ve seen examples of copying one or even two to another tab, but really not sure how it operates with multiples!
Pls note, the other columns (C to E) are blank now, but will have data later. I also cannot lump all the focus areas into a single sheet 🙁
Graphics below!
Thank you!
Hey all!Newbie, and could use some help, as I am not sure of the best way to achieve what I’m hoping to do :grinning_face: Effectively, various focus areas for a company have been identified (IT, HR, FINANCE, COMMS, SALES). One sheet for each. Each focus area has tasks assigned there. Each of these tasks is assigned to a specific region (South, North, West, East, Central). One sheet per each. There are five focus areas, and five regions So, looking at the ‘IT” sheet, I want all the tasks taking place in the SOUTH to be copied to a ‘SOUTH’ sheet Then, still looking at the ‘ IT’ sheet, I want all the tasks taking place in the “NORTH’ to be copied to NORTH’ sheet. You’d make your way through all the IT tasks, then HR then finance, then comms, then sales, with tasks for each copied to a new sheet correlating with the region. Basically, every task that’s assigned to a focus area will be copied to its respective region tab. I’ve seen examples of copying one or even two to another tab, but really not sure how it operates with multiples! Pls note, the other columns (C to E) are blank now, but will have data later. I also cannot lump all the focus areas into a single sheet 🙁 Graphics below! Thank you! Read More
Update booking events to individual staff member’s office 365 calendar
How to update individual staff member’s calendar with the booking events?
How to update individual staff member’s calendar with the booking events? Read More
VBA
Need to find errors in this excel VBA Code
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ws As Worksheet
Set ws = Me
Dim selectedQueue As String
Dim col As Integer
Dim cell As Range
Dim queueFound As Boolean
Dim i As Long
‘ Handle queue selection in cell A1
If Not Intersect(Target, Range(“A1”)) Is Nothing Then
selectedQueue = ws.Range(“A1”).Value
queueFound = False
‘ Unhide/hide columns based on queue selection
On Error GoTo ErrorHandler
Application.ScreenUpdating = False
‘ Loop through columns G to CZ
For col = 7 To 104
If ws.Cells(5, col).MergeCells Then
Set cell = ws.Cells(5, col).MergeArea
If Not IsError(cell.Cells(1, 1).Value) And Not IsEmpty(cell.Cells(1, 1).Value) Then
If Trim(CStr(cell.Cells(1, 1).Value)) = Trim(selectedQueue) Or Trim(selectedQueue) = “All Queues” Then
‘ Unhide the columns if they are hidden
If cell.Columns.Hidden Then
cell.Columns.Hidden = False
End If
‘ Select the first cell of the unhidden merged area
cell.Cells(1, 1).Select
queueFound = True
Else
‘ Hide the columns if they are not the selected queue
cell.Columns.Hidden = True
End If
End If
Else
‘ If the column is blank, hide it
ws.Columns(col).Hidden = True
End If
Next col
‘ If “All Queues” is selected, show all queues data
If selectedQueue = “All Queues” Then
For col = 7 To 104
ws.Columns(col).Hidden = False
Next col
queueFound = True
End If
‘ If the queue is not found, show a message
If Not queueFound Then
MsgBox “Queue not found in row 5.”
End If
Application.ScreenUpdating = True
Exit Sub
ErrorHandler:
MsgBox “An error occurred: ” & Err.Description
Application.ScreenUpdating = True
End If
‘ Handle status changes and timestamping
If Not Intersect(Target, Range(“G6:G1000”)) Is Nothing Then
If Not IsEmpty(Target) Then
‘ Define headers and their corresponding columns
Dim headers As Variant
headers = Array(“Status”, “Commence”, “Awaiting”, “Re-Picked”, “Completed”)
Dim headerCol As Integer
Dim statusCol As Integer
Dim timestampCol As Integer
‘ Find the header columns
For i = LBound(headers) To UBound(headers)
headerCol = Application.Match(headers(i), ws.Rows(6), 0)
If headers(i) = “Status” Then statusCol = headerCol
If Target.Column = statusCol Then
‘ Get corresponding timestamp column
Select Case Target.Value
Case “Commence”
timestampCol = Application.Match(“Commence”, ws.Rows(6), 0)
Case “Awaiting”
timestampCol = Application.Match(“Awaiting”, ws.Rows(6), 0)
Case “Re-Picked”
timestampCol = Application.Match(“Re-Picked”, ws.Rows(6), 0)
Case “Completed”
timestampCol = Application.Match(“Completed”, ws.Rows(6), 0)
End Select
‘ Insert timestamp
If timestampCol > 0 Then
ws.Cells(Target.Row, timestampCol).Value = Now
End If
End If
Next i
End If
End If
End Sub
Need to find errors in this excel VBA Code Private Sub Worksheet_Change(ByVal Target As Range)Dim ws As WorksheetSet ws = MeDim selectedQueue As StringDim col As IntegerDim cell As RangeDim queueFound As BooleanDim i As Long’ Handle queue selection in cell A1If Not Intersect(Target, Range(“A1”)) Is Nothing ThenselectedQueue = ws.Range(“A1”).ValuequeueFound = False’ Unhide/hide columns based on queue selectionOn Error GoTo ErrorHandlerApplication.ScreenUpdating = False’ Loop through columns G to CZFor col = 7 To 104If ws.Cells(5, col).MergeCells ThenSet cell = ws.Cells(5, col).MergeAreaIf Not IsError(cell.Cells(1, 1).Value) And Not IsEmpty(cell.Cells(1, 1).Value) ThenIf Trim(CStr(cell.Cells(1, 1).Value)) = Trim(selectedQueue) Or Trim(selectedQueue) = “All Queues” Then’ Unhide the columns if they are hiddenIf cell.Columns.Hidden Thencell.Columns.Hidden = FalseEnd If’ Select the first cell of the unhidden merged areacell.Cells(1, 1).SelectqueueFound = TrueElse’ Hide the columns if they are not the selected queuecell.Columns.Hidden = TrueEnd IfEnd IfElse’ If the column is blank, hide itws.Columns(col).Hidden = TrueEnd IfNext col’ If “All Queues” is selected, show all queues dataIf selectedQueue = “All Queues” ThenFor col = 7 To 104ws.Columns(col).Hidden = FalseNext colqueueFound = TrueEnd If’ If the queue is not found, show a messageIf Not queueFound ThenMsgBox “Queue not found in row 5.”End IfApplication.ScreenUpdating = TrueExit SubErrorHandler:MsgBox “An error occurred: ” & Err.DescriptionApplication.ScreenUpdating = TrueEnd If’ Handle status changes and timestampingIf Not Intersect(Target, Range(“G6:G1000”)) Is Nothing ThenIf Not IsEmpty(Target) Then’ Define headers and their corresponding columnsDim headers As Variantheaders = Array(“Status”, “Commence”, “Awaiting”, “Re-Picked”, “Completed”)Dim headerCol As IntegerDim statusCol As IntegerDim timestampCol As Integer’ Find the header columnsFor i = LBound(headers) To UBound(headers)headerCol = Application.Match(headers(i), ws.Rows(6), 0)If headers(i) = “Status” Then statusCol = headerColIf Target.Column = statusCol Then’ Get corresponding timestamp columnSelect Case Target.ValueCase “Commence”timestampCol = Application.Match(“Commence”, ws.Rows(6), 0)Case “Awaiting”timestampCol = Application.Match(“Awaiting”, ws.Rows(6), 0)Case “Re-Picked”timestampCol = Application.Match(“Re-Picked”, ws.Rows(6), 0)Case “Completed”timestampCol = Application.Match(“Completed”, ws.Rows(6), 0)End Select’ Insert timestampIf timestampCol > 0 Thenws.Cells(Target.Row, timestampCol).Value = NowEnd IfEnd IfNext iEnd IfEnd IfEnd Sub Read More
Assistance Needed: SQL Server 2019 Log Shipping for SharePoint SQL FCI Database
I hope this message finds you well.
I need some information regarding SQL Server 2019. Our client requires a Disaster Recovery (DR) solution for their SharePoint SQL Failover Cluster Instance (FCI) database. As they do not have an enterprise license, we need to use the standard edition, which necessitates an FCI for High Availability (HA).
We are considering configuring log shipping for DR purposes. However, I have come across some information suggesting that log shipping may not be supported with an FCI. Could anyone confirm whether this is the case? If it is supported, are there any specific considerations or best practices we should be aware of?
I hope this message finds you well.I need some information regarding SQL Server 2019. Our client requires a Disaster Recovery (DR) solution for their SharePoint SQL Failover Cluster Instance (FCI) database. As they do not have an enterprise license, we need to use the standard edition, which necessitates an FCI for High Availability (HA).We are considering configuring log shipping for DR purposes. However, I have come across some information suggesting that log shipping may not be supported with an FCI. Could anyone confirm whether this is the case? If it is supported, are there any specific considerations or best practices we should be aware of? Read More
Where does Windows 11 store File History
I had File History running in Windows for a while, probably staring under WIndows 10. I could go the the drive where History was stored and browse through the versions of files there with File Explorer. I recently discovered, to my horror, that File History was NOT running on my machine. I started it up, and it is now running. However when I go to the drive where the files are to be copied, I can”t find them. I find old ones from last year, with the date & time added to each version, but nothing new. When I use the built in restore feature I can see a few recent versions of a file that is updated every weekday. But I can NOT find anything using File Explorer. Google has let me down, Microsoft Help has let me down. I have found nothing about WHERE the files are stored.
(I’m no Windows expert but I’ve been using it since the Windows NT days, when I was a Microsoft SQL Server MVP. I’m long retired, but not a complete newby.)
I had File History running in Windows for a while, probably staring under WIndows 10. I could go the the drive where History was stored and browse through the versions of files there with File Explorer. I recently discovered, to my horror, that File History was NOT running on my machine. I started it up, and it is now running. However when I go to the drive where the files are to be copied, I can”t find them. I find old ones from last year, with the date & time added to each version, but nothing new. When I use the built in restore feature I can see a few recent versions of a file that is updated every weekday. But I can NOT find anything using File Explorer. Google has let me down, Microsoft Help has let me down. I have found nothing about WHERE the files are stored.(I’m no Windows expert but I’ve been using it since the Windows NT days, when I was a Microsoft SQL Server MVP. I’m long retired, but not a complete newby.) Read More
Attachment Column from List not showing up in Forms
I am trying to build a List to feed my forms, and I’m hoping to allow those who fill out the form to be able to add an attachment. Is this possible? I was able to add an attachments column in my list, but it’s not showing up as a field option when I create the form.
I am trying to build a List to feed my forms, and I’m hoping to allow those who fill out the form to be able to add an attachment. Is this possible? I was able to add an attachments column in my list, but it’s not showing up as a field option when I create the form. Read More