WimObiwan

Ctrl-S SRV*\barney\DebugSymbols*http://msdl.microsoft.com/download/symbols

Ctrl-P c:\SourceGIT\CTArchitect\CTArchitect

Ctrl-I \barney\DATA\Versies\CTArchitect\10.0.0.31 l

WimObiwan

rm -rf ContactCentre.git/
git clone --mirror [email protected]:Askia/ContactCentre.git
cd ContactCentre.git/

git filter-branch -f --prune-empty --index-filter \
  'git rm --cached -r -q -- . ; git reset -q $GIT_COMMIT -- Setups/ BuildScripts/ _Utilities/MyForceBuilder/ _MI4C\ Build\ Scripts/ ' -- --all
du . -h
git for-each-ref --format="%(refname)" refs/original/ | xargs -n 1 git update-ref -d
git reflog expire --expire=now --all
git gc --prune=now

WimObiwan

dotnet new sln -o FxMovieAlert
dotnet new -h
dotnet new console -o Grabber
dotnet sln add .\Grabber\Grabber.csproj
dotnet new classlib -o FxMoviesDB
dotnet sln add .\FxMoviesDB\FxMoviesDB.csproj
dotnet add package Microsoft.Extensions.Configuration
dotnet add .\Grabber\ package Microsoft.Extensions.Configuration
dotnet add .\Grabber\ package Microsoft.Extensions.Configuration.Json
dotnet add package Microsoft.EntityFrameworkCore

WimObiwan

#!/bin/bash

function test-ssl {
   # $1: descr
   # $2: server:port
   # $3: (optional) StartTLS indicator: [pop3|smtp]

   echo "(certificate"
   echo "-\\n"

WimObiwan

<#
    https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_functions_cmdletbindingattribute?view=powershell-6
    https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_functions_advanced_parameters?view=powershell-6
#>

[CmdletBinding(
    ConfirmImpact = "",
    DefaultParameterSetName = "",
    HelpUri = "",
    SupportsPaging = $false,

WimObiwan

<#
cd <waar je het script wil zetten>

$url = 'https://gist.githubusercontent.com/WimObiwan/78def2eb9b5c1254e5cbc12d7bd11e9f/raw'
wget $url -OutFile 'PhoneApps.ps1'
. .\PhoneApps.ps1
New-PhoneAppsShortcuts
#>

WimObiwan

WITH fragmented_indexes AS
(
	SELECT 
		s.name [schema], t.name [table], i.name [index], ips.page_count, 
		ips.avg_fragmentation_in_percent, 
		ips.page_count * ips.avg_fragmentation_in_percent weight
	FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) ips
		JOIN sys.indexes i ON ips.object_id = i.object_id AND ips.index_id = i.index_id
		JOIN sys.tables t ON i.object_id = t.object_id
		JOIN sys.schemas s ON t.schema_id = s.schema_id

WimObiwan

# one-time installation
Install-Module -Name Autotask

# initialize
Import-Module Autotask
$Credential = Get-Credential
Connect-AutotaskWebAPI -Credential $Credential

function ArrayToHash($a)
{

WimObiwan

function Get-DiskUsage ($Path)
{
    $BIG_THRESHOLD_MB = 50

    $directories = @(Get-ChildItem $Path -Directory)

    function Get-DiskUsage2 ($directoryFullName, $directoryName, $recurse)
    {
        $items = Get-ChildItem -Recurse:$recurse $directoryFullName | ?{ -not $_.PSIsContainer } | Select Length
        $measure = $items | Measure-Object Length -Sum -Average -Maximum -Minimum -StandardDeviation

WimObiwan

# Original script located at https://gist.github.com/WimObiwan/e04d2e18c84161e2651260f4df701c07

# https://stackoverflow.com/a/40887001
function DisplayInBytes($num) 
{
    $suffix = "B", "KB", "MB", "GB", "TB", "PB", "EB", "ZB", "YB"
    $index = 0
    while ($num -gt 1kb) 
    {
        $num = $num / 1kb