pufff

siempre se me olvida este show xD

 

now using windows 2008 server standar edition

 

y para el blog windows live writer :O lol

lol nice info

Top 10 SQL Server development tips of 2008

Here are the top 10 most viewed SQL Server development tips of 2008. Whether you were converting date/time data into character types, working with DATETIME and SMALLDATETIME in SQL Server 2005, using a stored procedure to find the size of SQL Server tables or retrieving XML data values with XQuery, these were the topics that piqued your interest this year.

#1 - SQL Server data conversions from date/time values to character types
T-SQL supports two built-in methods for converting date/time data to character data and vice versa. These are implicit and explicit conversions, and this tip will take you through a step-by-step process for using each method. Included in these steps is advice on how to use the CAST and CONVERT functions when converting date/time values.

#2 - Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
Understanding the DATETIME, SMALLDATETIME and TIMESTAMP data types in SQL Server is not always a straightforward process. Learn how data is stored within DATETIME and SMALLDATETIME and find out why TIMESTAMP is different and often confused with these two primary date/time data types.

#3 - Find size of SQL Server tables and other objects with an original stored procedure
Getting an overview of user table sizes in a database, a summary of the total space owned by a group of tables and the top 10 biggest indexed objects are among the important reasons to calculate the specific disc space used by an object in SQL Server. Sp_SOS, an original stored procedure, can replace the often inadequate sp_spaceused stored procedure that ships with SQL Server.

#4 - Using SQL Server datetime functions GETDATE, DATENAME and DATEPART
There are several functions used for retrieving the current date and time, or individual parts of a DATETIME or SMALLDATETIME value, in SQL Server. Learn how to extract the day, month or year from a datetime value, as well as the quarter, week, hour or even the millisecond.

#5 - Retrieve XML data values with XQuery in SQL Server 2005
XQuery is the scripting language to use when accessing specific XML data values, rather than XML as a single data type value. Find out how to use two XQuery methods within your T-SQL statements -- Value() to retrieve a single XML value and Query() to retrieve multiple XML values.

#6 - Stored procedure to monitor long-running jobs in SQL Server 2000
Monitoring long-running jobs in SQL Server 2000 is not a simple practice, but it is a best practice among DBAs. Discover a stored procedure that easily identifies long-running jobs while also alerting DBAs, through email alerts, of situations that may poorly affect SQL Server performance.

#7 - Create DDL table in SQL Server 2005 to audit DDL trigger activity
Whenever DDL statements in SQL Server 2005 make changes with commands, such as CREATE TABLE and ALTER, the DDL trigger fires an event. But, it's possible to log these events by designing an audit table and defining a custom-made DDL trigger, along with testing the auditing solution.

#8 - Using DATEADD and DATEDIFF to calculate SQL Server date/time values
The DATEADD and DATEDIFF functions in SQL Server can perform easy calculations, such as adding or subtracting a time interval from a date/time value or comparing two date/time values. Get examples of how to use these handy functions in table definitions, queries and data modification statements.

#9 - Configure SQL Server Service Broker for sending stored procedure data
The Service Broker feature in SQL Server 2005 allows you to queue data of stored procedures and other application development components. Follow these steps for setting up Service Broker and learn how to use this communications platform to transmit data and messages from one SQL Server system to another.

#10 - Simplify queries with SQL Server 2005 common table expressions (CTEs)
Common table expressions (CTEs) in SQL Server 2005 are an alternative to using derived tables and views for retrieving data. CTEs separate code into unique units, so there's no need to repeat complex code, and they are self-referencing within your query.

Probando o Provando ?

no se, la verdad es que mi horrografia esta para llorar

lol

el chiste es, que me baje el msn nuevo, por que jamaz me llego el mensaje para hacer una actualizacion, apezar de que ya existia una version nueva con ya tiempo de salida

la interfaz grafica mejoro, parece como si fuera la barra de windows 7, pero ahora toda la circunferencia del msn lo es

el programa que mas me gusto fue live mail o wlmail.exe es como un outlook chiquito y writer, es una aplicacion para crear post en blogs desde tu pc.

lo que si es que consume mucha memoria el msn, se crean 2 procesos, el comun que es msnmsgr.exe y wlcomm.exe y entre los 2 tienen una media cmo de 13,500 k, asi que a interfaz bonita menos performance.

