http://wiki.spectralcoding.com/ 2012-05-19T18:11:14-07:00 http://wiki.spectralcoding.com/ http://wiki.spectralcoding.com/lib/tpl/arctic-mbo/images/favicon.ico text/html 2011-11-16T10:54:34-07:00 http://wiki.spectralcoding.com/howto:how_to_configure_windows_ipv4_settings_using_the_command_prompt?rev=1321466074&do=diff The following is known to work on Windows 7. Set Primary DNS Server netsh interface ip set dns "[Adapter Name]" static [Primary DNS IP Address] OR netsh interface ip add dns name="[Adapter Name]" [Secondary DNS IP Address] index=1 Set Secondary DNS Server netsh interface ip add dns name="[Adapter Name]" [Secondary DNS IP Address] index=2 text/html 2011-11-30T20:37:30-07:00 http://wiki.spectralcoding.com/howto:how_to_disable_hiberfil_sys?rev=1322710650&do=diff Windows 7 Open a Administrator Command Prompt and run: powercfg -h off text/html 2011-11-16T00:24:34-07:00 http://wiki.spectralcoding.com/howto:how_to_disable_internet_explorer_enchanced_security_configuration?rev=1321428274&do=diff 1. Open Server Manager (servermanager.msc) 2. Under Security Information, on the right, click “Configure IE ESC“ 3. Choose Off for both Users and Administrators 4. Click Ok text/html 2012-03-29T17:59:49-07:00 http://wiki.spectralcoding.com/howto:how_to_install_vmware_tools_on_ubuntu_server?rev=1333069189&do=diff VMware tools can be install using the open-vm-tools package. This will install X-server. If you do NOT wish to install X, see below: Install VMware Tools Manually Install the support packages VMware Tools needs: apt-get install linux-headers-server build-essential text/html 2011-10-14T01:59:11-07:00 http://wiki.spectralcoding.com/howto:how_to_make_a_usb_drive_bootable?rev=1318582751&do=diff [HP's Make USB Bootable Utility] There are times when you may need to make a USB Flash Drive bootable. Please not that this does NOT work for non-flash USB devices such as External Hard Drives. Hewlett Packard (HP) Provides a Utility that allows you to make any USB Flash Drive able to boot into MS-DOS. text/html 2011-10-14T02:03:55-07:00 http://wiki.spectralcoding.com/howto:how_to_set_up_putty?rev=1318583035&do=diff This article should be considered a tutorial on setting up the PuTTY SSH for Windows. It explains from start to finish download, configuration, and connection to your SSH server! PuTTY is a free SSH and Telnet client designed and maintained by Simon Tatham. It is generally used for performing administrative tasks on remote servers using the SSH (Secure SHell) protocol. For PuTTY to be of any use to you, you MUST have an SSH server to connect to. text/html 2011-12-19T14:33:00-07:00 http://wiki.spectralcoding.com/howto:replace_nulls_with_blanks_in_sql_server?rev=1324330380&do=diff UPDATE table SET field = '' WHERE ISNULL(field, 'dummyvalue') = 'dummyvalue' ISNULL checks if “field” is null and if it is null it returns 'dummyvalue', if that's equal to 'dummyvalue' then it sets the field to '' (which is NOT the same as null in SQL Server). text/html 2011-12-19T14:15:42-07:00 http://wiki.spectralcoding.com/howto:reset_identity_column_value_in_sql_server?rev=1324329342&do=diff Check Identity Value DBCC CHECKIDENT (tablename, NORESEED) Set Identity Value DBCC CHECKIDENT (tablename, RESEED, identvalue) This means that the number you input in place of 'identvalue' should be the CURRENT last index. The next value will be identvalue + 1. If you enter 999 then the next record inserted will have a value of 1000.