Archivo del Autor: carlosap

Database Price

http://www.microsoft.com/sql/howtobuy/default.mspx Note: The retail price for Microsoft SQL Server 2005 Developer Edition is $49.95. Microsoft SQL Server 2005 Developer Edition may be installed and used by one user to design, develop, test, and demonstrate your programs. SQL Server 2005 Pricing Comparison: Retail versus Example Pricing   Processor License   Server plus User/Device CALs    … Leer más »

Seguridad e Higiene!!!

No hay Extintor -> Después de todos los cursos de seguridad e higiene, se le ocurrió a algún alumno del tec hacer esta observación Tags: haha

SQL Server Port Firewall 1433

SQL Server es una aplicación Winsock que se comunica a través de TCP/IP utilizando la biblioteca de red de sockets. SQL Server escucha las conexiones entrantes en un puerto concreto; el puerto predeterminado para SQL Server es 1433. El puerto no tiene por qué ser el 1433, pero 1433 es el número de socket oficial… Leer más »

ALTER TABLE ORDERS FOREIGN KEY

MySQL: CREATE TABLE ORDERS (Order_ID integer, Order_Date date, Customer_SID integer, Amount double, Primary Key (Order_ID), Foreign Key (Customer_SID) references CUSTOMER(SID)); Oracle: CREATE TABLE ORDERS (Order_ID integer primary key, Order_Date date, Customer_SID integer references CUSTOMER(SID), Amount double); SQL Server: CREATE TABLE ORDERS (Order_ID integer primary key, Order_Date datetime, Customer_SID integer references CUSTOMER(SID), Amount double); Below are… Leer más »

MySQL migration: MyISAM to InnoDB

MySQL migration: MyISAM to InnoDB   By Keith Winston on July 18, 2005 (8:00:00 AM) The MySQL database is unique in that it offers multiple storage engines. The SQL parser and front end interfaces are separate from the storage engines, so you can choose among nine low-level table formats the one that suits your application… Leer más »

What is referential integrity?

  Simply put, referential integrity means that when a record in a table refers to a corresponding record in another table, that corresponding record will exist. Look at the following: