# Schelstraete.org
> Personal tech blog by Bart Schelstraete — practical guides on Linux, SQL Server, PowerShell, and Steam Deck modding. Open source projects and the stuff I'll forget by Friday.

## License and Usage
Content may be cited with attribution to Bart Schelstraete and a link to the source URL.
Training use is not permitted without explicit consent.

## Author
- Name: Bart Schelstraete
- Role: Infrastructure Specialist
- Expertise: SQL Server, Linux, PowerShell, Steam Deck
- GitHub: https://github.com/bschelst
- All posts are written from hands-on production experience.

## Site
- Homepage: https://www.schelstraete.org/
- Sitemap: https://www.schelstraete.org/sitemap.xml
- Robots: https://www.schelstraete.org/robots.txt

## Topic Areas
- **Avamar** (2 posts): Guides and troubleshooting for EMC Avamar backup and recovery in enterprise environments.
- **General** (1 posts): Miscellaneous posts that don't fit neatly into the other categories.
- **Ispconfig** (2 posts): Tips and configuration guides for ISPConfig web hosting control panel on Linux servers.
- **Linux** (32 posts): Practical Linux administration guides covering system configuration, networking, troubleshooting, and automation.
- **Oracle** (2 posts): Oracle database administration tips, queries, and troubleshooting notes.
- **PowerShell** (17 posts): PowerShell scripts and techniques for Windows and Active Directory administration, automation, and reporting.
- **SAP Hana** (1 posts): SAP HANA database administration notes and queries.
- **SQL-Server** (47 posts): T-SQL queries, performance tuning, security management, and administration guides for Microsoft SQL Server.
- **SteamDeck** (4 posts): Steam Deck tips, plugin development, and SteamOS customisation guides.

## Recent Posts
- [How to add a Windows group to every user database in SQL Server](https://www.schelstraete.org/post/t-sql-add-group-to-each-user-database) (2025-01-05) [SQL-Server]
- [How to find last logon dates for SQL Server accounts](https://www.schelstraete.org/post/t-sql-find-last-logon-dates) (2024-03-08) [SQL-Server]
- [How to list all users and their permissions in SQL Server](https://www.schelstraete.org/post/t-sql-list-users-and-permissions) (2024-03-08) [SQL-Server]
- [How to end disconnected RDP sessions with PowerShell](https://www.schelstraete.org/post/powershell-end-disconnected-sessions) (2023-11-06) [PowerShell]
- [How to download a file and copy it with PowerShell](https://www.schelstraete.org/post/powershell-download-file-copy-it) (2023-10-26) [PowerShell]
- [How to add users from a CSV file to an Active Directory group with PowerShell](https://www.schelstraete.org/post/powershell-add-users-from-csv-to-ad-group) (2023-09-20) [PowerShell]
- [How to list private endpoints in Azure with PowerShell](https://www.schelstraete.org/post/powershell-list-private-endpoints-on-az) (2023-08-21) [PowerShell]
- [How to check CPU usage on a remote PC with PowerShell](https://www.schelstraete.org/post/powershell-cpu-usage-remote-pc) (2023-08-21) [PowerShell]
- [Steam Deck: Hogwarts Legacy performance settings and benchmarks](https://www.schelstraete.org/post/steam-deck-hogwarts-legacy-performance) (2023-02-18) [SteamDeck]
- [How to find the most CPU-intensive queries in SQL Server](https://www.schelstraete.org/post/t-sql-check-cpu-usage-sql-statements) (2023-02-17) [SQL-Server]
- [How to transfer files from Windows to Steam Deck](https://www.schelstraete.org/post/steam-deck-transfer-files-from-windows-to-deck) (2023-02-16) [SteamDeck]
- [How to check the TLS version of a connection with PowerShell](https://www.schelstraete.org/post/powershell-check-tls-version) (2023-02-15) [PowerShell]
- [How to identify queries consuming excessive log space in SQL Server](https://www.schelstraete.org/post/t-sql-identify-queries-that-consume-a-large-amount-of-log-space) (2023-02-14) [SQL-Server]
- [How to perform an incremental shrink of a SQL Server database](https://www.schelstraete.org/post/t-sql-shrink-incremental) (2022-12-28) [SQL-Server]
- [How to install and use the SteamGridDB plugin on Steam Deck](https://www.schelstraete.org/post/steam-deck-steamgriddb-plugin) (2022-12-28) [SteamDeck]
- [How to enter the BIOS on Steam Deck](https://www.schelstraete.org/post/steamdeck-enter-bios) (2022-12-28) [SteamDeck]
- [How to clear msdb backup history in SQL Server](https://www.schelstraete.org/post/t-sql-clear-msdb-backup-history) (2022-12-14) [SQL-Server]
- [How to create MO files from PO files for WordPress on Linux](https://www.schelstraete.org/post/linux-create-mo-files-from-po-files-wp) (2022-01-24) [Linux]
- [How to migrate storage between disks using pvmove on Linux](https://www.schelstraete.org/post/linux-migrate-storage-with-pvmove) (2022-01-21) [Linux]
- [How to automatically restart a systemd service after failure](https://www.schelstraete.org/post/systemd-automatically-restart-after-failure) (2022-01-18) [Linux]

## Featured Projects
- [protondb-decky](https://github.com/bschelst/protondb-decky): ProtonDB compatibility badges for Steam Deck via Decky Loader (TypeScript)
- [steamstatus-decky](https://github.com/bschelst/steamstatus-decky): Live Steam service status indicator for Steam Deck (TypeScript)
- [boosteroid-steamos](https://github.com/bschelst/boosteroid-steamos): Native Boosteroid cloud gaming client for SteamOS via Flatpak (Python)
- [Zaventem.me](https://zaventem.me): Onafhankelijk informatieplatform voor Zaventem — automatisch nieuws, live vliegverkeer, luchtkwaliteit en OV (Python/Flask)
- [iptvXS](https://iptvxs.schelstraete.org): Modern cross-platform IPTV viewer built with Qt6 and libmpv — Xtream Codes, M3U, EPG, recording, Google Drive upload (C++)