bash keyboard shortcuts

From HowToGeek

The useful ones:

  • Ctrl + A Go to the beginning of the line you are currently typing on
  • Ctrl + E Go to the end of the line you are currently typing on
  • Ctrl + W Delete the word before the cursor
  • Ctrl + K Clear the line after the cursor
  • Alt + F Move cursor forward one word on the current line
  • Alt + B Move cursor backward one word on the current line

August 25, 2008 at 2:21 pm 4 comments

Aqua Data Studio – CTRL+B Beautifies Query

In a query pane in Aqua Data Studio… turn a query that looks like this:

into a beauty, like this:

All by pressing CTRL+B.

For the text equivalent:

select m.city, m.st, count(*)
from ___________ m 
inner join ____________ z
on m.city = z.city and 
m.st = z.state and
m.zip = z.zip_code WHERE
m.zip > '' AND 
m.st > '' AND 
m.city > '' AND 
z.city is null AND 
z.state is null and 
z.ZIP_CODE is null
group by m.city, m.st, m.zip 
HAVING count(*) <= 1 ;

into:

SELECT
	M.CITY,
	M.ST,
	COUNT(*) 
FROM
	__________ M 
		INNER JOIN __________ Z 
		ON M.CITY = Z.CITY AND
		M.ST = Z.STATE AND
		M.ZIP = Z.ZIP_CODE 
WHERE
	M.ZIP > '' AND
	M.ST > '' AND
	M.CITY > '' AND
	Z.CITY IS NULL AND
	Z.STATE IS NULL AND
	Z.ZIP_CODE IS NULL 
GROUP BY
	M.CITY,
	M.ST,
	M.ZIP 
HAVING
	COUNT(*) <= 1

April 10, 2008 at 7:36 pm Leave a comment

Enterprise Manager / SSMS – Convert selection to Uppercase/Lowercase

I don’t know why I have this habit, but typically I write most of my queries in lowercase. All lowercase. Once I’m ready to publish them or have them reviewed, I’ll convert everything applicable (some parameters don’t need to be made uppercase) to uppercase.

CTRL+SHIFT+U converts your text selection to uppercase. CTRL+SHIFT+L converts your text selection to lowercase.

January 20, 2008 at 7:28 pm Leave a comment

CTRL+NumPadPlus Automatically Expands Windows Explorer to the Longest Column

[Via] From Windows Explorer, in Details View, to auto-expand to the longest column just press CTRL+NumPadPlus.

This one is my new favorite.

January 20, 2008 at 7:20 pm Leave a comment

Windows+R – Access your MMC via Run

Just enter one of the files (filename.msc) into the Run Program Dialog. Performance Monitor doesn’t require a .msc extension. The one I use the most is services.msc.

  • Certificates – certmgr.msc
  • Indexing Service – ciadv.msc
  • Computer Management – compmgmt.msc
  • Device Manager – devmgmt.msc
  • Disk Defragmenter – dfrg.msc
  • Disk Management – diskmgmt.msc
  • Event Viewer – eventvwr.msc
  • Shared Folders – fsmgmt.msc
  • Group Policy – gpedit.msc
  • Local Users and Groups – lusrmgr.msc
  • Removable Storage – ntmsmgr.msc
  • Removable Storage Operator Requests – ntmsoprq.msc
  • Performance – perfmon.msc
  • Resultant Set of Policy – rsop.msc
  • Local Security Settings – secpol.msc
  • Services – services.msc
  • Windows Management Infrastructure (WMI) – wmimgmt.msc
  • Component Services – comexp.msc

January 17, 2008 at 1:54 am 1 comment

SQL Server – F5 Executes Query

After you’ve parsed your query, in SQL Server, just press F5 and the query will be executed.

January 13, 2008 at 9:00 pm Leave a comment

SQL Server – CTRL+F5 Parses Query

Instead of going up to the check mark to parse your query for syntactic goodness, just press CTRL+F5.

January 10, 2008 at 10:09 pm 1 comment

IBM Thinkpad – Shift+ScrollLock Unlocks Function Key

This one is a little niche, but it’s saved me loads of time.

At work I use an IBM Thinkpad (T42p, to be specific) – and when I undock to go home, sometimes my funciton key is locked.

To unlock, press Shift+ScrollLock

January 9, 2008 at 5:08 pm 1 comment

Remote Desktop – CTRL+ALT+END emulates CTRL+ALT+DEL

When you’re using Remote Desktop to administer another computer, you may occaisionally need to view running processes. First, you try CTRL+ALT+DEL. This brings up your local machine’s CTRL+ALT+DEL screen, but in order to bring up the remote computer’s CTRL+ALT+DEL screen you must press CTRL+ALT+END.

January 8, 2008 at 7:07 pm 1 comment

Remote Desktop – Alt Tab Equivalent with MMC

This one has been bugging me for a while.

If you’re using Remote Desktop from an MMC snap in your Alt-Tabs aren’t effective on the machine you’re remotely accessing.

rds.png

Just use Alt+PageUp to scroll through your open programs from left to right and Alt+PageDown to scroll through your open programs from right to left.

January 7, 2008 at 3:51 pm 1 comment

Older Posts


Categories

  • Blogroll

  • Feeds


    Follow

    Get every new post delivered to your Inbox.