Skip to content

Instantly share code, notes, and snippets.

View skmkzyk's full-sized avatar

Kazuyuki Sakemi skmkzyk

  • Microsoft
  • Tokyo
View GitHub Profile
@skmkzyk
skmkzyk / repeat-azcopy.ps1
Created October 17, 2019 02:18
simple load test script for azcopy
while ($true) {
$i = Get-Random 20
./azcopy.exe cp https://xxxxxxxxxxxxxxxxxxxx.blob.core.windows.net/sample/test$(([string]$i).padleft(2,"0")).txt .
sleep $($i*30)
}
@skmkzyk
skmkzyk / sql-server-role-members.sql
Created October 18, 2019 07:11
list all the roles and its members
select sdrm.*, sdp.name, sdp2.name from sys.database_role_members as sdrm
inner join sys.database_principals as sdp on sdrm.role_principal_id = sdp.principal_id
inner join sys.database_principals as sdp2 on sdrm.member_principal_id = sdp2.principal_id
@skmkzyk
skmkzyk / private-link-center.ps1
Last active October 20, 2019 12:34
powershell script for private link center creation.
@skmkzyk
skmkzyk / gist:7304e3ae3d9be05306a4c249bfed061c
Created October 21, 2019 10:24
output for New-AzPrivateLinkService against Application Gateway
New-AzPrivateLinkService : Cannot bind parameter 'LoadBalancerFrontendIpConfiguration'. Cannot convert the "Microsoft.Azure.Commands.Network.Models.PSApplicationGatewayFrontendIPConfiguration" value of type "Microsoft.Azure.Commands.Network.Models.PSApplicationGatewayFrontendIPConfiguration" to type "Microsoft.Azure.Commands.Network.Models.PSFrontendIPConfiguration".
At line:5 char:38
+ -LoadBalancerFrontendIpConfiguration $frontendIP `
+ ~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (:) [New-AzPrivateLinkService], ParameterBindingException
+ FullyQualifiedErrorId : CannotConvertArgumentNoMessage,Microsoft.Azure.Commands.Network.NewAzurePrivateLinkService
@skmkzyk
skmkzyk / repeat-azcopy-sas.ps1
Created October 27, 2019 08:29
azcopy script using SAS.
while ($true) {
$i = Get-Random 10
$ext = ".dat"
$container = "test"
$filename = "test" + ([string]$i).padleft(2,'0') + $ext
$accountname = "xxxxxxxxxx"
$sas = "xxxxxxxxxx"
$url = "https://" + $accountname + ".blob.core.windows.net/" + $container + "/" + $filename + $sas
@skmkzyk
skmkzyk / az_vm_image_list_offer_windows-7
Created December 14, 2019 11:30
az vm image list --offer windows-7 --all
[
{
"offer": "windows-7",
"publisher": "MicrosoftWindowsDesktop",
"sku": "win7-enterprise",
"urn": "MicrosoftWindowsDesktop:windows-7:win7-enterprise:7601.24535.1911101844",
"version": "7601.24535.1911101844"
},
{
"offer": "windows-7",
@skmkzyk
skmkzyk / az_vm_image_list_offer_WindowsServer
Created December 14, 2019 11:34
az vm image list --offer WindowsServer --all
[
{
"offer": "WindowsServerHPCPack",
"publisher": "MicrosoftWindowsServerHPCPack",
"sku": "2012R2",
"urn": "MicrosoftWindowsServerHPCPack:WindowsServerHPCPack:2012R2:4.5.5159",
"version": "4.5.5159"
},
{
"offer": "WindowsServerHPCPack",
@skmkzyk
skmkzyk / az_vm_image_list_offer_WindowsServer_sku_smalldisk
Created December 14, 2019 11:37
az vm image list --offer WindowsServer --sku smalldisk --all
[
{
"offer": "WindowsServer",
"publisher": "MicrosoftWindowsServer",
"sku": "2008-R2-SP1-smalldisk",
"urn": "MicrosoftWindowsServer:WindowsServer:2008-R2-SP1-smalldisk:2.127.20180613",
"version": "2.127.20180613"
},
{
"offer": "WindowsServer",
@skmkzyk
skmkzyk / afd-routingrule.ps1
Created January 6, 2020 12:58
afd-routingrule.ps1 | clip
for ($i = 0; $i -lt 100; $i++) {
Write-output @"
{
"id": "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourcegroups/front-door/providers/Microsoft.Network/Frontdoors/xxxxxxxxxxxxxxxxxxxxx/RoutingRules/$(([string]$i).padleft(5,"0"))",
"name": "$(([string]$i).padleft(5,"0"))",
"properties": {
"acceptedProtocols": [
"Http",
"Https"
@skmkzyk
skmkzyk / msdocs trans
Last active January 14, 2020 12:53
bookmarklet to translate en-us <-> ja-jp for microsoft document pages. see also: https://gist.github.com/OpenJNY/e2e60d81b833677be55593ba15f9b1fa
javascript: var regexp = /((azure|docs)\.microsoft\.com)\/(en-us|ja-jp)\//; if (location.href.match(regexp)) { if (RegExp.$3 === "en-us") { lang = "/ja-jp/"; } else if (RegExp.$3 === "ja-jp") { lang = "/en-us/"; } location.href = location.href.replace(regexp, function () { return arguments[1] + lang }); }