View TestWAS.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$AppName=“Word Automation Services” | |
$timerJobName=“Word Automation Services” | |
$SiteUrl=“http://portal.contoso.com” | |
$WordDoc=“/Freigegebene%20Dokumente/Fdsfsfd.docx” | |
$PDF=“/Freigegebene%20Dokumente/test.pdf” | |
asnp *sh* | |
Write-Host -BackgroundColor Green -ForegroundColor Yellow “ — Test Word Automation Service — ” | |
write-host “” | |
$WASinstance=Get-SPServiceInstance | ?{$_.typename -eq “Word Automation Services”} |
View DeleteTables.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET FOREIGN_KEY_CHECKS = 0; | |
SET GROUP_CONCAT_MAX_LEN=32768; | |
SET @tables = NULL; | |
SELECT GROUP_CONCAT('`', table_name, '`') INTO @tables | |
FROM information_schema.tables | |
WHERE table_schema = (SELECT DATABASE()); | |
SELECT IFNULL(@tables,'dummy') INTO @tables; | |
SET @tables = CONCAT('DROP TABLE IF EXISTS ', @tables); | |
PREPARE stmt FROM @tables; |
View main.cpp
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#include <Homie.h> | |
#include <Ticker.h> | |
#define FW_NAME "bochumsba-iot-fw";# | |
##define FW_VERSION "2.0.0" | |
const int PIN_Church = 2; | |
const int PIN_TownHall = 0; | |
const int PIN_House1 = 4; | |
const int PIN_House2 = 16; |
View PowerShell Profile
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
if (Get-Module -ListAvailable -Name oh-my-posh) { | |
} | |
else{ | |
Install-Module oh-my-posh -Scope CurrentUser -AllowPrerelease | |
} | |
View Dockerfile
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MAINTAINER Sascha Bajonczak <xbeejayx@hotmail.com> | |
FROM python:3.9 | |
RUN apt-get -qq update; \ | |
apt-get install -qqy \ | |
graphviz | |
RUN pip install diagrams | |
RUN mkdir -p data | |
COPY data/diagramdata.py ./data |
View docker-compose.yml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
version: '3.3' | |
services: | |
postgres: | |
container_name: sonar-postgres | |
environment: | |
- POSTGRES_USER=sonar | |
- POSTGRES_PASSWORD=sonar | |
ports: | |
- '5432:5432' | |
networks: |
View DockerMsSqlFT
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# mssql-agent-fts-ha-tools | |
# Maintainers: Microsoft Corporation (twright-msft on GitHub) | |
# GitRepo: https://github.com/Microsoft/mssql-docker | |
# Base OS layer: Latest Ubuntu LTS | |
FROM ubuntu:16.04 | |
# Install prerequistes since it is needed to get repo config for SQL server | |
RUN export DEBIAN_FRONTEND=noninteractive && \ | |
apt-get update && \ |
View docker-compose.yml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
version: "3" | |
services: | |
FALCON: | |
image: falconchristmas/fpp | |
container_name: falcon | |
restart: always | |
volumes: | |
- "/docker/fpp/media:/home/fpp/media" | |
- "/docker/fpp/modprobe:/etc/modprobe.d" | |
ports: |
View IndexSize.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT i.[name] AS IndexName | |
,SUM(s.[used_page_count]) * 8 AS IndexSizeKB | |
FROM sys.dm_db_partition_stats AS s | |
INNER JOIN sys.indexes AS i ON s.[object_id] = i.[object_id] | |
AND s.[index_id] = i.[index_id] | |
GROUP BY i.[name] | |
ORDER BY i.[name] |
View IndexStatistics.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
- Ensure a USE statement has been executed first. | |
SELECT [DatabaseName] | |
,[ObjectId] | |
,[ObjectName] | |
,[IndexId] | |
,[IndexDescription] | |
,CONVERT(DECIMAL(16, 1), (SUM([avg_record_size_in_bytes] * [record_count]) / (1024.0 * 1024))) AS [IndexSize(MB)] | |
,[lastupdated] AS [StatisticLastUpdated] | |
,[AvgFragmentationInPercent] | |
FROM ( |
OlderNewer