{Patrick Tam Dot Net}

Connecting to WSS 3.0 Internal DB

patrick@patricktam.net (YPatrick) — Thu, 08 May 2008 21:16:50 GMT

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

Sun, 27 Apr 2008 19:48:47 GMT

Test drove this today. Very nice!

IMG00003.jpg

Gmail POP account setup on SE P1i

patrick@patricktam.net (YPatrick) — Fri, 22 Feb 2008 18:59:14 GMT

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

patrick@patricktam.net (YPatrick) — Fri, 08 Feb 2008 07:35:21 GMT

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

Screen cleaning

patrick@patricktam.net (YPatrick) — Tue, 29 Jan 2008 05:44:40 GMT

Could I clean your screen for some food?

screenclean.swf (1.61 MB)

FW: My new ax has arrived

patrick@patricktam.net (YPatrick) — Mon, 28 Jan 2008 17:32:15 GMT

-------------------------------------------
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

patrick@patricktam.net (YPatrick) — Fri, 26 Oct 2007 22:24:41 GMT

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

patrick@patricktam.net (YPatrick) — Tue, 23 Oct 2007 22:21:47 GMT

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.