SQL Manager for PostgreSQL

SQL Manager 2007 for PostgreSQL 4.5.0.8
http://www.megaupload.com/?d=3D0YCHSD

FATAL: sorry, too many clients already

Edit postgresql.conf,then on next lines increment values

max_connections = 8
shared_buffers = 16

queries for diagnostic current sessions.

1) Select * from pg_stat_activity;
2) Select count(*) as cnt, usename, current_query FROM pg_stat_activity Group by usename,current_query Order by cnt DESC;

Indice de masa corportal

Indice de masa corporal
http://www.buenasalud.com/tools/bmicalc.cfm

Otro medidor gráfico
http://www.bmivisualizer.com

Pruebas:
[1]
http://www.bmivisualizer.com/body_masses/generate_bmi?utf8=%E2%9C%93&locale=en&body_mass[unit_measurment]=M&body_mass[gender]=Male&body_mass[age]=35&body_mass[height]=1.66&body_mass[feet]=&body_mass[inches]=&body_mass[weight]=76&commit=Calculate+BMI

Condorito

http://issuu.com/ericm814/docs/v2/condorito_n1-1955


http://www.mcanime.net/foro/viewtopic.php?t=80082

http://www.atp.com.ar/post/Comics_%2F_Anime/76634/Coleccion_Condorito_completa__parte_1.html
http://www.atp.com.ar/post/Comics_%2F_Anime/76635/Coleccion_Condorito_completa__parte_2.html
http://www.atp.com.ar/post/Comics_%2F_Anime/76636/Coleccion_Condorito_completa__parte_3.html

Disable Yahoo Messenger Adds

First mode(Execute regedit)
[HKEY_CURRENT_USER\Software\Yahoo\pager\Locale]
Enable Messenger Ad = 0
restart yahoo messenger
Second mode

on file C:\WINDOWS\system32\drivers\etc\hosts

add next line

127.0.0.1 insider.msg.yahoo.com

Make Toolbar for Browser

conduit
http://www.conduit.com/ (toolbar editor)

http://davidwalsh.name/firefox-toolbar

Bloquear paginas web OpenDNS

http://www.surcultural.info/2008/06/como-bloquear-paginas-pornograficas-gratis/

http://es.kioskea.net/faq/410-opendns-un-dns-rapido-y-util

Jasper Report Netbeans todo lo necesario

http://www.blogger.com/home?pli=1


Lo unico que hay que saber aparte de descargar el software es crear una Libreria y agregar los .jar necesario ubicados en la carpeta de instalación:
[1] C:\Archivos de programa\JasperSoft\iReport-2.0.2\lib o
[2] C:\Archivos de programa\JasperSoft\iReport-3.7.6\ireport\modules\ext


Tutoriales
http://chuwiki.chuidiang.org/index.php?title=Ejemplo_b%C3%A1sico_con_Jasper_Report
http://mundobyte.wordpress.com/2008/01/06/creacion-de-reportes-en-java-parte-iii/
http://javatutoriales.blogspot.com/2009/02/creacion-de-reportes-con-jasperrepots-y.html
http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/samples.html

Recursos:
[1] jasper software http://sourceforge.net/projects/jasperreports
[2] ireport software http://sourceforge.net/projects/ireport/files/iReport%20%28classic%29/

SQL Server Analysis Service

Working with Microsoft Analysis Services (SSAS) / MSOLAP / MDX Queries
http://developer.klipfolio.com/developer/cookbook_item/item-64


Running the Analysis Services Deployment Wizard
http://msdn.microsoft.com/en-us/library/ms174817.aspx

Building a SQL Server Analysis Services .ASDatabase file from a Visual Studio SSAS Project
http://agilebi.com/ddarden/2009/05/31/building-a-sql-server-analysis-services-asdatabase-file-from-a-as-project/

Resources
[1] http://sqlsrvanalysissrvcs.codeplex.com/
[2] SQL Server software
http://www.todotegusta.com/2010/05/microsoft-sql-server-2008-r2-standard-edition-x86-y-x64/

Keylogger Apps

Perfect keylogger v1.7.5
http://www.intercambiosvirtuales.org/software/blazingtools-perfect-keylogger-v1-7-5-0-espia-sin-que-se-enteren-lo-que-sucede-en-una-pc

Referencias:
[1]http://www.elhacker.net/Textos1.html

Data Mining with C#

Data Mining with C# and ADO.NET
http://www.devsource.com/c/a/Languages/Data-Mining-with-C-and-ADONET/
Data Mining SDK
http://datamining.codeplex.com/

http://www.sqldev.org/sql-server-analysis-services/c-using-adomd-to-connect-to-olap-cube-10707.shtml

Another plataform
http://www.cs.waikato.ac.nz/ml/weka/

Other references:
Spanish
http://bernardorobelo.blogspot.com/2010/02/modelos-y-ejemplos-de-data-mining.html
http://alejandroesteban.wordpress.com/

C# Smtp Client using gmail account

using System;
using System.Collections.Generic;
using System.Text;

using System.Net.Mail;
using System.Net;

namespace SmtpMail
{
 class Program
 {

  static void Main(string[] args)
  {
   try
   {
      var client = new SmtpClient("smtp.gmail.com", 587)
      {
        Credentials = new NetworkCredential("compelligencelocal@gmail.com", "xxxxx"),
        EnableSsl = true
      };
      client.Send("myusername@gmail.com", "manager_27@hotmail.com", "test", "testbody");
      Console.WriteLine("Sent");
      Console.ReadLine();

   }
   catch (Exception ex)
   {
    Console.WriteLine( ex.Message );
   }

  }
 }
}

