Mar 14, 2014

GUID vs INT Debate - Microsoft SQL Server Tips & Tricks - Site Home - MSDN Blogs

GUID vs INT Debate - Microsoft SQL Server Tips & Tricks - Site Home - MSDN Blogs:





OS X: About OS X Recovery

OS X: About OS X Recovery:



How To Do A "Clean" Install of OS X Mavericks - Forums - World of Warcraft

How To Do A "Clean" Install of OS X Mavericks - Forums - World of Warcraft:



sql server - Is it better to use an uniqueidentifier(GUID) or a bigint for an identity column? - Stack Overflow

sql server - Is it better to use an uniqueidentifier(GUID) or a bigint for an identity column? - Stack Overflow: "That depends on what you're doing:

If speed is the primary concern then a plain old int is probably big enough.
If you really will have more than 2 billion (with a B ;) ) records, then use bigint or a sequential guid.
If you need to be able to easily synchronize with records created remotely, then Guid is really great.
Update
Some additional (less-obvious) notes on Guids:

They can be hard on indexes, and that cuts to the core of database performance
You can use sequential guids to get back some of the indexing performance, but give up some of the randomness used in point two.
Guids can be hard to debug by hand (where id='xxx-xxx-xxxxx'), but you get some of that back via sequential guids as well (where id='xxx-xxx' + '123').
For the same reason, Guids can make ID-based security attacks more difficult- but not impossible. (You can't just type 'http://example.com?userid=xxxx' and expect to get a result for someone else's account)."



'via Blog this'



Bookmark and Share

indexing - GUID clustered PK's faster than BIGINT and INT identity PK's on SQL Server 2012 Express? - Stack Overflow

indexing - GUID clustered PK's faster than BIGINT and INT identity PK's on SQL Server 2012 Express? - Stack Overflow:



Mar 12, 2014

Create FTP folder at Windows Explorer

1. Start Menu->Computer
2. On the left pane: right-click computer-> add network location
3. Follow the wizard and type in your ftp location (ftp://yourusername :  password@yourftpsite.com)
4. Right click the network location and send to your desktop as shortcut.

Mar 11, 2014

Form authentication and authorization in ASP.NET - CodeProject

Form authentication and authorization in ASP.NET - CodeProject:



ASPX Forms Authentication Across Applications

<configuration>
<system.web>
<authentication mode="Forms" >
<!-- The name, protection, and path attributes must match
exactly in each Web.config file. -->
<forms loginUrl="login.aspx"
name=".ASPXFORMSAUTH"
protection="All"
path="/"
domain="contoso.com"
timeout="30" />
</authentication>

<!-- Validation and decryption keys must exactly match and cannot
be set to "AutoGenerate". The validation and decryption
algorithms must also be the same. -->
<machineKey
validationKey="C50B3C89CB21F4F1422FF158A5B42D0E8DB8CB5CDA1742572A487D9401E3400267682B202B746511891C1BAF47F8D25C07F6C39A104696DB51F17C529AD3CABE"
decryptionKey="8A9BE8FD67AF6979E7D20198CFEA50DD3D3799C77AF2B72F"
validation="SHA1" />
</system.web>
</configuration>

 


Reference


http://msdn.microsoft.com/en-us/library/eb0zx8fc(v=vs.100).aspx

Hosting Comparison 2014

 

Reference: http://www.top10bestwebsitehosting.com/index.php?kw=best%20web%20hosts&c=37418839188&t=search&p=&m=b&adpos=1t1&dev=c&devmod=&mobval=0&a=2706&gclid=CJCht8y5ib0CFQZU4godd3cAvQ

Keep NodeJS running forever

reference: https://blog.nodejitsu.com/keep-a-nodejs-server-up-with-forever/

 

  1. Monit: http://mmonit.com/monit/
  2. Upstart: http://upstart.ubuntu.com/
  3. Daemontools: http://cr.yp.to/daemontools.html
  4. Launchtool: http://people.debian.org/~enrico/launchtool.html