Active blogs that frequently discuss Agile .NET development and tools
April 2004 Archives
Excel shortcuts
- F2: Edit a cell's contents.
- Ctrl-1: Open the Format Cells dialog.
- Ctrl-Page Up: Move to the next sheet in the workbook.
- Ctrl-Page Down: Move to the previous sheet in the workbook.
- Ctrl-Shift-": Copy the value from the cell above into the current cell.
- Ctrl-': Copy the formula from the cell above into the current cell.
- Ctrl-R: Fill contents of active cell into selected cells to the right.
- Ctrl-D: Fill contents of active cell into selected cells down.
- Ctrl-`: Toggle between showing cell values and formulas in cells.
- Ctrl-$: Set selection to currency format with two decimal places.
Outlook shortcuts
- Ctrl-Shift-I: Switch to in-box.
- Ctrl-Shift-O: Switch to out-box.
- Ctrl-Enter: Send current message.
- Ctrl-R: Reply to a message.
- Ctrl-Shift-R: Reply All to a message.
- Ctrl-Shift-A: Create a new appointment.
- Ctrl-Shift-M: Create a new message.
- Ctrl-1: Switch to Mail.
- Ctrl-2: Switch to Calendar.
- Ctrl-3: Switch to Contacts.
- Ctrl-4: Switch to Tasks.
Remote assistance
XP's Remote Desktop tool lets you remotely administer other Windows XP machines, as well as Windows 2000 and 2003 servers. On the client machine, select Start | All Programs | Accessories | Communications | Remote Desktop Connection, and enter the IP address of the computer you intend to connect to. If the connection is permitted, you'll get a window onto the server machine and be able to control it just as if you were sitting in front of its keyboard, monitor, and mouse. Conversely, you can set your Windows XP machine to accept connections from remote systems. Right-click on My Computer, select Properties, select the Remote tab, and mark the check box under Remote Desktop, then click on Select Remote Users... to specify who can access your machine.
Windows XP's Remote Assistance lets you request help from a friend or help desk staff, who can then log on during a period of time you specify, taking control while you observe (and chat via Windows Messenger). For these remote tools to work, your firewall or router will need to permit traffic across port 3389.
Hilarious translations of English travelers' phrases (I understand your language perfectly is translated into French as Je parle français comme une vache espagnole), plus provocative phrases like, How much is that in real money? and It's better in the States.
[Zompist phrase book]
[Zompist phrase book]
[Microsoft SQL Server 2000 Best Practices Analyzer 1.0 Beta]
Microsoft SQL Server Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices on your servers.
Turn ASP.NET 1.1 on
iisext /enext "ASP.NET v1.1.4322"
[Read and write data in Excel spreadsheets]
[Source control system]
[MS Visual Studio 6.0 Service Pack 6 released]
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mySpreadsheet.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes"""
Where "HDR=Yes" means that there is a header row in the cell range (or named range), so the provider will not include the first row of the selection into the recordset. If "HDR=No", then the provider will include the first row of the cell range (or named ranged) into the recordset.
[SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel Workbooks][Source control system]
[MS Visual Studio 6.0 Service Pack 6 released]
Running/developing as a non-admin
Why you should consider running as non-admin
How To: Secure Your Developer Workstation]
- Developing Software in Visual Studio .NET with Non-Administrative Privileges
- Developing as non-Admin with VS.NET 2003
- How to develop code as a non-admin
Ten rules of performance
MSN IM client library in .NET
[Trillian]
Data access layer dll connection string
