Skip to content

Instantly share code, notes, and snippets.

Avatar
🍇

Sascha Bajonczak SBajonczak

🍇
View GitHub Profile
@SBajonczak
SBajonczak / DockerMsSqlFT
Created Oct 22, 2021
Dockerfile to Create a SQL Server with fulltext support
View DockerMsSqlFT
# 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 && \
@SBajonczak
SBajonczak / docker-compose.yml
Last active Oct 5, 2021
Docker Compose for Sonarcube and Postgres
View docker-compose.yml
version: '3.3'
services:
postgres:
container_name: sonar-postgres
environment:
- POSTGRES_USER=sonar
- POSTGRES_PASSWORD=sonar
ports:
- '5432:5432'
networks:
@SBajonczak
SBajonczak / Dockerfile
Created Sep 30, 2021
Dockerfile for generating diagrams (with https://diagrams.mingrammer.com/)
View Dockerfile
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
@SBajonczak
SBajonczak / PowerShell Profile
Last active Sep 13, 2021
Custom PowerShell Profile that contains OmyPosh and some custom git aliasses
View PowerShell Profile
if (Get-Module -ListAvailable -Name oh-my-posh) {
}
else{
Install-Module oh-my-posh -Scope CurrentUser -AllowPrerelease
}
@SBajonczak
SBajonczak / ino.cpp
Created Dec 26, 2019
Scale Tare Measurements
View ino.cpp
/*
Open Hive | Scale Adjustment
----------------------------
| Scale ADC HX711
pins hard coded
---------------
D15 D14 Dout, SCK
*/
View main.cpp
#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;
@SBajonczak
SBajonczak / DeleteTables.sql
Created Mar 23, 2018
Delete all Tables from current mysql database
View DeleteTables.sql
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;
@SBajonczak
SBajonczak / TestWAS.ps1
Created Jun 12, 2016
Test the convertion of documents with WAS in SharePoint
View TestWAS.ps1
$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}