If you suspect a locking issue with your SQL Server database, this is how you can check with SQL Server 2005.
Thanks to McG for the tip.
activityblockedblockingdatabaselockinglocksmicrosoftmonitorsqlserverstudio
To have the width of the column accomodate the longest value, double-click the separator to the right of the column label.
excelmicrosoftui
To log into MySQL using the CLI in windows:
(in the mysql\bin directory) c:\mysql\bin> mysql --user=<user> --pass=<pass> --port=3306
commandlinecommandsmicrosoftmysqlshellwindows
There are a bunch of great switches for Outlook that you can use to automate some of your Windows mailing experience:
http://www.techgalaxy.net/Docs/Exchange/OL2003_switches.htm
Thanks Tucker for this URL!
automationmailmicrosoftmuaoutlookwindows
To update the password on MS SQL Server 2005:
SP_PASSWORD @NEW = 'new_password', @loginame = 'sa'
microsoftpasswordresetsp_password
To add odd-even row coloring to a spreadsheet, highlight the block of rows that you want colored and enter a conditional formatting formula:
Select the cells you want to format.
Access the menu: Format > Conditional Formatting...
Change the condition dropdown to Formula is.
Click the Format... button and select the formatting you want.
Enter the appropriate formula below:
=MOD(ROW()-Rw,N*2)+1<=N
For example:
=MOD(ROW()-2,1*2)+1<=1
Where Rw is the first row to be formatted and N is the number of rows for banding. If you want to alternate, set N to 1. For even banding, change the conditional to >N instead of <=N.
excelformulamicrosoftui