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

SQL Server Backup & Restore

E’ facile fare un backup con sql server: Basta selezionare tasto destro Tasks>>Backup su un db. Ma come fare il restore?… Ecco un semplice script che chiarisce la cosa (non sempre lampante dallo wizard di restore….): [sql] — Usare il seguente comando per recuperare i parametri sorgente da usare nella MOVE — Nel nostro caso …

SQL Server Backup & Restore Read More »

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. Code zauker started using Redis, because Redis is a very bold memory-based no-sql db. Redis also support complex data type like sorted set, lists and so on, which was very userful. Anyway I needed a very fast …

Help Daitan find a Sql solution for codezauker Read More »

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 interface. […] A key feature of Dapper is performance. The following metrics show how long it takes to execute 500 SELECT statements against a DB and map the data returned to objects. The performance tests are broken …

dapper-dot-net – Simple SQL object mapper for SQL Server – Google Project Hosting Read More »

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 could be a bit boring. Then we found this book written by one of the father of SQL. Years ago Google and then Facebook popped out with new incredible ideas, for improved and super fast scalability, which eventually …

NoSQL Rocks? We try to understand Read More »

SQL Server: meta programmazione e meta descrittori

In questo articolo della serie SQL Server, vedremo come creare  in modo dinamico delle istruzione per impostare delle policy di sicurezza. Creeremo da zero una stored procedure chiamata sp_FixOverallGrant che in modo dinamico imposterà i profili di sicurezza per due utenze, una in lettura e scrittura (EBRB0_APP) ed una in sola lettura (EBRB0_USR). In particolare …

SQL Server: meta programmazione e meta descrittori Read More »

Introduzione a SQL Server 2008 Express

In questo articolo parleremo di Microsoft SQL Server. SQL Server nasce inizialmente da uno sforzo congiunto di Microsoft, Sybase and Ashton-Tate che nel 1989 creano tale prodotto avente come target OS/2. Dopo alcune vicessitudini Microsoft si smarca da Sybase e SQL Server versione 6.0 è la prima versione per Windows NT che non ha più dipendenze di …

Introduzione a SQL Server 2008 Express Read More »

MySQL Installing MySQL on Mac OS X

If you’re trying to use MySQL with phpMyAdmin, you’ve set up the phpMyAdmin’s config.inc.php, and you’re getting an error saying “Client does not support authentication protocol requested by server; consider upgrading MySQL client”, you need to set the password on the mysql command line using the OLD_PASSWORD(‘password’) routine. For example: tcsh: mysql mysql> SET PASSWORD …

MySQL Installing MySQL on Mac OS X Read More »