Monthly Archives: September 2019

TSM_DataMgmt

SQL | DDL, DQL, DML, DCL and TCL Commands

Wikipedia

(de)
Relational algebra (en)
Join (SQL) (de)
Join (SQL) (en)
Data Manipulation Language (DML)
Transaction Control Language (TCL)
CRUD
ACID
NoSQL
Dokumentenorientierte Datenbank

Sakila Databas

MySQL Sakila Sample Database
The Sakila Database
github.com/jOOQ/jOOQ/tree/master/jOOQ-examples/Sakila

JOOQ

A Beginner’s Guide to the True Order of SQL Operations

Datenbankenlernen.de – Prof. Dr. Jens Dittrich


13.46 Unteranfragen mit IN, EXISTS, ALL, ANY

postgresql

postgresql – can’t create database – OperationalError: source database “template1” is being accessed by other users

Documentation

9.20. Aggregate Functions

SELECT DISTINCT, GROUP BY

SQL – select DISTINCT
Is there any difference between GROUP BY and DISTINCT

Windows 10 Boot-Manager (Safe Mode / Abgesicherter Modus)

HP PCs – Abgesicherter Modus von Windows (Windows 10, 8)

bootrec /fixmbr
bootrec /fixboot
bootrec /scanos
bootrec /rebuildbcd
msconfig
diskpart
bcdedit /set {default} safeboot minimal
bcdedit /set {default} safeboot network
bcdedit /set {default} safeboot minimal.
bcdedit /set {default} safebootalternateshell yes
bcdedit /deletevalue {default} safeboot 

Fix: Boorec /Fixboot Element Not Found on Windows
How to Rebuild the BCD in Windows
Anleitung zum Reparieren des EFI-Bootloaders auf einer GPT-Festplattenlaufwerk für Windows 7, 8, 8.1 und 10 auf Ihrem Dell PC
Gelöst: Das angeforderte Systemgerät kann nicht gefunden werden
Windows 10 – Boot-Manager anpassen, entfernen und reparieren

JavaSE 4, …, 9 Features

javaTpoint Java Tutorial

JavaSE 4, …, 9 Features

Java 9 Features

Interface Private Methods
Try-With Resources
Anonymous Classes
SafeVarargs Annotation
Collection Factory Methods
Process API Improvement
Version-String Scheme
JShell (REPL)
Module System
Control Panel
Stream API Improvement
Underscore Keyword

Java 8 Features

Lambda Expressions
Method References
Functional Interfaces
Stream API
Stream Filter
Base64 Encode Decode
Default Methods
forEach() method
Collectors class
StringJoiner class
Optional class
JavaScript Nashorn
Parallel Array Sort
Type Inference
Parameter Reflection
Type Annotations
JDBC Improvements

Java 7 Features

Binary Literals
Switch with String
Multi Catch
Try with Resources
Type Inference
Numeric Literals
JDBC

Java 4/5 Features

Assertion
For-each Loop
Varargs
Static Import
Autoboxing
Enums
Annotations
Generics

JavaSE 4, …, 8 Features

JavaSE 8 Features

Java 8 Date/Time API (Java 8)
Lambda Expressions (Java 8)
Method References (Java 8)
Functional Interfaces (Java 8)
Stream (Java 8)
Base64 Encode Decode (Java 8)
Default Methods (Java 8)
forEach method(Java 8)
Collectors(Java 8)
StringJoiner(Java 8)
Optional class (Java 8)
Nashorn JavaScript (Java 8)
Parallel Array Sorting (Java 8)
Type Inference (Java 8)
Method Parameter Reflection (Java 8)
Type annotations and repeating annotations (Java 8)
Java JDBC Improvements (Java 8)
Java IO Improvement (Java 8)
Java Concurrency Improvement (Java 8)

JavaSE 7 Features

String in switch statement (Java 7)
Binary Literals (Java 7)
The try-with-resources (Java 7)
Caching Multiple Exceptions by single catch (Java 7)
Underscores in Numeric Literals (Java 7)

JavaSE 6 Features

Instrumentation (premain method) (Java 6)

J2SE 5 Features

