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.
- Delete SQL Statement in SQL Server, Oracle and PostgreSQL (last update: 2/24/2021)
- INSERT INTO for SQL Server, Oracle and PostgreSQL (last update: 2/23/2021)
- SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL (last update: 1/4/2021)
- SQL Window Functions in SQL Server, Oracle and PostgreSQL (last update: 3/26/2021)