Category Archives: Uncategorized

Uncategorized

Facebook .NET SDK

An updated (actually 3.0) release of the Facebook .NET SDK was also released. Are you a .NET developer writing Facebook applications or desiring to integrate the social network into your applications? Check out the Facebook .NET SDK which provides:

  • Silverlight-compatible assembly for handling all the logic to communicate with Facebook platform and has specific support for XAML data binding.
  • Web API for Facebook IFrame/FBML applications
  • Using ASP.NET MVC? There’s an assembly to support that model as well

The Facebook .NET SDK encapsulates the interaction with the developer platform for Facebook and should help .NET developers in web or client get started in a familiar way with Facebook. I’m excited to see what folks might do with Silverlight and Facebook!

Download the Facebook .NET SDK here and get links to getting started with the Facebook API.

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,