-
-
Save DocGreenRob/a7f08d56bae684f7f00583f446c27e8a to your computer and use it in GitHub Desktop.
| Windows Pro Tips | |
| ----------------- | |
| powertoys - https://apps.microsoft.com/store/detail/microsoft-powertoys/XP89DCGQ3K6VLD | |
| devtoys - https://apps.microsoft.com/store/detail/devtoys/9PGCV4V3BK4W | |
| Visual Studio 2022 Pro Tips | |
| --------------------------- | |
| vscoloroutput - https://marketplace.visualstudio.com/items?itemName=MikeWard-AnnArbor.VSColorOutput | |
| solutionColor - https://marketplace.visualstudio.com/items?itemName=Wumpf.SolutionColor | |
| save vs settings to apply to other computer - https://learn.microsoft.com/en-us/visualstudio/install/import-export-installation-configurations?view=vs-2022 | |
| Podcasts | |
| -------- | |
| Dev interrupted | |
| Hacking Humans | |
| Cyber Security Headlines | |
| Click Here | |
| Malicious Life | |
| The Stack Overflow Podcast | |
| The Backend Engineering (with Hussein Nasser) | |
| The Changelog: Software Development, Open Source | |
| Tech Stuff | |
| Cyberwire Daily | |
| Techmeme Ride Home | |
| Soft Skills Engineering | |
| Syntax - Tasty Web Development Treats | |
| Cyber Security Today | |
| Software Engineering Daily | |
| Developer Tea | |
| Coding Blocks .NET | |
| The Cloud Cast | |
| JS Party: Javascript, CSS, Web Development | |
| Go Time: Golang, Software Engineering | |
| Cyber | |
| Dev Questions with Tim Corey | |
| Thoughtworks Technology Podcast | |
| .NET Rocks! | |
| Smashing Security | |
| Hanselminutes with Scott Hanselman | |
| Software Engineering | |
| Talk Python To Me | |
| Security Now | |
| Darknet Diaries | |
| Hacked | |
| The .NET Core Podcast | |
| The .NET MAUI Podcast | |
| Kubernetes Podcast from Google | |
| Adventures in .NET | |
| Coding After Work | |
| Base.cs Podcast | |
| The Static Void Podcast | |
| Tools | |
| ------ | |
| couchbase | |
| honeycomb.io/changelog | |
| firehydrant | |
| logrocket | |
| playwright | |
| openmct | |
| thundra.io | |
| raygun | |
| fly.io | |
| appwrite | |
| sentry.io | |
| https://sourcegraph.com/ | |
| https://www.kolide.com/ | |
| https://entity.services/ | |
| WeekPlan | |
| Docker Extensions | |
| ------------------ | |
| Ddosify - High-performance load testing tool | |
| - https://github.com/ddosify/ddosify | |
| BurpSuite | |
| - https://portswigger.net/burp | |
| - https://danaepp.com/ | |
| VS Tips | |
| -------- | |
| Extract method from selected code | |
| - Ctrl + R + M | |
| Ctrl + K + D | |
| Ctrl + R + G | |
| Ctrl + M + Z (Code Maid) | |
| Important | |
| ---------- | |
| ApplicationInsights SamplingSettings for AzFn | |
| - https://learn.microsoft.com/en-us/azure/azure-functions/functions-host-json | |
| Design Patterns in C# | |
| - https://www.dofactory.com/net/factory-method-design-pattern | |
| - https://github.com/DovAmir/awesome-design-patterns?utm_source=programmingdigest&utm_medium&utm_campaign=1493 | |
| Shopify Query | |
| - https://shopify.engineering/reducing-bigquery-costs?utm_source=programmingdigest&utm_medium&utm_campaign=1403 | |
| Building Own Operating System | |
| - https://o-oconnell.github.io/2023/01/12/p1os.html?utm_source=programmingdigest&utm_medium&utm_campaign=1493 | |
| Debugging Linq | |
| - https://www.red-gate.com/simple-talk/development/dotnet-development/linq-secrets-revealed-chaining-and-debugging/ | |
| --> https://michaelscodingspot.com/debug-linq-in-csharp/ | |
| Bleeping Computer | |
| - https://www.bleepingcomputer.com/ | |
| Utilities | |
| --------- | |
| Handle v5.0 | |
| - https://learn.microsoft.com/en-us/sysinternals/downloads/handle?WT.mc_id=DT-MVP-5003978 | |
| Auto Increment Build # | |
| - https://stackoverflow.com/questions/826777/how-to-have-an-auto-incrementing-version-number-visual-studio | |
| Phylosophy | |
| ---------- | |
| 1. Do I have to have a "purpose" to have an address in the USA? | |
| - if yes, then as a Human being I must have a purpose? Seriously? Ok, a purpose to whom? To whom must I state my pupose or execute or report to about...??? | |
| 2. System Failure - Zero Day Exploit | |
| 3. Good PR example - https://github.com/dotnet/aspnetcore/pull/45587/files | |
| App Insights Log Queries | |
| ------------------------ | |
| availabilityResults | |
| | where timestamp > datetime("2022-12-19T04:07:00.000Z") and timestamp < datetime("2022-12-20T04:07:00.000Z") | |
| | where customDimensions["WebtestArmResourceName"] == "availability-test-1-app-notepad-physical-activity-dev-eastus" | |
| | where true and true | |
| | extend percentage = toint(success) * 100 | |
| | summarize avg(percentage) by bin(timestamp, 1h) | |
| | render timechart | |
| ****************************************************************** | |
Random Key Generator
Set Execution Policy (Powershell)
Set-ExecutionPolicy RemoteSigned
Set-ExecutionPolicy Restricted
Great! Let's create a basic web scraper using Python that will scrape a simple, publicly accessible news website. We'll use BeautifulSoup for parsing HTML content and requests for making HTTP requests. Our scraper will extract article titles and their corresponding URLs from the website's main page. Here's a step-by-step plan:
- Setup: Install BeautifulSoup and requests libraries.
- Fetching Web Page Content: Use requests to fetch the HTML content of the news website.
- Parsing HTML Content: Use BeautifulSoup to parse the HTML and extract the desired data.
- Storing Results: Store the extracted titles and URLs in a structured format like a CSV file.
- Handling Exceptions: Implement error handling to manage potential issues like network problems.
- Ethical Considerations: Brief discussion on ethical web scraping practices.
I'll provide a sample code for these steps. You can then run this code in your local Python environment. Let's start with the code:
import requests
from bs4 import BeautifulSoup
import csv
def scrape_news_site(url):
# Send a request to the website
response = requests.get(url)
# Parse the HTML content of the page
soup = BeautifulSoup(response.text, 'html.parser')
# Find all article elements (this depends on the website's structure)
articles = soup.find_all('article')
news_data = []
for article in articles:
title = article.find('h2').get_text() # Example, change the tag based on the actual structure
link = article.find('a')['href']
news_data.append({'title': title, 'url': link})
return news_data
def save_to_csv(data, filename):
with open(filename, 'w', newline='', encoding='utf-8') as file:
writer = csv.DictWriter(file, fieldnames=['title', 'url'])
writer.writeheader()
for row in data:
writer.writerow(row)
def main():
url = 'https://example-news-site.com' # Replace with the actual URL
news_data = scrape_news_site(url)
save_to_csv(news_data, 'news_data.csv')
print("Scraping completed and data saved to news_data.csv")
if __name__ == "__main__":
main()In this example, we're assuming a simple structure for the news website where each article is contained in an <article> tag, and the title is in an <h2> tag within it. The actual tags and structure would depend on the specific website you're scraping.
Remember, this is a basic example for educational purposes. Real-world web scraping can be more complex due to the varied and dynamic nature of websites.
Feel free to run this script in your Python environment, and let me know if there are specific aspects of web scraping or ethical discussions you'd like to delve into further!
.NET Conf 2023 Links
- https://github.com/sayedihashimi/restaurantservice
- VS Code Extension Building - Github @ kinfey
Handsontable
<style type="text/css">
/*#requestTable .ht_master .htCore > tbody > tr:first-child > td {
background-color: #b6ff00;
}*/
#requestTable .ht_master .htCore > tbody > tr:nth-child(even) > td {
background-color: #f3f3f3;
}
#requestTable .ht_master .htCore > tbody > tr > td {
font-size: 16px;
}
#requestTable .ht_master .htCore > thead > tr > th {
font-size: 22px;
font-weight:bold;
color:blue;
background-color:blue;
}
#requestTable .ht_master .htCore > tbody > tr > th {
font-size: 22px;
font-weight:bold;
color:blue;
background-color:blue;
}
</style>
<script type="text/javascript">
$(document).ready(() => {
return;
var _ = <%= GetJsonTableData() %>;
const [header, ...rows] = _;
console.log(_);
const container = document.querySelector('#requestTable');
const hot = new Handsontable(container, {
contextMenu: true,
columnSorting: true,
//contextMenu: ['remove_row'
// , 'undo'
// , 'copy'
// , 'copy_with_column_headers'
// , 'copy_with_column_group_headers'
// , 'freeze_column'
// , 'unfreeze_column'
// , 'filter_by_condition'
// , 'filter_operators'
// , 'filter_by_value'
// , 'filter_action_bar'],
//columnSorting: {
// initialConfig: {
// column: 1,
// sortOrder: 'desc'
// },
// // sort empty cells as well
// sortEmptyCells: true,
// // display the arrow icon in the column header
// indicator: true,
// // disable clicking on the column header to sort the column
// headerAction: true,
// // add a custom compare function
// //compareFunctionFactory(sortOrder, columnMeta) {
// // return function (value, nextValue) {
// // // some value comparisons which will return -1, 0 or 1...
// // }
// //}
//},
// set any other column's width to the default 50px (note that longer cell values and column names can get cut)
colWidths: [80, 100, 100, 100, 200, 100, 100, 100, 100, 100],
readOnly: true,
data: rows,
//fixedRowsTop: 1,
rowHeaders: true,
colHeaders: header,
height: '50vh',
width: '100vw',
stretchH: 'all',
// enable filtering
filters: true,
// enable the column menu
dropdownMenu: true,
manualColumnResize: true,
licenseKey: 'non-commercial-and-evaluation', // for non-commercial use only
afterOnCellMouseUp: function (event, coords, TD) {
if (coords.row == 0) {
return;
}
if (coords.row < 0 || coords.col < 0) {
return;
}
var row = coords.row;
var data = this.getDataAtRow(row);
var id = data[0];
var documentType = data[15];
var customer = data[8];
var mil_comm = data[10];
var partNumber = data[1];
var program = data[7];
var division = data[11];
var status = data[17];
var requestor = data[13];
var requestStatus = data[20];
var pdf = data[19];
//alert(`Id: ${id}`);
//alert(`Document Type: ${documentType}`);
var destination = '';
if (documentType == 'CMM') {
destination = `CMMRequest?ID=${id}`;
} else {
destination = `ServiceBulletinRequest?ID=${id}`;
}
var port = window.location.port;
var url = '';
if (port == undefined
|| port == null
|| port == '') {
url = `${window.location.protocol}//${window.location.hostname}/techpubs/${destination}`;
} else {
url = `${window.location.protocol}//${window.location.hostname}:${port}/${destination}`;
}
window.location = `${url}`;
}
});
hot.alter('remove_col', 10);
})
</script>
Awesome AZD
DORA Metrics
SQL: Batch Deletes
DECLARE @BatchSize INT = 10000;
DECLARE @RowCount INT = @BatchSize;
BEGIN TRY
BEGIN TRAN;
WHILE @RowCount = @BatchSize
BEGIN
DELETE FROM "x".dbo.my_table
WHERE contact_id IN (
SELECT TOP(@BatchSize) contact_id FROM "x".dbo.my_table
WHERE created_date <= '2020-12-31'
AND (activity_code = 'APPEAL'
OR activity_code = 'EO')
);
SET @RowCount = @@ROWCOUNT;
END
SET @RowCount = @BatchSize;
WHILE @RowCount = @BatchSize
BEGIN
DELETE TOP(@BatchSize) FROM "x".dbo.my_table
WHERE created_date <= '2020-12-31'
AND (activity_code = 'APPEAL'
OR activity_code = 'EO');
SET @RowCount = @@ROWCOUNT;
END
COMMIT TRAN;
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION;
SELECT
ERROR_NUMBER()
, ERROR_SEVERITY()
, ERROR_STATE()
, ERROR_PROCEDURE()
, ERROR_LINE()
, ERROR_MESSAGE();
END CATCH
RegEx Find & Replace - (DateTime)
CAST\(.*? AS DateTime\)
PrimeIcons
The pi-eye and pi-save are part of the PrimeIcons library, which is used by PrimeFaces and PrimeNG components¹². The icons in this library use the pi pi-{icon} syntax, such as pi pi-check¹².
You can find the full list of available icons in the PrimeIcons library on the official PrimeFaces¹ and PrimeNG² websites. More icons are added periodically, and you can also request new icons at the issue tracker².
Here's an example of how you can use these icons:
<i class="pi pi-check"></i>
<i class="pi pi-times"></i>
<i class="pi pi-eye"></i>
<i class="pi pi-save"></i>You can control the size of an icon with the font-size property of the element². For example:
<i class="pi pi-check" style="font-size: [1](https://www.primefaces.org/diamond/icons.xhtml)rem"></i>
<i class="pi pi-times" style="font-size: 1.5rem"></i>
<i class="pi pi-eye" style="font-size: [2](https://primeng.org/icons)rem"></i>
<i class="pi pi-save" style="font-size: 2.5rem"></i>And you can define the icon color with the color property, which is inherited from the parent by default². For example:
<i class="pi pi-check" style="color: slateblue"></i>
<i class="pi pi-times" style="color: green"></i>
<i class="pi pi-eye" style="color: 'var(--primary-color)'></i>
<i class="pi pi-save" style="color: #708090"></i>Remember to import the CSS file of the icon library in styles.scss of your application²:
@import "primeicons/primeicons.css";I hope this helps! Let me know if you have any other questions. 😊
Source: Conversation with Bing, 1/27/2024
(1) Icons - PrimeFaces. https://www.primefaces.org/diamond/icons.xhtml.
(2) PrimeNG. https://primeng.org/icons.
Export Azure Web App Configuration Settings
To export the configuration settings from one Azure App Service and import them into another, you can use the Azure CLI or PowerShell. Here's how you can do it using the Azure CLI:
-
Export Configuration Settings:
az webapp config appsettings list --name <app-name> --resource-group <resource-group-name> --output json > appsettings.json
This command will export the application settings of the specified Azure App Service to a JSON file named
appsettings.json. -
Import Configuration Settings:
az webapp config appsettings set --name <app-name> --resource-group <resource-group-name> --settings @appsettings.json
This command will import the application settings from the
appsettings.jsonfile and apply them to the specified Azure App Service.
Make sure to replace <app-name> and <resource-group-name> with the appropriate values for your Azure App Service.
By following these steps, you can easily export and import the configuration settings between Azure App Services.
Service Bus Queues and Topics
az servicebus queue list --resource-group cge-rg-cgecoresandbox-dev --namespace-name sbns-cge-hzz-api-dev
az servicebus topic list --resource-group cge-rg-cgecoresandbox-dev --namespace-name sbns-cge-hzz-api-dev
# Define variables
source_rg=cge-rg-cgecoresandbox-dev
source_ns=sbns-cge-hzz-api-dev
target_rg=cge-rg-cgecoresandbox-qa
target_ns=sbns-cge-hzz-api-dev
# Get list of queues from source namespace
queues=$(az servicebus queue list --resource-group $source_rg --namespace-name $source_ns --query "[].name" -o tsv)
# Copy each queue to target namespace
for queue in $queues; do
az servicebus queue create --resource-group $target_rg --namespace-name $target_ns --name $queue
done
To achieve a single endpoint that routes traffic to your app service instances deployed in different regions, you can use Azure Traffic Manager or Azure Front Door. These services provide global load balancing and routing capabilities, allowing you to direct incoming requests to the nearest or most available instance of your app service based on factors such as geographic location, latency, or endpoint health.
Here's how you can set it up:
-
Deploy your app service instances: Deploy your app service to multiple regions as you normally would.
-
Configure Azure Traffic Manager or Azure Front Door:
- Create a new instance of either Azure Traffic Manager or Azure Front Door in your Azure portal.
- Define the routing method you prefer, such as geographic routing or performance-based routing.
- Add the endpoints of your app service instances deployed in different regions to the routing configuration.
- Configure the desired routing behavior, such as priority-based or weighted routing, depending on your requirements.
-
Update DNS settings: Point your domain's DNS records to the endpoint provided by Azure Traffic Manager or Azure Front Door. This ensures that incoming requests to your domain are routed through the load balancer or traffic manager, which then forwards them to the appropriate app service instance based on the routing rules you've defined.
By using Azure Traffic Manager or Azure Front Door, you can maintain a single endpoint for your application while distributing traffic across multiple app service instances deployed in different regions for improved availability and performance.
SQL: Find Indexes in DB
To find all indexes for all tables in any database in SQL Server, you can use the following query:
USE [YourDatabaseName]; -- Replace with your actual database name
GO
SELECT
DB_NAME() AS DatabaseName,
SCHEMA_NAME(t.schema_id) AS SchemaName,
t.name AS TableName,
ind.name AS IndexName,
col.name AS ColumnName
FROM
sys.tables t
INNER JOIN
sys.indexes ind ON t.object_id = ind.object_id
INNER JOIN
sys.index_columns ic ON ind.object_id = ic.object_id AND ind.index_id = ic.index_id
INNER JOIN
sys.columns col ON t.object_id = col.object_id AND col.column_id = ic.column_id
WHERE
ind.index_id > 0 -- Ignore heap tables
AND ind.is_hypothetical = 0 -- Ignore hypothetical indexes
ORDER BY
SchemaName,
TableName,
IndexName,
ic.index_column_id;Replace YourDatabaseName with the name of your database. You will need to run this script for each database you have.
For the second query, to find tables without indexes in any database, use the following query:
USE [YourDatabaseName]; -- Replace with your actual database name
GO
SELECT
DB_NAME() AS DatabaseName,
SCHEMA_NAME(t.schema_id) AS SchemaName,
t.name AS TableName
FROM
sys.tables t
WHERE
NOT EXISTS (
SELECT
1
FROM
sys.indexes ind
WHERE
t.object_id = ind.object_id
AND ind.index_id > 0 -- Indexes with index_id = 0 are heaps
AND ind.is_hypothetical = 0 -- Ignore hypothetical indexes
)
AND t.type = 'U' -- Only include user tables
ORDER BY
SchemaName,
TableName;Again, replace YourDatabaseName with the name of your database. This script also needs to be run for each database.
If you are looking to run these queries across all databases on a server, you would need to create a dynamic SQL script that iterates through each database and executes the query. However, this approach is more complex and should be handled with care, as it may have implications for performance and security.
Manually Rebuilding Indexes
For SQL Server, you can rebuild all indexes on a table with the following command:
ALTER INDEX ALL ON YourTableName REBUILD;If you have many tables and want to rebuild all indexes on all tables, you can use a cursor to loop through the tables:
DECLARE @TableName VARCHAR(255)
DECLARE TableCursor CURSOR FOR
SELECT [name]
FROM sys.tables
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC('ALTER INDEX ALL ON ' + QUOTENAME(@TableName) + ' REBUILD WITH (ONLINE = ON)')
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursorRemember to replace YourTableName with the actual table name. The WITH (ONLINE = ON) option allows the index to be rebuilt without taking the underlying table offline. This is only available in SQL Server Enterprise edition.
Automating Index Rebuilds with a Job
In SQL Server, you can schedule a job using SQL Server Agent:
- Open SQL Server Management Studio (SSMS).
- Connect to your SQL Server instance.
- Expand the "SQL Server Agent" node.
- Right-click on "Jobs" and choose "New Job...".
- Name your job and provide a description.
- Go to the "Steps" page and create a new step.
- Name the step and set the type to "Transact-SQL script (T-SQL)".
- Paste your index rebuild script into the command window.
- Go to the "Schedules" page and create a new schedule.
- Set the schedule to run daily at a time when the database load is low, like during the night.
Here is an example T-SQL script for the job step that rebuilds all indexes on all user tables:
DECLARE @TableName VARCHAR(255)
DECLARE @Sql NVARCHAR(1000)
DECLARE TableCursor CURSOR FOR
SELECT [name]
FROM sys.tables
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @Sql = N'ALTER INDEX ALL ON ' + QUOTENAME(@TableName) + ' REBUILD WITH (ONLINE = ON)'
EXEC sp_executesql @Sql
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursorMake sure you have proper backups and understand that index rebuilding can be resource-intensive. Monitor the job execution to ensure it doesn't adversely affect production workloads.
Also, consider whether you need to rebuild all indexes; sometimes, it's better to analyze index usage and fragmentation levels and only rebuild or reorganize where necessary. There are scripts available to help with this, such as Ola Hallengren's SQL Server Maintenance Solution.
Storing data in crystals
Storing data in crystals, specifically using 5D optical data storage in nanostructured glass, is a fascinating and cutting-edge technology. However, it's important to note that this technology is still in the experimental stage and not yet available for everyday use, like storing a "Hello World" program in a crystal.
The process involves using ultrafast lasers to create microscopic structures in fused quartz. These structures, representing the stored data, can be manipulated in five dimensions: three spatial dimensions plus two additional configurations related to the orientation and size of the nanostructures. The University of Southampton has been at the forefront of this research. Their technique allows for incredibly dense and long-lasting data storage – up to 360 terabytes of data can potentially be stored in a disc the size of a conventional CD, with a lifespan of up to 13.8 billion years.
Reading the data requires specific equipment like an optical microscope and a polarizer due to the microscopic and complex nature of the data encoding.
Meanwhile, Project Silica by Microsoft is exploring similar technology, focusing on storing data in quartz glass for long-term archival purposes. They aim to create a storage technology that's both sustainable and secure, using a unique approach that involves writing data with femtosecond lasers and reading it with polarization-sensitive microscopy.
It's an exciting field, but for now, these technologies are mainly in the research phase and not yet available for personal computing or general programming applications. Keep an eye on the progress in this area, as it holds great potential for future data storage solutions!
Certainly! Here are 10 .NET and software engineering-themed jokes for you and your coworkers:
-
Why do C# and VB.NET developers stay away from the beach? Because they can't handle unmanaged sandboxes.
-
Why was the JavaScript developer sad? Because he didn't Node how to Express himself!
-
Why do programmers always mix up Halloween and Christmas? Because Oct 31 equals Dec 25.
-
Why did the .NET developer feel boxed in? Because he was surrounded by too many frameworks!
-
How many software engineers does it take to change a light bulb? None, that's a hardware problem.
-
Why did the software engineer go to art school? To learn how to handle exceptions beautifully.
-
What do you call a .NET developer who writes clean code? A C#arp individual.
-
Why don't .NET developers play hide and seek? Because good luck hiding when the garbage collector is running.
-
How do you praise a .NET developer? "You're so good, you must have a really strong Framework of knowledge!"
-
Why was the ASP.NET website so alert? Because it was always awaiting requests.
Enjoy sharing these with your team! 😄
You can use the git branch command in PowerShell to list all branches in your repository. To exclude specific branches like 'master' and 'branch one', you can use the grep -v command which inverts the match. Here is the command you can use:
git branch | grep -v "master\|branch one"This command will list all the branches in your current repository except for 'master' and 'branch one'. Please replace 'master' and 'branch one' with the actual names of the branches you want to exclude if they are different.
Please note that this command requires Git Bash utilities. If you're using pure PowerShell, you might need to use a different approach as grep is not a built-in command in PowerShell. Here's how you can do it in pure PowerShell:
git branch | Where-Object {$_ -notmatch 'master|branch one'}This command does the same thing: it lists all branches except 'master' and 'branch one'. The Where-Object cmdlet in PowerShell is used to filter out objects from a collection that do not meet a certain condition. In this case, the condition is that the branch name does not match 'master' or 'branch one'.
You can delete all branches in your repository except for 'master', 'branch one', and the currently checked out branch using the following command in PowerShell:
git branch | ForEach-Object { if ($_ -notmatch '\*|master|branch one') { git branch -d $_.trim() } }This command does the following:
git branchlists all branches.ForEach-Objectloops over each branch.if ($_ -notmatch '\*|master|branch one')checks if the branch is not the currently checked out branch (represented by*) and is not 'master' or 'branch one'.git branch -d $_.trim()deletes the branch if the condition is met.
Please replace 'master' and 'branch one' with the actual names of the branches you want to keep if they are different.
Note: This command will only delete branches that have been merged. If you want to delete all branches regardless of whether they have been merged or not, you can use the -D option instead of -d.
git branch | ForEach-Object { if ($_ -notmatch '\*|master|branch one') { git branch -D $_.trim() } }Be careful with this command as it will delete branches even if they contain unmerged changes. Always make sure to check the branches and their changes before deleting them. It's a good practice to keep your work committed and pushed to a remote repository to avoid any loss of work.
$WShell = New-Object -Com Wscript.Shell
while (1) {$WShell.SendKeys("{SCROLLLOCK}"); sleep 60}
See VB Script behind Excel data
Alt + F11