Andrea Gnemmi

Andrea Gnemmi is a Database and Data Warehouse professional with almost 20 years of experience, having started his career in Database Administration with SQL Server 2000. His expertise ranges from SQL Server to Oracle and Postgres for database administration and from SAP BO to SSIS, SSRS and Power BI regarding BI and ETL. He has worked both in SQL Server and Oracle mostly in multinational environments with very high transaction volumes and large datasets. Performance tuning, indexing techniques and in general Database administration are his hot topics. Ensuring a 24/7 uptime of the various databases in shop is his main responsibility, as well as the best possible performances of all queries run on the databases. He has started working with PostgreSQL two years ago loving many of the features of this RDBMS.
  • MSSQLTips Awards: Trendsetter (25+ tips) - 2024 | Rookie of the Year - 2021
Title Category Date
PostgreSQL Static Data Masking with DataVeil Security2026-05-18
PostgreSQL Monitoring with pg_stat_statements PostgreSQL2026-03-06
PostgreSQL 18 New Features PostgreSQL2026-02-17
PostgreSQL EXPLAIN for Query Tuning PostgreSQL2025-11-14
PostgreSQL monitoring with pg_stat_activity and pg_locks PostgreSQL2025-04-07
PostgreSQL Download and Install on Ubuntu, RedHat and Docker PostgreSQL2025-02-20
PostgreSQL VACUUM, AUTOVACUUM and ANALYZE Processes PostgreSQL2025-01-02
PostgreSQL VACUUM, AUTOVACUUM, and ANALYZE Processes for Deleted Data PostgreSQL2024-10-11
Steps to Change a PostgreSQL Column Datatype when Included in a View PostgreSQL2024-08-16
PostgreSQL JSON and JSONB Data Types Overview PostgreSQL2024-07-11
PostgreSQL CREATE TABLE Examples PostgreSQL2024-05-23
PostgreSQL Create Database Options and Settings PostgreSQL2024-02-26
PostgreSQL History, Features and SQL Server Comparison PostgreSQL2024-01-12
Syntax, Features and Options for PostgreSQL Partitioning Tables PostgreSQL2023-10-02
PostgreSQL Prepared Statements as a Performance Improvement PostgreSQL2023-07-11
Roles, Schemas, Grants and Owners in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2023-02-28
Options for Granting Privileges in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2023-01-27
Learn SQL Variables for SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2022-09-19
Job Scheduler in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2022-08-22
SQL Aggregate Functions in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2022-06-27
SQL Aggregate Functions Examples in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2022-04-28
SQL COALESCE, ISNULL, NULLIF in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2022-03-21
Varchar SQL Data Types for SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2022-01-31
SQL Identity Columns Gaps in SQL Server, Oracle, PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-12-29
SQL Identity Examples in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-11-30
Sample Code for Time zones in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-11-05
SQL String functions Examples for SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-10-12
SQL Date Functions for Microsoft SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-09-07
SQL VIEW Comparison in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-07-29
SQL Linked Server, Oracle DBLink and PostgreSQL Foreign Data Wrapper SQL Server vs Oracle vs PostgreSQL Comparison2021-05-27
Relational Database Comparison for SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-04-23
SQL Window Functions in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-03-26
Delete SQL Statement in SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-02-24
INSERT INTO SQL Server, Oracle and PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-02-23
SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL SQL Server vs Oracle vs PostgreSQL Comparison2021-01-04