The Cubicle

In order to change the authentication mode for SQL Server 2005 one little registry key needs to be changed.

The registry path: \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\

The registry key: LoginMode – REG_DWORD – 0×00000001

This needs to be 0×00000002 for mixed mode authentication, so change the value of the REG_DWORD by double-clicking the registry key(LoginMode) and replacing the value from 1 to 2.

Here is the simple log truncation script:

use myDB
backup log myDB
with truncate_only

If you would like to shrink the file afterwards then run:

dbcc shrinkfile(myDB_Log, 1)

Be sure and do a full backup of the database because you will not be able to get a log backup again until you do.

1. hold down the center select button in the middle of the D-pad/joypad (the raised silver one.) 

2. Continue to hold it for at least five seconds simultaniously press the power button to allow the device to power up. 

3. Continue to hold the select button until you get a screen which asks if you want to perform the master reset. 

4. Let go of the select button, and press the appropriate soft action key to respond yes.

MSN - Resumes and Cover Letters 

Continuous effort - not strength or intellegence - is the key to unlocking our potential.
- Winston Churchill

To view all (and only) unread messages in your Gmail account:

• Type “label:unread” (not including the quotation marks) in the Gmail search field.
• Click Search Mail.

However this isn’t very helpful if you use labels and filters very much.
Try “label:unread label:inbox” to return only the messages in your inbox.

Home Theater Project Notes

I have been buying “wide screen” DVDs for years now, planning for the day that I would own a widescreen DVD. It isn’t that simple as it turns out as there are a number of things to work on to take advantage of what is to become entry level technology. I am not audiophile or television/movie enthusiast of any kind, but when I do watch a movie, I want it to look and sound great. For the typical home, I do not believe that top end equipment is required, especially when the viewing room is about 14′x 14′ as mine is.

Sharp AQUOS

 I will outine the path I take to upgrade from all SD equipment to a goal of all 1080p equipment as my personal budget permits both as a personal notebook and for reference to all who follow behind me. It all starts around this Sharp AQUOS 37″ LC37D64U 1080p LCD HDTV that I was able to get from Dell for $699 in January 2009 in time to watch the Pittsburg Steelers win the NFL AFC championship. Watch for a description of the TV and hurdles to overcome in the next article in this series.

To set to single user mode, execute the following query:

ALTER DATABASE [Works] SET SINGLE_USER WITH NO_WAIT

or

EXEC sp_dboption ‘Works’, ’single user’, ‘true’

To return the database to normal,  execute the following query:

ALTER DATABASE [Works] SET MULTI_USER WITH NO_WAIT

or

EXEC sp_dboption ‘Works’, ’single user’, ‘false’

I am always ready to learn although I do not always like being taught
-Winston Churchill

From a command prompt opened with administrative privileges, enter the following command:

slmgr -rearm

This command can be used 3 times for a possible total of 120 days running unactivated.