Web Capture

ScreenGrab
https://addons.mozilla.org/es-ES/firefox/addon/1146/

Series

http://www.series21.com/padre-de-familia/

http://padre-made-in-usa-american-dad.seriespepito.com/

Picapiedras & Otros
http://www.nuncamas.org/

Aida
http://aida.seriespepito.com/

un-install GRUB from MBR to restore Windows/DOS

HOWTO: How to erase, un-install GRUB from MBR to restore Windows/DOS bootloader
http://linux.koolsolutions.com/2009/06/08/howto-how-to-erase-un-install-grub-from-mbr-to-restore-windowsdos-bootloader/

How to uninstall GRUB
http://www.cyberciti.biz/faq/linux-how-to-uninstall-grub/


Making MBR Backup

mke2fs /dev/fd0 (formating)
dd if=/dev/hda of=/dev/fd0 bs=512 count=1 (dump to floppy)
dd if=/dev/fd0 of=/dev/hda bs=512 count=1 (dump from floppy)

/dev/fd0, replacemente with file or path
hda, sda o SCSI


resources:
[1]Download optional or missing files for Easy Recovery
http://www.easydesksoftware.com/optional.htm

Keylogger source code

Visual C++
https://github.com/ajayrandhawa/Keylogger/blob/master/Sourcecode.cpp

C#
http://sourceforge.net/projects/superkeylogger/
http://www.elguille.info/colabora/NET2006/drosa_KeyLogger.htm
http://www.c-sharpcorner.com/UploadFile/grusso/KeyLoggerAplicationinCSharp11252005000941AM/KeyLoggerAplicationinCSharp.aspx


resources:
[1] http://social.msdn.microsoft.com/forums/en-US/csharpgeneral/thread/ed63b033-663a-4a20-80a5-a732d31e9486

Postgres DEBUG

Errors and Messages

RAISE level 'format' [, expression [, ...]];

levels-> DEBUG, LOG, INFO, NOTICE, WARNING, and EXCEPTION(raises an error).

format-> string, % is replaced by the next optional argument's string representation.

usages:
RAISE NOTICE 'Calling cs_create_job(%)', v_job_id;
--This example replace % with v_job_id
RAISE EXCEPTION 'Nonexistent ID --> %', user_id;
--This example will abort the transaction with the given error message:


references:
[1] http://www.postgresql.org/docs/8.1/static/plpgsql-errors-and-messages.html

NHibernate works without mapping

ISQLQuery query = Session.CreateSQLQuery("SELECT p.*, c.* FROM Product p Left JOIN Product_CustomField c on p.ProductId=c.ProductId");
query.SetResultTransformer(NHibernate.Transform.Transformers.AliasToBean(typeof(Product)));
IList resultList = query.List();

Notes:
Add CusTomField1..5 into Product Class,not need declared in .hbm.xml

Combine with ScalarFields
public class SqlRepository {
...
public IList ListEmployees() {
using (ISession session = _sessionBuilder.GetSession()) {
return session
.CreateSQLQuery(@"
SELECT No_ AS EmployeeNumber, [E-mail Login] AS Username
FROM Employees")
.AddScalar("EmployeeNumber", NHibernateUtil.String)
.AddScalar("Username", NHibernateUtil.String)
.SetResultTransformer(Transformers.AliasToBean())
.List();
}
}
}


Add nHibernate mapping at run time
ISessionFactory sf = new Configuration()
.AddFile("Product.hbm.xml")
.AddFile("Category.hbm.xml")



References:
[1] http://docs.jboss.org/hibernate/core/3.3/reference/en/html/querysql.html
[2] Store procedure http://www.martinwilley.com/net/code/nhibernate/sql.html
[3] Reduced wiring code needed for native sql http://swik.net/Hibernate/Hibernate+GroupBlog/Hibernate+3.1:+Reduced+wiring+code+needed+for+native+sql
[4] AddJoin http://es.efreedom.com/Question/1-1132059/NHibernate-problema-de-AddEntity-y-AddJoin
[5] Native SQL http://knol.google.com/k/fabio-maulo/nhibernate-chapter-14-native-sql/1nr4enxv3dpeq/17#
[6]Fluent NHibernate http://wiki.fluentnhibernate.org/Auto_mapping
[7]Dynamically load .hbm.xml http://www.codeguru.com/forum/showthread.php?t=474322

How to get Machine Remote Client information

Access to the network host mac address,CPU access to suppliers,...
http://www.hackchina.com/en/cont/82131

Three ways to get your MAC address.
http://www.codeguru.com/Cpp/I-N/network/networkinformation/article.php/c5451
Enterprise Logging for Distributed J2EE Applications
http://javaboutique.internet.com/tutorials/logging/index4.html

How do I get MAC address of a host? (JAVA)
http://www.kodejava.org/examples/250.html
Extract network card address(JAVA)
http://www.rgagnon.com/javadetails/java-0369.html

References:
http://mindprod.com/project/macaddress.html

Cubecart:: Deprecated: Function eregi() is deprecated in

The latest versions of PHP 5 have deprecated a few functions, for turn off those messages as seen in CubeCart.

Edit /includes/ini.inc.php
error_reporting(E_ALL & ~(E_NOTICE | E_STRICT | E_DEPRECATED | E_USER_DEPRECATED));