Mi no terminado .txt

es sobre c#, conceptos basicos, en si esta muy pobre no lo hise como quise por huevon

pero pss total

http://rootmexico.com/index.php?topic=3.msg3;topicseen#msg3

casos de la vida real

nomams, he visto cosas raras y medio locas

como hacerle pings a una tarjeta de red o un tipo que queria bajar una tarjeta de video de internet......

pero que un wey quiera tener un web server sin computadora, es lo mas pendejo y chistoso que he visto ajajaja

es lo malo de los foros de hackers, siempre por ser publicos permiten la entrada de cualquier tipo de personas.

Instalar Windows 2008 Server

Se baja de

http://www.microsoft.com/windowsserver2008/en/us/default.aspx

http://www.microsoft.com/windowsserver2008/en/us/default.aspx

http://www.microsoft.com/windowsserver2008/en/us/trial-software.aspx
yo use el standar y me va de maravilla la verdad, es mejor que XP y que VISTA en 32 y 64 bits.

Requerimientos:

[code]Processor Minimum: 1GHz
Recommended: 2GHz
Optimal: 3GHz or faster
*Intel Itanium 2 processor required for Windows Server 2008
for Itanium-based systems
Memory Minimum: 512MB RAM
Recommended: 1GB RAM
Optimal: 2GB RAM (Full installation) or 1GB RAM
(Server Core installation) or more
Maximum (32-bit): 4GB (Standard) or 64GB
(Enterprise and Datacenter)
Maximum (64-bit): 32GB (Standard) or 2TB
(Enterprise, Datacenter, and Itanium-based systems)
Disk Space Minimum: 8GB
Recommended: 40GB (Full installation) or 10GB
(Server Core installation)
Optimal: 80GB (Full installation) or 40GB
(Server Core installation) or more
Drive DVD-ROM drive
Display SVGA (800 × 600) or higher resolution
Keyboard
Microsoft mouse or compatible pointing device[/code]
Y ya, lo que sigue…..
Metes tu disco
seleccionas el lenguaje de instalación

IMG]http://img201.imageshack.us/img201/8894/75786783je6.jpg[/img][/URL][URL=http://g.imageshack.us/img201/75786783je6.jpg/1/][IMG]http://img201.imageshack.us/img201/75786783je6.jpg/1/w435.png[/img][/URL]

seleccionas el tiempo y el formato

clic en INSTALL

[URL=http://img247.imageshack.us/my.php?image=79882938gh3.jpg][IMG]http://img247.imageshack.us/img247/2695/79882938gh3.th.jpg[/img][/URL]

metes tu clave de producto, si es que la tienes

[URL=http://img510.imageshack.us/my.php?image=90027881nj0.jpg][IMG]http://img510.imageshack.us/img510/7281/90027881nj0.th.jpg[/img][/URL]

Luego escoges entre FULL y SERVER CORE installation

[URL=http://img247.imageshack.us/my.php?image=86443101vc0.jpg][IMG]http://img247.imageshack.us/img247/4537/86443101vc0.th.jpg[/img][/URL]

Hay 2 tipos de instalación, UPGRADE o CUSTOM, custom es cuando tu disco esta limpio y no se reconoce al sistema operativo que tengas instalado, upgrade es actualizar un sistema reconocido y actualmente instalado.

[URL=http://img201.imageshack.us/my.php?image=79719084po8.jpg][IMG]http://img201.imageshack.us/img201/1439/79719084po8.th.jpg[/img][/URL]

seleccionas o creas tu particion.

[URL=http://img201.imageshack.us/my.php?image=85934707lu6.jpg][IMG]http://img201.imageshack.us/img201/9333/85934707lu6.th.jpg[/img][/URL]

y comienza, despues de instalar los features
ya puedes remover la media (disco)

[URL=http://img201.imageshack.us/my.php?image=36927705ew1.jpg][IMG]http://img201.imageshack.us/img201/6524/36927705ew1.th.jpg[/img][/URL]

Se reiniciara 1 ves para configurarse, después al entrar te pedirá que pongas la contraseña de administrador, tienes que crear una, por lo regular no tiene que ser una fácil, si no el sistema las rechaza, trata de mezclar letras y números.