How to Quickly Pick up a Project

Database Tips & SQL Tools

Mornitor the T-SQL executed in background when operating through SSMS:

At least you need to know how to list the names of the tables/views, columns, stored procedures, where they are stored.

To find the columns in question by the piece of string its name may contain:

SELECT * FROM [DB_NAME].INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%piece_of_name%'

To find the sprocs in question by the piece of string its body may contain:

SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
AND definition LIKE '%piece_of_body%'

Reference: http://stackoverflow.com/questions/5079457/how-do-i-find-a-stored-procedure-containing-text

C# Tips

How to make use of immediate window

DataColumn[] temp_cols = new DataColumn[myDataTable.Columns.Count];
myDataTable.Columns.CopyTo(temp_cols, 0);

JavaScript Tools & Tips

Set Up JavaScript Tool in an Internet-Isolated Environment

First of all, you may in the need of debug tools for JavaScript. Portable Firefox is a good choice. You can download it from a number of websites, like PortableApps.com, but it may be blocked by large corporate's internal policy, I got it from CNET.

Then run the .exe, and it will unpack the files.

There you go:

However, the debugger for JavaScript comes with Firefox may not be in your favor. Then you need to install Firebug anyway. This post gives some useful advice. But you may find there is no 'Open File' button in your Firefox, because by default it is not shown in the tool panel:

You can download the install file from Firebug's page anyway, and type its local path into the address bar:

Set the context of the Web Console to run JavaScript

In Firebug, you have to reference to the object from the root:

frames[2].frames[1].document.getElementsByClassName("ClassName")

But in Web Console coming with Firefox Developer Tool, you can use a command:

cd()
cd(frames[2])
cd(frames[1])
document.getElementsByClassName("")

http://stackoverflow.com/questions/5047360/firebug-how-to-cd-to-an-iframe

http://stackoverflow.com/questions/7961229/is-there-a-way-to-change-context-to-iframe-in-javascript-console

How to find the attached event listeners with a given DOM element

https://msdn.microsoft.com/en-us/library/ms189461.aspx

https://msdn.microsoft.com/en-us/library/ms189461.aspx

https://www.simple-talk.com/sql/learn-sql-server/window-functions-in-sql-server/

http://stackoverflow.com/questions/4382801/how-can-i-make-a-sql-temp-table-with-primary-key-and-autoincrmenting-field

http://stackoverflow.com/questions/1022514/selecting-nth-record-in-an-sql-query