dataGriff

Git Links

• [GitFlow] (https://nvie.com/posts/a-successful-git-branching-model/)
• Git emjois
• Get By With Git

dataGriff

Git Links

• GitFlow
• Git emjois
• Get By With Git
• Git Playlist
• MarkdownCheatsheet

dataGriff

title	author	date
Working with Git	Steph Locke	15 September 2018

Source control fundamentals

Source control concepts

dataGriff

#
# Install-Module -Force AzureRM #run as administrator
# run all below as administrator!!!
# may get errors if done one bit as admin and one bit not, remove and start again in new window 
# remember if using in releases to wrap passwords in double quotes in release! e.g. ""$(Password)""

$failoverGroup = $true
$passwordOverride = $true
$adminPasswordOverride = $true
$secretOverride = $false

dataGriff

$resourceGroupName = "datagriff-rg"
$location = "north europe"
$storageAccountName = "datagriffsa123456"
$tableName = "mytable"
$storagePolicyName = “readpolicy”
$expiryTime = (Get-Date).AddDays(7)
$permission = "r" ##r,w,l,d
$requestSaS = 1

function Update-StorageAccountTableSharedAccessPolicyWithSignature {

dataGriff

## Test Azure Resource Exists
clear-host
Write-Host "Test-AzureResourceExists Starting..."
if ([string]::IsNullOrEmpty($(Get-AzureRmContext).Account)) {Login-AzureRmAccount}
$resourceGroupName = "test-rg"
$resourceNames = @("test1", "test2")
$resourceExists = 0
if (-Not(Get-AzureRmResourceGroup  | where {$_.ResourceGroupName -eq $resourceGroupName } | Select Name)) {
    Write-Host "Resource group does not exist!" -ForegroundColor Red
    ##break

dataGriff

param(
    [string]$testScript,
    [string]$resourceGroupName
)

## $testScript = .\AzureTest\Test-AzureResourceExists.tests.ps1

Write-Host "Executing Pester tests..."

$outputPath = $testScript.replace("Tests.ps1","xml");

dataGriff

## Test Azure Resource Exists

clear-host

Write-Host "Test-SQL Starting..."

$serverName = "test-griff.database.windows.net"
$databaseName = "AdventureWorksLT"
$password = ConvertTo-SecureString "5up3r53cr3t!" -AsPlainText -Force #need to convert to key vault get

dataGriff

	Column1	Column2

dataGriff

<#

//Amend the values below to represent your environment

string connectionName = "Datawarehouse";
string serverName = "localhost";
string databaseName = "AdventureWorksDW";
string schemaName = "dbo";

var includedSchemas = new List<string>{schemaName};