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 python è che è un linguaggio molto facile da imparare, con un notevole numero… Read more ›
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… Read more ›
SQLite is a small, powerful embedded database. A friend of mine started using it about six years ago. Some years ago it comes also on top of Python 2.5. It is used inside FileMaker Bento: its ultra customized model is based on… Read more ›
XAMPP is a very easy to install Apache Distribution for Linux, Solaris, Windows and Mac OS X. The package includes the Apache web server, MySQL, PHP, Perl, a FTP server and phpMyAdmin.
PHing Is Not GNU make; it’s a project build system based on Apache Ant. You can do anything with it that you could do with a traditional build system like GNU make, and its use of simple XML build files… Read more ›
After a bit of work, I have managed to optimize the performance of my Postgresql Server. I have spent a saturday morning digging around postgresql, using the fantastic komodo editor, and I am happy with the final solution. I followed … Read more ›
I have read http://www.manageability.org/blog/stuff/chandler-failure and I think it is very danger way of exposing concepts.
In the article pointed out, the quite dead Chandler project is compared to the multi-billion Eclipse project. And then a too easy analysis is done against dynamic languages, where Java is the absolute winner.
I will try to fix some of the things said there, and to add also my two cents here :)
Read more ›
Oracle buys BEA and Sun buys MySql.
In reply,Migrosoft is hungry and is watching Yahoo :-)
Let's play a bit with these ideas :)
Read more ›
Sometimes I need to build a small script to delete a huge set of tables of a schema. In Oracle is easy to do it, using the meta tables "all_tables", "all_views", and "all_sequences":
select 'drop table ' || table_name || ' cascade constraints;' <br /> from all_tables where owner='protoss' and table_name not like 'BIN%';<br /><br />select 'drop view ' || view_name || ' ;' <br /> from all_views where owner='zerg' ;<br /> <br /> select 'drop sequence ' || sequence_name || ' ;' <br /> from all_sequences where sequence_owner='spacemarine' ;
The "BIN%" table are special temp… Read more ›
Biblio wolf has been installed in a production environment. Read more ›