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/1022514/selecting-nth-record-in-an-sql-query