matejskubic

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
        <staticContent>
            <mimeMap fileExtension="." mimeType="text/plain" />
        </staticContent>
    </system.webServer>
</configuration>

matejskubic

CREATE USER [name@domain.com] FROM EXTERNAL PROVIDER
sp_addrolemember  @rolename =  'db_datawriter',  @membername =  'name@domain.com'
sp_addrolemember  @rolename =  'db_datareader',  @membername =  'name@domain.com'

matejskubic

CREATE CREDENTIAL [https://_name_.blob.core.windows.net/backup] WITH IDENTITY='Shared Access Signature', SECRET='sp=racwdl&st=2023-06-01T12:17:10Z&se=2024-01-01T21:17:10Z&spr=https&sv=2022-11-02&sr=c&sig=doW...3D'

DECLARE @dbToBackup as sysname = 'DB'
DECLARE @folder as nvarchar(50) = 'shrinked'
DECLARE @file as nvarchar(100) = @dbToBackup + N'_' + FORMAT(GETDATE(), N'yyyy-MM-dd_hhmmss') + N'.bak'
DECLARE @destUrl as nvarchar(500) = N'https://_name_.blob.core.windows.net/backup/' + @folder + N'/' + @file
PRINT @destUrl
BACKUP DATABASE @dbToBackup TO
  URL = @destUrl
   WITH NOFORMAT, NOINIT,  NAME = N'Full Database Backup', NOSKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 5

matejskubic

$rra = [System.Collections.Generic.List[Microsoft.Open.AzureAD.Model.RequiredResourceAccess]]::new()

$ra = [Microsoft.Open.AzureAD.Model.RequiredResourceAccess]::new()
$ra.ResourceAppId = "00000003-0000-0000-c000-000000000000" # graph
$ra.ResourceAccess = [Microsoft.Open.AzureAD.Model.ResourceAccess]::new("e1fe6dd8-ba31-4d61-89e7-88639da4683d", "Scope") # User.Read
$rra.Add($ra)

$ra = [Microsoft.Open.AzureAD.Model.RequiredResourceAccess]::new()
$ra.ResourceAppId = "00000007-0000-0000-c000-000000000000" # CDS / Dynamics CRM
$ra.ResourceAccess = [Microsoft.Open.AzureAD.Model.ResourceAccess]::new("78ce3f0f-a1ce-49c2-8cde-64b5c0896db4", "Scope") #user_impersonation

matejskubic

select top 100 *
from DeploymentInstanceArtifact

select top 100 * 
from OrchestratorCommand
order by QueuedDateTime desc

select top 100 *
from OrchestratorJob

matejskubic

function InitializeWindowsCredential
{
    Write-Verbose ("Loading PasswordVault Class.")
    [void][Windows.Security.Credentials.PasswordVault,Windows.Security.Credentials,ContentType=WindowsRuntime]
}

InitializeWindowsCredential

function ConvertTo-PasswordCredential
{

matejskubic

SELECT
	--TOP 100
	AllocUnitName,
	Operation,
	COUNT(*) c,
	SUM([Log Record Length]) l
FROM sys.fn_dblog(NULL,NULL)
GROUP BY
	AllocUnitName,
	Operation

matejskubic

https://mrochon.azurewebsites.net/2015/11/19/using-oauth2-with-soap/ https://github.com/microsoft/Dynamics-AX-Integration/blob/master/ServiceSamples/SoapConsoleApplication/Program.cs

matejskubic

$srcDir="c:\Temp\ax-build\src\" # source packages in c:\Temp\ax-build\Metadata\
$Build_BuildNumber = "0.0.1"

$binDir=(mkdir -Force (Join-Path $srcDir "..\bin\")).FullName
$Build_SourcesDirectory = Join-Path $srcDir "Metadata"
$PackagingExclusions = ""

pushd $srcDir

$Agent_BuildDirectory=$binDir

matejskubic

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
    xmlns:xliff="urn:oasis:names:tc:xliff:document:1.2"
>
  <xsl:output method="text" omit-xml-declaration="yes" indent="no"/>
  <xsl:template match="/">
    <xsl:apply-templates select="xliff:xliff/xliff:file/xliff:body/xliff:group/xliff:trans-unit"/>
  </xsl:template>
  <xsl:template match="xliff:trans-unit">