SQL: One of the most valuable skills – Craig Kerstiens
I admit it. I suffered from an “algebra narcoleptic syndrome” during my relational database lessons at University (1996…
Category: Structured Query Language (SQL)
Structured Query Language (SQL) is a standard computer language for relational database management and data manipulation. SQL is used to query, insert, update and modify data
Outer full and inner SQL joins: you are wellcome
For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
SQLite Oracle Compatibility Layer
It aims to provide a minimal compatibility with Oracle. The need was having some regular expression functions, and…
Removing duplicate rows in PostgreSQL, Oracle and SQLite
Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On…
Italian Accent Oracle fix
In Italian language we have accent words like àèéìòù They are quite important because for instance “is” is…
Oracle SQL Developer Keep Alive plugin
On some environment, on some customers, Oracle connections are drop after some idle time (i.e. 2 minutes). I…
Oracle Auto increment trigger HOWTO
Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I…
Oracle Database Sync
Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I…
Oracle Invalid number ORA-01722
I stumbled upon a very brain-f**k error on Oracle 10g on these days. Context: the following query [sql]SELECT…
Come evitare iniezioni SQL lato DB in SQLServer, Oracle, MySQL
Come evitare iniezione SQL: lato SQL Server (SP_EXECUTESQL) In generale va evitato nel modo più assoluto la scrittura…
SQL Server Backup & Restore
E’ facile fare un backup con sql server: Basta selezionare tasto destro Tasks>>Backup su un db. Ma come…
Help Daitan find a Sql solution for codezauker
In my code ramblings during the developement of Code Zauker, I ended up studing a bit NoSql database.…
dapper-dot-net – Simple SQL object mapper for SQL Server – Google Project Hosting
Dapper is a single file you can drop in to your project that will extend your IDbConnection…
NoSQL Rocks? We try to understand
At Gioorgi.com we was never a SQL fan. In 2000 we thinked SQL was boring, mostly because sql algebra…
SQL Server e Python
L’integrazione tra .NET e SQL Server è data per scontata: in questo articolo esploreremo invece come accedere a…