Skip to content

Instantly share code, notes, and snippets.

ashtewari /
Created September 5, 2022 02:25 — forked from yorickdowne/
Get that sweet Sepolia ETH

Sepolia is now on PoS

As of 2022/7/6, Sepolia has switched to PoS. The window to do some mining has closed.

Testnets after merge (original, old content from here)

It's mid 2022, Ethereum is still PoW and motoring towards merge / PoS. Surviving testnets will be Sepolia - currently PoW - and Goerli. Ropsten will be merged and then deprecated, Rinkeby and Kovan won't be merged.

I want to "get ready" for some Sepolia testing pre- and post-merge. Sepolia will not have a public validator set; testing post-merge will be limited to running applications on it. As Sepolia is PoW, I can actually go mine myself some SepplETH. Here's how.

View Get-AksSupportedVersions
$header = @"
h1 {
font-family: Arial, Helvetica, sans-serif;
color: #296940;
font-size: 28px;
h2 {
font-family: Arial, Helvetica, sans-serif;
View simplebank-destructible.sol
pragma solidity ^0.4.24;
import "";
contract SimpleBank is Destructible {
mapping (address => uint) private balances;
address public owner;
View simplebank.sol
pragma solidity ^0.4.24;
contract SimpleBank {
mapping (address => uint) private balances;
event LogDepositMade(address accountAddress, uint amount);
address public owner;
View create-bacpac.ps1
Visual Studio 2015 build creates a dacpac file, but Azure Resource Manager templates can use only bacpac files.
This powershell script automates creation of bacpac and publishing to the blob storage.
After building the data project, open a command prompt on the folder containing the dacpac file.
Copy this script to the same folder.
You need :
1. Name of the localdb server where the dacpac is published ((localdb)\ProjectsV13)
ashtewari / azure-ad-login.js
Last active July 30, 2019 09:43
Protractor script for Azure AD Login
View azure-ad-login.js
Usage :
Execute protractor on command line
protractor e2e.conf.js --params.url= --params.pwd=PASSWORD
Sample spec file
var AzureAdLogin = require('./azure-ad-login');
View Search-Splunk-Using-Powershell.ps1
$lastDay = ( get-date ).addDays( -1 ).toString( ‘s’ );
$lastHour = ( get-date ).addMinutes( -60 ).toString( ‘s’ );
$searches = @(
, "source=""*"" ERROR"
, "CreditDoesNotMatch"
,"source=""\\www3/access.log"" productId=WC-SH-G04"
View transfer_data_between_azure_storage_accounts
## Transfer data in Azure Storage Tables from one Azure Storage Account to another
## Download and install AzCopy --
## Get the Preview version of AzCopy in order to access Table Storage. The current stable version works with Blob storage only.
## Tables will be created if they don't exist
$source_acct = "Source_Azure_Storage_Account_Name"
View ExecuteTwoMethodsOpeningTwoConnections
private static void ExecuteTwoMethodsOpeningTwoConnections(string connectionString)
using(TransactionScope scope = new TransactionScope())
Console.WriteLine("Both records are written to database transactionally.");
View ExecuteSqlTransactionUsingTransactionScope
private static void ExecuteSqlTransactionUsingTransactionScope(string connectionString)
using(TransactionScope scope = new TransactionScope())
using (SqlConnection connection = new SqlConnection(connectionString))
SqlCommand command = connection.CreateCommand();