parsed.org

Tips by tag: microsoft

Check for Locks by xinu on Feb 13, 2008 07:29 AM

If you suspect a locking issue with your SQL Server database, this is how you can check with SQL Server 2005.

  1. Launch Microsoft SQL Server Management Studio
  2. In the left panel, click Management > Activity Monitor.
  3. At the top, click the 'Filter...' button.
  4. In the Resources section, enter the name of your database.
  5. Click OK to apply.
  6. Scroll to the far right and check for 'Blocking' and 'Blocked By'.

Thanks to McG for the tip.

activityblockedblockingdatabaselockinglocksmicrosoftmonitorsqlserverstudio
Column Width by xinu on Sep 08, 2005 02:26 PM

To have the width of the column accomodate the longest value, double-click the separator to the right of the column label.

excelmicrosoftui
MySQL Windows CLI by xinu on Jul 27, 2007 03:28 PM

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
Outlook Switches by xinu on Dec 31, 2005 04:12 PM

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
Reset MSSQL Password by xinu on Jun 27, 2008 08:20 AM

To update the password on MS SQL Server 2005:

SP_PASSWORD @NEW = 'new_password', @loginame = 'sa'
microsoftpasswordresetsp_password
Row Banding with Conditional Formatting by xinu on Aug 27, 2005 09:05 AM

To add odd-even row coloring to a spreadsheet, highlight the block of rows that you want colored and enter a conditional formatting formula:

  1. Select the cells you want to format.

  2. Access the menu: Format > Conditional Formatting...

  3. Change the condition dropdown to Formula is.

  4. Click the Format... button and select the formatting you want.

  5. 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
RSS