Remote Server MSSQL

I have just had occasion to want to access data from two MSSQL databases. One is on my workstation. The other is out there in cyberspace someplace. I used MS SQL Server Management Studio Express. Here is how I did it:

First, I created two new scripts, CreateServer.sql and ProcessData.sql. Each of these was created with a connection to my local instance.

Then, I created a named reference to the remote database. In their parlance, it is a server and the reference is in sys.server (as I found out from one of the many error messages* I got along the way). This required EXEC'ing two commands, both placed in the CreateServer file:

EXEC    sp_addlinkedserver    @server='LOCALSERVERNAME', @srvproduct='', @provider='SQLOLEDB', @datasrc='999.999.999.999'

EXEC sp_addlinkedsrvlogin @rmtsrvname=LOCALSERVERNAME, @useself=FALSE, @rmtuser='REMOTEUSERNAME', @rmtpassword='remotepassword'

Then I could access them using straightforward syntax (in the ProcessData file):

SELECT field1, field2 FROM LOCALSERVERNAME.DATABASENAME.dbo.TABLENAME

Obviously, DATABASENAME and TABLENAME must represent things that exist in the remote database. Less obviously, "dbo" must be exactly the way it is shown.

Microsoft explains some of the particulars: sp_addlinkedserver and sp_addlinkedsrvlogin.

*fyi, "Could not find server in sysservers. Execute sp_addlinkedserver to add the server to sysservers. The statement has been terminated."

No We Can't

Every other industrial country has managed to provide health care to their citizens. Now that he decision is made, the Republicans are telling us we can't do it.

Are we Americans? Is there something America we can't do?

The party of Can't Do. Amazing.

(Thanks Phred!)

Apple Multi Touch enhancement adds gestures, incredible improvement: http://j.mp/blKYqb

It's called Better Touch Tool. I got it when I got a Magic Mouse. It defines many gestures and allows you to associate them with actions, both in general and for specific programs, and for both the mouse and trackpad. It's great for the mouse, but it's also totally worth it just for the trackpad.

For Safari, I have added a mechanism that lets me enlarge a page with a gesture he calls the "right-tip-tap". I put a finger on the trackpad and the just tap with a finger to the right of it. Poof! the page gets bigger. Do it with a finger to the left of the reference finger and Bang! it's smaller again. If I tap my pad with three fingers, it jumps to the top of the page. It is fully awesome. 

I have similar suite on my mouse, though with different gestures. The trackpad won't let you define many one and two finger gestures (I assume Apple has claimed them) and those are best for a lot of things, especially on a track surface that moves. For paging back and forward on my mouse, I use a left or right single finger swipe. It was hard to work at first. Eventually, I realized that I just needed to let go of the mouse and brush my fingertip across it delicately. It also works great.

If you have either device, multi touch track pad or magic mouse, get this right away.

Police want backdoor to Web users' private data | Politics and Law - CNET News

I thought you'd find this interesting. It says:

"Anyone with an e-mail account likely knows that police can peek inside it if they have a paper search warrant.
But cybercrime investigators are frustrated by the speed of traditional methods of faxing, mailing, or e-mailing companies these documents. They're pushing for the creation of a national Web interface linking police computers with those of Internet and e-mail providers so requests can be sent and received electronically.
CNET has reviewed a survey scheduled to be released at a federal task force meeting on Thursday, which says that law enforcement agencies are virtually unanimous in calling for such an interface to be created. Eighty-nine percent of police surveyed, it says, want to be able to "exchange legal process requests and responses to legal process" through an encrypted, police-only "nationwide computer network." 

"

Check it out at: