Skip to content

Instantly share code, notes, and snippets.

View EbenZhang's full-sized avatar

EbenZhang EbenZhang

  • Nicologies
  • Perth
View GitHub Profile
@EbenZhang
EbenZhang / FindConflictingReferences.cs
Created October 26, 2015 04:36 — forked from brianlow/FindConflictingReferences.cs
Find conflicting assembly references
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Reflection;
using NUnit.Framework;
namespace MyProject
{
[TestFixture]
@EbenZhang
EbenZhang / RestoreSQLServerDBUsingSMOInPowershell.ps1
Last active September 24, 2019 07:57
Restore SQLServer Database using Powershell and SMO
$ErrorActionPreference = "Stop"
$assemblylist =
"Microsoft.SqlServer.Management.Common",
"Microsoft.SqlServer.Smo",
"Microsoft.SqlServer.Dmf ",
"Microsoft.SqlServer.Instapi ",
"Microsoft.SqlServer.SqlWmiManagement ",
"Microsoft.SqlServer.ConnectionInfo ",
"Microsoft.SqlServer.SmoExtended ",
"Microsoft.SqlServer.SqlTDiagM ",
@EbenZhang
EbenZhang / CallGitHubApi.ps1
Last active November 21, 2022 09:12
Powershell to call GitHub Api using personal token
function CreateGitHubRequestHeaders([string]$username, [string]$token){
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
$base64AuthInfo = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(("{0}:{1}" -f $username,$token)))
$headers = @{Authorization="Basic $base64AuthInfo"}
return $headers
}
function GetRestfulErrorResponse($exception) {
$ret = ""
if($exception.Exception -and $exception.Exception.Response){