-
Tunneling http traffic through ssh
James Strassburg gave a great tutorial on tunneling http(s) traffic through ssh with your Linksys WRT-54GL router. Actually, if you have a server that you can ssh to that has web access, like your web host, you can tunnel all your http(s) traffic through that server from your Windows workstation. It is pretty simple to…
-
sqlcmd error handling
I did manage to work while in Barcelona last month, not just to visit. I delivered a session on sqlcmd, attended other sessions, and learned from others. After the session, fellow PASS volunteer Thomas LaRock asked a great question regarding error handling. Pat Wright also talked about the same issue in this blog entry here.…
-
File type, directory size, free space, disk usage, and tar in Linux
A few quick notes for people who want to know how to do simple things in *nix. This is for Windows users who are making the transition or find themselves dealing with *nix from time to time. Use file FooBar to find out what kind of file FooBar is. This is helpful when you need…
-
Barcelona recommendations?
As posted here earlier, I will be in Barcelona next week to deliver a session on sqlcmd for PASS 2006 European conference. I have some time for sight-seeing. So I am seeking comments and recommendations on anything you can provide: must-see, food, places of interest, etc.. I may even do some geocaching, if possible. So…
-
Connect to SQL Server 2005 using Query Analyzer, osql, and isql
In this post, I talked about some potential permission issues facing average users regarding Sql Server Management Studio (SSMS) reports. When you manage Sql Server 2000 servers with SSMS, those reports will not be available, for the simple reason that most of those reports are based on DMVs, which are newly introduced in SQL Server…