Skip to content

Instantly share code, notes, and snippets.

:octocat:
Hello!

Richie Lee RichieBzzzt

:octocat:
Hello!
Block or report user

Report or block RichieBzzzt

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View InvokeMsBuildSSDTIncDacpacRootPathBasic.ps1
function Invoke-MsBuildSSDT {
<#
.SYNOPSIS
Build a datbase project/solution using Microsoft.Data.Tools.MSBuild
.DESCRIPTION
Using MSBUild, the database project/solution is comiled using Microsoft.Data.Tools.MSBuild. This can be downloaded by using Install-MicrosoftDataToolsMSBuild
.PARAMETER DatabaseSolutionFilePath
Mandatory - Filepath to the sln/sqlproj file.
View syncCredntials.ps1
$subscriptionId = ''
$resourceGroupName = ''
$factoryName = ''
$integrationRuntimeNames = @('', '')
$ErrorActionPreference = "Stop"
try{
Get-AzureRmSubscription -SubscriptionId $subscriptionId -ErrorVariable nosession
}
catch {}
if ($nosession) {
View Disable_pipelinetrigger.ps1
param(
[parameter(Mandatory = $true)] [string]$ResourceGroupName,
[parameter(Mandatory = $true)] [string]$dataFactoryName,
[parameter(Mandatory = $true)] [string]$location,
[parameter(Mandatory = $false)] [string]$environmentsuffix,
[parameter(Mandatory = $false)] [string]$clientID,
[parameter(Mandatory = $false)] [string]$tenantID,
[parameter(Mandatory = $false)] [string]$key
)
View Enable_pipelinetrigger.ps1
param(
[parameter(Mandatory = $true)] [string]$ResourceGroupName,
[parameter(Mandatory = $true)] [string]$dataFactoryName,
[parameter(Mandatory = $true)] [string]$location,
[parameter(Mandatory = $false)] [string]$environmentsuffix,
[parameter(Mandatory = $false)] [string]$clientID,
[parameter(Mandatory = $false)] [string]$tenantID,
[parameter(Mandatory = $false)] [string]$key
)
View InstallFromPSGallery.ps1
try {
Find-Module -Name "AzureRM"
}
catch {
Write-Host "No AzureRM, Installing from PSGallery."
Install-PackageProvider -Name NuGet -Force -Scope CurrentUser
Install-Module AzureRM -Force -Scope CurrentUser
}
View InstallNuget.ps1
function Install-MicrosoftDataToolsMSBuild {
[cmdletbinding()]
param (
[parameter(Mandatory)]
[string] $WorkingFolder,
[string] $NuGetPath
)
Write-Verbose "Verbose Folder (with Verbose) : $WorkingFolder"
Write-Verbose "DataToolsVersion : $DataToolsMsBuildPackageVersion"
View InstallNuget.ps1
function Install-MicrosoftDataToolsMSBuild {
[cmdletbinding()]
param (
[parameter(Mandatory)]
[string] $WorkingFolder,
[string] $DataToolsMsBuildPackageVersion,
[string] $NuGetPath
)
Write-Verbose "Verbose Folder (with Verbose) : $WorkingFolder"
View mungemarkDownFiles.ps1
Get-ChildItem "C:\phbx\phbx\phbx\markdown5" -Filter *.md |
Foreach-Object {
$content = Get-Content $_.FullName
ForEach ($line in $content) {
$ignore = $false
if ($line -match "(jpg|png|bmp)" ) {
try {
$sub = $line.SubString(0, $line.IndexOf(">"))
$sub = $sub.Substring(0, $sub.LastIndexOf('"'))
$sub = $sub.trim('<a href="http://phoenixultd.files.wordpress.com')
View MigrateFromWordpressToMarkdown.ps1
[xml]$xml = Get-Content "C:\phbx\phbx\phbx\1.xml"
$folderformarkdown = "C:\phbx\phbx\phbx\markdown4"
$xmlposts = $xml.rss.channel.Item | Where-Object {($_.creator -eq "phoenixultd") -and ($_.status -eq "publish")}
foreach ($xp in $xmlPosts)
{
$content = $xp.content.InnerText
$date = Get-Date $xp.pubDate -Format 'yyyy-MM-dd'
$tags = @()
for ($i = 0; $i -le $xp.category.Count-1; $i++)
View deployment.targets
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
<OutputPath>bin\$(Configuration)\</OutputPath>
<DebugSymbols>false</DebugSymbols>
<SkipCopyBuildProduct>true</SkipCopyBuildProduct>
<AddAdditionalExplicitAssemblyReferences>false</AddAdditionalExplicitAssemblyReferences>
<TargetRuntime>None</TargetRuntime>
You can’t perform that action at this time.