Category Archives: Uncategorized

Uncategorized

twtad: publicidade no twitter

twtad

Para quem usa o twitter e não tinha ou não sabia uma forma de pode rentabiliza-lo pode utilizar o twt ad.
É muito simples de usar pois após fazerem o registo no sponsor, podem fazer posts de anunciantes no vosso twitter.
Os valores podem variar entre 0.05 e 0.20 por cada click. e as stats são em tempo real.

Link: http:// twtad.com

Uncategorized

O futuro é hoje! se dúvida veja o vídeo..

SQL Server Uncategorized

Mudar o ownership de um objecto

sp_changeobjectowner

Fonte: http://msdn2.microsoft.com/en-us/library/Aa259618(SQL.80).aspx

read more »

Exchange Uncategorized

Exchange transaction logs

The Exchange transaction logs are 5 MB files that are used to ensure database integrity. When handling the storage of transaction log files, it is best to have separate mirrored disks that are dedicated for the storage of these files. The main advantage of this is that in the event of a disk failure the other mirrored disk will contain current logs that are necessary for the operation of the Exchange database.

The transaction log files tend to grow rapidly, especially if circular logging is disabled. This uses up a lot of disk storage space. Disabling circular logging, however, has its advantages, especially in the event that any of the Exchange database becomes corrupted. To reduce buildup of these logs, perform daily backups of the Exchange database.

If the Exchange server contains one disk that handles both the transaction logs and the Exchange database, and this disk becomes full DO NOT DELETE THE TRANSACTION LOGS. Perform a full database backup that will then flush out the old log files.

source: Adesh Rampat

Uncategorized

Funções VB

read more »

Code Snippets ASP.Net Uncategorized

Convert Int16 to Bool

Convertendo um campo do tipo Int16 para Boolean em ASP.NET no ficheiro aspx ou ascx, para poder ser usado numa CheckBox, podemos utilizar o seguinte código:

<%# Convert.ToBoolean((DataBinder.Eval(Container.DataItem, "myInt16value")) )%>

SQL Server Uncategorized

SQL Server Reserved Word

