Category: Microsoft
Category Archives: Microsoft
How to write SQL putting subquery in output
The title may not be clear but here is what I am trying to achieve. I have a People table (irrelevant columns omitted):
PersonID int
Name varchar(32)
PartnerID int
Where PartnerID revers to another individual in the People table. I would like a query like this:
SELECT Name+PartnerName FROM People;
I know how to get the Partner name but I don’t know to get it into the output.
The title may not be clear but here is what I am trying to achieve. I have a People table (irrelevant columns omitted): PersonID int
Name varchar(32)
PartnerID intWhere PartnerID revers to another individual in the People table. I would like a query like this:SELECT Name+PartnerName FROM People;I know how to get the Partner name but I don’t know to get it into the output. Read More
File Explorer stealing back focus when opening files from “Recent” listing
Not sure if you have noticed the same happening for you, but it seems to be something that started after a recent update (I’m on Win 11 Enterprise 23H2 – 2261.3155). When opening files that are in the “Recent” list in File Explorer, after the associated program launches and loads said file, the Explorer window seems to steal back focus. I suspect it’s due to Explorer pulling a refresh itself of the “Recent” section, putting the file I just launched to the top of the “Recent” list. I’m able to reproduce this about 8 times out of 10 attempts.
Just to be sure, I’ve confirmed that it happens with both local files on the hard drive as well as Onedrive files (irrespective of them being online-only or locally sync’d). Also, file type (i.e. notepad, word, pdf). Have any of you noticed this behavior? If I recall correctly, I’ve noticed this for approximately the past month, and have been on Win 11 since pre-public days.
Lastly, this is reproducible in other machines as well that I have the same build installed on (both newer laptops and desktops), so it does not appear to be hardware-related. Thanks in advance for any feedback.
Not sure if you have noticed the same happening for you, but it seems to be something that started after a recent update (I’m on Win 11 Enterprise 23H2 – 2261.3155). When opening files that are in the “Recent” list in File Explorer, after the associated program launches and loads said file, the Explorer window seems to steal back focus. I suspect it’s due to Explorer pulling a refresh itself of the “Recent” section, putting the file I just launched to the top of the “Recent” list. I’m able to reproduce this about 8 times out of 10 attempts. Just to be sure, I’ve confirmed that it happens with both local files on the hard drive as well as Onedrive files (irrespective of them being online-only or locally sync’d). Also, file type (i.e. notepad, word, pdf). Have any of you noticed this behavior? If I recall correctly, I’ve noticed this for approximately the past month, and have been on Win 11 since pre-public days. Lastly, this is reproducible in other machines as well that I have the same build installed on (both newer laptops and desktops), so it does not appear to be hardware-related. Thanks in advance for any feedback. Read More
Organizing Music Collection on SSD in Windows 11
I have a moderate size music collection which I’m recording from CD to SSD. I’ve created a Primary folder and set it up with the information required. All CDs are copied to their own folder. Modifying the look of the folders is no problem, however, when I try to get all folders to conform to the primary with the information in the primary folder some will and some won’t. Each folder requires 8 columns. I can go down about 8 folders and they are all the same, yet I can go to the ninth and there are 3 columns. I’ve used the OPTIONS>VIEW>APPLY TO ALL FOLDERS using the primary folder but with no luck. Am I assuming that the look of the primary folder should apply to all folders or is it done manually. I am using Windows 11, VERSION 23H2, 11/28/2023. Any help would be greatly appreciated and thanks in advance.
I have a moderate size music collection which I’m recording from CD to SSD. I’ve created a Primary folder and set it up with the information required. All CDs are copied to their own folder. Modifying the look of the folders is no problem, however, when I try to get all folders to conform to the primary with the information in the primary folder some will and some won’t. Each folder requires 8 columns. I can go down about 8 folders and they are all the same, yet I can go to the ninth and there are 3 columns. I’ve used the OPTIONS>VIEW>APPLY TO ALL FOLDERS using the primary folder but with no luck. Am I assuming that the look of the primary folder should apply to all folders or is it done manually. I am using Windows 11, VERSION 23H2, 11/28/2023. Any help would be greatly appreciated and thanks in advance. Read More
The Documents folder is not grouped to the other folders such as Downloads
I have a fresh installation of Windows 11 Pro, about a couple weeks old or so. The Documents folder was stubbornly stuck on OneDrive. I followed a YouTube video that showed how to move it successfully. Afterwards I removed OneDrive from startup but didn’t remove it altogether.
I won’t go into the details of my attempted fix. But the lingering side effect is the local Documents folder lacks an icon and will NOT even browse for an icon. I even have an extracted icon file, from imageres.dll, for the Documents folder. But the folder properties box on the Customize tab does not have the usual buttons (Choose File & Restore Default) to prompt for an icon change. I had those buttons yesterday, which didn’t work. But after tampering with the registry, even those buttons are gone.
The easiest option is to simply reinstall the OS from scratch. But then I’d lose a couple weeks of software installs and configurations. The other option is to live with it.
You can see the attached screenshots for more details. The Documents folder is not grouped to the other folders such as Downloads.
Hopefully someone can help?
I have a fresh installation of Windows 11 Pro, about a couple weeks old or so. The Documents folder was stubbornly stuck on OneDrive. I followed a YouTube video that showed how to move it successfully. Afterwards I removed OneDrive from startup but didn’t remove it altogether. I won’t go into the details of my attempted fix. But the lingering side effect is the local Documents folder lacks an icon and will NOT even browse for an icon. I even have an extracted icon file, from imageres.dll, for the Documents folder. But the folder properties box on the Customize tab does not have the usual buttons (Choose File & Restore Default) to prompt for an icon change. I had those buttons yesterday, which didn’t work. But after tampering with the registry, even those buttons are gone. The easiest option is to simply reinstall the OS from scratch. But then I’d lose a couple weeks of software installs and configurations. The other option is to live with it. You can see the attached screenshots for more details. The Documents folder is not grouped to the other folders such as Downloads.Hopefully someone can help? Read More
Frequent Critical Events on Dell Mini Tower 3910
Two weeks ago, my Dell Mini tower 3910 started showing frequent critical events in the reliability monitor-Microsoft Storage Spaces SMP stopped working. This happens once or twice a day. It can occur by itself or with another fault. I’m at a loss to determine the cause.
I back up with Macrium twice a month, use Malwarebytes Premium services., have no infections, items in quarantine or other significant problems.
Is this a known defect? Is there a solution?
Thank you for any assistance and ideas.
Two weeks ago, my Dell Mini tower 3910 started showing frequent critical events in the reliability monitor-Microsoft Storage Spaces SMP stopped working. This happens once or twice a day. It can occur by itself or with another fault. I’m at a loss to determine the cause. I back up with Macrium twice a month, use Malwarebytes Premium services., have no infections, items in quarantine or other significant problems. Is this a known defect? Is there a solution? Thank you for any assistance and ideas. Read More
Login account at startup that is listed as first 5 letters of Microsoft email account, does n
After I changed my laptop name, at startup I now get an account titled as the first 5 letters of my user folder name and it is also the first 5 letters of my Microsoft outlook email account. There is no such account. It requests a password, but of course there is not one. I tried several of my usual passwords, but none worked.
There is an alternate account option, which I use to log in, but it always opens with this non-existent account. l don’t use password logins, so it’s quite annoying.
After I changed my laptop name, at startup I now get an account titled as the first 5 letters of my user folder name and it is also the first 5 letters of my Microsoft outlook email account. There is no such account. It requests a password, but of course there is not one. I tried several of my usual passwords, but none worked.There is an alternate account option, which I use to log in, but it always opens with this non-existent account. l don’t use password logins, so it’s quite annoying. Read More
Sudden Strange Icon Behaviour
I noticed about three days ago that when I log on, my icons are now all over half my screen and are widely spaced out side to side and top and bottom. If I log out and then log back in, the icons are where they are supposed to be, but all mixed up. If I reboot, they are all over the place again until I log out then back in after it boots up.
I have made no adjustments to my computer other than the recent patch Tuesday updates, and I have not installed any new software in the past month or so, with the exception of my new Nvidia GPU drivers. There is a tutorial on setting icon spacing, and I might try that. I’m just not sure it will hold between boot ups.
Anyone have this recent experience too? Or is it just me? And what could be the cause of this sudden weirdness?
I noticed about three days ago that when I log on, my icons are now all over half my screen and are widely spaced out side to side and top and bottom. If I log out and then log back in, the icons are where they are supposed to be, but all mixed up. If I reboot, they are all over the place again until I log out then back in after it boots up. I have made no adjustments to my computer other than the recent patch Tuesday updates, and I have not installed any new software in the past month or so, with the exception of my new Nvidia GPU drivers. There is a tutorial on setting icon spacing, and I might try that. I’m just not sure it will hold between boot ups. Anyone have this recent experience too? Or is it just me? And what could be the cause of this sudden weirdness? Read More
Why PC doesn’t boot from C drive?
Can anyone explain why my PC is giving this screen on boot? The Boot options are shown below.
After going to boot options and selecting Save and Restart, it boots normally once, then gives the error screen every boot after this.
Can anyone explain why my PC is giving this screen on boot? The Boot options are shown below.After going to boot options and selecting Save and Restart, it boots normally once, then gives the error screen every boot after this. Read More
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