Author: John

Covering Indexes in SQL 2005 – Results

No Picture

After a few queries regarding my recent post on Covering Indexes, I decided to do a couple of tests to show you the results. Below are the actual execution plan results using the table structure and SQL query from…

Read More »

Screenshots in Mac OS X from the terminal

No Picture

Following on from yesterdays post about screen shots, if you want to script a screen grab, the following command will work. screencapture ~/Desktop/filename.jpgscreencapture ~/Desktop/filename.jpg Remember that you can get the list of options by using man: man screencapture

Read More »

Screenshots in Mac OS X

No Picture

The following key-presses will take a screen grab and save it to the desktop.  Add CTRL to the mix to save it to the clipboard for later pasting. Full Screen Command-Shift-3. Selected Area Command-Shift-4 Then click and drag to select…

Read More »

USB Remote Completed

No Picture

I’ve made my remote, it’s as simple as it gets, with a momentary push switch. Behold the monstrosity that is my USB camera remote: It does look like a detonator but I’m hoping when plugged into two cameras…

Read More »

Flush DNS Cache on Mac OS X

No Picture

Go to a terminal window and type: dscacheutil -flushcachedscacheutil -flushcache

Read More »

Editing your hosts file in Mac OS X

No Picture

So you need to edit your hosts file? It’s path is /etc/hosts but being a system file, you’ll need to use sudo to get to it. Open a terminal and type: sudo vim /etc/hostssudo vim /etc/hosts Now, you’re…

Read More »

Low CPU Load Delays with SQL

No Picture

Use WAITFOR to pause scripts while using minimal CPU overhead. WAITFOR TIME ’09:15′; –Wait until 9:15am   WAITFOR DELAY ’00:00:05′ –Wait for 5 secondsWAITFOR TIME ’09:15′; –Wait until 9:15am WAITFOR DELAY ’00:00:05′ –Wait for 5 seconds It is…

Read More »

Covering Indexes in SQL 2005

No Picture

For some strange reason, covering indexes are not used or understood as much as they should. To quote Microsoft… “A Covering Index is a nonclustered index built upon all of the columns required to satisfy a SQL Server…

Read More »

Making the USB Remote

No Picture

I’ve picked up my pieces from Maplin and started building my remote. I’ve been playing around and found that with my cameras, they seem happy receiving 9 volts to trigger them. This makes the circuit very simple. Disclaimer:…

Read More »

A few things have arrived

No Picture

I ordered a few items off the Bay of E and am getting excited about this project. Here is the Flash Bracket I ordered: It’s just a straight rail with TWO screws for mounting the cameras. It’s already…

Read More »