Speed Up ToolBox Opening

Change setting
Tools > Options > Windows Forms Designer > ToolBox > AutoToolBoxPopulate
From True to False

FXCop Analyze shows dialog “Locate Assembly Reference”

If when using FXCop Analyze you get a dialog box entitled "locate assembly reference"
  1. Go to the project references.
  2. Find the related reference and note it’s location in the file system.
  3. Return to FXCop and browse to this location and put in dialog box

Also Crystal Decisions.Shared lives in C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Shared\10.5.3700.0__692fb ….
Unable to navigate to this or find a copy of the file. So for GAC use following

  1. Open FxCop 1.36.
  2. Click menu: “Project | Options…”
  3. Click the “Spelling & Analysis” tab in the “Project Options” dialog.
  4. Select the “Search Global Assembly Cache for missing references” option (by default it is unselected).


Also see that the Config file "FxCopCmd.exe.config" may be edited. See


Strongly Named Key


Names all those tricks that you have been doing for a while and a lot of those that you may not currently do.
Explains motivation – method and examples.
Very good.

How to add a network place directed to your own PC

How to add a network place directed to your own PC
file://C:\Documents and Settings\UserName\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\Templates\Sql

Bind a Combo or ListBox to an Enumeration

While this works, most Enum are in Camel case and do not have spaces, which may not be what you want

ComboBox1.DataSource = System.Enum.GetValues(GetType(PeopleNames))

Dim nameid As PeopleNames = CType(ComboBox1.SelectedValue, PeopleNames)

Note there should be no need to set the DisplayMember. If it does not work check that you have nothing on the control > DataBindings > Text binding

The variable “nameid” contains a 0, or 1, or 2 etc. depending on the value of the enumerated item that is currently selected.

May also bind to VS enumerations. Good use would be to bind to

ListBoxChartType.DataSource = System.Enum.GetValues(GetType(System.Windows.Forms.DataVisualization.Charting.SeriesChartType))


Office save/backup my settings

Save My Settings does not exist in Office 2007.
However see below copied from link:
1. The Quick Access Toolbars for Excel, Word, and PowerPoint are saved in
separate ".QAT" files (stands for Quick Access Toolbar), in the following
directory in Windows XP:

C:\Documents and Settings\(User Name)\Local Settings\Application

In that folder look for:    Excel.qat, PowerPoint.qat, Word.qat, etc.
So for example, if you want to transfer your Excel toolbar settings to
another computer, or after you reinstall Office 2007, just copy your custom
Excel.qat to that same folder, replacing the original.

2. All other settings (options menu) are stored in the registry here:


You can just export the whole "12.0" registry tree to a .REG file, and store
it somewhere. When you need to use it (after reinstall or on a different
computer), just double click on that REG file to update the registry.  Before
you do that, I suggest that you backup your registry just to be safe, if
something goes south.

Good luck


My Other Blog Start

Technorati Tags: ,

This blog is intended for non-IT posts.
Not certain of content at the moment

Determine Table Size

EXECUTE sys.sp_spaceUsed ‘dbo.TableName’

To determine for more tables need to use a cursor. See below and other articles ( unchecked )http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx


SSMS Database Built-In Reports Page Setup

There is a print button on the report. Changing the settings from here seems to have no effect. For instance changing from Portrait to Landscape.
Insted right-click anywhere on the report itself and then work with Page Setup. Seems to work.