Category Archives: Uncategorized

Networking Uncategorized

DHCP Database Topics

Perhaps you have never given the DHCP database a thought. Well the time may come where you need to backup, reconcile or compact the DHCP database. At the very least, I expect you will want to check your lease statistics.
Tutorial Topics for DHCP Database

  • DHCP – Display Statistics
  • DHCP Database
  • Backing up the DHCP Database
  • Reconcile
  • DHCP Audit Log
  • Summary – Challenges


DHCP – Display Statistics

Bizarrely, I find ‘Display Statistics’ the most difficult tab to find on the DHCP server. This is because it’s the first item on the menu, and is often masked by the very highlight that should attract me. I just hope that you are not afflicted by this blind spot. In any event, Display Statistics is one of the most interesting and rewarding items on the DHCP menu.

Display Statistics is available at both the server and the scope level. My first thought is, ‘How many leases are left?’ Next, I look to see if there have been any NACKS or lease declines. See the screen shot to find the Display Statistics… menu.

read more »

Uncategorized

Enviando artigo para blog através do Word 2007

Interessante esta funcionalidade do Microsoft Word que permite, assim como criar um novo documento, criar um novo artigo para o Blog.

Suporta por defeito alguns tipos de blog (WordPress, Typepad, Bloguista…), curiosamente por defeito não aparece um dos maiores serviços de blog, o BlogSpot, mas parece ser possível adicioná-lo á lista.

Ao usar pela primeira vez pede o tipo de blog, o URL, login e password de acesso ao BackOffice, depois +e começar a escrever e publicar. Simples e prático.

Permite mais algumas funcuinalidades, tipo: Publicar como rascunho, inserir Categoria, mas não me está a mostrar as existentes…

Resta fazer mais uns testes com upload de imagens por exemplo..

Testing….. J

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