How can I see all of the bash history?
cat ~/.bash_history would also work, although I tend to just use vim ~/.bash_history and then use /to search
history
How to undelete a file previously deleted in git’s history?
git checkout <commit> <filename>
What are the file/group/record/unit separator control characters and their usage?
Lammert Bies explains both their usage and the history behind. 28 – FS – File separator The file separator FS is an interesting control code, as it gives us insight in the way that computer technology was organized in the sixties. We are now used to random access media like RAM and magnetic disks, but … Read more
Keep git history when splitting a file
The general rule to maintaining blame history is to make a separate move commit first before any edits. It has been my experience that this allows git blame to work without the need for the -C option. So in the case of splitting the file up into new files, this can be done in two … Read more
Why the \G in SELECT * FROM table_name\G?
Short Answer The ubiquitous semicolon command terminator ; is actually shorthand for the \g command, which is in itself shorthand for the go command. The go command is used both historically and currently in other flavours of SQL to submit batches of commands to be compiled and / or interpretted by the server. The \G … Read more
Filtering ZSH history by command
Hit Ctrl+R, type some letters, it will find the previous command with these letters, keep hitting Ctrl+R to continue through the previous findings. Works in bash, zsh (and other shells i suppose). What i personally like to have is: type some letters, press Up, the previous commands starting with the same letters appear. Very powerful, … Read more
How can I rewrite history so that all files, except the ones I already moved, are in a subdirectory?
To rewrite the history with the files moved: If you want the project’s history to look as though all files have always been in the directory foo/bar, then you need to do a little surgery. Use git filter-branch with the “tree filter” to rewrite the commits so that anywhere foo/bar doesn’t exist, it is created … Read more
How to see the Check-In History of a particular user in TFS?
How to: Find a Changeset in Visual Studio 2010: In Source Control Explorer, on the File menu, point to Source Control, and then click Find Changesets. For some reason newer versions of the article are in a different location. Here are links to newer versions of the article: How to: Find a Changeset in Visual … Read more
How to get a list of all recent SVN commit messages?
You can use svn log -l5 -v <URL of your repository>. svn info can be used to get the root URL for the repository where your working copy is connected to.
TSQL: Get Last Queries Ran
Yes, take a look, this will give you the 50 most recent executed SQL statements sql 2005 and up only SELECT TOP 50 * FROM(SELECT COALESCE(OBJECT_NAME(s2.objectid),’Ad-Hoc’) AS ProcName, execution_count,s2.objectid, (SELECT TOP 1 SUBSTRING(s2.TEXT,statement_start_offset / 2+1 , ( (CASE WHEN statement_end_offset = -1 THEN (LEN(CONVERT(NVARCHAR(MAX),s2.TEXT)) * 2) ELSE statement_end_offset END)- statement_start_offset) / 2+1)) AS sql_statement, last_execution_time … Read more