matejskubic

netsh dnsclient show state
netsh name show effective
netsh name show policy
netsh interface httpstunnel show interfaces

Get-DAConnectionStatus

matejskubic

SELECT r.session_id,r.command,CONVERT(NUMERIC(6,2),r.percent_complete)
AS [Percent Complete],CONVERT(VARCHAR(20),DATEADD(ms,r.estimated_completion_time,GetDate()),20) AS [ETA Completion Time],
CONVERT(NUMERIC(10,2),r.total_elapsed_time/1000.0/60.0) AS [Elapsed Min],
CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0) AS [ETA Min],
CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0/60.0) AS [ETA Hours],
CONVERT(VARCHAR(1000),(SELECT SUBSTRING(text,r.statement_start_offset/2,
CASE WHEN r.statement_end_offset = -1 THEN 1000 ELSE (r.statement_end_offset-r.statement_start_offset)/2 END)
FROM sys.dm_exec_sql_text(sql_handle)))
FROM sys.dm_exec_requests r WHERE command IN ('RESTORE DATABASE','BACKUP DATABASE')

matejskubic

SELECT TOP 10 
    root.Name RootElemnetName
    , me.Name ElementName
    , et.ElementTypeName
    , CAST([SourceText] AS nvarchar(MAX)) SourceText
    , me.RootHandle
    , me.ElementHandle
FROM [dbo].[Sources] s
    JOIN ModelElement me ON s.SourceHandle=me.ElementHandle
    JOIN ModelElement root on root.ElementHandle=me.RootHandle

matejskubic

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet 
    version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:old="http://something/old/"
    xmlns:new="http://something/new/">
  <xsl:template match="node()|@*">
    <xsl:copy>
      <xsl:apply-templates select="node()|@*"/>
    </xsl:copy>

matejskubic

### http://www.hass.de/content/setup-your-iis-ssl-perfect-forward-secrecy-and-tls-12

# Add and Enable SSL 3.0 for client and server SCHANNEL communications
md 'HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0' -Force
md 'HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0\Server' -Force
New-ItemProperty -path 'HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0\Server' -name 'Enabled' -value '0xffffffff' -PropertyType 'DWord' -Force
New-ItemProperty -path 'HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0\Server' -name 'DisabledByDefault' -value 0 -PropertyType 'DWord' -Force
 
# Add and Enable TLS 1.0 for client and server SCHANNEL communications
md 'HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0' -Force

matejskubic

$resp = Invoke-WebRequest -Verbose -Uri $url
$selectedForm = $resp.Forms[0]
$webAction = New-Object System.Uri ($resp.BaseResponse.ResponseUri, $selectedForm.Action)
$resp2 = Invoke-WebRequest -Verbose -Uri $webAction -Method $selectedForm.Method -Body $selectedForm

matejskubic

powercfg -lastwake

matejskubic

Exportfile for AOT version 1.0 or later
Formatversion: 1

***Element: FRM

; Microsoft Dynamics AX Forms unloaded
; --------------------------------------------------------------------------------
FRMVERSION 12

FORM #_AreaPageSimulation_

matejskubic

function Get-LatestDropLocation {
	param(
		[Parameter(Position=0,Mandatory=$true)] [string]$tfsLocation,
		[Parameter(Position=1,Mandatory=$true)] [string]$projectName,
		[Parameter(Position=3,Mandatory=$true)] [string]$buildDefinitionName
	)

	Add-Type -AssemblyName "Microsoft.TeamFoundation.Client, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL"
	Add-Type -AssemblyName "Microsoft.TeamFoundation.Build.Client, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL"
	$tfsUri = New-object Uri($tfsLocation)

matejskubic

set xact_abort on
declare @media_set_id int = 6089
use msdb
begin tran

delete from backupfile 
where exists 
    (select null 
    from backupset
    where backupset.backup_set_id = backupfile.backup_set_id