- Reported on - 2023-12-18
- Last updated on - 2023-12-26
- Environment - All
- Investigators
- Joy George Kunjikkuru
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
################ Azure login params ################### | |
$ServicePrincipalCertificateThumbprint = '' | |
$TenantId = '' #This is AAD Tenant Id where the below app registration is created, not Subscription Id | |
$ApplicationId = '' #THis is the application registration id sometimes called clientId. Make sure this app registration has permission to send message. | |
################# One time install #################### | |
$azAccountsInstalled = Get-InstalledModule Az.Accounts |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Target Filder where files should be moved to. The script will automatically create a folder for the year and month. | |
$sourcePath = 'd:\Media' | |
$targetPath = 'd:\Media' | |
# Get the files which should be moved, without folders | |
$files = Get-ChildItem $sourcePath | where {!$_.PsIsContainer} | |
foreach ($file in $files) | |
{ | |
# Get year and Month of the file. Used LastWriteTime. | |
$date = "{0:00}" -f $file.LastWriteTime.Day |
The comparison is done based on 5 years usage and 1TB of storage. Below are the rationale
- Most hard drives has warranty till 5 years
- After 5 years some revolutionary technology may replace existing
- 1 TB is a good amount of data a beginner YouTuber will produce.
- If the 1 TB storage need changes the comparison would be void.
- Also this excludes the taxes as it changes by geography and time.
- Has free tier
- Social media login
Name | Mobile? | Connectors available | Connectors not available | Limits | Comments |
---|---|---|---|---|---|
Zapier | No | Only 2 steps,5 workflows,100 tasks/month | Youtube new video auth require posting video permission | ||
Microsoft flow / Power Automate | Android, iOS | 15mins frequency, unlimited workflows, 750 tasks/month | Need Microsoft account | ||
Integromat | Android | YouTube¹ | Unlimited workflows, 1000 tasks/month | Have generic HTTP SOAP and JSON connectors | |
Automate | Blogger, YouTube | 5 workflows, 250 tasks/month |
Comparison of SQL Server HA & DR solutions and comparison
No | SQL FCI with S2D | Alwasy On AG | Description |
---|---|---|---|
1 | MSDTC is not in pre Azure Win 2019 | Available from SQL 2016 SP2 onwards | Official link |
2 | Good for large no of database | MSFT only tested upto 100 DBs | |
3 | Fail over 30+secs | Fail over 1 secs | |
4 | Required shared storage | Each node stores | |
5 | DR to be done separately | One async node can be for DR | |
6 | FileStream needs non CSV volumne | Works natively |
Applies to - Web Server, Application Server & Database server
Counter | Instance | Object | Description |
---|---|---|---|
Processor Queue Length | System | Official link | |
% Processor Time | _Total | Processor Information | |
Available MBytes | Memory | ||
% Processor time | w3wp## | Process |
NewerOlder