PowerShell: How to add a new blank line at every 30 words in several text files that contains 1000 words?
hello, is is possible to add a new blank line at every 30 words in several text files that contains 1000 words using PowerShell?
DATE() Not working after BE converted to SQL
I converted my Access Backed to SQL yesterday everything went well except now the Date() function doesn't work. The query below returns no records. If I change the dates to "4/7/2021" it works fine. One thing I noticed is if I put in #4/7/2021#…
How to insert parsed and non-parsed data from one table into another table using AFTER INSERT trigger
I want to take the data from 3 columns of one table and input them into another table via an AFTER INSERT Trigger. One of the columns is a VARCHAR datatype that consists of a large string of text (a csv file). I can parse this data if I take a record…
Delete high volume of data and performance issue
I have store procedure which delete data from sql server table. We store ticker wise data. Some ticker’s has high volume of data. Suppose for a ticker X which has 4 million data. When deleting 4 million data in batch then it takes lots of time. …
How to get the owner name of a registry key?
I want to get the owner name of a registry key, for example, return "TrustedInstaller" or "Administrator" etc. I have the setacl.exe, but it doesn't seem to have that function.

NIC Effective Routes
Hi, from Network Interfaces, under Support + troubleshooting. there's a effective routes feature. May I know how did it derives the routes? There isn't any routing tables being define in my environment. We have VPN and expressroute. I ask because…


Azure DataFactory: How order the execution Flow of one Dataflow
I want to know if it´s posible to order the execution of the different activities inside a dataflow. For this example: I want to assure that the execution of the “sink source 1” occurs before than the “lookup source 1” activity. I know…
Microsoft Identity Manager, Exporting last modified date from metaverse
I have a SQL Server database connected to my metaverse and would like to populate a column in that database with the date when an export runs against one of the records in that database. I can see MIM tracks the last modify date of each attribute of a…
How to export data, functions, classes from C++/WinRT library
Usually we are using dllexport/dllimport method for c++ libraries. Then a test application can use the dll implicitly/explicitly for accessing the dll functions. And we can make use of .winmd files in the c++/winRT to access the classes, functions…
Transport Rule - false positive
Hello, I have a problem where I set up a transport rule to block xlsm attachments sent to a distribution group, however at times it blocks pdf-s as well. I checked the message tracking log and sometimes pdf-s arrive, sometimes not. Each fail contains…
Limited group management permissions
We’re implementing Azure MFA with all of our staff Occasionally one of them will hit the “Deny” button in an MFA request, and cause their account to be “blocked”. At the present, only our SysAdmins can unblock the account – often resulting in the user…

How can we test the c++/WinRT library using a c++ console application
Im writing a C++/WinRT library now and I'd like to test the API in a C++ console. Any way to do this?
Azure Cognitive Search
Hello All... I have a few Excel files stored in a Blob Storage Container. Each file is of size ranging from 5 MB to 8 MB with the record counts ranging from 40K to 70K. After setting up Azure Cognitive Search for these files (via Azure Blob…
Not able to add MPN ID for App registeration
Hi, I am trying to add an MPN ID for my app registeration. But it showing the following error" The MPN ID you provided (XXXXXX) does not exist, or you do not have access to it. Please provide a valid MPN ID and try again " How do I get…
Bitlocker - Window 10 Locked
Dear All, A Customer Laptop , not part of domain had bitlocker enabled, There was an issue with Motherboard and it was changed now the BitLocker is asking for password at boot time which is not remembered by customer. Customer has the local…
On HCK studio for Windows 7 machine, some of kernel drivers(sys file) have no testing item.
On HCK studio for Windows 7 machine, some of kernel drivers(sys file) were recognized as software device in [Selection] tab, but there is no testing item in [Tests] tab. I could add features in [Seletion] tab but I am not sure it's right. Do you…
On HCK studio for Windows 7 machine, some of kernel drivers(sys file) were recognized as "device manager" not "software device".
On HCK studio for Windows 7 machine, some of kernel drivers(sys file) were recognized well as a "software device", but some were recognized as "device manager" and any test item were not assigned. Some of drivers were detected as…
On Premise Exchange Server after wonky migration to Identity Hybrid
We were hit with a ransomware attack back in 2019 and lost our Exchange Server 2016. We synced our users from Active Directory to 365 and gave them new mailboxes. Then, we reinstalled Exchange 2016 and restored our old mailboxes. We migrated users'…
IServiceCollection Access
How can I access IServiceCollection from web api or controller?


Bing Maps API Distance Matrix Travel Mode is ALWAYS driving
Hi, I'm on a Basic Education license for the Bing Maps REST services, and I'm using the Distance Matrix API (https://learn.microsoft.com/en-us/bingmaps/rest-services/routes/calculate-a-distance-matrix) in my project. I have noticed that for some…