Skip to content

Instantly share code, notes, and snippets.

View pietheinstrengholt's full-sized avatar

Piethein Strengholt pietheinstrengholt

88 followers · 0 following
View GitHub Profile
@pietheinstrengholt
pietheinstrengholt / ValidateDataQuality.ipynb
Created May 14, 2024 21:05
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@pietheinstrengholt
pietheinstrengholt / Slowly_Changing_Dimension.ipynb
Last active May 15, 2024 09:00
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@pietheinstrengholt
pietheinstrengholt / CreateBronzeTables.ipynb
Created May 14, 2024 20:21
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@pietheinstrengholt
pietheinstrengholt / .env
Last active August 29, 2023 14:48
Azure OpenAI demo using azure-sdk-for-js
OPENAI_API_HOST=https://endpointname.openai.azure.com/
OPENAI_API_KEY=xxxxxxxxxxxxxxxxxxxxxx
AZURE_DEPLOYMENT_ID=text-davinci-003
@pietheinstrengholt
pietheinstrengholt / RB5009-iptv-kpn-ipv6
Created September 16, 2022 10:51
# sep/16/2022 12:50:26 by RouterOS 7.5
# software id = 79VK-VRAH
#
# model = RB5009UPr+S+
# serial number = HCY08E7SYTZ
/interface bridge
add name=bridge-local
/interface vlan
add interface=ether1 name=vlan1.4 vlan-id=4
add interface=ether1 loop-protect=off name=vlan1.6 vlan-id=6
@pietheinstrengholt
pietheinstrengholt / RB5009-iptv-kpn-ipv4
Created September 15, 2022 06:49
# sep/15/2022 08:47:33 by RouterOS 7.5
# software id = 79VK-VRAH
#
# model = RB5009UPr+S+
# serial number = HCY08E7SYTZ
/interface bridge
add name=bridge-local
/interface vlan
add interface=ether1 name=vlan1.4 vlan-id=4
add interface=ether1 loop-protect=off name=vlan1.6 vlan-id=6
@pietheinstrengholt
pietheinstrengholt / DataProcessing.py
Last active March 29, 2022 18:50
# Set arguments
SourceSystemName = "AdventureWorks"
FlowName = "SalesLTAddress"
SourceStorageAccount = "synapsepiethein"
SourceContainer = "synapsedata"
SourcePath = "/landingzone/AdventureWorks/"
TargetStorageAccount = "synapsepiethein"
TargetContainer = "synapsedata"
TargetPath = "/processedzone/AdventureWorks"
SinkOperation = "merge"
@pietheinstrengholt
pietheinstrengholt / producer.js
Created January 6, 2022 15:21
var Kafka = require('node-rdkafka');
var producer = new Kafka.Producer({
//'debug' : 'all',
'metadata.broker.list': 'atlas-004133bc-3c87-4862-bf9d-b0ea6ae351f5.servicebus.windows.net:9093', //REPLACE
'dr_cb': true, //delivery report callback
'security.protocol': 'SASL_SSL',
'sasl.mechanisms': 'PLAIN',
'sasl.username': '$ConnectionString', //do not replace $ConnectionString
'sasl.password': 'Endpoint=sb://atlas-004133bc-3c87-4862-bf9d-b0ea6ae351f5.servicebus.windows.net/;SharedAccessKeyName=AlternateSharedAccessKey;SharedAccessKey=WrIVbXQnYutxKXsvmfP+Wz4G4OLKHjDtuKH&6=' //REPLACE
@pietheinstrengholt
pietheinstrengholt / consumer.js
Created January 6, 2022 14:44
var Transform = require('stream').Transform;
var Kafka = require('node-rdkafka'); //See more info: https://github.com/Blizzard/node-rdkafka
var consumer = new Kafka.KafkaConsumer({
//'debug' : 'all',
'metadata.broker.list': 'atlas-004133bc-3c87-4862-bf9d-b0ea6ae351f5.servicebus.windows.net:9093', //REPLACE
'group.id': 'nodejs-cg', //The default consumer group for EventHubs is $Default
'socket.keepalive.enable': true,
'enable.auto.commit': false,
'security.protocol': 'SASL_SSL',
@pietheinstrengholt
pietheinstrengholt / DNS-over-HTTPS-and-Private-Proxy.sh
Created January 5, 2022 07:47
=== INSTALL SQUID ===
sudo apt install squid
sudo systemctl status squid
sudo cp /etc/squid/squid.conf{,.orginal}
sudo ufw allow 'Squid'