{Patrick Tam Dot Net}

Connecting to WSS 3.0 Internal DB

2008-05-08T14:16:50.0091394-07:00

I'm running WWS 3.0 with the internal database but I need to connect to it to make some security changes. Here's how.

Use Microsoft SQL Server Management Studio

Server type: Database Engine

Server name: \\.\pipe\mssql$microsoft##ssee\sql\query

Authentication: Windows Authentication

Audi A5

2008-04-27T12:48:47.0000000-07:00

Test drove this today. Very nice!

IMG00003.jpg

Gmail POP account setup on SE P1i

2008-02-22T10:59:14.0363449-08:00

This is the setting for Gmail pop account setup on the Sony Ericsson P1i.

Account name: Gmail
Your name:
E-mail Address:
Connection type:POP3
Inbox
Incoming mail server: pop.gmail.com
Username:E-mail Address
Password:
Download restrictions: <100KB
Receive using group:Preferred group
Outbox
Outgoing mail server: smtp.gmail.com
Use SMTP authentication:yes
Use Inbox login details:yes
User name:E-mail Address
Password:
Send using group:Preferred group
Advanced
Incoming
Secure connection:SSL
Incoming mail port:995
Secure password authentication:none
Outgoing
Secure connection:SSL
Outgoing mail port:465
Use MIME encoding:yes

Happy Chinese New Year

2008-02-07T23:35:21.0780000-08:00

Happy rat year, everyone. Best of luck to all you rat people like myself.

Screen cleaning

2008-01-28T21:44:40.3490000-08:00

Could I clean your screen for some food?

screenclean.swf (1.61 MB)

FW: My new ax has arrived

2008-01-28T09:32:15.0000000-08:00

-------------------------------------------
From: weblog@0o0.org[SMTP:WEBLOG@0O0.ORG]
Sent: Monday, January 28, 2008 9:30:06 AM
To: My Dash
Subject: My new ax has arrived
Auto forwarded by a Rule

But with a minor problem. A replacement is on the way.

IMAGE_214.jpg

IMAGE_213.jpg

Changing schema names on Sql Server 2005

2007-10-26T15:24:41.0950000-07:00

In database on Sql Server 2005, I have to change schema names from some username to dbo and I wrote the following sql statements which simply generates alter queries. All you have to do is to change 'Username Here' to actual username, it will generates alter queries for you and then just copy and execute them in query window.

SELECT 'ALTER SCHEMA dbo TRANSFER' + s.Name + '.' + p.Name FROM sys.Procedures p INNER JOIN sys.Schemas s on p.schema_id = s.schema_id WHERE s.Name = 'Username Here'

SELECT 'ALTER SCHEMA dbo TRANSFER' + s.Name + '.' + t.Name FROM sys.Tables t INNER JOIN
sys.Schemas s on t.schema_id = s.schema_id WHERE s.Name = 'Username Here'

SELECT 'ALTER SCHEMA dbo TRANSFER' + s.Name + '.' + v.Name FROM sys.Views v INNER JOIN
sys.Schemas s on v.schema_id = s.schema_id WHERE s.Name = 'Username Here'

T-Mobile Dash Internet Connection Sharing

2007-10-23T15:21:47.6310000-07:00

I was in training yesterday and the training office did not have Internet access. I know that the T-mobile Dash smartphone I have has the capability of sharing its Internet access. So I played around with the setting and struck gold. It was pretty easy to setup.

On the Dash, go to Start>Accessories>Internet Sharing on the PC Connection make sure is set to USB or Bluetooth PAN and Network Connection make sure is set to T-Mobile Data and hit Connect. That should do it. You should be able to get an IP address from the Dash for your laptop to be able to connect to the Internet.

From your PC, connect to the Dash with USB cable or Bluetooth PAN (preferred). The connection is as fast as GPRS could offer but it is better than nothing when you are desperate for an Internet connection.