Essential SQL Server Date, Time and DateTime Functions

Essential SQL Server Date, Time and DateTime Functions: "Essential SQL Server Date, Time and DateTime Functions "

How to Set Up a Logon Script Only for Terminal Server Users

The built-in event logging for Terminal Services is lacking if you want to easily know who logged in and when. This is how you can create a log file of everyone that connects to your Terminal Server.

You can use a logon script to dump out the connecting user with the following script in the \windows\system32 directory.

Create a batch file with this line:
echo %username% %clientname% %date% %time% >> C:\TermServLog\logon.log
And enter the name of the batch file into the registry entry as follows:

Run Regedt32.exe and go to the following value: HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\CurrentVersion
\Winlogon\Appsetup

After the last entry in the Appsetup value, place a comma and a space and then enter the name and extension of the logon script you placed in the %SystemRoot%\System32 folder. For example, if the value of Appsetup is: Usrlogon.cmd, Rmvlinks.exeAfter adding an entry for Termlogon.cmd, the value would look like: Usrlogon.cmd, Rmvlinks.exe, Termlogon.cmdTermlogon.cmd will now run every time a user logs into the Terminal Server.

How to Set Up a Logon Script Only for Terminal Server Users

Terminal Services client keyboard shortcuts

Microsoft Windows XP - Using Terminal server shortcut keysUsing Remote Desktop Connection

Clearing the browser cache for various browsers

http://www.qgm.com/support/cache.html

Microsoft Internet Explorer

From the text menu at the top of your Internet Explorer browser window, click on VIEW
From the drop down list that appears, select and click on INTERNET OPTIONS. (If this option isn't present, click on FILE on the text menu and look for it there).

In the Options dialogue box which should appear, click on the tab at the top labeled ADVANCED.

In the area entitled "Temporary Internet Files" click on the button labeled SETTINGS.

Below the phrase "Check for newer versions of stored pages:" click the radio button labeled "Every visit to the page"

Then click on the button labeled "Empty Folder" to remove older versions already in your cache - click YES in response to the verification query.

Click OK at the bottom of the Settings dialogue box.

Click OK at the bottom of the Options dialogue box.

Revisit the page in question.

If the current page is still not displayed, hit RELOAD while holding down the SHIFT key.

After doing the above, you should be able to see the latest version of the page every time you come back.

Script SQL Server 2005 diagrams to a file

Script SQL Server 2005 diagrams to a file

Here is how to export sql server 2005 diagrams to another database:

ATX power supply connector pinout and signals @ pinouts.ru

Here is the pinout for an ATX power supply:


http://pinouts.ru/Power/atxpower_pinout.shtml

Pin	Name		Color	Description
1	3.3V		Orange	+3.3 VDC
2	3.3V		Orange	+3.3 VDC
3	COM		Black	Ground
4	5V		Red	+5 VDC
5	COM		Black	Ground
6	5V		Red	+5 VDC
7	COM		Black	Ground
8	PWR_OK		Gray	Power Ok (is a status signal generated by the power supply to notify the computer that the DC operating voltages are within the ranges required for proper computer operation)
9	5VSB		Purple	+5 VDC Standby Voltage (max 10mA)
10	12V		Yellow	+12 VDC
11	3.3V		Orange	+3.3 VDC
12	-12V		Blue	-12 VDC
13	COM		Black	Ground
14	/PS_ON		Green	Power Supply On (active low). Short this pin to GND to switch power supply ON, disconnect from GND to switch OFF.
15	COM		Black	Ground
16	COM		Black	Ground
17	COM		Black	Ground
18	-5V		White	-5 VDC
19	5V		Red	+5 VDC
20	5V		Red	+5 VDC

/PSON activated by pressing and releasing the power button while the power supply is in standby mode. Activating /PSON connects the power supply’s /PSON input to ground, thereby switching the power supply to full-on condition.

How to automatically turn on computer after power loss

Here is how to automatically turn on computer after power loss:


http://www.expresshosting.net/howto/atx-powersupply-modification-auto-turnon.html

How To Setup SQL Server Reporting Services for email delivery

Here is how to get SQL Server Reporting Services email to work:

You simply need to edit the RSreportserver.config file and enter your mail host name.

In the section; you need to alter the following two lines in the reportserver.config:

mail.yourname.com
ReportServer@yourname.com

For further information, see Microsoft's long winded version here:
Configuring a Report Server for E-Mail Delivery

Changing the web.config while web server is running

When an ASP.NET application launches a watch is put on the web.config file. ASP.NET will detect if the web.config changes while the application is running.

When ASP.NET detects a change it will spin up a new version of the application with the new settings in effect.

Any in process information, such as data kept in Session, Application, and Cache will be lost (assuming session state is InProc and not using a state server or database).

http://www.odetocode.com/Articles/345.aspx

Windows Vista Beta: How to dual-boot Windows XP and Windows Vista - Lifehacker

If you need to get out of Vista, and get back to XP, try this:

Windows Vista Beta: How to dual-boot Windows XP and Windows Vista - Lifehacker:

"type FIXBOOT followed by FIXMBR "

I was unable to modify the boot order and defaults from within XP. Vista uses a new system. So, if you wish to remove Vista, be very careful. Don't just blunder in from XP and remove the partition... The technique that I used was to boot off the XP CD and enter a recovery console. Then, after logging is as administrator, type FIXBOOT followed by FIXMBR and exit to reboot. It goes without saying that you should be sure that you have a backup before doing this. You do, don't you? This will get you back to your original XP boot process.

Massive deletes and updates in SQL Server are ALWAYS logged

SQL Server always writes to the log file for massive delete / update operations, even in simple mode.

http://www.realsqlguy.com/serendipity/index.php?url=archives/14-When-Is-A-Transaction-Log-Not-A-Transaction-Log.html&serendipity[csuccess]=moderate