Securing PostgreSQL Against Injection, Misconfiguration, and Privilege Escalation
PostgreSQL is a robust and trusted database platform, but it’s not invincible. The PostgreSQL Global Development Group […]
Archives du mois : juin 2025
SQL Automate – A DBA’s Time-Saving Toolkit
Introduction Installing SQL Server can be a very boring and time consuming task, especially when you have to […]
Index Scans and Table Scans
The post Index Scans and Table Scans appeared first on SQLServerCentral.
Oracle ASM: A Simple Solution or Another Complexity? (part 1)
For highly performant Oracle databases, the storage must be scalable, resilient, and easy to manage—especially as infrastructure […]
[Video] Office Hours in the Detroit Airport
I’m in the Detroit airport today, en route home after a client gig. I’ve got some time to […]
Query Exercise: Return Routes in the Right Order
I’mma be honest with you, dear reader: this query exercise stems from a client problem that I couldn’t […]
Performing a Bulk Insert in SQL Server
Learn how to use the BULK INSERT command to import large data sets into SQL Server.
Managing Fabric Lakehouse objects with the new CLI: Data Engineering ...
Microsoft Fabric has been evolving since its general availability in November 2023. Developers have asked for a command […]
Who’s Hiring in the Microsoft Database Community? June 2025 Edition
Is your company hiring for a database position as of June 2025? Do you wanna work with the […]
MySQL vs. PostgreSQL: Date and Time Data Types
Date and time data types are important because they help track and manage time-based information in databases. […]
SQL Server 2025 – Change Event Streaming
Les missions que je réalise au quotidien pour mes clients sont diversifiées. Et c’est « Win-Win » comme disent certains, […]
DMV Comparison for SQL Server 2019 vs Azure SQL Database
The post DMV Comparison for SQL Server 2019 vs Azure SQL Database appeared first on SQLServerCentral.
Parameterize Connections in Microsoft Fabric Data Factory using Variable Libraries
When you create a data pipeline in Microsoft Fabric, you typically use one or more connections. A connection […]