Blogs

Here is how to use the SQL convert function to extract just the date portion of a SQL datetime field.

convert(varchar(10), eventdate, 101)

It will result in something like this:

04/20/2010

You can change the syntax slightly if you want a different date format. Here is the full documentation on the convert function: http://msdn.microsoft.com/en-us/library/aa226054%28SQL.80%29.aspx

Here's how to control Window's Application Compatibility settings through the registry. This is normally controlled by right-clicking on an executable, clicking on the Compatibility tab, and making a selection in the Compatibility mode area. However, you can easily control Application Compatibility for all computers in a domain or network environment through the registry.

The registry key is HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags

If you see this message when trying to print a SQL Server Report, you probably don't have local admin rights. These instructions explain how to resolve the issue http://www.kodyaz.com/articles/client-side-printing-silent-deployment-of-rsclientPrint.aspx

 Personally, I used the excellent VNCScan to make a remote script so I
can fix this with one click.

If you are getting crooked prints from your printer, the solution might be as simple as replacing your toner cartridge. I was using a refurb toner cart in my HP LaserJet 1200 and thought the fuser was bad - I went so far as replacing it, before I realized that my almost-new toner cartridge was to blame.

Page skew is when the image and text on your paper is rotated or crooked. On mine, the top right corner of printing was off the page, while the top right corner looked ok. The whole print was rotated counter-clockwise.

When you attach a picture to an email in Outlook 2007, Outlook can resize the photos for you. Here's how to control this useful feature.

http://office.microsoft.com/en-us/outlook/HA102349021033.aspx?mode=print

If you turn on Audit Object Access, which is useful to find when and who access and deleted files, you may see thousands of Event 562 in the Windows Security event log. Here's how I fixed it.

ISSUE
-----------
After turning on Success auditing for Object
Access on the SBS 2003 Server,
the security event is fills up with:

My iPhone battery was very weak. It would go dead before the end of a day of moderate usage. Apple would replace my iPhone for about 200 bucks. AT&T suggested restoring my iPhone 3G from scratch, and then reloading my Apps one-by-one. I found a solution that made my iPhone 3G last all day, and then some.

Event ID 1017 "The license store for the client access licenses was corrupt and had to be deleted." Other messages on the server console indicating that license usage has been exceeded, and users' inability to access network resources may be symptoms of a full C: volume.

Treesize can help with this problem by finding the largest directories on your hard drive.

###############################################
# Sample OpenVPN 2.0 uci config for             #
# multi-client server.                          #
#################################################

config openvpn sample_server

        # Set to 1 to enable this instance:
        option enable 1

        # Which local IP address should OpenVPN
        # listen on? (optional)
#       option local 0.0.0.0

If you use OpenWRT and have a server on your LAN, you probably want to setup loopback forwarding. Here's how to do it.

These instructions came from this page. I simply want to explain them a bit more, and confirm that these instructions for loopback forwarding work on OpenWRT Kamikaze.