Category: Tips and tricks

Frameworks and libraries

JS front-end frameworks and libs

Ext Js: powerful MVC and MVVM framework for desktop like UI on the web using mostly declarative programming.

jQuery: no need to say more

Underscore.js: library with utility functionalities, binding, applying, map, reduce, all, each, etc.

Meld: Aspect oriented programming for JS.

Backend frameworks

ASP.NET Web forms, MVC: MVC is the future.

ASP.NET Web API

Zend framework

Other libraries and technologies

NHibernate, LINQ, Entity Framework: ORMs

Dependency injection: Spring.NET, Spring for Java, Unity.

Strategy to debug Javascript

Make sure you read the relevant API docs.

Use Chrome’s developer tools, Firebug, or IE’s, and Visual Studio debugger, they are awesome.

Use console.log and alert in code when necessary when tracing code is difficult.

Run JS scripts from JS console.

Don’t be afraid to trace through third party’s frameworks and libraries when necessary.

 

Tips to generate a large SQL Server table for testing

To generate a large table with millions of records, it’s possible to use the following script:

declare @RecordsNum int = 10000000-(select count(*) from Person)

declare @Count int = 0

set nocount on

Begin transaction

while(@Count < @RecordsNum)

begin

insert into MyTable(Name, Address, Age)

values(substring(Convert(varchar(255), NewID()), 0, 30),

substring(Convert(varchar(255), NewID()),0 ,30), RAND(100) * 100)

set @Count = @Count + 1

End

commit

select count(*) from MyTable

Some things to do to improve performance of the script:

  • Set NoCount to ON
  • enclose the while loop in a transaction explicitly

Ideas were found in this page: http://mitchelsellers.com/blogs/2008/09/12/creating-random-sql-server-test-data.aspx