dataGriff

/*
https://www.mssqltips.com/sqlservertip/4772/refactor-sql-server-scalar-udf-to-inline-tvf-to-improve-performance/
https://dba.stackexchange.com/questions/204545/creating-a-persisted-computed-column-with-a-function
*/

CREATE SCHEMA etl;
GO
CREATE SCHEMA staging;
GO
CREATE SCHEMA store;

dataGriff

 ###############################################################################################################
###############################################################################################################

function Update-SQLAgentJobProperty(
[string]$serverName,
[string]$jobName,
[string]$property,
[string]$propertyValue
){

dataGriff

$localinstance = "grifftest"
SqlLocalDB.exe create "grifftest"  
SqlLocalDB.exe start "grifftest" 

## https://docs.microsoft.com/en-us/sql/tools/sqllocaldb-utility?view=sql-server-2017

$dacpacpath = "E:\Documents\Projects\Demo_DatabaseDevOps\AdventureWorks\AdventureWorks\bin\Debug\AdventureWorks.dacpac"
$profilepath = "E:\Documents\Projects\Demo_DatabaseDevOps\AdventureWorks\AdventureWorks\AdventureWorks.publish.xml"
$outputpath = "E:\Documents\Projects\Demo_DatabaseDevOps\AdventureWorks\AdventureWorks\"
$scriptpath = "$outputpath\script.sql"

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};

dataGriff

	Column1	Column2

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

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-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

$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

#
# 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