L'integrazione tra .NET e SQL Server è data per scontata: in questo articolo esploreremo invece  come accedere a SQL Server da Python. Uno dei vantaggi di …
Read More

At Gioorgi.com we was never a SQL fan. In 2000 we thinked SQL was boring, mostly because sql algebra could be a bit boring. Then we found this book written by …
Read More

 

 Dapper is a single file you can drop in to your project that will extend your IDbConnection interface. [...]

A key feature of Dapper is performance. The …

Read More

 Come evitare iniezione SQL: lato SQL Server (SP_EXECUTESQL)

In generale va evitato nel modo più assoluto la scrittura di query sql diamiche.

Va evitato cioè …

Read More

I stumbled upon a very brain-f**k error on Oracle 10g on these days.

Context: the following query [sql]SELECT * FROM (
SELECT TO_NUMBER(CUSTOMER_ID) AS SNDG …

Read More

[caption id="attachment_5294" align="alignright" width="150"] Disapprove with me![/caption]

Okey, you know Oracle. A very good …

Read More

On some environment, on some customers, Oracle connections are drop after some idle time (i.e. 2 minutes).

I have found a small plugin for Sql Developer to …

Read More

Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On every big database there is something called "rowid" …
Read More

The Sqlite Oracle Compatibility Functions is an experimental compatibility layer for SQLite vs Oracle, written in Python 3.

 

It aims to provide a …

Read More

For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

Read More