Policy Management in SQL Server

After reading help this is quite easy

Spreadsheets (Excel) compared to Database

Triangle of Solution

Based on number of times used:

  1. 1-5 use a piece of paper
  2. 5-20 use a spreadsheet
  3. 20+ use a database

 Spreadsheets Disadvantages

  1. Data should be stored once and only once. Using spreadsheets often creates multiple out of date files
  2. VLookup is far inferior to SQL links
  3. Some problems are very difficult to solve in comparison with similar solution in database transact sql
  4. Limited or no programmatic power dependent on developer
  5. Out of systems – suggests refactor not found
  6. Out of security control
  7. Unable to unit test
  8. Unstructured data
  9. A little knowledge is a dangerous thing
  10. Spreadsheets exported from a database – just adds another step – NOT combine, reduce, eliminate

 Spreadsheet Advantages

  1. More people can prepare them
  2. Users can demonstrate requirements by attempting to build what they want . Form of tracer bullet
  3. Possibly more print control
    1. offset by users knowledge of how to use Context Menu in grids
    2. why are they printing anyway – why not two screens – are they avoiding IT – find it easier to work with paper

Spreadsheets Interesting

  1. For users showing advanced spreadsheet skills. Could promote move to SQL Express of other. Or MS Access using ODBC. Or Reporting.
  2. Could direct them to request views for plugging in

Real-life Examples

  1. Model in Database exported to Spreadsheet
    • Created a model.
    • User downloaded to spreadsheet and then edits some data.
    • Model is blind to changes.
    • Also Model then changed in database and spreadsheet is out of date.
    • Also spreadsheet is not used for a few days so data in it becomes a little out of date.
  2. User wants to export to excel – to print out a stock driven demand. This is a step that was removed before in order to save time.

AMD HD6770 Secondary Screen Flicker

Open google and run mouse over menu. Second screen flickers with a horizontal line across it.


  1. Catalyst Control Center
  2. Performance
  3. Enable AMD Overdrive check box. Uncheck this. Apply.

Reported in several websites

“Missing Operating system” on Boot

ERROR Yikes.
When  playing with BIOS settings to try and use Graphics card + OnBoard (see previous post), I was curious to see if OnBoard would work on it’s own. So change one option to IDE, with no graphics card. At this point I had no monitor, possibly only on boot. I may have at some point used some form of Restore Default Settings. From this point forth it would not boot, but would just display “Missing Operating System”.

SOLVED: With more technical support we realised that the SATA configuration settings were something other than RAID, which this machine is on. After reverting this back to RAID the machine booted again.

How to set up 3 monitors by using a graphics card plus onboard graphics and BIOS

The following is instructions received from a technical support, regarding my new PC

I can advise of the following settings that need to be set for 3 monitor support on your system.
You need to enter the BIOS by pressing either DEL or F2 during the POST. 

(1)    In the Chipset section, then Northbridge, the Initiate Graphic Adaptor setting needs to be set to PEG/IGD
(2)    In the Chipset section, then Northbridge, the IDG Memory setting needs to be set to at least 64MB.
(3)    In the Chipset Section, then Northbridge, the IDG Multi-monitor setting needs to be set to Enabled.
(4)    In the Advanced Section. Then Intel IDG SWCSI OpRegion. The DMVT/Fixed Memory needs to be set to at least 256MB. 

You will then need to press either F4 or F10 to save and exit.