Skip to content

Instantly share code, notes, and snippets.

@kevinhillinger
kevinhillinger / SQLFireOpenConnectionCountTest
Created April 10, 2014 15:05
Try to open sql connections against sqlfire
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Dapper;
using VMware.Data.SQLFire;
namespace sqlfire._112
@kevinhillinger
kevinhillinger / Global.asax.cs
Created March 2, 2017 16:40
Setting IP Restrictions on web.config through a data source
using IpRestrict.App_Start;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Optimization;
using System.Web.Routing;
namespace IpRestrict
@kevinhillinger
kevinhillinger / FileCacher.cs
Created April 10, 2017 20:04
Cache XML Files
class FileCacher
{
public Dictionary<string, byte[]> GetXmlFilesAsCache(IEnumerable<string> xmlFiles)
{
var cache = new Dictionary<string, byte[]>();
foreach (var file in xmlFiles)
{
cache.Add(file, GetBytes(file));
}
@kevinhillinger
kevinhillinger / function.cs
Last active September 6, 2018 21:20
Azure Functions - Azure Blob Storage - Streaming block blobs
// generic use of SDK
var account = new CloudStorageAccount(credentials, true);
var client = new CloudBlobClient(account.BlobEndpoint.AbsoluteUri, account.Credentials);
var container = client.GetContainerReference("test");
var blob = container.GetBlobReference("CloudBlob.txt");
using (var stream = blob.OpenRead())
{
using (var reader = new StreamReader(stream))
{
@kevinhillinger
kevinhillinger / __main__.py
Last active August 3, 2017 12:34
Azure SDK - Python - Delete Managed Data Disk with VM Lease check
import os
from delete_datadisk import delete_data_disk
def main():
os.environ['AZURE_SUBSCRIPTION_ID'] = ""
os.environ['AZURE_CLIENT_ID'] = ""
os.environ['AZURE_CLIENT_SECRET'] = ""
os.environ['AZURE_TENANT_ID'] = ""
resource_group = 'managed-disks'
@kevinhillinger
kevinhillinger / update_nic.py
Last active November 13, 2023 00:12
Azure Python SDK - Networking - Network Interface - updating nic
import os
from azure.common.credentials import ServicePrincipalCredentials
from azure.mgmt.network import NetworkManagementClient
subscription_id = os.environ.get(
'AZURE_SUBSCRIPTION_ID',
'11111111-1111-1111-1111-111111111111') # your Azure Subscription Id
credentials = ServicePrincipalCredentials(
client_id=os.environ['AZURE_CLIENT_ID'],
@kevinhillinger
kevinhillinger / provision_vm.ps1
Created August 9, 2017 18:39
Provision VM from existing OS disk and data disks
function New-ProvisionVirtualMachineCommand() {
$command = (New-Object -TypeName PSObject -Prop (@{
Name = $null;
Size = $null;
DnsLabel = $null;
Location = $null;
Credentials = $null
ResourceGroup = @{ Name = $null; Location = $null };
VirtualNetwork = @{ Name = $null; ResourceGroupName = $null; Location = $null; SubnetName = $null; };
OS = @{ Windows = $true; Linux = $false };
@kevinhillinger
kevinhillinger / AzureSettings.cs
Last active September 28, 2017 15:38
Lookup FQDN of Application Gateway for backend App Services Web App - asp.net core
public class AzureSettings
{
public IAzure Azure { get; set; }
}
@kevinhillinger
kevinhillinger / self_delete_aci.py
Created October 3, 2017 16:55
Azure Container Instance - Self Deletion - Python
import os
from azure.common.credentials import ServicePrincipalCredentials
from azure.mgmt.containerinstance import ContainerInstanceManagementClient
subscription_id = os.environ.get(
'AZURE_SUBSCRIPTION_ID',
'11111111-1111-1111-1111-111111111111') # your Azure Subscription Id
credentials = ServicePrincipalCredentials(
client_id=os.environ['AZURE_CLIENT_ID'],
@kevinhillinger
kevinhillinger / create_aci_.py
Last active October 3, 2017 17:11
Azure Container Instance - Create - Python
import os
from azure.common.credentials import ServicePrincipalCredentials
from azure.mgmt.containerinstance import ContainerInstanceManagementClient
from azure.mgmt.containerinstance.models import ContainerGroup
from azure.mgmt.containerinstance.models import IpAddress
subscription_id = os.environ.get(
'AZURE_SUBSCRIPTION_ID',
'11111111-1111-1111-1111-111111111111') # your Azure Subscription Id