Windows Posts | JB IT Consulting

Debugging PostgreSQL with Visual Studio Code

by jb 3. June 2026

Debugging a database system often requires looking beyond SQL statements and configuration parameters. When investigating complex issues, understanding what happens inside the PostgreSQL source code can provide valuable insights into query execution, process behavior and internal database mechanisms. For developers, contributors and advanced database administrators, the ability to step through PostgreSQL code can significantly simplify troubleshooting and performance analysis.

0

Security, SQL Server, Windows

Patching SQL Server

by jb 30. May 2026

Keeping Microsoft SQL Server environments secure and up to date is one of the most important responsibilities of every SQL Server DBA and infrastructure team. Regular security patching not only helps protect critical business data against newly discovered vulnerabilities, but also improves system stability, reliability and compliance with modern security standards.

In this blog post, we will look at best practices for securing and patching SQL Server environments.

0

Linux, Performance, PostgreSQL, Scripts, Windows

PostgreSQL Cheat Sheet

by jb 28. May 2026

This PostgreSQL Cheat Sheet provides a compact overview of commonly used SQL statements, functions and administration commands for developers and DBAs. Whether for quick lookup, troubleshooting or learning purposes, this reference guide is designed to make working with PostgreSQL faster and more efficient.

0

Linux, Oracle, Veeam, Windows

Veeam Backup and Recovery for Oracle Databases

by jb 13. May 2026

This post shows how to install Veeam Backup and Recovery on a Windows system and how to perform a full backup and a point in time recovery of an Oracle Database on Linux.

0

Oracle, Scripts, Windows

Exporting Data in Parallel

by jb 3. April 2026

I recently had a customer that needed to export data from a huge table to a different machine in csv format very fast. The Database was Standard Edition 2 (SE2) so there was no Parallel Query Option to use.

0