EppesConsulting Blog

I was playing around with MOBI/EBOOK formats today (more posts to come in the future) and needed to add a MIME type to my GoDaddy shared hosting account.  I found a great article on how to do this through your Web.config file here.  In my case, the Web.config ended up looking like this:


<configuration>
    <system.webServer>
        <staticContent>
            <mimeMap fileExtension=".epub" mimeType="application/xhtml+xml" />
     </staticContent>
    </system.webServer>
</configuration>


One of my friends wrote an excellent article on Wireframing
with Fisher Price.  The idea is that you can use a child’s toy (similar to
an Etch A Sketch) to wireframe effectively.  I believe the most important theme
he captured was:

No detail – It’s very hard or nearly impossible to put any type of detail into
these drawings. In some parts of design, detail is very important, but in wireframing,
detail can be the downfall of the process.

I’ve found serversniff.net to have quite
a few domain tools, including traceroute and SSL certificate inspection.

I’ve found this page very
handy when it comes to writing LINQ queries.

From this site:

select @@VERSION

exec sp_server_info

SELECT SERVERPROPERTY(‘ProductLevel’)

Ever need to automatically send a tweet?

Tweet#

Solution 1:

Select Table_name as “Table Without PK”
From Information_schema.Tables
Where Table_type = ‘BASE TABLE’ and
Objectproperty (Object_id(Table_name), ‘TableHasPrimaryKey’) = 0 and

Objectproperty (Object_id(Table_name), ‘IsUserTable’) = 1

Solution 2:

Select [name] as “Table Without PK”

from SysObjects where xtype=’U’ and
id not in
(
Select parent_obj from SysObjects where xtype=’PK’
)

It threw me for a loop when a Cisco CallManager version of a SQL server was on an
abnormal port (not 1433).  It took me a while to find it, but if you want to
connect to a non-standard TCP/IP port from SQL Management Studio, simply connect to
the hostname then a comma with the port number.

Example:  MySqlServer.MyDomain.com,3821

I stole this information from here.

I used to run Trillian from my USB drive under U3.  Then I got a laptop with
a built-in SD card reader, so I wanted to run all my apps without having a USB
drive sticking out the side of the computer.  As far as I know, you can’t get
a U3 SD card (wouldn’t make sense at all).  Also, there is not a “portable” version
of Trillian other than U3.  I found a way to use the U3 version of Trillian
as a truly portable application.

Trillian U3 on a standard
USB drive

Instructions copied here for convenience sake:

First you will need access to a U3 drive.

1. Download and install Trillian for U3 on to the U3 Drive.
2. Copy the U3P file from the system\apps folder to a temporary location.
       i.e. U:\System\Apps\58EA136C-7E57-4416-B59E-394C46DD505B\Trillian-v3.11-b1028.u3p
3. Rename the u3p file you just copied to a zip file. i.e. Trillian-v3.11-b1028.zip
4. You can now uninstall Trillian from the U3 drive if you wish.
5. Extract the zip file.
6. Copy the Data\Users folder to the Host folder
7. Delete the Data folder, delete the Exec folder, delete the manifest folder
   Optional: Rename the host folder to Trillian
8. Copy to your usb drive
9. Run Trillian

Have you ever needed to get the output of a program into an environment variable so
another program can read it?  It’s really easy to do in a Linux shell, but how
about in DOS?  I’ve found this program to be invalueable:

XSET