Tag Archives: microsoft
My Mouse Pointer Speed always Changes!
I have my mouse speed set to 2 which is comfortable for me. But after a restart or just adjusting an app like my head set it jump’s to 10! And so I have to manually set it back it 2. This is driving me nut having to do this all the time. I fixed this a number of years back like 6 years but I can’t remember what I did to fix it.
I have my mouse speed set to 2 which is comfortable for me. But after a restart or just adjusting an app like my head set it jump’s to 10! And so I have to manually set it back it 2. This is driving me nut having to do this all the time. I fixed this a number of years back like 6 years but I can’t remember what I did to fix it. Read More
Windows required fonts
Using windows 10 and wanting to remove all non-system required fonts, I know 10 uses Segeo UI as it’s default, but which one, I have L,SL,SB,B, Blk, symbols, Variables, historic, script, print, mdl2 assets and regular. Also does Windows require any other fonts to properly run (Terminal, system, roman, Sm Fnts, Calibri,TNR, etc.). Thanks
Using windows 10 and wanting to remove all non-system required fonts, I know 10 uses Segeo UI as it’s default, but which one, I have L,SL,SB,B, Blk, symbols, Variables, historic, script, print, mdl2 assets and regular. Also does Windows require any other fonts to properly run (Terminal, system, roman, Sm Fnts, Calibri,TNR, etc.). Thanks Read More
Filter the Planner Tasks instead of getting all of them inside our power apps planner connector
I have the following formula to get all the planner tasks:-
Collect(colRelatedPlannerTasks,
Planner.ListTasksV3(planner.id,group.Value).value);
now how i can dynamically filter those tasks based on the AssignedTo user and the Completion status? currently i am getting all the tasks and then filter them, but is there a more efficient way so we only get the needed filtered planner tasks?
Thanks
I have the following formula to get all the planner tasks:-Collect(colRelatedPlannerTasks,
Planner.ListTasksV3(planner.id,group.Value).value); now how i can dynamically filter those tasks based on the AssignedTo user and the Completion status? currently i am getting all the tasks and then filter them, but is there a more efficient way so we only get the needed filtered planner tasks? Thanks Read More
Azure SQL Managed Instance Zone Redundancy to begin billing
Azure SQL Managed Instance with Zone Redundancy to begin billing in Italy-North, Israel-Central, and West-Europe
Microsoft Azure continues to enhance its services, ensuring that customers have access to the latest innovations and features. The latest update is particularly exciting for businesses operating in Italy, Israel, and West Europe: Azure SQL Managed Instance with Zone Redundancy is available in these regions and starts billing for all configurations.
What is Azure SQL Managed Instance?
Azure SQL Managed Instance is a fully managed database service that offers the best of SQL Server with the operational and financial benefits of an intelligent, fully managed service. It provides a near-100% compatibility with the latest SQL Server (Enterprise Edition) database engine, which makes it easy to migrate your SQL Server databases to Azure without changing your apps.
Understanding Zone Redundancy
Zone Redundancy is a feature designed to improve the availability and resilience of your database instances. In the context of Azure SQL Managed Instance, Zone Redundancy means that your instances are replicated across multiple availability zones within a region. Each availability zone is a physically separate location with independent power, cooling, and networking. This separation ensures that even in the event of a data center outage, your database remains available and operational.
Benefits of Zone Redundancy
1. Increased Resilience
By replicating your data across multiple zones, you safeguard your applications from data center failures. This redundancy minimizes the risk of downtime and ensures that your critical business applications remain online, providing a more reliable service to your users.
2. Improved Business Continuity
With Zone Redundancy, you can achieve higher availability SLAs. For many businesses, this means meeting stringent uptime requirements and maintaining customer trust by ensuring their services are always available.
3. Cost Efficiency
While Zone Redundancy does come with additional costs, the benefits of reduced downtime and the potential financial impact of data loss often outweigh these expenses. In essence, investing in Zone Redundancy can save your business money in the long run by avoiding costly downtime and data recovery efforts.
How to Enable Zone Redundancy
Enabling Zone Redundancy for your Azure SQL Managed Instance is straightforward:
During Instance Creation:
When creating a new managed instance, you can specify Zone Redundancy in the configuration options.
For Existing Instances:
If you have an existing instance, you can modify its settings to enable Zone Redundancy in configure blade
Microsoft Tech Community – Latest Blogs –Read More
Windows Server 2012R2 patching
Hello Team,
We have in our company some old servers – Windows Server 2012R2. We don’t have ESU.
Now we need to rebuild some of them and install only security patches.
I don’t want to install all single security patches and my patching strategy is:
1. Install cumulative patch KB2919355 and some other patches according to the KB below:
https://www.microsoft.com/en-us/download/details.aspx?id=42334
2. Install the latest SSU(As we don’t have ESU the latest SSU is from september 2023):
KB5030329 2023-09 Servicing Stack Update for Windows Server 2012 R2 for x64-based Systems
3. Install below patches(We don’t have ESU so the latest patches are from September and October):
KB5031419 2023-10 Security Monthly Quality Rollup for Windows Server 2012 R2 for x64-based Systems
KB5031407 2023-10 Security Only Quality Update for Windows Server 2012 R2 for x64-based Systems
KB5031355 2023-10 Cumulative Security Update for Internet Explorer 11 for Windows Server 2012 R2 for x64-based systems
KB5029915 2023-09 Security and Quality Rollup for .NET Framework 3.5 for Windows Server 2012 R2 for x64
KB5031008 2023-10 Security and Quality Rollup for .NET Framework 4.6.2, 4.7, 4.7.1, 4.7.2 for Windows Server 2012 R2 for x64
And now I have 2 questions:
1. Is this patching strategy correct?
2. If I install KB5031419 2023-10 Security Monthly Quality Rollup for Windows Server 2012 R2 for x64-based Systems do I still need to install KB5031407 2023-10 Security Only Quality Update for Windows Server 2012 R2 for x64-based Systems or this patch i already included in Rollup?
Hello Team,We have in our company some old servers – Windows Server 2012R2. We don’t have ESU.Now we need to rebuild some of them and install only security patches.I don’t want to install all single security patches and my patching strategy is:1. Install cumulative patch KB2919355 and some other patches according to the KB below:https://www.microsoft.com/en-us/download/details.aspx?id=423342. Install the latest SSU(As we don’t have ESU the latest SSU is from september 2023):KB5030329 2023-09 Servicing Stack Update for Windows Server 2012 R2 for x64-based Systems3. Install below patches(We don’t have ESU so the latest patches are from September and October):KB5031419 2023-10 Security Monthly Quality Rollup for Windows Server 2012 R2 for x64-based SystemsKB5031407 2023-10 Security Only Quality Update for Windows Server 2012 R2 for x64-based SystemsKB5031355 2023-10 Cumulative Security Update for Internet Explorer 11 for Windows Server 2012 R2 for x64-based systemsKB5029915 2023-09 Security and Quality Rollup for .NET Framework 3.5 for Windows Server 2012 R2 for x64KB5031008 2023-10 Security and Quality Rollup for .NET Framework 4.6.2, 4.7, 4.7.1, 4.7.2 for Windows Server 2012 R2 for x64And now I have 2 questions:1. Is this patching strategy correct?2. If I install KB5031419 2023-10 Security Monthly Quality Rollup for Windows Server 2012 R2 for x64-based Systems do I still need to install KB5031407 2023-10 Security Only Quality Update for Windows Server 2012 R2 for x64-based Systems or this patch i already included in Rollup? Read More
Script to find out if updates are installed on a number of servers
Hello Team,
I found some script which is checking if particular updates have been installed on remote servers. This script might be very helpfull but unfortunatelly it is not working. I’m the beginner and don’t know how to correct it. May I kindly ask you to help me correct it?
$computers=Get-Content .computers.txt
$Kbs=Get-Content .updates.txt
$ErrorActionPreference=“SilentlyContinue”;
ForEach ($computerin$computers) {
add-content“———————— $computer ——————————————————-“-path .hotfixes.txt
ForEach ($Kbin$Kbs) {
$Info=$null
$Info=Get-HotFix-cn$computer-ID“$Kb”
if ($Info-eq$null) {
add-content“$Kb not installed”-path .hotfixes.txt
}
else {
$InstalledDate=$Info.InstalledOn
add-content“$Kb installed $InstalledDate“-path .hotfixes.txt
}
}
}
Thank you in advance.
Hello Team, I found some script which is checking if particular updates have been installed on remote servers. This script might be very helpfull but unfortunatelly it is not working. I’m the beginner and don’t know how to correct it. May I kindly ask you to help me correct it? $computers=Get-Content .computers.txt$Kbs=Get-Content .updates.txt$ErrorActionPreference=“SilentlyContinue”;ForEach ($computerin$computers) {add-content“———————— $computer ——————————————————-“-path .hotfixes.txtForEach ($Kbin$Kbs) {$Info=$null$Info=Get-HotFix-cn$computer-ID“$Kb”if ($Info-eq$null) {add-content“$Kb not installed”-path .hotfixes.txt}else {$InstalledDate=$Info.InstalledOnadd-content“$Kb installed $InstalledDate“-path .hotfixes.txt}}} Thank you in advance. Read More
lines between rows and columns
I had to move information from one row to another to keep it in alphabetical order but now some of the rows and columns don’t have lines between them. How do I get the lines back?
I had to move information from one row to another to keep it in alphabetical order but now some of the rows and columns don’t have lines between them. How do I get the lines back? Read More
2FA Requirement Preventing Me Getting Support
Any idea how I can get support to contact me? I’m a member of th eMicrosoft Partner Program and earlier this year I contacted them asking them to not turn on 2FA on my account; we manage our security ourselves etc.
Now, it seems I cannot login to the portal without setting up Authenticator. I can’t contact them because the only way to contact them is by logging in.
Any ideas? I’ve contacted them using the information on this page https://support.microsoft.com/en-au/topic/global-customer-service-phone-numbers-c0389ade-5640-e588-8b0e-28de8afeb3f2 but it’s some useless AI menu that doesn’t allow me to speak to a human. I’ve tried to re-open my previous ticket and they are ignoring me.
Any idea how I can get support to contact me? I’m a member of th eMicrosoft Partner Program and earlier this year I contacted them asking them to not turn on 2FA on my account; we manage our security ourselves etc. Now, it seems I cannot login to the portal without setting up Authenticator. I can’t contact them because the only way to contact them is by logging in. Any ideas? I’ve contacted them using the information on this page https://support.microsoft.com/en-au/topic/global-customer-service-phone-numbers-c0389ade-5640-e588-8b0e-28de8afeb3f2 but it’s some useless AI menu that doesn’t allow me to speak to a human. I’ve tried to re-open my previous ticket and they are ignoring me. Read More
excel calendar add worksheet
I have an excel workbook with several tabs – one per month. I need to add the rest of the year and I can’t see any way.
I have an excel workbook with several tabs – one per month. I need to add the rest of the year and I can’t see any way. Read More
Help with tallying votes
Hello, I am the secretary of a car club. We hold an annual car show. I would like to create an excel spreadsheet that would list cars 1 through 200. each car needs 3 categories attached to it.
Then, either on the same sheet or a second sheet I’d like to be able to collect the paper ballet from the voter and enter, as an example, that the voter choose car number 10 for category 1, car number 80 for category 2, and car number 115 for category 3. Once I enter those values it would automatically tally on the first sheet.
Hello, I am the secretary of a car club. We hold an annual car show. I would like to create an excel spreadsheet that would list cars 1 through 200. each car needs 3 categories attached to it. Then, either on the same sheet or a second sheet I’d like to be able to collect the paper ballet from the voter and enter, as an example, that the voter choose car number 10 for category 1, car number 80 for category 2, and car number 115 for category 3. Once I enter those values it would automatically tally on the first sheet. Read More
Deleting unwanted parts of a line
I have an address list, name, address, phone number. I want to keep just the name. The non-name part of the line begins with a digit. I wish I could find that first digit, and delete the rest of the line.
I appreciate any help.
I have an address list, name, address, phone number. I want to keep just the name. The non-name part of the line begins with a digit. I wish I could find that first digit, and delete the rest of the line. I appreciate any help. Read More
VSTAMajorVersion – SQL Server x Visual Studio
Hello,
Please, I need some help, on my machine I have installed:
1. SQL Server 2019 RTM- CU16 – GRD / catálogo environment with shared_component_version 15.0.4236.7
2. Visual Studio 2019 ( version 16.11.19) with Visual Studio tools for applications 2019 ( 16.0.3.1110)
When on VS 2019 I import a package from integration catalog (SQL 2019) the VSTAMajorVersion is equal 16.
If I try to open a script task from this package I get error message in Visual Studio 2019:
” XML: Sustem.Exception: The script Task ST_.……… Uses version 16.0 script that IS not supported in this release of Integration Services. To run the package, use the Script Task to create a new VSTA script. In most cases Scripts até converted automatically to use a supported version, when you open a SQL Server Integration Services package in %SQL_Product_Short_Name% Integration Services”.
And script task lost all code and configurations.
If I changed the VSTAMajorVersion to 15 in the code (XML) package before open script task works.
But it’s a problem: changed It all packages all the time after importes :(.
Ps: If I created a new package with script task the VSTAMajorVersion is equal 15 even though the TargetServerVersion property from my integration services project = ” SQL Server 2019″.
Hello, Please, I need some help, on my machine I have installed: 1. SQL Server 2019 RTM- CU16 – GRD / catálogo environment with shared_component_version 15.0.4236.7 2. Visual Studio 2019 ( version 16.11.19) with Visual Studio tools for applications 2019 ( 16.0.3.1110) When on VS 2019 I import a package from integration catalog (SQL 2019) the VSTAMajorVersion is equal 16. If I try to open a script task from this package I get error message in Visual Studio 2019:” XML: Sustem.Exception: The script Task ST_.……… Uses version 16.0 script that IS not supported in this release of Integration Services. To run the package, use the Script Task to create a new VSTA script. In most cases Scripts até converted automatically to use a supported version, when you open a SQL Server Integration Services package in %SQL_Product_Short_Name% Integration Services”. And script task lost all code and configurations. If I changed the VSTAMajorVersion to 15 in the code (XML) package before open script task works. But it’s a problem: changed It all packages all the time after importes :(. Ps: If I created a new package with script task the VSTAMajorVersion is equal 15 even though the TargetServerVersion property from my integration services project = ” SQL Server 2019″. Read More
Files or Folders are missing from SharePoint
Hello
Please i need your help on this issue.
Files or Folders are missing from SharePoint.
I need to recover missing files.
Hello Please i need your help on this issue. Files or Folders are missing from SharePoint. I need to recover missing files. Read More
New Sharepoint List form width issue
Hi, I have a Sharepoint list and I have customized the Sharepoint list form header and body with Json code. Recently due to change the Microsoft sharepoint forms it’s showing a small form in the middle without being connected to the page. Any way to go back to large form with width ? Any solution will be highly appreciated.
Hi, I have a Sharepoint list and I have customized the Sharepoint list form header and body with Json code. Recently due to change the Microsoft sharepoint forms it’s showing a small form in the middle without being connected to the page. Any way to go back to large form with width ? Any solution will be highly appreciated. Read More
excell logical functions based on cell fill color
I would like to use the countif function with a criteria based on the cell’s fill color.
I would like to use the countif function with a criteria based on the cell’s fill color. Read More
In excel add ribbon back to tool bar
Not very knowledgeable – in past opening excel doc had a tool bar on top and just under that was a “RIBBON” that showed what cell you were in and you could make corrections – that ribbon vanished and I don’t know how to get it back – HELP, PLEASE. RON
Not very knowledgeable – in past opening excel doc had a tool bar on top and just under that was a “RIBBON” that showed what cell you were in and you could make corrections – that ribbon vanished and I don’t know how to get it back – HELP, PLEASE. RON Read More
Zombie Default Access Request Management Group
Hi,
Our SharePoint default control group “Asset Management Admins” is deleted several months ago. However, in the Access Requests Settings, the system still set it as the default owner group. And since that group is deleted and no member exists inside, no one is receiving any access request.
Below image is all the groups of the SP site. As you can see, goup “Asset Management Admins” does not exist.
We did one experiment by creating a new control group having same group name as the deleted one. “Asset Management Admins”. Then we assigned a new developer as its group member. However, new access request does not go to that developer’s mail box, it goes to someone who was a member of the deleted group.
What’s the trouble of this issue?
The field below the default admin group only allows filling one email address to receive access request. This causes trouble when that person is out-of-office, and add extra SP maintenance workload.
How to change the default access management group?
or how to thoroughly delete the zombie “Asset Management Admin” group?
Any advice/ workaround is welcome!
Warm Regards,
Xuan
Hi, Our SharePoint default control group “Asset Management Admins” is deleted several months ago. However, in the Access Requests Settings, the system still set it as the default owner group. And since that group is deleted and no member exists inside, no one is receiving any access request.Below image is all the groups of the SP site. As you can see, goup “Asset Management Admins” does not exist. We did one experiment by creating a new control group having same group name as the deleted one. “Asset Management Admins”. Then we assigned a new developer as its group member. However, new access request does not go to that developer’s mail box, it goes to someone who was a member of the deleted group. What’s the trouble of this issue? The field below the default admin group only allows filling one email address to receive access request. This causes trouble when that person is out-of-office, and add extra SP maintenance workload.How to change the default access management group?or how to thoroughly delete the zombie “Asset Management Admin” group?Any advice/ workaround is welcome!Warm Regards,Xuan Read More
United States-International Keyboard
Hi,
I just moved from Windows 10 to 11. In W10 I used the US-International keyboard to enter characters like “a umlaut”. It was easy to do by typing a ” character and then the character itself. To type the ” character you just had to wait a bit. I used the keyboard to type in Finnish language, which uses “a umlaut”, and “o umlaut” characters (lower and upper case).
W11 does not seem to have a US-International language or keyboard. There is a MS note about adding the keyboard to W11, but it just talks about various features you can use to change your chosen language, nothing is mentioned about keyboards.
In another note I learned that I can enter an “a umlaut” by entering ALT-132 (the numeric keyboard numbers), but that is pretty cumbersome. So I tried the MS PowerToys Keyboard Manager app to set up a Remap Shortcut. But it seems that I can not enter the ALT-132 code to be sent, the app can only do a plain text, with no ALT key pressed, or to do only one character while ALT key is pressed.
So without going to some third party app, is there a solution in W11 for my problem? My alternative is to find some third party app that allows the mapping I need, but I would prefer to stay within the MS world.
Hi,I just moved from Windows 10 to 11. In W10 I used the US-International keyboard to enter characters like “a umlaut”. It was easy to do by typing a ” character and then the character itself. To type the ” character you just had to wait a bit. I used the keyboard to type in Finnish language, which uses “a umlaut”, and “o umlaut” characters (lower and upper case).W11 does not seem to have a US-International language or keyboard. There is a MS note about adding the keyboard to W11, but it just talks about various features you can use to change your chosen language, nothing is mentioned about keyboards.In another note I learned that I can enter an “a umlaut” by entering ALT-132 (the numeric keyboard numbers), but that is pretty cumbersome. So I tried the MS PowerToys Keyboard Manager app to set up a Remap Shortcut. But it seems that I can not enter the ALT-132 code to be sent, the app can only do a plain text, with no ALT key pressed, or to do only one character while ALT key is pressed.So without going to some third party app, is there a solution in W11 for my problem? My alternative is to find some third party app that allows the mapping I need, but I would prefer to stay within the MS world. Read More
Cloned SSD will not boot computer
Although a NVMe SSD is much faster than a SATA SSD, you only see the difference on the benchmark test. On old computers you can’t boot directly to the PCIe card with the NVMe SSD as there is no option on BIOS to do so. The EFI partition must be on a SATA drive and then transfer the boot sequence to the PCIe card。
Although a NVMe SSD is much faster than a SATA SSD, you only see the difference on the benchmark test. On old computers you can’t boot directly to the PCIe card with the NVMe SSD as there is no option on BIOS to do so. The EFI partition must be on a SATA drive and then transfer the boot sequence to the PCIe card。 Read More
RunMRU missing from regedit
RunMRU is not where places said it would be. It is missing from HKCUSoftwareMicrosoftWindowsCurrentVersionExplorer
RunMRU is not where places said it would be. It is missing from HKCUSoftwareMicrosoftWindowsCurrentVersionExplorer Read More