Blog Home  Home RSS 2.0 Atom 1.0 CDF  
{Patrick Tam Dot Net}
Patrick's Web and Moblog About Nothing
 
 Thursday, May 08, 2008

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

5/8/2008 2:16:50 PM (Pacific Daylight Time, UTC-07:00)  #      Computer and Gadgets  | 
 Sunday, April 27, 2008
Test drove this today. Very nice!

4/27/2008 12:48:47 PM (Pacific Daylight Time, UTC-07:00)  #       | 
 Friday, February 22, 2008

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

2/22/2008 10:59:14 AM (Pacific Standard Time, UTC-08:00)  #      Computer and Gadgets  | 
 Thursday, February 07, 2008
Happy rat year, everyone. Best of luck to all you rat people like myself.

2/7/2008 11:35:21 PM (Pacific Standard Time, UTC-08:00)  #      General Blog  | 
 Monday, January 28, 2008

Could I clean your screen for some food?

screenclean.swf (1.61 MB)
1/28/2008 9:44:40 PM (Pacific Standard Time, UTC-08:00)  #      General Blog  | 


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

1/28/2008 9:32:15 AM (Pacific Standard Time, UTC-08:00)  #      General Blog  | 
 Friday, October 26, 2007
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'

10/26/2007 3:24:41 PM (Pacific Daylight Time, UTC-07:00)  #       | 
 Tuesday, October 23, 2007

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.

tmobiledash.jpg

10/23/2007 3:21:47 PM (Pacific Daylight Time, UTC-07:00)  #       | 
 Thursday, September 20, 2007

U.S. Senate Roll Call Votes 110th Congress - 1st Session

as compiled through Senate LIS by the Senate Bill Clerk under the direction of the Secretary of the Senate

Vote Summary

Question: On the Cloture Motion (Motion to Invoke Cloture on the Specter Amdt. No. 2022 )
Vote Number: 340 Vote Date: September 19, 2007, 10:47 AM
Required For Majority: 3/5 Vote Result: Cloture Motion Rejected
Amendment Number: S.Amdt. 2022 to S.Amdt. 2011 to H.R. 1585 (National Defense Authorization Act for Fiscal Year 2008)
Statement of Purpose: To restore habeas corpus for those detained by the United States.
Vote Counts: YEAs 56
NAYs 43
Not Voting 1

The Assholes who voted NO. Fucking republicans Bush cronies and one traitor LIEberman.
Alexander (R-TN)
Allard (R-CO)
Barrasso (R-WY)
Bennett (R-UT)
Bond (R-MO)
Brownback (R-KS)
Bunning (R-KY)
Burr (R-NC)
Coburn (R-OK)
Cochran (R-MS)
Coleman (R-MN)
Collins (R-ME)
Corker (R-TN)
Cornyn (R-TX)
Craig (R-ID)
Crapo (R-ID)
DeMint (R-SC)
Dole (R-NC)
Domenici (R-NM)
Ensign (R-NV)
Enzi (R-WY)
Graham (R-SC)
Grassley (R-IA)
Gregg (R-NH)
Hatch (R-UT)
Hutchison (R-TX)
Inhofe (R-OK)
Isakson (R-GA)
Kyl (R-AZ)
Lieberman (ID-CT)
Lott (R-MS)
Martinez (R-FL)
McCain (R-AZ)
McConnell (R-KY)
Murkowski (R-AK)
Roberts (R-KS)
Sessions (R-AL)
Shelby (R-AL)
Stevens (R-AK)
Thune (R-SD)
Vitter (R-LA)
Voinovich (R-OH)
Warner (R-VA)

http://www.senate.gov/legislative/LIS/roll_call_lists/roll_call_vote_cfm.cfm?congress=110&session=1&vote=00340

9/20/2007 1:38:19 AM (Pacific Daylight Time, UTC-07:00)  #      Rant  | 
 Monday, August 13, 2007

Migrate content by using import/export

The import/export feature is based on the new Content Migration APIs. With import/export, you can migrate either subsites or entire site collections, and you can import a subsite into an existing site collection. Like the Smigrate.exe utility in the previous version, import/export requires that the site you import to already exists. Note that import/export does not include some site settings, such as Recycle Bin state and alerts.

To use import/export to migrate a site or site collection, use the following process:

1.

Export the subsite or site collection by using the following command:
c:\program files\common files\microsoft shared\web server extensions\12\bin\stsadm.exe

Stsadm.exe -o export -url <URL> -includeusersecurity

2.

In Central Administration, on the Manage Content Databases page, set to offline all databases except the one that currently contains the subsite or site collection.

3.

Create a blank site or site collection to contain the content you are importing.

4.

Import the subsite or site collection by using the following command:

Stsadm.exe -o import -url <URL> -includeusersecurity

The includeusersecurity parameter specifies that you want to import the security settings for the subsite or site collection. If you do not need the security settings, you can omit this parameter.

OR

Migrate a site collection by using backup/restore

If you want to migrate an entire site collection, you can do so by using the backup and restore operations with the Stsadm.exe command-line tool. First, back up the site collection you want to move, then delete it from the current database and take the database offline. Then, restore the site collection to the new URL. Be sure that there is no site collection already at the new location, or the restore operation will fail.

 

If there is a site collection at the destination and you want to overwrite it, you can use the overwrite parameter with the restore operation.

To use backup/restore to migrate a site collection, use the following process:

1.

Back up the site collection by using the following command:

Stsadm.exe -o backup -url <URL> -filename <filename.dat>

2.

In Central Administration, on the Manage Content Databases page, set to offline the database that currently contains the site collection.

3.

Restore the site collection by using the following command:

stsadm.exe -o restore -url <URL> -filename <filename.dat>

4.

In Central Administration, on the Manage Content Databases page, set to online the database that originally contained the site collection.

8/13/2007 5:20:30 PM (Pacific Daylight Time, UTC-07:00)  #      Computer and Gadgets  | 
 Wednesday, August 01, 2007
Okay, this one took me a while to figure out, but nonetheless I found it and will share it.

In order to turn off or disable the MySite or MyLinks functionality you need to be an Sharepoint administrator.

Go to the Central Administration Web Page
Click on the link for Shared Services Administration
     --If you have more than one SSP, select the one that is running the MySites functionality
Under "User Profiles and My Sites" click Personalization Services Permissions

Select the group you want to limit the functionality for.  More than likely you will just have NTAuthority\Authenticated Users.

In the next screen you will see a list of checkboxes,
     --To disable MySites uncheck "Create Personal Site"
     --To disable MyLinks uncheck "Use Personal Features"

8/1/2007 5:47:37 PM (Pacific Daylight Time, UTC-07:00)  #      Computer and Gadgets  | 
 Thursday, July 26, 2007

There are so many things the main stream media outlet in the U.S. won't tell you about the middle-east. They all are propaganda machines. Get your news elsewhere.

7/26/2007 5:11:58 PM (Pacific Daylight Time, UTC-07:00)  #      Rant  | 
 Friday, June 29, 2007

I spotted the Google street view car at Baja Fresh in Sunnyvale during lunch today. It's amazing that they have million of dollars of equipment in this modified beat-up mini van. They take so many high resolution images that they have to swap out terabyte of hard drives every other day or so.

 





6/29/2007 5:46:50 PM (Pacific Daylight Time, UTC-07:00)  #      Computer and Gadgets  | 
 Monday, June 11, 2007

We need more people like you to stand up to the morons running our government. This country is so f'ed up.

6/11/2007 10:49:46 AM (Pacific Daylight Time, UTC-07:00)  #      Rant  | 
Copyright © 2008 Partick Tam. All rights reserved.