Category: Microsoft
Category Archives: Microsoft
HP SpareKey recovery issue
I’ve tried windows + b twice put that didn’t work and neither did ctrl + alt +delete.
Booted my pc up its never had problem for the 3 years I have had it and I was brought to this screen.
I can’t find an hp sparekey usb recovery key on the internet either!
Any help would be greatly appreciated.
I’ve tried windows + b twice put that didn’t work and neither did ctrl + alt +delete. Booted my pc up its never had problem for the 3 years I have had it and I was brought to this screen.I can’t find an hp sparekey usb recovery key on the internet either! Any help would be greatly appreciated. Read More
stop your computer from locking
This is a useful trick to stop your computer from locking.
write “… screen will be awake for $minutes”
$myshell = New-Object -com “Wscript.Shell”
for ($i = 0; $i -lt $minutes; $i++) {
write “… screen will be awake for” ($minutes-$i)
Start-Sleep -Seconds 60
$myshell.sendkeys(“{NUMLOCK}{NUMLOCK}”)
}
This is a useful trick to stop your computer from locking. Code:param($minutes = 9999)
write “… screen will be awake for $minutes”
$myshell = New-Object -com “Wscript.Shell”
for ($i = 0; $i -lt $minutes; $i++) {
write “… screen will be awake for” ($minutes-$i)
Start-Sleep -Seconds 60
$myshell.sendkeys(“{NUMLOCK}{NUMLOCK}”)
} Read More
File search based on Excel list
Hello everyone,
I have this Excel list with approximately 200 names and I would like to perform a file explorer search of the files NOT containing any of the names in this list.
Any idea how to do this?
Thank you very much,
Hello everyone, I have this Excel list with approximately 200 names and I would like to perform a file explorer search of the files NOT containing any of the names in this list. Any idea how to do this?Thank you very much, Read More
Surface Laptop 7 BatteryDm.exe Stopped Working
I have two new Surface Laptop 7. One with the 13.8″ screen, plus processor, and 16GM RAM and one with 15″ screen, the elite processor, and 64GB Ram.
On both after a few weeks of using it I see in the Reliability History a lot of critical errors of the Batter Service Stopped Working. Some info on the error includes the bellow.
On both, it looks like the errors started after several weeks of using the machines. In the last week on the 15″, there is only one day I do not see the error. some days there is only a 2 or 3 instances. Some days there are dozens.
MS Support does not have any answer on this and at this point states live with it or return it.
Considering it is happening on two separate machines, I am thinking it is not a hardware issue and instead something with the drivers or firmware and getting a new machine I may see the same thing.
Besides seeing the error, I do not see any performance issues. On the 15″ one day I did have it where the charging light was lit but it was not charging and a restart solved that. I had the errors both before and after that restart.
All drivers are up to date and all windows apps are up to date.
SFC /scannow shows no issues.
Any ideas?
I have two new Surface Laptop 7. One with the 13.8″ screen, plus processor, and 16GM RAM and one with 15″ screen, the elite processor, and 64GB Ram. On both after a few weeks of using it I see in the Reliability History a lot of critical errors of the Batter Service Stopped Working. Some info on the error includes the bellow. On both, it looks like the errors started after several weeks of using the machines. In the last week on the 15″, there is only one day I do not see the error. some days there is only a 2 or 3 instances. Some days there are dozens.MS Support does not have any answer on this and at this point states live with it or return it.Considering it is happening on two separate machines, I am thinking it is not a hardware issue and instead something with the drivers or firmware and getting a new machine I may see the same thing.Besides seeing the error, I do not see any performance issues. On the 15″ one day I did have it where the charging light was lit but it was not charging and a restart solved that. I had the errors both before and after that restart. All drivers are up to date and all windows apps are up to date.SFC /scannow shows no issues.Any ideas? Read More
Odd behavior across multiple PCs
PC1 = desktop 9900k/2060 Win 11 Pro
PC2 = multimedia 4790K/1030 Win 10 Home
PC3 = laptop i3/HD5500 Win 10 Home
PC4 = desktop 7800X3D/4070 Win 11 Pro
The only common thing between them is my Microsoft account. This happens on all 4 PCs:
First problem is that when logging in, the language selector shows on taskbar, despite being hidden. I use US language for OS with another one for my keyboard. If I sign out and back in, the circle loading icon and cursor will stutter, I get to desktop and language selector is gone.
The second problem that I think is related to the first one is random stutters. Again this happens now and then on all 4 PCs. My sign in background is also black, even on the new PC.
I don’t have account sync on and this started happening about 2 years ago on PC1, before I got the other PCs. I pretty much have up and accepted it, but when I recently got PC4 that have the same problem, it was just too much for me.
I hope someone got a solution.
PC1 = desktop 9900k/2060 Win 11 ProPC2 = multimedia 4790K/1030 Win 10 HomePC3 = laptop i3/HD5500 Win 10 HomePC4 = desktop 7800X3D/4070 Win 11 Pro The only common thing between them is my Microsoft account. This happens on all 4 PCs:First problem is that when logging in, the language selector shows on taskbar, despite being hidden. I use US language for OS with another one for my keyboard. If I sign out and back in, the circle loading icon and cursor will stutter, I get to desktop and language selector is gone. The second problem that I think is related to the first one is random stutters. Again this happens now and then on all 4 PCs. My sign in background is also black, even on the new PC. I don’t have account sync on and this started happening about 2 years ago on PC1, before I got the other PCs. I pretty much have up and accepted it, but when I recently got PC4 that have the same problem, it was just too much for me. I hope someone got a solution. Read More
Parsing a JSON string in sqlserver
I am attempting a JSON string. The expected output is
TVSTP45743 0 DBSSINB0XXX ICICI BANK LIMITED addr1
TVSTP45743 0 DBSSINB0XXX ICICI BANK LIMITED addr2
Please help me
/*
EXEC [dbo].[API_JCRUD_DBS_RTGS_ACK33]
‘{
“header”: {
“msgId”: “TVSTP45743”
},
“txnResponses”: [{
“chargesAmount”: “0”,
“senderParty”: {
“swiftBic”: “DBSSINB0XXX”
},
“receivingParty”: {
“bankName”: “ICICI BANK LIMITED”,
“bankAddresses”: [{
“address”: “addr1”
},
{
“address”: “addr2”
}]
}
}]
}’
*/
alter PROCEDURE [dbo].[API_JCRUD_DBS_RTGS_ACK33]
@pJson VARCHAR(MAX)
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
BEGIN TRAN
select a.msgId,
b.responseType,
b.senderPartyswiftBic,
b.receivingPartybankName,
c.address1
FROM OPENJSON(@pJson)
WITH
(
msgId VARCHAR(100) N’$.header.msgId’,
txnResponses NVARCHAR(MAX) AS JSON
) as a
CROSS APPLY OPENJSON(a.txnResponses)
WITH
(
responseType VARCHAR(100) ‘$.chargesAmount’,
senderPartyswiftBic VARCHAR(100) ‘$.senderParty.swiftBic’,
receivingPartybankName VARCHAR(100) ‘$.receivingParty.bankName’,
bankAddresses NVARCHAR(MAX) AS JSON
) as b
CROSS APPLY OPENJSON(b.bankAddresses)
WITH (
address1 VARCHAR(100) ‘$.address’
) as c;
COMMIT TRAN
END TRY
BEGIN CATCH
END CATCH
end
I am attempting a JSON string. The expected output isTVSTP45743 0 DBSSINB0XXX ICICI BANK LIMITED addr1TVSTP45743 0 DBSSINB0XXX ICICI BANK LIMITED addr2 Please help me /*EXEC [dbo].[API_JCRUD_DBS_RTGS_ACK33]'{“header”: {“msgId”: “TVSTP45743″},”txnResponses”: [{“chargesAmount”: “0”,”senderParty”: {“swiftBic”: “DBSSINB0XXX”},”receivingParty”: {“bankName”: “ICICI BANK LIMITED”,”bankAddresses”: [{“address”: “addr1”},{“address”: “addr2”}]}}]}’*/alter PROCEDURE [dbo].[API_JCRUD_DBS_RTGS_ACK33]@pJson VARCHAR(MAX)ASBEGINSET NOCOUNT ON;BEGIN TRYBEGIN TRANselect a.msgId,b.responseType,b.senderPartyswiftBic,b.receivingPartybankName,c.address1FROM OPENJSON(@pJson)WITH(msgId VARCHAR(100) N’$.header.msgId’,txnResponses NVARCHAR(MAX) AS JSON) as aCROSS APPLY OPENJSON(a.txnResponses)WITH(responseType VARCHAR(100) ‘$.chargesAmount’,senderPartyswiftBic VARCHAR(100) ‘$.senderParty.swiftBic’,receivingPartybankName VARCHAR(100) ‘$.receivingParty.bankName’,bankAddresses NVARCHAR(MAX) AS JSON) as bCROSS APPLY OPENJSON(b.bankAddresses)WITH (address1 VARCHAR(100) ‘$.address’) as c;COMMIT TRANEND TRYBEGIN CATCHEND CATCHend Read More
I need a best & safe FB video downloader for PC Windows 11
I recently prepared some teaching materials and needed to download videos from FB for classroom demonstrations. I have tried some online FB video downloader tools before, but they either had too many ads, were slow, or had errors halfway through downloading, which really affected my efficiency. I am also quite worried that these tools may cause security issues, such as viruses or malware.
I use Windows 11 and want to find a stable and secure FB video downloader, preferably one that can download in batches to save time. Has anyone used this kind of tool and can recommend a reliable one? The quality of the video after downloading should not be too bad, and it would be better if it can maintain clarity.
I recently prepared some teaching materials and needed to download videos from FB for classroom demonstrations. I have tried some online FB video downloader tools before, but they either had too many ads, were slow, or had errors halfway through downloading, which really affected my efficiency. I am also quite worried that these tools may cause security issues, such as viruses or malware. I use Windows 11 and want to find a stable and secure FB video downloader, preferably one that can download in batches to save time. Has anyone used this kind of tool and can recommend a reliable one? The quality of the video after downloading should not be too bad, and it would be better if it can maintain clarity. Read More
microsoft defender won’t open
The other day, when I initialized Defender without inheriting the folder, an error message saying [Restricted by IT administrator] appeared and I was unable to scan.
While investigating various things, I was able to find out that the problem was caused by the disappearance of the contents of the [C:WindowsSystem32SecurityHealth] folder. In order to recover the folders inside this, I opened a site from Microsoft Support where you can download update files.
I’m stuck with an error message like this and can’t download it.
<エラー>
<コード: >BlobNotFound</コード>
<メッセージ>指定された BLOB は存在しません。RequestId:fb236ec3-901e-0030-050d-0660bc00000時間:2024-09-13T18:44:50.0004525Z</メッセージ>
</エラー>
I’ve managed to revive it, but if anyone knows what to do, please let me know <(_ _)>
The other day, when I initialized Defender without inheriting the folder, an error message saying [Restricted by IT administrator] appeared and I was unable to scan.
While investigating various things, I was able to find out that the problem was caused by the disappearance of the contents of the [C:WindowsSystem32SecurityHealth] folder. In order to recover the folders inside this, I opened a site from Microsoft Support where you can download update files.
I’m stuck with an error message like this and can’t download it. <エラー><コード: >BlobNotFound</コード><メッセージ>指定された BLOB は存在しません。RequestId:fb236ec3-901e-0030-050d-0660bc00000時間:2024-09-13T18:44:50.0004525Z</メッセージ></エラー> I’ve managed to revive it, but if anyone knows what to do, please let me know <(_ _)> Read More
Charts with multiple series
I’m on a version of Excel that seems to be nowhere to be found anywhere else on the internet, so I haven’t found any meaningful help so far. I need to create a chart with 3 series out of a single set of data. I haven’t been able to figure out how to properly make a chart how I want. In the attached image, I have 2 charts. I need to make the top one look like the bottom one and I don’t have the SLIGHTEST idea how to do it. I do need to keep the data in 3 separate series, unless there is a way to make a trendline for a specific portion of a single series. Any help is appreciated.
I’m on a version of Excel that seems to be nowhere to be found anywhere else on the internet, so I haven’t found any meaningful help so far. I need to create a chart with 3 series out of a single set of data. I haven’t been able to figure out how to properly make a chart how I want. In the attached image, I have 2 charts. I need to make the top one look like the bottom one and I don’t have the SLIGHTEST idea how to do it. I do need to keep the data in 3 separate series, unless there is a way to make a trendline for a specific portion of a single series. Any help is appreciated. Read More
Exceld file has spaces from the print preview?
Our Excel file has an edge on a Mac on the top and on the right side. So it is only displayed when we have clicked on printing. We don’t want to have this area. This is not the case with another HP printer from us. We have already tried everything possible to change in the print preview, like:
-Printing area to change
-Without spaces in DIN A4 print
-Spaces like with other printer with which it works
-Searching for empty lines and crevices
Image of edge in the print preview in the appendix (The area of the “added” spaces is marked):
Our Excel file has an edge on a Mac on the top and on the right side. So it is only displayed when we have clicked on printing. We don’t want to have this area. This is not the case with another HP printer from us. We have already tried everything possible to change in the print preview, like: -Printing area to change -Without spaces in DIN A4 print -Spaces like with other printer with which it works-Searching for empty lines and crevices Image of edge in the print preview in the appendix (The area of the “added” spaces is marked): Read More
Export MS ToDo from gmail account?
I set up a MS ToDo with a gmail account.
I now have a microsoft account as I want to use the TimeBlocking function from ToDo in Outlook.
I therefore want to export that gmail-based ToDo into the new MS account ToDo.
I have quite a lot in it so don’t want to have recreate every list.
Googling seems to suggest I can only export from an MS account within Outlook – the Export My Data in the android app takes me to a website showing how to do it in Outlook. And in Outlook when I try, it says “You can’t export email calendar items or contact for nonOutlook mailbox here.” (this the ‘new’ outlook in Windows 11).
Surely there is a way to export all my ToDo lists and tasks from my gmail linked MS Todo!!
I set up a MS ToDo with a gmail account.I now have a microsoft account as I want to use the TimeBlocking function from ToDo in Outlook.I therefore want to export that gmail-based ToDo into the new MS account ToDo.I have quite a lot in it so don’t want to have recreate every list.Googling seems to suggest I can only export from an MS account within Outlook – the Export My Data in the android app takes me to a website showing how to do it in Outlook. And in Outlook when I try, it says “You can’t export email calendar items or contact for nonOutlook mailbox here.” (this the ‘new’ outlook in Windows 11). Surely there is a way to export all my ToDo lists and tasks from my gmail linked MS Todo!! Read More
Installing Windows 11 build 27695 but stuck on boot
It has been 44 minutes and never bypass the boot screen on my Dell PC. Is this normal?
It has been 44 minutes and never bypass the boot screen on my Dell PC. Is this normal? Read More
duplicate photos in the gallery
i was on my pc last night and connected to my phone and was trying to delete phots on the phone thru the pc. and managed to delete all of them using ctrl a . i figured i could just put them back with google but that seemed pointless because i see them on the phone anyway and now i just put new photos on an sd card because it is way easier to get them in the proper ofer for coping to the pc.
anyway as i was doing this i saw a folder called gallery on the file explorer and when i clicked it i had tons of duplicate photos. where is that gallery folder locater so i can just delete that folder to get rid of all those dupes and just copy back the originals? i’m figuring win11 is getting them from my picture section anywaywhen i open my other pc it has photos that i have on that pc and it seems just a few are duplicated in the first few lines of photos so on that pc it should be easy enough to delete the dupes. but on this pc there are tons and tons of dupes. so i’m hoping by deleting the gallery folder and then creating it again i will only get the originals. if not then i will just format the drive and re install win10.
i was on my pc last night and connected to my phone and was trying to delete phots on the phone thru the pc. and managed to delete all of them using ctrl a . i figured i could just put them back with google but that seemed pointless because i see them on the phone anyway and now i just put new photos on an sd card because it is way easier to get them in the proper ofer for coping to the pc.anyway as i was doing this i saw a folder called gallery on the file explorer and when i clicked it i had tons of duplicate photos. where is that gallery folder locater so i can just delete that folder to get rid of all those dupes and just copy back the originals? i’m figuring win11 is getting them from my picture section anywaywhen i open my other pc it has photos that i have on that pc and it seems just a few are duplicated in the first few lines of photos so on that pc it should be easy enough to delete the dupes. but on this pc there are tons and tons of dupes. so i’m hoping by deleting the gallery folder and then creating it again i will only get the originals. if not then i will just format the drive and re install win10. Read More
Desktop PC Freezing yet powered on.
Lately I’ve been experiencing a problem with my desktop PC .. It is a custom build.
1st the problem. Each morning I go to check the logs from last night’s backup. Lately and without any pattern I’ll occasionally find that my desktop, while running, is unresponsive to both my keyboard and mouse clicks. Only by pressing the reset button can I get back into the PC. My build is..
CURRENT SYSTEM COMPONENTS
ASUS AMD AM4 ROG Strix X570-E Gaming ATX Motherboard
AMD Ryzen 9 3950X 16-Core, 32-Thread Unlocked Desktop Processor
CORSAIR Vengeance RGB Pro 64GB (4 x 16GB) 288-Pin DDR4 SDRAM DDR4 3200
Corsair RMx Series (2021), RM850x, 850 Watt, GOLD power supply
ASUS TUF Gaming NVIDIA GeForce RTX 3080 Ti Graphics Card
WD_BLACK 2TB SN850X NVMe – Gen4 PCIe, M.2 2280 – C: (Boot)
WD_BLACK 2TB SN850X NVMe – Gen4 PCIe, M.2 2280 – 😧
Corsair iCUE H150i Elite CAPELLIX XT Liquid CPU Cooler – Three AF120 RGB Elite Fans – 360mm Radiator
Corsair iCUE Elite CPU Cooler LCD Display Upgrade Kit
CORSAIR 7000D AIRFLOW Full-Tower ATX PC Case, Black case
Windows 11 Pro 23H2 Build 22631.3737
Looking at the temps reported by the iCUE LCD the CPU is ~116 F and the pump shows ~95-96 F
I’ve run sfc /scannow with no problems found.
I reviewed the Event logs for System / Application et al and there is nothing in it The log stops at a different time each time with no discernable events that would indicate a problem. In the log I can find the last event date/time and then the messages from hours later when I press the reset to restart the PC.
There is no pattern to the problem. It’ll go a couple of weeks, and the a couple of days. Today it was back to back with yesterday.
Lately I’ve been experiencing a problem with my desktop PC .. It is a custom build.1st the problem. Each morning I go to check the logs from last night’s backup. Lately and without any pattern I’ll occasionally find that my desktop, while running, is unresponsive to both my keyboard and mouse clicks. Only by pressing the reset button can I get back into the PC. My build is.. CURRENT SYSTEM COMPONENTSASUS AMD AM4 ROG Strix X570-E Gaming ATX MotherboardAMD Ryzen 9 3950X 16-Core, 32-Thread Unlocked Desktop ProcessorCORSAIR Vengeance RGB Pro 64GB (4 x 16GB) 288-Pin DDR4 SDRAM DDR4 3200Corsair RMx Series (2021), RM850x, 850 Watt, GOLD power supplyASUS TUF Gaming NVIDIA GeForce RTX 3080 Ti Graphics CardWD_BLACK 2TB SN850X NVMe – Gen4 PCIe, M.2 2280 – C: (Boot)WD_BLACK 2TB SN850X NVMe – Gen4 PCIe, M.2 2280 – 😧Corsair iCUE H150i Elite CAPELLIX XT Liquid CPU Cooler – Three AF120 RGB Elite Fans – 360mm RadiatorCorsair iCUE Elite CPU Cooler LCD Display Upgrade KitCORSAIR 7000D AIRFLOW Full-Tower ATX PC Case, Black caseWindows 11 Pro 23H2 Build 22631.3737Looking at the temps reported by the iCUE LCD the CPU is ~116 F and the pump shows ~95-96 FI’ve run sfc /scannow with no problems found. I reviewed the Event logs for System / Application et al and there is nothing in it The log stops at a different time each time with no discernable events that would indicate a problem. In the log I can find the last event date/time and then the messages from hours later when I press the reset to restart the PC. There is no pattern to the problem. It’ll go a couple of weeks, and the a couple of days. Today it was back to back with yesterday. Read More
Annoying problem
Before I begin has anything happened to the forum as it will not take my old login details, saying they are incorrect?
Anyway over the past few weeks have noticed a problem that is either getting worse or I perceive it so. That is namely the speed with which a site loads. My internet speed is around 35Mbps, I know not fast but way bigger than it used to be and when I did not experience this problem. I will click on a website and all I get is the blue dot going back and forth for up to 10 seconds and then I get a timeout message. If I open multiple sites I am stuck with the last one as it seems to get priority, in doing nothing. Can happen over a range of sites, new ones and well visited ones.
Annoyingly this scenario is not consistant. At times things load with no delay. Have run AV and malware checks both come back as no problem. Be great if someone could point me in the right direction.
Before I begin has anything happened to the forum as it will not take my old login details, saying they are incorrect? Anyway over the past few weeks have noticed a problem that is either getting worse or I perceive it so. That is namely the speed with which a site loads. My internet speed is around 35Mbps, I know not fast but way bigger than it used to be and when I did not experience this problem. I will click on a website and all I get is the blue dot going back and forth for up to 10 seconds and then I get a timeout message. If I open multiple sites I am stuck with the last one as it seems to get priority, in doing nothing. Can happen over a range of sites, new ones and well visited ones.Annoyingly this scenario is not consistant. At times things load with no delay. Have run AV and malware checks both come back as no problem. Be great if someone could point me in the right direction. Read More
Any way to track the malformed apps at startup?
No ideal for the first two apps on the list. Do they belong to Microsoft service or third-party? very confused for this!
No ideal for the first two apps on the list. Do they belong to Microsoft service or third-party? very confused for this! Read More
Win 11 is a lot slow at boot time
Hi long time no see! I just made a fresh reinstall of my Win 11. And for some odd reason it is slow as f… when booting. I have never seen this before. The BIOS is in secure boot and CSM is turned off and off Couse I use UEFI – all updates are installed also
And disk 4 is my system disk.
More system info:
Hi long time no see! I just made a fresh reinstall of my Win 11. And for some odd reason it is slow as f… when booting. I have never seen this before. The BIOS is in secure boot and CSM is turned off and off Couse I use UEFI – all updates are installed alsoAnd disk 4 is my system disk.More system info: Anyone have and idea ? Read More
How do I download an entire playlist from YT on PC Windows 11
Hi All. I recently encountered a small issue and I’m hoping to find a solution here. I’m using Windows 11 and I need to download an entire playlist from YT to my computer for students to watch, as there’s no internet in the classroom, so the videos have to be viewed offline. I’m looking for a method that’s easy to use. If you have any recommendations or personal experiences, please share them with me. Thank you very much!
Hi All. I recently encountered a small issue and I’m hoping to find a solution here. I’m using Windows 11 and I need to download an entire playlist from YT to my computer for students to watch, as there’s no internet in the classroom, so the videos have to be viewed offline. I’m looking for a method that’s easy to use. If you have any recommendations or personal experiences, please share them with me. Thank you very much! Read More
