Archive for August, 2007

MSSQL Server Database ID

When using MSSQL Profiler you need your Database ID in order to limit the data returned to you when watching where a process fails. Here is a quick query to return the name of your databases and the IDs associated to them.

SELECT name, database_id FROM sys.databases

Comments

Web Host

I am done hosting this site at home and have now moved it to a web hosting company. Should be a bit more reliable than my cable modem and should save me a ton of time by not tinkering with it.

Comments

Browser ID

I was playing around with my BlackBerry at lunch and surfing the web with the thing. In the logs on a web server you get info like the platform and the browser version of visitors, so I got to wondering what it looks like when I browse with the phone.

First with the BlackBerry Browser. Wow it reveals a lot about the phone it came from.
BlackBerry7130e/4.1.0 Profile/MIDP-2.0 Configuration/CLDC-1.1 VendorID/105

Then with the Opera browser from the BlackBerry.
Opera/8.01 (J2ME/MIDP; Opera Mini/3.1.8295/1690; en; U; ssr)

Then curiosity got me at home later and I grabbed the PocketPC running Windows Mobile 5.
First with the IE that comes with WM5 and it explains why sites look like crap with the IE on the PPC, it is using IE4 rendering. Then the resolution is off since the PPC is actually at 480×640
Mozilla/4.0 (compatible; MSIE 4.01; Windows CE; PPC; 240×320)

Next up Opera for the PPC, and Opera gets it right, renders pages better too.
Mozilla/4.0 (compatible; MSIE 6.0; Windows CE; PPC; 480×640) Opera 8.65 [en]

Finally Minimo which is a mini browser based off the Mozilla project.
Mozilla/5.0 (Windows; U; Windows CE 5.1; rv:1.8.1.4pre) Gecko/20070327 Minimo/0.020

Now I have to get my hands on an iPhone to see how Safari shows itself off there and a Wii to see what the Opera browser on it looks like.

::UPDATE::
Thanks to Steve here is the iPhone tag
Mozilla/5.0 (iPhone; U; CPU like Mac OS X; en) AppleWebKit/420+ (KHTML, like Gecko) Version/3.0 Mobile/1C25 Safari/419.3

Comments (1)