Category: Microsoft
Category Archives: Microsoft
How can I download YouTube shorts video to watch offline?
I’ve seen a lot of interesting short videos on YouTube recently, the kind called YouTube Shorts. I want to download short videos to my device so I can watch them offline, especially when I don’t have an internet connection. I’ve tried to find some methods and tools to download them, but they don’t seem ideal, either the quality of the downloaded videos is not good enough or the operation process is too complicated.
Does anyone have any good recommendations methods that can easily download YouTube Shorts? It would be best if the operation is simple, the download speed is fast, and the original quality of the video is maintained. If you have any good experience or suggestions, please share them, thank you very much!
I’ve seen a lot of interesting short videos on YouTube recently, the kind called YouTube Shorts. I want to download short videos to my device so I can watch them offline, especially when I don’t have an internet connection. I’ve tried to find some methods and tools to download them, but they don’t seem ideal, either the quality of the downloaded videos is not good enough or the operation process is too complicated. Does anyone have any good recommendations methods that can easily download YouTube Shorts? It would be best if the operation is simple, the download speed is fast, and the original quality of the video is maintained. If you have any good experience or suggestions, please share them, thank you very much! Read More
Vyapar Referral Code PNQ1G9 Get Upto 60% Discount
Vyapar Referral Code PNQ1G9 Get Upto 60% Discount #Vyapar :party_popper:🥳 Enjoy Vypar App Coupon Code — Upto 60% Discount 🥳
Use Coupon Code “PNQ1G9” & Get Upto 60% Discount! 🥳🥳🥳🥳🥳 — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — :backhand_index_pointing_right:Queries Solved in This Video: Vyapar app promo code | vyapar app discount code | vyapar app coupon Code | Latest Promo code of Vyapar | Vyapar app promo code | vyapar app discount code | vyapar app coupon Code | Latest Promo code of Vyapar — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — –
#Vyapar Enjoy Vypar App Coupon Code — Upto 60% Discount 🥳
In this exciting video, we bring you exclusive deals and discounts on the Vyapar app. By using the coupon code “PNQ1G9,” you can unlock amazing savings of up to 60%! :money_with_wings::money_bag::party_popper:
Introduction Vyapar Referral Code:
Vyapar Referral Code PNQ1G9 Get Upto 60% Discount. Welcome to our blog post on Vyapar App Coupon Code, where you can unlock big savings and enjoy an incredible discount of up to 60%! By using the coupon code “PNQ1G9,” you can take advantage of this exclusive offer. Get ready to elevate your business with Vyapar’s powerful features and efficient accounting solutions. :money_with_wings::party_popper:
Queries Solved in This Post:
In this post, we’ll address some common queries related to Vyapar app promo codes, discount codes, and coupon codes. Find answers to questions like: What are the latest promo codes for Vyapar? How can I get a discount on the Vyapar app subscription? Where can I find the Vyapar app coupon code?
Unlock Big Savings:
Vyapar is your ultimate business accounting software, simplifying financial management, inventory tracking, and tax management. With its user-friendly interface and robust features, Vyapar helps you streamline your business operations. And now, with our exclusive coupon code, discount code, or promo code, you can save big on your Vyapar subscription, making it an even more cost-effective solution for your business. :flexed_biceps::briefcase::money_bag:
Step-by-Step Guide:
We’ll provide you with a detailed step-by-step guide on how to apply the coupon code, discount code, or promo code to your Vyapar subscription. Follow our instructions carefully to ensure you maximize your savings and make the most out of Vyapar’s features. We’re here to support you throughout the process! :video_camera::clipboard::light_bulb:
Check Pricing Details:
Find the perfect plan for your business needs by checking out the Pricing Details .
Vyapar offers flexible pricing options that cater to businesses of all sizes, ensuring you get the right package that suits your requirements.
Conclusion:
Watch the video, read our post, and don’t forget to like, share, and subscribe for more valuable content. Start saving with Vyapar today and take your business to new heights! :rocket::briefcase::money_with_wings:
Tags:
#vyaparappcouponcode #vyaparappdiscountcode #vyaparapppromocode #vyaparappreferralcode #businessaccountingsoftware #financialmanagement #inventorymanagement #taxmanagement #smallbusinesssolutions #entrepreneertools #costeffectivesolutions #savings #businessgrowth #financemanagement #invoicemanagement #expensetracking #profittracking #productivitytools #businessefficiency #businesssoftware #businessautomation #digitalsolutions #businesssuccess #discountoffers #exclusivedeals
Disclaimer:
Please note that this video and blog post are for educational purposes only. All images, music, and graphics used belong to their respective owners, and we do not claim any rights over them. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education, and research. Thank you for reading! :folded_hands::party_popper::bell:
Vyapar Referral Code PNQ1G9 Get Upto 60% Discount #Vyapar :party_popper:🥳 Enjoy Vypar App Coupon Code — Upto 60% Discount 🥳 Use Coupon Code “PNQ1G9” & Get Upto 60% Discount! 🥳🥳🥳🥳🥳 — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — :backhand_index_pointing_right:Queries Solved in This Video: Vyapar app promo code | vyapar app discount code | vyapar app coupon Code | Latest Promo code of Vyapar | Vyapar app promo code | vyapar app discount code | vyapar app coupon Code | Latest Promo code of Vyapar — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — -#Vyapar Enjoy Vypar App Coupon Code — Upto 60% Discount 🥳In this exciting video, we bring you exclusive deals and discounts on the Vyapar app. By using the coupon code “PNQ1G9,” you can unlock amazing savings of up to 60%! :money_with_wings::money_bag::party_popper:Introduction Vyapar Referral Code:Vyapar Referral Code PNQ1G9 Get Upto 60% Discount. Welcome to our blog post on Vyapar App Coupon Code, where you can unlock big savings and enjoy an incredible discount of up to 60%! By using the coupon code “PNQ1G9,” you can take advantage of this exclusive offer. Get ready to elevate your business with Vyapar’s powerful features and efficient accounting solutions. :money_with_wings::party_popper:Queries Solved in This Post:In this post, we’ll address some common queries related to Vyapar app promo codes, discount codes, and coupon codes. Find answers to questions like: What are the latest promo codes for Vyapar? How can I get a discount on the Vyapar app subscription? Where can I find the Vyapar app coupon code?Unlock Big Savings:Vyapar is your ultimate business accounting software, simplifying financial management, inventory tracking, and tax management. With its user-friendly interface and robust features, Vyapar helps you streamline your business operations. And now, with our exclusive coupon code, discount code, or promo code, you can save big on your Vyapar subscription, making it an even more cost-effective solution for your business. :flexed_biceps::briefcase::money_bag:Step-by-Step Guide:We’ll provide you with a detailed step-by-step guide on how to apply the coupon code, discount code, or promo code to your Vyapar subscription. Follow our instructions carefully to ensure you maximize your savings and make the most out of Vyapar’s features. We’re here to support you throughout the process! :video_camera::clipboard::light_bulb:Check Pricing Details:Find the perfect plan for your business needs by checking out the Pricing Details .Vyapar offers flexible pricing options that cater to businesses of all sizes, ensuring you get the right package that suits your requirements.Conclusion:Watch the video, read our post, and don’t forget to like, share, and subscribe for more valuable content. Start saving with Vyapar today and take your business to new heights! :rocket::briefcase::money_with_wings:Tags:#vyaparappcouponcode #vyaparappdiscountcode #vyaparapppromocode #vyaparappreferralcode #businessaccountingsoftware #financialmanagement #inventorymanagement #taxmanagement #smallbusinesssolutions #entrepreneertools #costeffectivesolutions #savings #businessgrowth #financemanagement #invoicemanagement #expensetracking #profittracking #productivitytools #businessefficiency #businesssoftware #businessautomation #digitalsolutions #businesssuccess #discountoffers #exclusivedealsDisclaimer:Please note that this video and blog post are for educational purposes only. All images, music, and graphics used belong to their respective owners, and we do not claim any rights over them. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education, and research. Thank you for reading! :folded_hands::party_popper::bell: Read More
Philippines Currency Missing from Partner Center Payout and Tax Profile!.
Hi There,
Does anyone know why the Philippines currency is missing from Partner Center Payout and Tax Profile?
I’m trying to configure a payment profile within partner Center and it prompts me configure the currency for the new MPN id location I created but when I go to Partner Center to complete the profile setup, I don’t see the Philippines Peso ,PHP code, so how can I proceed to set this up?
Partner Center shows a default list of payment currency and the PHP isn’t among it…
Hi There, Does anyone know why the Philippines currency is missing from Partner Center Payout and Tax Profile? I’m trying to configure a payment profile within partner Center and it prompts me configure the currency for the new MPN id location I created but when I go to Partner Center to complete the profile setup, I don’t see the Philippines Peso ,PHP code, so how can I proceed to set this up? Partner Center shows a default list of payment currency and the PHP isn’t among it… Read More
Updating a teams meeting
Every time i set up a meeting and I have to change the time, when I click on the “send Update button, I get a pop up windows that says” One or more items in the folder you synchronized do not match. To resolve the conflicts, open the items, and then try this operation again” All I did was change the time or added another person.
Dan
Every time i set up a meeting and I have to change the time, when I click on the “send Update button, I get a pop up windows that says” One or more items in the folder you synchronized do not match. To resolve the conflicts, open the items, and then try this operation again” All I did was change the time or added another person. Dan Read More
Need help to understand what Always On is creating with domainServer$
Hi I hope this is the right group to post this, if not, let me know please.
When installing AlwaysOn and setting permissions, it makes you grant permissions to a domainServer$ account in the domain (which gets created, but seemingly it can be deleted with no issue). There is no Server$ in AD i can find (hence my previous statement). what is up with the the domainServer$ creatation?
Hi I hope this is the right group to post this, if not, let me know please.When installing AlwaysOn and setting permissions, it makes you grant permissions to a domainServer$ account in the domain (which gets created, but seemingly it can be deleted with no issue). There is no Server$ in AD i can find (hence my previous statement). what is up with the the domainServer$ creatation? Read More
Error in cascading Combo Boxes
Hi Access community,
In a form, I’d like to filter choices in combo box cobStatus based on the value I select in combo box cobCountry. The code I copied from an online post is:
Private Sub cobCountry_AfterUpdate()
Dim strSQL As String
strSQL = “SELECT [Tables]![Project Database].[Project Stage]” & _
“FROM [Tables]![Project Database]” & _
“WHERE [Tables]![Project Database].Country = ” & Me.cobCountry & _
“ORDER BY [Tables]![Project Database].[Project Stage];”
Me.cobStatus.RowSource = strSQL
Me.cobStatus.Requery
End Sub
So, I select a country in cobCountry but, when selecting cobStatus an alert pops us:
‘Syntax error in FROM clause’
As I said, I copied the code from a demo database a user shared online and in his demo database the code works. The only difference btw my DB and his is that he’s pulling values from two separate tables (tblCountry and tblStatus), whereas I am pulling data from a single table. May that be the issue?
Thanks for any help you can provide!
Hi Access community, In a form, I’d like to filter choices in combo box cobStatus based on the value I select in combo box cobCountry. The code I copied from an online post is: Private Sub cobCountry_AfterUpdate()Dim strSQL As StringstrSQL = “SELECT [Tables]![Project Database].[Project Stage]” & _”FROM [Tables]![Project Database]” & _”WHERE [Tables]![Project Database].Country = ” & Me.cobCountry & _”ORDER BY [Tables]![Project Database].[Project Stage];”Me.cobStatus.RowSource = strSQLMe.cobStatus.RequeryEnd Sub So, I select a country in cobCountry but, when selecting cobStatus an alert pops us: ‘Syntax error in FROM clause’ As I said, I copied the code from a demo database a user shared online and in his demo database the code works. The only difference btw my DB and his is that he’s pulling values from two separate tables (tblCountry and tblStatus), whereas I am pulling data from a single table. May that be the issue? Thanks for any help you can provide! Read More
unable to provide consent
Hi All,
I am facing an issue with API permissions. I have an Azure App Registration with the following Microsoft Graph API permissions. Let’s say the App Registration name is TESTAPP and the Client ID is xxxx-xxxx-xxxxx-xxxxx.
I have a SharePoint site, let’s say mysite1, and I am trying to provide permissions in the following way:
I obtained the site ID using the following URL:
https://mydomain.sharepoint.com/sites/mysite1/_api/site/id. Let’s say the site ID i got is
11111-111-1111-11221
i have logged into https://developer.microsoft.com/en-us/graph/graph-explorer/
Post–>v1.0–>https://grapsh.microsoft.com/v1.0/sites/{11111-111-1111-11221}/permissions
Request headers: Key:application/json
Request Body:
{
“roles”: [
“write”
],
“grantedToIdentities”: [
{
“application”: {
“id”: “xxxx-xxxx-xxxxx-xxxxx”, # This is my app regisration id
“displayName”: “TESTAPP”
}
}
]
}
When i click modify permissions and search for sites permissions, i am unable to provide consent, its grayed out. I am a global admin and i have full access on the SharePoint site. Please guide me.
Hi All,I am facing an issue with API permissions. I have an Azure App Registration with the following Microsoft Graph API permissions. Let’s say the App Registration name is TESTAPP and the Client ID is xxxx-xxxx-xxxxx-xxxxx. I have a SharePoint site, let’s say mysite1, and I am trying to provide permissions in the following way:I obtained the site ID using the following URL:https://mydomain.sharepoint.com/sites/mysite1/_api/site/id. Let’s say the site ID i got is11111-111-1111-11221 i have logged into https://developer.microsoft.com/en-us/graph/graph-explorer/ Post–>v1.0–>https://grapsh.microsoft.com/v1.0/sites/{11111-111-1111-11221}/permissionsRequest headers: Key:application/jsonRequest Body:{“roles”: [“write”],”grantedToIdentities”: [{“application”: {“id”: “xxxx-xxxx-xxxxx-xxxxx”, # This is my app regisration id”displayName”: “TESTAPP”}}]} When i click modify permissions and search for sites permissions, i am unable to provide consent, its grayed out. I am a global admin and i have full access on the SharePoint site. Please guide me. Read More
New Teams Uninstalling After Reboot
I am having an issue in our environment with the New MS Teams uninstalling itself after rebooting, or if a user is working within their Windows profile. This is issue just started occurring 06/06/2024. Here are the following troubleshooting steps I have tried to resolve the issue with no prevail.
• Isolated the issue to domain-joined machines.
• Uninstalled and reinstalled the Teams client.
• Removed the Classic Teams client and Teams System-Wide Installer.
• Deleted all Classic Teams program data folders, including AppData and any Teams Addin folder.
• Verified that there are no Group Policies managing or deploying the new Teams.
• Managed the new Teams deployment in Intune via an Entra ID security group and removed the group associated with the application package.
• Confirmed that ME Endpoint Central has no configurations or updates managing the new Teams.
• Deployed the latest May and June 2024 Cumulative Security updates to test machines, but the new Teams client still uninstalls after rebooting.
• Repaired the Edge Webview2 Runtime component.
• Checked application logs; none are associated with Teams.
• Moved a test machine from the “Workstation OU” to the “Test OU” to bypass the Endpoint Central Agent push by group policy, rebooted with and without the Endpoint Central agent, but the new Teams client still uninstalled.
• Reviewed the Teams Update Policy in the Teams Admin Center; it is set to update all users within the organization to the new Teams.
• Removed the Endpoint Central agent from his machine, rebooted, and the new Teams client did not uninstall. However, it uninstalled overnight once he connected to the domain the following day.
• Raised support tickets with ME Endpoint Central and Microsoft to check machine logs.
If anyone knows anything, any help would be greatly appreciated.
I am having an issue in our environment with the New MS Teams uninstalling itself after rebooting, or if a user is working within their Windows profile. This is issue just started occurring 06/06/2024. Here are the following troubleshooting steps I have tried to resolve the issue with no prevail. • Isolated the issue to domain-joined machines.• Uninstalled and reinstalled the Teams client.• Removed the Classic Teams client and Teams System-Wide Installer.• Deleted all Classic Teams program data folders, including AppData and any Teams Addin folder.• Verified that there are no Group Policies managing or deploying the new Teams.• Managed the new Teams deployment in Intune via an Entra ID security group and removed the group associated with the application package.• Confirmed that ME Endpoint Central has no configurations or updates managing the new Teams.• Deployed the latest May and June 2024 Cumulative Security updates to test machines, but the new Teams client still uninstalls after rebooting.• Repaired the Edge Webview2 Runtime component.• Checked application logs; none are associated with Teams.• Moved a test machine from the “Workstation OU” to the “Test OU” to bypass the Endpoint Central Agent push by group policy, rebooted with and without the Endpoint Central agent, but the new Teams client still uninstalled.• Reviewed the Teams Update Policy in the Teams Admin Center; it is set to update all users within the organization to the new Teams.• Removed the Endpoint Central agent from his machine, rebooted, and the new Teams client did not uninstall. However, it uninstalled overnight once he connected to the domain the following day.• Raised support tickets with ME Endpoint Central and Microsoft to check machine logs. If anyone knows anything, any help would be greatly appreciated. Read More
Converting smtp email
hello
hello how can i convert smtp email to smb with exchange server?what connectors i need to use? 10x rami Read More
Copilot in PowerPoint 365 do not edit the slides anymore?
I wonder, is the copilot for Microsoft PowerPoint not editing the slides anymore? It is rather providing only default options i.e. add image, organize ppt, add slide etc but do not edit the slides anymore i.e. no more prompt for changing the fonts, animating the bullets, reducing or increasing the text etc. Or is it only happening with me?
I wonder, is the copilot for Microsoft PowerPoint not editing the slides anymore? It is rather providing only default options i.e. add image, organize ppt, add slide etc but do not edit the slides anymore i.e. no more prompt for changing the fonts, animating the bullets, reducing or increasing the text etc. Or is it only happening with me? Read More
How to disable the ‘Join’ button for meetings
Is there a way to disable the JOIN button on a scheduled meeting? We would like to have the user enter the meeting ID and password in order to have an MTR joint he room.
Its for security purposes.
Thanks
Is there a way to disable the JOIN button on a scheduled meeting? We would like to have the user enter the meeting ID and password in order to have an MTR joint he room. Its for security purposes. Thanks Read More
segmentação de dados
gostaria de saber se é possível usar uma única segmentação de dados para varias tabelas dinâmicas em diferentes planilhas na mesma pasta de trabalho.
contexto: eu tenho 3 tabelas diferentes, usadas para diferentes propósitos. Com essas tabelas eu crie tabelas dinâmicas e com os dados unificados criei um dashboard. Porém na hora de usar os filtros dinâmicos (segmentação) eles só aceitam conexão com uma mesma pasta de trabalho mesmo todos os dados sendo iguais nas diferentes planilhas. Nas tabelas tenho a mesma base de dados, que são nome, e até mesmo datas e meses.
gostaria de saber se é possível usar uma única segmentação de dados para varias tabelas dinâmicas em diferentes planilhas na mesma pasta de trabalho. contexto: eu tenho 3 tabelas diferentes, usadas para diferentes propósitos. Com essas tabelas eu crie tabelas dinâmicas e com os dados unificados criei um dashboard. Porém na hora de usar os filtros dinâmicos (segmentação) eles só aceitam conexão com uma mesma pasta de trabalho mesmo todos os dados sendo iguais nas diferentes planilhas. Nas tabelas tenho a mesma base de dados, que são nome, e até mesmo datas e meses. Read More
Excel – best way to perform my end result
I have data with the following headers, name, class and amount. (I can delete the unwanted columns just fine)
1) I need to sort by class and have total amounts based on each class. ( I know how to sort and use subtotal groups) I can’t figure out out to copy that info with just the totals of each class and identify who those amounts belong to. I use paste special, value (I still end up with the rows expanding out)
Data I start with (with several rows (including more than 1 name) and multiple classes with varying amounts)
NameWhy date date 2 n/a n/a n/a Class AmountJoe SmithHoliday 06/06/2024 ########## 0.00 0.00 Y 281.00_General Operations195.00
2) after I get the data of just the totals for each class I am going to have my rows with the class with the amount in a column and the name relating somehow to the that data. In the end I will have multiple names and amounts going horizontal with some other added columns and formulas to determine a incentive payout but based on the amount in each class. ( I have figured out to use transpose and or just some simple formulas to make this happen. I just thought maybe if you knew the big picture you would see an easier way to get around it all)
ClassJoe Smith% (amount/total)Bonus AmountFinal Funding200781%910
I have data with the following headers, name, class and amount. (I can delete the unwanted columns just fine)1) I need to sort by class and have total amounts based on each class. ( I know how to sort and use subtotal groups) I can’t figure out out to copy that info with just the totals of each class and identify who those amounts belong to. I use paste special, value (I still end up with the rows expanding out) Data I start with (with several rows (including more than 1 name) and multiple classes with varying amounts)NameWhy date date 2 n/a n/a n/a Class AmountJoe SmithHoliday 06/06/2024 ########## 0.00 0.00 Y 281.00_General Operations195.00 2) after I get the data of just the totals for each class I am going to have my rows with the class with the amount in a column and the name relating somehow to the that data. In the end I will have multiple names and amounts going horizontal with some other added columns and formulas to determine a incentive payout but based on the amount in each class. ( I have figured out to use transpose and or just some simple formulas to make this happen. I just thought maybe if you knew the big picture you would see an easier way to get around it all)ClassJoe Smith% (amount/total)Bonus AmountFinal Funding200781%910 Read More
Why .net says it is not supported
I have exagear installed on my Samsung Andriod to emulate windows in it. I specifically activated Windows in it. Then I downloaded.net and now .net the installer says This OS does not support it. what should I do now?
I have exagear installed on my Samsung Andriod to emulate windows in it. I specifically activated Windows in it. Then I downloaded.net and now .net the installer says This OS does not support it. what should I do now? Read More
Regarding Triworker.exe crash to cbscore.dll with an error code of c0000005…
Hello to all, On Windows 11 Pro 24H2 RP latest build I sometimes get a crash regarding Windows Modules Installer Worker. This is the complete error message under the Windows Error Reporting Dialog under control panel and then security and mantainance and then etc etc etc It says this :
Description
Faulting Application Path: C:WindowsWinSxSamd64_microsoft-windows-servicingstack_31bf3856ad364e35_10.0.26100.998_none_ab30feedb06cf8c8TiWorker.exe
Problem signature
Problem Event Name: APPCRASH
Application Name: TiWorker.exe
Application Version: 10.0.26100.998
Application Timestamp: f6990ba2
Fault Module Name: cbscore.dll
Fault Module Version: 10.0.26100.998
Fault Module Timestamp: a149c54c
Exception Code: c0000005
Exception Offset: 000000000004c140
OS Version: 10.0.26100.2.0.0.256.48
Locale ID: 1033
Additional Information 1: 7fcc
Additional Information 2: 7fccea33ab95e3af7744a9e0e0dde74b
Additional Information 3: d367
Additional Information 4: d367613844bd03775cf0e169aaa7fdb7
Extra information about the problem
Bucket ID: c811e39e947f331e3acf5ddcf708b0aa (1931865968783962282)
Anyways, I think it has to do with whenever it is in use and the memory usage gets high enough on the process known as triworker.exe it might crash that process in question which is triworker.exe although I am not entirely sure about that though.!! Anyways, If there is a possible fix or workaround I am open ears to anybody who might know of it!.. Thanks in advance for listening and Have a great day and stay safe also!.
Hello to all, On Windows 11 Pro 24H2 RP latest build I sometimes get a crash regarding Windows Modules Installer Worker. This is the complete error message under the Windows Error Reporting Dialog under control panel and then security and mantainance and then etc etc etc It says this : DescriptionFaulting Application Path: C:WindowsWinSxSamd64_microsoft-windows-servicingstack_31bf3856ad364e35_10.0.26100.998_none_ab30feedb06cf8c8TiWorker.exeProblem signatureProblem Event Name: APPCRASHApplication Name: TiWorker.exeApplication Version: 10.0.26100.998Application Timestamp: f6990ba2Fault Module Name: cbscore.dllFault Module Version: 10.0.26100.998Fault Module Timestamp: a149c54cException Code: c0000005Exception Offset: 000000000004c140OS Version: 10.0.26100.2.0.0.256.48Locale ID: 1033Additional Information 1: 7fccAdditional Information 2: 7fccea33ab95e3af7744a9e0e0dde74bAdditional Information 3: d367Additional Information 4: d367613844bd03775cf0e169aaa7fdb7Extra information about the problemBucket ID: c811e39e947f331e3acf5ddcf708b0aa (1931865968783962282) Anyways, I think it has to do with whenever it is in use and the memory usage gets high enough on the process known as triworker.exe it might crash that process in question which is triworker.exe although I am not entirely sure about that though.!! Anyways, If there is a possible fix or workaround I am open ears to anybody who might know of it!.. Thanks in advance for listening and Have a great day and stay safe also!. Read More
How do I encrypt email messages outlook
Hello
Please i need your help on this issue.
How do I encrypt email messages outlook.
Are any steps I need to follow to configure encrypt email messages on outlookAre they any license I need to haveAre they any requirements I need to meet
Hello Please i need your help on this issue. How do I encrypt email messages outlook. Are any steps I need to follow to configure encrypt email messages on outlookAre they any license I need to haveAre they any requirements I need to meet Read More
Importing a Database into VS Code
About
This article will talk through how one can import an existing database that lives on a SQL Server either on prem or in Azure onto a local machine. This import will create a .sqlproj. Per the documentation a sql Project is:
A Management Studio project is a collection of logically related scripts and files that can be saved together for database administration and development.
Once we have this then we will have the ability to make and test changes locally, place the contents under source control, and leverage Azure DevOps for CI/CD deployment. One misnomer that I will call out is that we will do this all without leveraging a Visual Studio License, which historically has been a prerequisite for managing SQL Databases.
Pre Reqs
In order to follow along with this process, one will need to have a combination of access and software installed on their computer. I will be walking through using Visual Studio Code; however, the process is quite similar if leveraging Azure Data Studio.
Visual Studio Code with the SQL Database Projects Extension OR Azure Data Studio
Via network connectivity/firewall ability to establish a connection to the desired SQL Database
Ability to login to the database and read all schema objects. This can be achieved via SQL Login or Entra ID. We will use Entra ID for our purposes.
Importing the Database
Now we will go step by step how to effectively download and recreate the database schema files on our local machine. This process will entail Creating the Connection Profile, Downloading the Database, and Confirming Your Local Copy.
Creating the Connection Profile
The first step is to launch Visual Studio Code (VS Code), or Azure Data Studio. Once we have this launched VS Code, we will leverage the Command Pallet in VS Code by the shortcut Ctrl+Shift+P and type in “Database Projects”
This will provide a list of actions one can perform in VS Code leveraging the Database Projects Extension. In our case we want to select “Database Projects: Create Project From Database”
After selecting this you will see an option to “Create Connection Profile” –it is possible if you have previously used Data Studio or VS Code to create a Connection Profile to the desired database in the past. If so, then feel free to skip this section.
The next prompt will ask you for the connection string. We will use just the server address to keep it basic. I am using a SQL PaaS Database that contains just the sample schema/data for Adventure Works.
We will then be prompted for an optional parameter to include the name of the database we’d like to download. I HIGHLY recommend scoping your project import to a single database. The reason behind this is, typically, individual databases are maintained, operated, and scoped for a single purpose. This means in the grand scheme of source control management and CI/CD we would want to scope our projects according to not only lifecycle but purpose as well.
In my case the database name is “sqlmoveme“
We will then be prompted to how to authenticate to the SQL DB. I will be using “Microsoft Entra Id – Universal”. The next screen will confirm the Entra Account we will be using to connect if leveraging SQL Login it will ask for the username and password. Odds are you will be choosing the “Add” option. When clicking this VS Code will launch a new browser session where you will log/MFA into the Entra ID Tenant.
After this step the MSSQL library will be testing a connection behind the scenes. This can be confirmed in the VS Code Output window by selecting MSSQL from the drop down and inspecting the logging:
Downloading the Database
After connecting VS Code will now prompt you to give your project a name. I would recommend naming the project either the same as your database or something similar.
After this VS Code will now ask what folder we should download and create the .sqlproj in.
I would recommend each database you are downloading have a separate folder. This will help later if we want to put our database under source control.
Once we have a location we will be asked how to import the database. This can be a bit of a dealer’s choice; however, I am going to choose to import the “Schema/Object Type” option. Others are perfectly fine.
Once selecting this you will be prompted if permissions and security scripts should be included. I would advise you not to include this as it will contain the credentials for SQL Logins, which we should not be storing under source control.
The next prompt around “SDK-style project” may sound a bit confusing. This is prompting the user if they’d like to leverage Use SDK-style projects with the SQL Database Projects extension though listed in preview at the time of this writing I’d still encourage you to select this option. It will let us build the .sqlproj leveraging a ‘dotnet build’ build command and more importantly won’t require us to have Visual Studio.
Once selected VS Code will download the database locally and the result, in the case of Adventure Works, will look like:
Confirming Your Local Copy
At this point we can see the database schemas, in our example this is just `dbo` and `SalesLT`. If expanding these folders we can see all the object types and their definitions. In this screenshot the table Address has been selected and one can see the associated SQL script:
Let’s make a change and save it. I am going to add an “Address Line3” with NULLs being allowed into our table definition and save it.
Now let’s right click the Address.sql file in the File Explorer and select “Reveal in File Explorer”. This will launch File Explorer where we can confirm the date modified on our Address.sql has been updated.
Building the Database
Now that we confirmed we can make these changes in our local .sqlproj the next logical question is how should we deploy or product an artifact to deploy. Since we are using the SDK-style projects with the SQL Database Projects extension a `dotnet build` command entered in the VS Code terminal will produce our deployable artifact. I am going to use .dacpac for future iterations of this blog series.
Next Steps
Once we have the .dacpac file locally we can deploy this either manually through SQL Server Management Studio or Azure Data Tools or preferrable through a CI/CD process which I will cover in a future post leveraging the SqlAzureDacpacDeployment task. However; before we do that we should discuss how to push the database project we just created to source control. To be alerted when this blog is available be sure to follow me on Tech Community
Microsoft Tech Community – Latest Blogs –Read More
Is it Entra ID and Entra External ID Collab + Entra External ID B2C? Or?
Hi,
Will someone please clarify something for me.
Are Entra ID and Entra External ID different products or just the same product separated into logical tenants for the purpose of security partitioning?
I was reviewing the FAQ for an upcoming CIAM webinar the following question was presented:
Question: I am currently using Azure AD B2B collaboration and B2B direct connect, have these experiences changed?
Answer: Azure AD B2B collaboration and B2B direct connect are now part of Microsoft Entra External ID as External ID B2B collaboration and B2B direct connect. There are no changes to your product experience, B2B collaboration features remain in the same location in the Microsoft Entra admin center within the workforce tenant, allowing you to secure all business guests, streamline collaboration, and limit access risks extending ID Governance to external users.
This indicates that if you are currently using Azure AD for guest accounts (due to the limitations of Azure B2C) then there’s no change. The conclusion then is the only benefit of using Entra External ID is strictly for any new/future capabilities and replacement of Azure AD B2C. We are looking for federation of B2C customers IdP customers on a more enterprise level, not just Google and Facebook but we desire to have the security partition in place and not have guest accounts in our Entra ID Enterprise tenant.
Very confusing.
Thanks.
Hi,Will someone please clarify something for me. Are Entra ID and Entra External ID different products or just the same product separated into logical tenants for the purpose of security partitioning? I was reviewing the FAQ for an upcoming CIAM webinar the following question was presented: Question: I am currently using Azure AD B2B collaboration and B2B direct connect, have these experiences changed?Answer: Azure AD B2B collaboration and B2B direct connect are now part of Microsoft Entra External ID as External ID B2B collaboration and B2B direct connect. There are no changes to your product experience, B2B collaboration features remain in the same location in the Microsoft Entra admin center within the workforce tenant, allowing you to secure all business guests, streamline collaboration, and limit access risks extending ID Governance to external users. This indicates that if you are currently using Azure AD for guest accounts (due to the limitations of Azure B2C) then there’s no change. The conclusion then is the only benefit of using Entra External ID is strictly for any new/future capabilities and replacement of Azure AD B2C. We are looking for federation of B2C customers IdP customers on a more enterprise level, not just Google and Facebook but we desire to have the security partition in place and not have guest accounts in our Entra ID Enterprise tenant. Very confusing. Thanks. Read More
What Are the Benefits and Considerations for Switching to a Local Account
I recently inherited a laptop and started using it, only to discover that it’s currently set up with a Microsoft account instead of a local account. I’d like to switch to a local account, but I’m concerned about what features or data might become inaccessible as a result.
Specifically, one of the laptop’s internal drives has BitLocker encryption enabled. If I switch to a local account, will I still be able to access the encrypted drive, or will it become inaccessible? Any insight or guidance would be greatly appreciated!
I recently inherited a laptop and started using it, only to discover that it’s currently set up with a Microsoft account instead of a local account. I’d like to switch to a local account, but I’m concerned about what features or data might become inaccessible as a result. Specifically, one of the laptop’s internal drives has BitLocker encryption enabled. If I switch to a local account, will I still be able to access the encrypted drive, or will it become inaccessible? Any insight or guidance would be greatly appreciated! Read More
tracking user activity to data/shares
Hello,
Sorry in advance if this isn’t the right place to post this.
I have a group of people that I need to figure out what data/shares they are accessing the most.
Is there a way to see this in AD or by using some sort of PowerShell command?
Thank you,
J
Hello,Sorry in advance if this isn’t the right place to post this.I have a group of people that I need to figure out what data/shares they are accessing the most. Is there a way to see this in AD or by using some sort of PowerShell command? Thank you,J Read More