ADD                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ALL                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ALTER                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
AND                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ANY                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
AS                   => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ASC                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
AUTHORIZATION        => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
AVG                  => SQLSERVER7,
BACKUP               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
BEGIN                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
BETWEEN              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
BREAK                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
BROWSE               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
BULK                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
BY                   => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CASCADE              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CASE                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CHECK                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CHECKPOINT           => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CLOSE                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CLUSTERED            => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
COALESCE             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
COLLATE              =>              SQLSERVER2000 | SQLSERVER2005,
COLUMN               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
COMMIT               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
COMMITTED            => SQLSERVER7,
COMPUTE              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CONFIRM              => SQLSERVER7,
CONSTRAINT           => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CONTAINS             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CONTAINSTABLE        => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CONTINUE             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CONTROLROW           => SQLSERVER7,
CONVERT              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
COUNT                => SQLSERVER7,
CREATE               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CROSS                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CURRENT              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CURRENT_DATE         => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CURRENT_TIME         => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CURRENT_TIMESTAMP    => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CURRENT_USER         => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
CURSOR               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DATABASE             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DBCC                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DEALLOCATE           => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DECLARE              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DEFAULT              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DELETE               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DENY                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DESC                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DISK                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DISTINCT             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DISTRIBUTED          => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DOUBLE               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DROP                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DUMMY                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
DUMP                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ELSE                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
END                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ERRLVL               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ERROREXIT            => SQLSERVER7,
ESCAPE               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
EXCEPT               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
EXEC                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
EXECUTE              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
EXISTS               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
EXIT                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
FETCH                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
FILE                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
FILLFACTOR           => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
FLOPPY               => SQLSERVER7,
FOR                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
FOREIGN              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
FREETEXT             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
FREETEXTTABLE        => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
FROM                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
FULL                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
FUNCTION             =>              SQLSERVER2000 | SQLSERVER2005,
GOTO                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
GRANT                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
GROUP                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
HAVING               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
HOLDLOCK             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
IDENTITY             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
IDENTITYCOL          => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
IDENTITY_INSERT      => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
IF                   => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
IN                   => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
INDEX                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
INNER                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
INSERT               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
INTERSECT            => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
INTO                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
IS                   => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ISOLATION            => SQLSERVER7,
JOIN                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
KEY                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
KILL                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
LEFT                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
LEVEL                => SQLSERVER7,
LIKE                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
LINENO               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
LOAD                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
MAX                  => SQLSERVER7,
MIN                  => SQLSERVER7,
MIRROREXIT           => SQLSERVER7,
NATIONAL             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
NOCHECK              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
NONCLUSTERED         => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
NOT                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
NULL                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
NULLIF               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
OF                   => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
OFF                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
OFFSETS              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ON                   => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ONCE                 => SQLSERVER7,
ONLY                 => SQLSERVER7,
OPEN                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
OPENDATASOURCE       => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
OPENQUERY            => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
OPENROWSET           => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
OPENXML              =>              SQLSERVER2000 | SQLSERVER2005,
OPTION               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
OR                   => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ORDER                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
OUTER                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
OVER                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
PERCENT              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
PERM                 => SQLSERVER7,
PERMANENT            => SQLSERVER7,
PIPE                 => SQLSERVER7,
PLAN                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
PRECISION            => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
PREPARE              => SQLSERVER7,
PRIMARY              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
PRINT                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
PRIVILEGES           => SQLSERVER7,
PROC                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
PROCEDURE            => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
PROCESSEXIT          => SQLSERVER7,
PUBLIC               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
RAISERROR            => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
READ                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
READTEXT             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
RECONFIGURE          => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
REFERENCES           => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
REPEATABLE           => SQLSERVER7,
REPLICATION          => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
RESTORE              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
RESTRICT             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
RETURN               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
REVOKE               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
RIGHT                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ROLLBACK             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ROWCOUNT             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
ROWGUIDCOL           => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
RULE                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
SAVE                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
SCHEMA               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
SELECT               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
SERIALIZABLE         => SQLSERVER7,
SESSION_USER         => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
SET                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
SETUSER              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
SHUTDOWN             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
SOME                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
STATISTICS           => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
SUM                  => SQLSERVER7,
SYSTEM_USER          => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
TABLE                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
TAPE                 => SQLSERVER7,
TEMP                 => SQLSERVER7,
TEMPORARY            => SQLSERVER7,
TEXTSIZE             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
THEN                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
TO                   => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
TOP                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
TRAN                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
TRANSACTION          => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
TRIGGER              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
TRUNCATE             => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
TSEQUAL              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
UNCOMMITTED          => SQLSERVER7,
UNION                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
UNIQUE               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
UPDATE               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
UPDATETEXT           => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
USE                  => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
USER                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
VALUES               => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
VARYING              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
VIEW                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
WAITFOR              => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
WHEN                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
WHERE                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
WHILE                => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
WITH                 => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
WORK                 => SQLSERVER7,
WRITETEXT            => SQLSERVER7 | SQLSERVER2000 | SQLSERVER2005,
Microsoft Uncategorized

Microsoft .NET Framework 3.0 – Release Candidate

.Net Fx 30O Microsoft® .NET Framework 3.0 (conhecido com WinFX) inclui todos os requisitos necessários para o utilizador poder executar aplicações concebidas em .NET Framework, incluindo a Common Language Runtime, a “biblioteca� .NET Framework , e ASP.NET. Este pack de recursos mostrar-se-á imensamente importante pois muito software existente no mercado corre sobre a plataforma .NET Framework e sem este pack não poderá executar os ditos aplicativos. Este pack não é cumulativo, necessitando o utilizador de ter no seu sistema as anteriores versões 1.1 e 2.0 para correr aplicações desenvolvidas sobe essas plataformas.

Download

Microsoft® .NET Framework 3.0 Final x86
Microsoft® .NET Framework 3.0 Final x64

Site

Microsoft® .NET Framework