For-each loop (Java 5)
Varargs (Java 5)
Static Import (Java 5)
Autoboxing and Unboxing (Java 5)
Enum (Java 5)
Covariant Return Type (Java 5)
Annotation (Java 5)
Generics (Java 5)

J2SE 4 Features

Assertion (Java 4)

DermaIR

Steckverbinder

Board-to-Board

Motherboard Connector

All about the various PC power supply cables and connectors
What is this connector for?

WM16255-ND, CONN RCPT HSG 10POS 3.00MM
WM1787-ND, CONN RECEPT 10POS 3MM VERT DUAL

Compona AG

Receptacle Housing 2 Row UL94V-2 6p Receptacle Housing 2 Row UL94V-2 6p
Header 2 Row 180° w/o PCB Lock 6p 94V-2 Tin Plating w/o Drain Holes
Header 2 Row 90° PCB Lock 6p 94V-2 Tin Plating

CPU-Lüfter

Prozessor-Lüfter-Anschluss
4 pin Molex KK (PWM) CPU fan connector
Computer fan Connector

  • KK 47053
  • KK 47054
  • Molex 2510-04/
  • Molex 2695-04
  • Molex 2510-03/2695-03 – IDC-KK

KK 254 Wire-to-Board Header 2p Friction Lock, 0.508µm Gold (Au)
LUEFTERSTECKER Lüfterstecker 3pol. zum Selbstbau
PSS 254/3G Printstecker, Einzelstecker, gerade, 3-polig

WM4330-ND (KK 47053), CONN HEADER VERT 4POS 2.54MM
WM3285-ND (KK 47054), CONN RCPT HSG 4POS 2.54MM
WM4202-ND / (KK 6373), CONN HEADER VERT 4POS 2.54MM
WM2002-ND (KK 2695), CONN HOUS 4POS .100 W/RAMP/RIB

Temperatursensor

Adafruit MAX31865 RTD PT100 or PT1000 Amplifier

PT1000

Widerstandsthermometer
Platin-Messwiderstand (PT100, PT1000)
Pt100 oder Pt1000? – Die Unterschiede

Widerstandsthermometer
Sensorelemente (analog)
1 kOhms Industrielle Temperatursensoren

Ubuntu: Logitech MX Anywhere 2S / Logitech K270

[   90.096420] input: Logitech MX Anywhere 2S as /devices/pci0000:00/0000:00:08.1/0000:05:00.3/usb1/1-1/1-1.4/1-1.4.4/1-1.4.4.2/1-1.4.4.2:1.2/0003:046D:C52B.001B/0003:046D:406A.001C/input/input34
[   90.096850] logitech-hidpp-device 0003:046D:406A.001C: input,hidraw1: USB HID v1.11 Keyboard [Logitech MX Anywhere 2S] on usb-0000:05:00.3-1.4.4.2:1
[   90.176418] usb 1-1.4.4.3: new full-speed USB device number 15 using xhci_hcd
[   90.300091] usb 1-1.4.4.3: New USB device found, idVendor=046d, idProduct=c52b, bcdDevice=12.09
[   90.300095] usb 1-1.4.4.3: New USB device strings: Mfr=1, Product=2, SerialNumber=0
[   90.300098] usb 1-1.4.4.3: Product: USB Receiver
[   90.300100] usb 1-1.4.4.3: Manufacturer: Logitech
[   90.447524] logitech-djreceiver 0003:046D:C52B.001F: hiddev1,hidraw2: USB HID v1.11 Device [Logitech USB Receiver] on usb-0000:05:00.3-1.4.4.3/input2
[   90.602329] input: Logitech K270 as /devices/pci0000:00/0000:00:08.1/0000:05:00.3/usb1/1-1/1-1.4/1-1.4.4/1-1.4.4.3/1-1.4.4.3:1.2/0003:046D:C52B.001F/0003:046D:4003.0020/input/input35
[   90.602604] logitech-hidpp-device 0003:046D:4003.0020: input,hidraw3: USB HID v1.11 Keyboard [Logitech K270] on usb-0000:05:00.3-1.4.4.3:2