jjerome.com

Visual Studio 2010 comment syntax

2012-05-14T10:20:00.000-07:00

I just want to air an annoyance with Visual Studio 2010 and how it formats comments.

Code I want to comment:

I select the code and hit the comment button:

(By the way, Ctrl+K, Ctrl+C is the worst key combination I've ever heard of)

The Result:

Why can't I get a result where the comment tags are on their own lines?
This seems much cleaner to me. It also is the same syntax the Microsoft doc uses.

SQL Server and Excel: Include column headers

2012-02-16T11:02:00.000-08:00

If you want to build a quick report from your sql results in Excel, I'd highly recommend turning an option in Management Studio (SSMS) called "Include column headers when copying or saving the results". Dare I say it's one of those helpful options you only know about if you happened to stumble across it?

You'll find it under:

[System Menu] > Tools > Options...
Query Results + SQL Server + Results to Grid
Check the box that says "Include column headers when copying or saving the results"

Options dialog:

Example of use:

Select from Results Grid


Select All (or Ctrl+A & Ctrl+C)

Pasting into Excel

Headers included!

Backup Visual SVN Repositories

2012-02-13T14:07:00.000-08:00

(using svnadmin dump)

After migrating from a Linux SVN server to a Windows server with Visual SVN, I needed a new backup script. Visual SVN doesn't come with a backup solution, but it does have enough SVN admin tools to be able to complete this task without having to install any additional SVN tools.

The scripts perform an svadmin dump on every repository on the server, then zip those dump files into a one zip file with the current date, using 7-zip. I used 2 scripts because I wanted to get as much logging as possible into the final zip file.

You’ll find loads of similar scripts throughout the web, the ones below are just my variant of other methods found; please feel free to cherry pick anything you need out of here. It goes without saying that you'll have to customize each script to get it work on your system. This code is free and comes with no guarantees. Good luck!

Code Highlights:
These are conventions I felt were interesting, I've removed some of the script particulars:

Call svn_dump_repos.cmd > log.txt

Calls the dump script and pipes the output to a text file (log_timestamp.txt)

Dir /A:D /B> dirs.txt

(Run in Repository folder) Stores a list of all folders (repositories) into a text file (dirs.txt)

FOR /F %%r IN (dirs.txt) DO ( ... )

Runs a loop for each item (%%r) in dirs.txt (i.e. each repository)

I highlighted the same lines that I felt were important in the code below.

Script 1:
svn_backup.cmd

@ECHO OFF
REM svn_backup.cmd
REM 02/10/2012 jmj
REM
REM This script will log the entire script: svn_dump_repos.cmd, and add it to the final zip file.
REM Instead of providing command-line arguments, each variable is set below.
REM

CLS

REM cpuname used for filename, workingdir for holding dumps/logs/etc,
REM and destdir for final destination
set cpuname=svnserver
set workingdir=D:\svn_backup\temp
set destdir=\\backup_server\DEV

REM timestamp = YYYYMMDD
set timestamp=%DATE:~-4%%DATE:~4,2%%DATE:~7,2%

REM Program file locations
set zipexe="C:\Program Files\7-Zip\7z.exe"

echo.
echo ****************************************************
echo Starting svn_dump_repos.cmd, (log as log_timestamp.txt)
echo ****************************************************
if not exist %workingdir% md %workingdir%
call svn_dump_repos.cmd > %workingdir%\log_%timestamp%.txt

REM svn_dump_repos.cmd created the final zip file, add any log files into it (*.txt)
echo.
echo ****************************************************
echo Adding log files to zip file
echo ****************************************************
cd %workingdir%
%zipexe% a %cpuname%_%timestamp%.zip %workingdir%\*.txt

echo.
echo ****************************************************
echo Move archive to final destination
echo ****************************************************
move *.zip %destdir%

echo.
echo ****************************************************
echo Removing the temporary files and exit
echo ****************************************************
del /f /q %workingdir%\*.txt
del /f /q %workingdir%\*.svndump

Script 2:
svn_dump_repos.cmd

@ECHO OFF
REM svn_dump_repos.cmd
REM 02/10/2012 jmj
REM
REM This script will perform a svnadmin dump on each repository in a folder
REM
REM Instead of providing command-line arguments, each variable is set below.
REM

REM cpuname used for filename, workingdir for holding dumps/logs/etc,
REM and destdir for final destination (not used here, but you want to include location in log)
set cpuname=svnserver
set repo=D:\Repositories
set workingdir=D:\svn_backup\temp
set destdir=\\backup_server\DEV

REM timestamp = YYYYMMDD
set timestamp=%DATE:~-4%%DATE:~4,2%%DATE:~7,2%

REM Program file locations
set svnadminexe="C:\Program Files\VisualSVN Server\bin\svnadmin"
set zipexe="C:\Program Files\7-Zip\7z.exe"

echo.
echo ****************************************************
echo Hello! Ready!
echo.
echo Create svn dump files for each repository on server
echo.
echo Using these Settings:
echo - Computer Name: %cpuname%
echo - Repository Folder: %repo%
echo - Working Directory: %workingdir%
echo - Destination Directory: %destdir%
echo - Zip Exe (7-zip) Location: %zipexe%
echo - svnadmin Location: %svnadminexe%
echo ****************************************************
echo.

echo.
echo ****************************************************
echo Dump Respositories (name_timestamp.svndump)
echo ****************************************************
cd %repo%
dir /A:D /B> %workingdir%\dirs.txt
cd %workingdir%

FOR /F %%r IN (%workingdir%\dirs.txt) DO (
    echo Dumping: %%r
    %svnadminexe% dump %repo%\%%r > %workingdir%\%%r_%timestamp%.svndump
    if errorlevel 1 then Goto Error
)

echo.
echo ****************************************************
echo Compressing Dump files (servername_timestamp.zip)
echo ****************************************************
%zipexe% a -tzip %workingdir%\%cpuname%_%timestamp%.zip %workingdir%\*.svndump

if errorlevel 1 then Goto Error

echo.
echo ****************************************************
echo testing the new archive
echo ****************************************************
%zipexe% t %workingdir%\%cpuname%_%timestamp%.zip

if errorlevel 1 then Goto Error

echo.
echo ****************************************************
echo listing contents of new archive
echo ****************************************************
%zipexe% l %workingdir%\%cpuname%_%timestamp%.zip

if errorlevel 1 then Goto Error

GOTO Finish

:Error
echo.
echo There was an Error in the process
echo Please double-check the results!
echo.
echo GoodBye!
@ECHO ON

:Finish
echo.
echo Finished!

@ECHO ON

Show/Hide Results Pane – SQL Server 2008

2012-02-06T11:36:00.000-08:00

A few years back I wrote an article about doing this same thing in SQL Server 2005. All the images from the previous post were somehow lost, and since the instructions are basically the same for SQL 2008 I thought it would be a nice refresher.

One of the simplest and most useful features when debugging a sql script is to be able to run your query to see some results, then hide the results pane to continue tweaking your sql code. This feature was a button on the toolbar in Query Analyzer in SQL Server 2000, but for some reason it has been missing in SSMS (SQL Server Management Studio) since 2005. Well, the button may not exist by default, but it's easy to add it in.

This is what we are striving for, a button on the SQL Editor toolbar that says either "Show Results Pane" or "Hide Results Pane":

To add a button to hide the results pane:

1. Click on the little down-arrow at the end of a toolbar and choose "Add or Remove Buttons", then choose "Customize...":

Add button to Toolbar

2. The Customize dialog window will open with the "Commands" tab selected. Now we only need to find the command we are looking for. Under "Categories:", choose "Window". Then under "Commands:", find the command "Show Results Pane":

Choosing the "Show Results Pane" command from the menus

3. Once you have located the "Show Results Pane" command, you have to click and drag it to where you want it to be located on the toolbar:

Starting the drag

Placing on toolbar

End result after placement

Originally I had my button located on the Standard toolbar, but eventually I figured out it made more sense to add it to the SQL Editor toolbar. It's pretty easy to find the SQL Editor toolbar - it only displays when you are working in a query window.

Here is the end result again:

Notice the button says "Hide Results Pane" when the results pane is showing:

"Hide Results Pane" Button

Also notice that the button says "Show Results Pane" when the results pane is hidden:

"Show Results Pane" Button

SQL 2008 Installation Follies

2012-02-03T14:15:00.000-08:00

I installed SQL Server 2008 (R2) on my machine alongside SQL Server 2005, which was already on there as the default instance; I named my 2008 instance “SQL2008”.

If you’re like me, you have lived the past few years without the need to think about default instances. So remember that stuff like “(local)” will connect to your 2005 instance, and “(local)\SQL2008” will connect to your 2008 instance.

SSMS 2008 will gladly connect to your (default) 2005 instance, and then you will be left scratching your head trying to figure out why you can’t create databases with a compatibility level of 100, or continue to get frustrating errors trying to restore 2008 backups.

That’s my errant move of the day, I hope this finds you before you do anything drastic.

Things that make me happy

2011-11-10T13:29:00.001-08:00

I've been really feeling busy the last couple of years, and it's easy to lose sense of who you are when all you are doing is living a to-do list. A while back I decided to write down all the things I can think of that make me happy. By happy I mean truly happy, not something I'm doing for the sake of looking happy.

Hiking in a scenic place. Looking out over the snowy mountains with a cool breeze in my face. The breeze cooled by the wind flowing over the snow reminds me of how real the world is, and it's one of my favorite feelings in the world.

Camping. It reminds me that I can still live without all the modern conveniences, although I really like campgrounds that have nice bathrooms.

Skiing/Snowboarding. I’ve had some difficulty with this lately, because it’s easy to get caught up in the technical stuff like equipment and tricks. I really like tricks, but I’m afraid it’s just a means of showing off and not as fun for me on a fundamental level. Exploring around the slope with friends on a snowy day is fantastic fun. One of my best times on the slope was when I got stuck in a snow drift up to my chest (cascade concrete); it took me 30 minutes to get myself out.

Music. I love listening to music, and if the song is right it can make the hairs on the back of my neck stand up straight.

Technology. I think it appears to my tinkering nature, but I also like a dose of reality mixed in. I'm a huge fan of applying new technology to things that really make life better. A fridge with a computer in the door is not making life better, but a video baby monitor with night vision is making life better.

Hanging out with friends. I miss college parties, and I’m not sure I would have outgrown them if it wasn’t for not wanting to be the oldest one there. Lots of people to talk to, and the conversation could get surprisingly deep if you allow it.

Water. For some reason I love water: swimming, water skiing, and other water sports are really fun for me. I don’t like lap swimming as much because it gets kind of boring. However lap swimming is the best I can do for now.

Traveling. The planning is kind of annoying, and I’m not too hot on flying either, but I love getting into the everyday of some other place I’ve never been to. I think it pushes me out of my comfort zone and it’s a great feeling once I realize I’m going to be ok.

Kids. At some point I came to the realization that I wasn’t going to be any kind of person remembered for generations to come. At that point I started reflecting inward on what I was here for, because simply existing wasn't good enough for me. After peeling off layer by layer, I decided the best thing I could do for society was to have kids that grew up with well-balanced stable parents. Parents who leave their kids in the car while they are at the bar might make the nightly news, but it's the parents who keep a steady ship that make all the difference in the world.

Open Source Lent - Software List

2011-08-12T10:44:00.000-07:00

I forgot to post my list of software projects I donated to for Lent in 2011. Anyway, here is the list (albeit a little late):

3/09 Launchy
3/10 ssms tools pack
3/11 TWiT Leo Laporte
3/12 TortoiseSVN
3/13 NUnit
3/14 Notepad++
3/15 irfanview
3/16 AstroGrep
3/17 Mantis
3/18 Angry IP Scanner
3/19 Subversion (Apache foundation)
3/20 Wikipedia
3/21 FileZilla
3/22 Firefox
3/23 PDF Creator
3/24 Gimp for Windows (http://gimp-win.sourceforge.net)
3/25 OpenOffice.org
3/26 VLCQui
3/27 Audacity
3/28 FSF
3/29 jQuery
3/30 sharpdevelop
3/31 Eclipse
4/01 dosbox
4/02 thunderbird
4/03 apache http server
4/04 python
4/05 EFF
4/06 Creative Commons
4/07 lightbox
4/08 Eraser
4/09 TuxPaint
4/10 LibreOffice
4/11 OpenStreetMap
4/12 aspell
4/13 GTK+
4/14 Spybot - Search & Destroy
4/15 Truecrypt
4/16 VirtualDub
4/17 Rockbox
4/18 portableapps.com
4/19 WinDirStat
4/20 Project Gutenberg
4/21 Greenshot
4/22 gnucash
4/23 Cinemetropolis by the Blue Scholars
4/24 (Easter!) Twuffer

Open Source Lent

2011-03-11T10:08:00.000-08:00

I’ve found that most casually religious people I know who grew up with a religion in their family, usually pay attention to at least one holiday or religious rule. I have Jewish friends who will do nothing except try their best to not eat bread on Passover, or won’t do any work for one Sabbath a year (i.e. turn on a light). I’m a textbook Cafeteria Catholic who happens to pay close attention to Lent.

I use the holiday to try to better myself and show that I can give something up for 40 days. In the past I’ve given up: meat, coffee, cookies, sugar, French fries (I LOVE French fries), beer, and a few other things. I look at it as an excuse to try something different – I may not be a vegetarian, but I have a taste of what it’s like (no pun intended). I would argue that Odysseus did the same thing when he ordered his crew to plug their ears with beeswax and tie him to the mast of his ship, so that he could hear the songs of the Sirens as they sailed by.

A few years ago, a friend of mine (Nicole) suggested that I could give something away instead of giving something up. I thought this was a brilliant idea, so that year I donated something to charity/goodwill for every day of lent. It started with a couple things I had lying around the house, and eventually I was de-cluttering my home of stuff I had stored away for years. I was amazed how positive it was: I was refocusing what many people feel as an internal religious experience into an external one.

I struggled quite a bit with what I wanted to do this year, and decided I wanted to help the industry I’m involved in. I will be donating to a free or open source project for every day of lent. I use quite a bit of open source tools every day, and I’m admittedly too lazy to bother to donate. The truth is, I would probably buy an app on my iPhone without even thinking about it, but some of these developers of open source projects would love $3 dollars. Even if it only buys a beer, at least they get some recognition for their time.

I also thought it would be a cool way of promoting certain tools I use every day. I’m always curious as to the tools other people use for certain tasks, so maybe my list will help someone else find the tool they have always been searching for. I plan to post each donation on twitter (http://twitter.com/jjerome). I don’t have a lot of followers on Twitter, but it makes a nice way to keep an active list.

I already have a list of ideas, but not quite 40 of them. Let me know if you have any suggestions!

You can see my progress on my twitter account: http://twitter.com/jjerome

End Of Day(s) Function

2010-06-09T10:23:00.000-07:00

Some of our reports were not showing items marked with a date and time when using the BETWEEN operator. This was because BETWEEN only considers values that are equal to one of the values, or falls in-between the range defined by them. When you use dates with with no time, the operator assumes the time is 0.

i.e.: BETWEEN '1/1/2010' and '1/2/2010' would mean '1/2/2010' would be treated as '1/2/2010 00:00:00.000'.

I created a date function to return a given day as the last second of the day. So '1/2/2010' will be returned as '1/2/2010 23:59:59.997. The milliseconds weren't really needed in my case, but I felt like doing it anyway.

Here is the function I created. I use a [DATE] schema for my date-related functions on our server.

/*
[DATE].[EndOfDay]
6/3/2010 JMJ

Returns a datetime set to the Last possible (milli) second of the day.
i.e. [DATE].[EndOfDay]('12/8/2008') would return '12/31/2008 23:59:59.997'
*/
CREATE FUNCTION [DATE].[EndOfDay] (
@InputDate DATETIME
)

RETURNS DATETIME
BEGIN
--Get Next day (with no time)
declare @dtNextDay datetime;
set @dtNextDay = DATEADD(d, 1, DATEADD(d, DATEDIFF(d, 0, @InputDate), 0));

-- remove -2 milliseconds (that's as close as you can get)
-- which puts you into the last second of the original given day
return DATEADD(ms, -2, @dtNextDay);
END

----
Here is some example code using the function:

declare @dates table (
entrydate datetime
);

insert into @dates
select '1/1/2010 00:00:00.000'
union all
select '1/1/2010 10:00:00.000'
union all
select '1/2/2010 00:00:00.000'
union all
select '1/2/2010 12:00:00.000'
union all
select '1/2/2010 23:00:00.000'
;

select * from @dates
where entrydate between '1/1/2010' and '1/2/2010'
;

-- returns:
-- 2010-01-01 00:00:00.000
-- 2010-01-01 10:00:00.000
-- 2010-01-02 00:00:00.000

select * from @dates
where entrydate between '1/1/2010' and DATE.EndOfDay('1/2/2010')
;

-- returns:
-- 2010-01-01 00:00:00.000
-- 2010-01-01 10:00:00.000
-- 2010-01-02 00:00:00.000
-- 2010-01-02 12:00:00.000
-- 2010-01-02 23:00:00.000

This blog has moved (kind of)

2010-03-18T13:12:00.001-07:00

This blog is now located at http://blog.jjerome.com/.
You will be automatically redirected in 30 seconds, or you may click here.

For feed subscribers, please update your feed subscriptions to
http://blog.jjerome.com/feeds/posts/default.

A few more things to note:

I renamed it from "projects" to "blog" in a few places. I figured the term blog as a little more general.
I host my blog via Blogger thinking that it would be a little easier to manage than one I hosted myself (time, security updates, etc). However, they got rid of FTP support so I was forced to make these changes. All old links (jjerome.com/projects) automatically point to the new location (blog.jjerome.com).
Somewhere along the line Blogger lost some images I had included within a few posts (screen shots, etc). I have no idea how it lost them, but I'll have to look around to see if I can find them and update the original posts. In most cases the instructions I give are enough to not really need the screen shots.

SSRS Multi-Select Parameters for Stored Procedures in SQL 2005

2009-07-23T08:32:00.000-07:00

[Intro]

Using SSRS multi-value parameters with stored procedures can be a bit of a pain. Multi-Valued parameters are sent to Stored Procedures as a comma-delimited string. What follows is the method I use to write and debug stored procedures for SSRS reports.
The web is full of tutorials on handling multi-valued parameters in stored procedures. What I’m hoping to show is a method to set them up so that you can easily debug the stored procedure later on down the road.

[Background]

I found some code on SQLServerCentral.com that does a good job of splitting a comma-delimited string into a table of individual values. I wish I could credit the person who originally posted this idea, but there are lots of variations of this code floating around, and I modified the version I originally found, so please accept my apologies if this looks familiar.
This function will break down a comma-delimited string into a table of individual values. The one I’m posting here returns a table of ints, but I have others that return a table of other values (i.e. strings):


---------------------------------------------------- 
-- [dbo].[fnc_split_int] 
-- Parse a comma delimited string and insert the values into a table variable. 
-- Useful for sending a comma-delimited string parameter to a stored proc that will 
-- use it in a where IN clause.     
-- 
-- Ex: 
-- select * from customers     
-- will not work: Where customer_id in (@parameter)     
-- will work        : Where customer_id in (select item from fnc_split_string(@parameter,',')) 
--------------------------------------------------------- 
ALTER    FUNCTION [dbo].[fnc_split_int](
       @list varchar(8000),   
       @Delimiter VARCHAR(10) = ','
)
RETURNS @tablevalues TABLE (
       item int
)
AS
BEGIN

DECLARE @P_item varchar(255)
                                   
WHILE (DATALENGTH(@list) > 0)
BEGIN
   IF CHARINDEX(@Delimiter,@List) > 0
           BEGIN
           SELECT @p_Item = SUBSTRING(@List,1,(CHARINDEX(@Delimiter,@List)-1))
               SELECT @List = SUBSTRING(@List,(CHARINDEX(@Delimiter,@List) + DATALENGTH(@Delimiter)),DATALENGTH(@List))
           END
   ELSE
           BEGIN
               SELECT @p_Item = @List
       SELECT @List = NULL
           END

       INSERT INTO @tablevalues
   SELECT Item = convert(int, LTRIM(RTRIM(@p_Item)))
END

RETURN

END

Here’s a simple example of a stored procedure using this function:


create proc dbo.salesinfo (
       @customers varchar(max)
)
as
      
Select * from dbo.sales
where customer_id in ( select item from fnc_split_int(@customers, ',') )

[Using Table Variables]

The method above works well, but can get kind of annoying if you ever have to debug the stored procedure. The stored procedure could be huge, and you might not care too much about which customers are displayed. However it now requires a comma-delimited string of customers anytime you want to run some tests.
To keep me from losing my mind, I add a few table variables in my stored procedure that are designed to handle the multi-value SSRS parameters.

This is probably best explained in an example:


create proc rpt.salesinfo (
   @customers varchar(max) = null    --set to null by default 
)
as
      
--Build local customer table
declare @customerlist table (
   customer_id int
)

if @customers is null
begin
       --Load all customers (null) 
       insert into @customerlist
       select customer_id from customers
end
else
begin
       --Load only those customers chosen in @customers 
       insert into @customerlist
       select item from fnc_split_string(@customers, ',')
end


--report query (using @customerlist) 
select * from sales
where customer_id in (select customer_id from @customerlist)

Notes:

It might seem a little excessive to build a local table of values when you already have those values in comma-delimited form. But using this method has saved me a lot of headaches when I’m trying to debug something in the stored procedure.

I could use a join instead of putting the @customerlist table in the where string. However, I’ve found that performance hasn’t really been an issue for our setup. I also think it’s a little easier to read – a new developer doesn’t have to worry about finding a join that is only used to limit the resultset. From what I remember, the server does a lot to optimize queries anyway, so things like this usually do not matter as much.

[Final Thoughts]

This example shows a method I use to test and debug stored procedures for SSRS reports that use multi-valued parameters. There isn’t any ground breaking functionality introduced, just a bunch of smaller things strung together to hopefully make life easier. I should mention there are other ways of doing this, some might be better than this one. At the time of this writing I was only using SQL Server 2005.

Please feel free to ask questions or suggest improvements.

IIS 7 ASP scripts (vbscript) fail to send email (web.com)

2009-02-11T13:50:00.000-08:00

I recently had a horrible experience with web.com. They "upgraded" our web server that broke all my client's email functionality for his ASP scripts. These scripts ran flawlessly for years without issue, then all of the sudden none of them worked, and the web host seemed unwilling to help us.

After doing some research, I discovered that they upgraded their servers to MS IIS 7, which no longer directly supports sending emails from an ASP page using "CDO.Message" or "CDONTS". I'm hoping that other web.com users might come across this article in a google search and could save some themselves some time. There might also be other people who have another web host with similar problems.

From what I understand, according to all articles I have found around the web, IIS7 no longer supports sending emails from an ASP page using "CDO.Message" directly.

Here is my old code, which no longer works:

Sub SendMail(Subject,Body,EmailTo,EmailFrom)
Set Newmail = CreateObject("CDO.Message")
newmail.TextBody = Body
newmail.Subject = Subject
newmail.To = EmailTo
newmail.From = EmailFrom
newmail.Send
set newmail = nothing
end Sub

There are a few solutions out there, but the one that worked for me (as a web.com user) is to use CDOSYS. I found this through a series of searches, and my solution I present is just my flavor of the method recommended:

Regarding the Fields used for "CDO.Configuration", I had to play around to find the ones that my webhost seemed to care about. For instance, I have commented out cdoSendUsingPort and replaced it with a 2 (the actual value of cdoSendUsingPort). Most people online seem to be recommending putting the address of your SMTP server for the "smtpserver" setting, but I found that web.com only worked with "localhost".

Function SendEmail(Subject,Body,EmailTo,EmailFrom)
' SendEmail(Subject,Body,EmailTo,EmailFrom)
' 2/10/2009 JMJ: Uses CDOSYS method of sending email
'

Set cdoMessage = CreateObject("CDO.Message")
Set cdoConfig = CreateObject("CDO.Configuration")

Set Flds = cdoConfig.Fields

With Flds
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'cdoSendUsingPort
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "localhost"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
.Update
End With

With cdoMessage
Set .Configuration = cdoConfig
.To = EmailTo
.From = EmailFrom
.Subject = Subject
.TextBody = Body
.Send
End With

Set cdoMessage = Nothing
Set cdoConfig = Nothing
Set Flds = Nothing

SendEmail = true

End Function 'SendEmail()

Coincidentally, there are a couple more solutions out there. One is to copy a couple dll’s onto the new server to provide support for legacy ASP scripts; another is to just send emails using the database. I’ve provided some links below that were helpful to me.

Tips for Classic ASP developers on IIS7

IIS7 - Classic ASP Forum

How to send e-mail with CDO

ASP Sending e-mail with CDOSYS

Directv Tivo in two rooms

2008-07-03T14:37:00.000-07:00

For the longest time I’ve struggled with what to do about a TV in our bedroom. We don’t watch a lot of TV in bed, but occasionally it’s nice to have. We currently only have 2 TVs – one in our living room with a DirecTV Tivo, and the already mentioned bedroom TV with nothing. The Bedroom TV used to have a satellite connection, but we didn’t use it enough to justify the cost.

I finally did some research online and came across the idea to take the Video-Out from the Tivo (actually the Cable-Out) and run a cable to another room. What this does is essentially give us an exact copy of what’s on one TV on the other.

The specifics of the cable hookup are like this:

I had all our rooms wired for cable quite some time ago, and all the rooms run into a box in the basement
I ran an additional cable from that box to the living room with the Tivo, and fished it through the same hole as the existing cable wall outlet
I bought a new cable wall faceplate that has 3 cable connectors instead of the usual one (Directv Tivos use 2 cables from the Satellite dish, I just needed 1 to go back out) and connected this new cable to it. This made it look perfectly normal in the living room, no messy cables coming out of a hole in the wall
Connect the new cable coming from the living room (connected to the extra Cable-out from the Tivo) to the cable going to the bedroom
Now the TV upstairs sees exactly the same thing as the living room

This solved the problem of getting the TV upstairs to work, but how do I control the Tivo, change channels, etc? Simple, I used a Remote Control Extender – which I got here (link). You basically set up the ufo-looking object somewhere in the room with the Tivo, then put the transmitter in as one of the batteries for your remote. You can then operate the remote from almost anywhere in the house – it’s great. They even supply two batteries, one of which is stored (and charged) in the ufo base.

Number of Decimal places and the SubString() function

2008-07-03T13:55:00.000-07:00

I wanted a function that could give me the number of decimal places used in a given number. I really didn’t find any elaborate solutions on the web, so I decided to write my own by converting the number into a varchar and parsing it appropriately. While building the function, I discovered a neat little feature of the SubString() function.

Normally, SQL seems to work with an index of 1. So I if asked it the position of the “J” in “Jason”, it would return 1 (one). However, I was surprised to learn that the SubString() function accepts a 0 (zero) as a parameter for where to start the sub string.

This is an effective way to trim-off the last character of a string using SubString(@var, 0, len(@var)). For example, if I want to trim off the last character of “0040”, I can use the SubString() command to trim off the last “0”.

Here is an explanation with code:

--SubString(string, start, length)

Declare @var varchar(10);

Set @var = '0040';

Select SubString(@var, 1, len(@var)) --will return ‘.0040’

Select SubString(@var, 0, len(@var)) --will return ‘.004’

Using 0 for the start point with the length of the string has the effect of trimming the last character from the string. I wasn’t expecting this behavior, but it certainly is nice!

Decimal Count Function

Here is the entire function in case you are looking for something similar. I built it for use with SQL Server 2005.

Here is my usual disclaimer:

I’m not sure if this was the best way to go about solving the problem, but it worked. I thought my code and comments might be useful for someone else who has a similar problem. This code is free and comes with no guarantees.

One more thing - apparently I lost my formatting (tabs/spaces/etc) when I pasted this code, and I'm too lazy to fix it. Should only take a couple of minutes to make it look the way you're used to seeing it.

DecimalCount

7/3/2008 JMJ

Count of the number of decimal places used after decimal point.

Params:

@numString varchar(MAX) varchar representing a number, assumes 1 (one) decimal point

Returns:

int Number of places used after decimal point, 0 (zero) if no decimal point

is found in the number. Will not consider zeros on the end of the number

(i.e. .0040 will consider only .004, which will return 3).

CREATE function [dbo].[DecimalCount] (

@numString varchar(MAX)

) returns int

begin

declare @decimalPlace bigint;

declare @subStr varchar(max);

set @decimalPlace = 0;

--find index of decimal place

set @decimalPlace = Charindex('.',@numString,0);

if (@decimalPlace > 0)

begin

-- @subStr = string without decimal (or anything left of decimal)

set @subStr = @numString;

set @subStr = Right(@numString, Len(@numString) - @decimalPlace);

-- remove any trailing zeros

while(charindex('0',@subStr,len(@subStr))) = len(@subStr)

begin

-- catch conditions for numbers like '100.' or '100.0'

if ( charindex('0',@subStr,len(@subStr)) = 0

and len(@subStr) = 0 )

begin

break;

end

--using 0 for beginning will trim the last char from string

set @subStr = SubString(@subStr, 0, len(@subStr));

end

if (len(@subStr) is null)

begin

return 0;

end

else

begin

return len(@subStr);

end

else

begin

--no decimal place

return 0;

end

return 0;

end

SSRS code examples

2008-03-16T20:43:00.000-07:00

I use SQL Server 2005 Report Services (SSRS) quite a bit. I thought I'd share some code examples I keep handy.

First day of Month
To get the first day of the current month:
=CDate(Month(Today).ToString() & "/1/" & Year(Today).ToString())

Last day of Month
To get the last day of the current month (use first day of the next month and subtract one):
=DateAdd("d",-1,DateAdd("m",1,CDate(Month(Today).ToString() & "/1/" & Year(Today).ToString())))

Page number
Simple page count, easy to do but handy to have a copy of it around. I usually put this and the global execute time in the footer of the report:
="Page " & Globals!PageNumber & " of " & Globals!TotalPages

Global Execution time
Good for displaying in the footer in case it gets printed - the person looking at the report then knows when the report was ran.
=Globals!ExecutionTime

Clean URL for a direct link to a report
If want to provide a direct link to a report most people usually end up copying it from the Address bar in their web browser. However, that address usually has a lot of extra characters such as %20. I've found an address that can provide a somewhat cleaner link. Use the example below (substitute your own servername and Report+Name.

Example of a easy to paste direct link to a report (notice no %20, etc).
http://servername/ReportServer/Pages/ReportViewer.aspx?/Reports/Report+Name

These are pretty simple examples, but I can't remember how many times I've thanked myself for keeping them around in a small text file.

Scripting Database Objects from MS SQL Server 2000 to 2005 for Subversion

2008-03-06T07:44:00.000-08:00

Our development team keeps track of Database objects in our environment by scripting changes from SQL Server to a text file, then using a Subversion repository to keep track of changes. The process works pretty well for our team size, and Subversion provides us with a fairly good history of each database object.

We started this process back in SQL Server 2000 using the scripting utilities provided to generate the text files, using their file name convention. However, after we upgraded to SQL Server 2005, Microsoft changed the file naming convention of the text files. I’ve included a small table showing some of the differences.

Database Object	SQL 2000	SQL 2005
View	dbo.ViewName.VIW	dbo.ViewName.View.sql
Table	dbo.TableName.TAB	dbo.TableName.Table.sql
Table Trigger	dbo.TriggerName.TRG	TriggerName.Trigger.sql
Stored Procedure	dbo.StoredProcName.PRC	dbo.StoredProcName.StoredProcedure.sql

The filename change was a big thorn in our side. Subversion was tracking the files by filename and now all the filenames were going to change! At first we toyed with the idea of writing our own code to export the objects using the old naming convention, but we didn’t want to have to maintain yet another program. In the end we decided we were just going to have Subversion rename all the files accordingly.

Since we’re mostly doing our development on Windows, we use TortoiseSVN (http://tortoisesvn.tigris.org/), which is a great tool. However, we had around 600+ script files to rename and I didn’t feel like individually renaming each. Instead, I decided to write a small program to break down each file, determine what type of object it was, and then call “svn rename” with the appropriate change.

To do this, I had to download the Subversion client tools for Windows (http://subversion.tigris.org/project_packages.html). After I had it installed and the command line tools were working, I wrote a small C# program in Visual Studio to do the work. I never formally finished the program; instead I simply used it in debug mode so that I could step through to watch the process in detail (It only had to work once).

The end result was a bunch of renamed script files that had their revision history kept intact. I’m not sure if this was the best way to go about solving the problem, but it worked. I thought my code and comments might be useful for someone else who has a similar problem. This code is free and comes with no guarantees. Good luck.

Download the code here

using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Text;
using System.IO;

namespace RenameSVNFiles
{
class Program
{
static void Main(string[] args)
{

Console.WriteLine("Begin SVN Rename Script");

//Set to your directory
String sDir = "D:/Projects/dbscripts";

DirectoryInfo sourceFiles = new DirectoryInfo(sDir);
FileInfo[] destFiles = sourceFiles.GetFiles("*.*");

String sOrigFileName = "";
String sNewFileName = "";
String strCmdLine = "";
String sOrigFileExt = "";
int iFileExtLength = 0;
int iModifiedCount = 0;

//Declare and instantiate a new process component.
System.Diagnostics.Process process1 = new System.Diagnostics.Process();
process1.StartInfo.WorkingDirectory = sDir;

foreach (FileInfo fi in destFiles)
{

sOrigFileName = fi.Name;

//Find extension length and File name (assumes syntax of filename.extension)
iFileExtLength = sOrigFileName.Length - sOrigFileName.LastIndexOf(".");
sOrigFileExt = sOrigFileName.Substring(sOrigFileName.LastIndexOf("."), iFileExtLength);

//change each file's extention to the new naming standard
switch(sOrigFileExt)
{
case ".VIW":
sNewFileName = sOrigFileName.Substring(0, sOrigFileName.LastIndexOf(".")) + ".View.sql";
iModifiedCount++;
break;
case ".TAB":
sNewFileName = sOrigFileName.Substring(0, sOrigFileName.LastIndexOf(".")) + ".Table.sql";
iModifiedCount++;
break;
case ".TRG":
sNewFileName = sOrigFileName.Substring(0, sOrigFileName.LastIndexOf(".")) + ".Trigger.sql";

//Triggers do not have the "dbo." at the beginning of the file anymore - remove them
String tmpStr = "dbo.";
char[] trimChars = tmpStr.ToCharArray();
sNewFileName = sNewFileName.TrimStart(trimChars);
iModifiedCount++;
break;
case ".PRC":
sNewFileName = sOrigFileName.Substring(0, sOrigFileName.LastIndexOf(".")) + ".StoredProcedure.sql";
iModifiedCount++;
break;
default:
//default - skip file
continue;
}

strCmdLine = "rename " + sOrigFileName + " " + sNewFileName;

try
{
process1.StartInfo.FileName = "svn.exe";
process1.StartInfo.Arguments = strCmdLine;
process1.StartInfo.CreateNoWindow = true;
process1.Start();
process1.WaitForExit();
}
catch (Exception ex)
{
Console.WriteLine(
"Exception Occurred :{0},{1}",
ex.Message, ex.StackTrace.ToString()
);
Console.WriteLine("While trying: " + sOrigFileName + " -> " + sNewFileName);
}

Console.WriteLine(sOrigFileName + " -> " + sNewFileName);
}

process1.Close();

Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine("Number of files in directory: " + destFiles.GetLength(0));
Console.WriteLine("Number of files modified: " + iModifiedCount);
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
}
}

Back to the Turntable, I've regressed back to before my youth

2008-02-29T22:01:00.001-08:00

Quick Note: I've added myself as an Amazon Associate - so most of these links will refer to products on Amazon's website. I figured if anyone was getting any use out of my thoughts they might want to know where to start.

I'm not sure how I got here, but I'm now the owner of a restored turn table (or record player as I used to refer to them). I was just a little too young to own any real vinyl albums besides the occasional single or Star Wars adventure story. I remember my sister had a few, Michael Jackson's "Thriller" and "Celebration" by Cool and the Gang. My first real vinyl record purchase came in college when I started buying old Led Zeppelin albums to hang on my wall as artwork. It's those albums that led me to eventually end up purchasing a record player a couple weeks ago.

I have always wanted to find a cheap record player to play some of those albums I still have lying around, and my wife had a couple as well. I regularly visit my local Goodwill store to find deals on various things, so I decided to start looking for a record player as well. A couple weeks ago I found one - a BIC 960 for $6 dollars. I had no idea if it would work, but I decided it was worth the money to try.

After I got it home I discovered it was missing a needle and needed some cleaning, but it worked! I looked up places to get it repaired and found a Mom and Pop store called JNS Phonograph Needles near the U-District on 65th (almost a block East of Roosevelt on 65th). The guy there told me I had done really well - he usually will sell the model I found for upwards of $250 dollars. So I went ahead and had it cleaned up and now I have a working record player (turn table) connected to my stereo.

I've been pretty happy with my purchase thus far: I've been playing those older albums I already owned and I even picked up a few new ones. I'm listening to "A Kind of Blue" right now with my BIC 960 hooked up to my Harman/Kardon AVR 310 (with a pre-amp, see notes). Kind of nice to play - no pause, rewind, just Miles Davis. There are a few shops in the area that sell new and used albums, and I noticed Amazon.com also has a vinyl section as well. Some albums in the local stores include a coupon to download the songs in mp3 off the internet, a great idea if you ask me.

My first new album purchases were the Blue Scholars "Bayani" and U2: The Joshua Tree (remastered edition). I'm hoping to get more classic hip-hop albums in the future, but they seem to be pretty expensive. The Joshua Tree purchase was kind of a mistake. It was a gift for my wife, who is a big U2 fan. I noticed that the re-mastered album came with some extra tracks, and thought buying the album would be a great way to get the original album and the extra tracks. However, I was mistaken - the extra tracks only come with the CD Version, not the vinyl. Fortunately she still liked having the album sans-extra tracks, but I still feel kind of jipped. Bono, if you're listening, please send me one vinyl version of your extra tracks :)

If you're thinking of getting a record player (turn table), here's a list of things to consider:

Find out if you're going to use it. Vinyl really isn't cheaper than CD or mp3, and not as portable. Though some artists include a coupon to download the tracks if you buy their album on Vinyl (a great idea). Goodwill has some records, but most of that stuff is thoroughly searched through well before you get there.

You need either a stereo with a phono (RCA) input jack, or you have to pick up a Turntable Pre-Amp. They are not too expensive, about $20-30 dollars. I have one for my stereo and it works just fine.

If you grew up with CDs or mp3's (or it's been a while), keep in mind that you can't play an album straight through on vinyl. Each side of a record can only hold a few songs, and I don't know if anyone has ever invented a mechanism to physically flip a record for you (besides a jukebox). For example: if you think of a 13-track CD, on a record player (with 2 records - one stacked) expect to hear songs 1-3 (1st record), then 7-10 (2nd), then flip both over and hear 4-6 (1st), then 11-13 (2nd). The format lends itself to playing the entire album, but not in the order which you may be used to.

For those interested, here is a list of my albums on Vinyl:

Led Zeppelin I
Led Zeppelin IV
Led Zeppelin Physical Graffiti
Led Zeppelin Presence
Led Zeppelin In Through The Out Door
Led Zeppelin Coda
Led Zeppelin Kashmir (Live bootleg)
The Beatles Please Please Me
The Beatles Abey Road
Miles Davis Kind of Blue
Blue Scholars Bayani
U2 The Joshua Tree

Rhapsody Online

2007-12-28T14:50:00.000-08:00

I was browsing around the other day and ran into a small debate about whether subscription based music services have a market. After reading a few comments I found myself writing my own post, and then I decided to post part of that comment here.

I was against subscription based music for a long time, but eventually broke down and decided to try it out. My overall experience is good, some things I love, others no so much. By the way, this list is not weighted, even though I have more Cons I still think the Pros win.

Pros:

Access to all the music I can handle, which opened me up to more music. For example, when I heard that Bob Dylan released a new album, I decided to listen to it. I would have never given that album another thought if I didn't have this service. It’s the same story for a bunch of other albums/artists that I just never had the desire to buy a CD to try out.

TiVo - Rhapsody now works on TiVo. Navigating the music lists on a TiVo isn’t as easy as just playing a CD, but it has its advantages. I created a playlist for our Halloween party on my computer using Rhapsody, then hooked my TiVo to my stereo and played it for the party. We added some classic Halloween songs by the original artists and a few Top 40 songs that I would have never purchased otherwise. Despite his issues, I’d rather hear Thriller sung by Michael Jackson than some second-rate cover band.

I like to try new music and I sit at a desk all day, so if I like an album I usually get sick of it after a couple weeks of listening to it every day. I'm always looking for something new, and I used to buy at least 4 CDs a month. It's much cheaper this way and I look at it as a $14 monthly trial period for all the albums I'm considering purchasing (Kanye West - great album, 50 Cent – not so much).

You can share your playlists and other users can rate them. It’s nice since everyone using the service has access to the same songs.

It has its own music player you can download, or you can just play through a simple web app (which works with Linux).

Cons:

Great to use when I have a connection to the Internet, not so great otherwise. When I jump into my car I find myself wishing I had some of that new music I was listening to. Rhapsody Online does work with a couple portable players (Sansa), but I already have an iPod so I would have to make a commitment to switch players to get anymore out of the service. Not so much a knock on their service as it is just an inconvenience.

You don't always get every song with each album; there are certain albums and songs that are not available. I can understand a certain artist or album (though it still annoys me), but sometimes it's just some random song on an album, or every other song on an album with no rhyme or reason. It can also change: one day half of Common’s album “Finding Forever” was no longer available. I already own the album, but it was just easier to listen through the service.

Discovering new music is not as easy to do when you have so much available. Rhapsody needs some sort of service like Last.fm or Pandora. Maybe they should even consider buying or licensing Pandora’s technology.

I still get a strange feeling about not owning the music, or if my network connection is down that I might not have access to anything.

I haven't found a well-designed easy method of hooking the service up to my stereo. My wife still prefers to pop a CD into the player or just listen to her iPod.

It's priced higher than Yahoo or Napster, but I liked the fact that it works with more platforms

I'm sure there are some other benefits and annoyances I'm forgetting, but hopefully you get the point. The subscription model can work for you - not if you've been listening to the same Led Zeppelin album for the past 20 years, but there is a market for it.

In my opinion, the anti-DRM movement doesn’t really apply to these services. Their whole model is to provide a large amount of music for a monthly fee. If I’m going to buy music online, I feel I can only trust mp3. However, if I’m renting it I’m only concerned with it working on the devices that I am using. Rhapsody even provides an integrated way to buy songs from their store in mp3 format.

Contacts > Sync > Yahoo! Autosync

2007-10-19T16:09:00.000-07:00

I wrote earlier that I was looking for a personal "Holy Grail of Synchronization" to keep my contacts on my Palm device in sync with my email. I was fully willing to move to whatever platform gave me that option and I was rooting for Google since they already had an API for their Calendar web application. I am still a fan of Google's Gmail, but I still stand behind my previous statement that Yahoo Mail provides much more features that I can't leave behind if I switched.

Of all the features I want out of an email client, integration with Palm devices was my number one. Yahoo came closest with their Intellisync product, but the product was outdated and no longer worked with the majority of Palm devices. Intellisync tried to be part of Palm's HotSync process, the process by which the Palm would synchronize information with information stored on the computer. Adding Yahoo's Intellisync product slowed down the HotSync process so much that often the HotSync itself would timeout and fail. Eventually Intellisync stopped working altogether as new Palms came out or an update to the HotSync tool was released.

Nothing happened for years afterwards, but there was always people looking around for some sort of solution to the problem. A few articles were written, some buzz after Google released an API for their Calendar, but still things stayed the same. Eventually I wrote a blog post about the issue as well, where I suggested that someone just export the contact information directly out of Palm Desktop instead of using the HotSync process. Well, it appears that someone (I'm sure it was just a coincidence) was listening, and this time it was Yahoo.

Yahoo quietly released an update to Intellisync; well it's more like an entirely new product, called Yahoo Autosync. This tool does almost exactly what I originally suggested: it will export your contact and calendar information out of the Palm Desktop (avoiding the HotSync) and sync those setting directly with Yahoo Mail! I was so ecstatic that I could barely contain myself. Finally the tool I was waiting for!

Actual Experience

After downloading the tool, I had some initial problems, which I will post here in case you've run across the same issues. As usual, I wrote to Yahoo about the problems and got an automated response basically telling me that it's a free product and I'm on my own. I guess I could have written back and said my $25/year for Yahoo Plus did in fact qualify me as a non-free user, but that's not the point.

The first limitation I noticed was that it appeared as if the Calendar sync didn't work at all. Turned out that if I limited the time span for it to sync that I finally got a successful sync (limited to 30 days). I also originally installed the program on the D drive, which I believe also caused some errors until I uninstalled and installed on the C drive. That might have more to do with the discovery that Calendar syncing wasn't working, but I thought I'd mention it in case someone runs into the same problem.

I've also noticed a few contacts disappear here and there. I'm not sure when it happens, but it all started when I told the Autosync application to do a Two-way sync between Yahoo and Palm instead of a one-way Palm beats Yahoo role. After a couple of times when I picked up my phone only to find someone I call quite often suddenly missing from my contacts list I switched back to One-way sync from Palm Desktop to Yahoo.

Other Thoughts

I'm also a bit surprised that this tool hasn't gotten more recognition from the blogging community. The "Holy grail of synchronization" blog from a year ago was a huge hit, but the steps involved were crazy. It almost seems as if Yahoo doesn't stand a chance against Google because a certain population is so enamored with Google that they refuse to use any other service. It's almost as if they hear silence every time I mention the word Yahoo.

I love Google, and I really like Gmail, but I know at the end of the day that I need certain features and I'm not willing to jump through a bunch of hoops to get them when another service provides them easily for free. When are we going to see a little retro-feedback for Yahoo already?

-jj

Local Google Docs Server

2007-10-03T14:32:00.000-07:00

The other day I decided to try out Google Apps. I work with a few remote developers and it seemed that looking into Apps was worth my time. After trying it out for a few days, I'm considering using this tool as our developer document manager.

Google Apps basically wraps a bunch of Google's online applications under an umbrella of an organization or company. All users under this umbrella can email each other, share calendars, documents, and a few other things.

For the most part, I am only interested in the Docs application. It allows you to store documents, share them with other users, keeps a history of changes, and you can edit the documents directly in the browser. Oh, and don’t forget you can export those documents to your computer in a number of different formats (MS Office, Open Office, PDF, HTML, etc). Currently it can handle: word processing (Word), spreadsheets (Excel), and presentations (PowerPoint).

I have a few complaints – the document organizer doesn’t allow you to share folders. In fact, folders might as well be tags, because they are only useful for organizing things for yourself (your folders do not show up for other users in your system).

I would love to introduce this kind of tool to my client, but I already know the answer. They would want to own the content by hosting the Google Apps application on their own intranet server and I can’t blame them. Keeping an application like this behind a company firewall makes everyone feel a little safer. I started to look around for some sort of equivalent online document editor, but I can’t seem to find anything that allows you to use it on your own server.

In fact, I haven’t even found any open source tools for editing documents online at all. I’m kind of surprised, because this kind of functionality could be a huge addition to other projects. Imagine an open source online document editor like Google Apps that could be used in other projects. Wikis could use the document editor object to allow users to easily edit pages instead of coming up with these strange markup languages. Heck, shouldn’t Google be using their own Doc App within Blogger? It seems much better than Blogger’s online editor.

I heard the other day that Microsoft will be creating their own online Office tools. One would hope that they would incorporate this technology within SharePoint. I can’t stand opening documents that are stored in SharePoint, it takes forever and seems like such a hack to save the open document back to the server. Of course I heard they will require the user to have Office installed on their local computer. I guess this shouldn’t be a huge deal for corporate users, but you can’t help but think that this is just another limitation that will cause the tool to be useless.

I guess I’ll just take the "wait and see" route until something better comes along.

Show/Hide Results Pane -- SQL Server 2005

2007-04-12T16:01:00.000-07:00

I've been using Microsoft SQL Server 2005 for a few months now, and I've noticed a few differences between the SQL Server 2000 Enterprise Manager / Query Analyzer tools and the new Management Studio. I'll post some quick things I did to feel more at home in the new development environment.

Show/Hide Results Pane

One of the simplest and most useful features when debugging a script is to able to run your query to see some results, then hide the results pane to continue tweaking the sql code. This feature was a button in Query Analyzer in SQL Server 2000, but for some reason disappeared from the default buttons available in SQL Server 2005's Management Studio. Well, the button may not exist as a default button, but it's easy to add it back in.

After running a script in a query window, the window splits between the script and the results (each referred to as a pane). See the snapshot above.

To add a button to hide the results pane, click on the little down-arrow at the end of a toolbar and choose "Add or Remove Buttons", then choose "Customize..."

The Customize dialog window will open with the "Commands" tab selected. Now we only need to find the command we are looking for. Under "Categories:", choose "Window". Then under "Commands:", find the command "Show Results Pane".

Once you have located the "Show Results Pane" command, you have to click and drag it to where you want it to be located on the toolbar.

You can now Hide the Results Pane

Or you can Show the Results Pane

Tabbed vs. MDI Queries - SQL Server 2005

2007-03-19T14:53:00.000-07:00

I've been using Microsoft SQL Server 2005 for a few months now, and I've noticed a few differences between the SQL Server 2000 Enterprise Manager / Query Analyzer tools and the new Management Studio. I'll post some quick things I did to feel more at home in the new development environment.

Tabbed vs. MDI (Toolbar vs individual windows)

This is extremely simple, but I'm often surprised how many developers are debugging an issue but only looking at one query at a time. They often forget the exact item they are looking for. I switched to a windowed view a long time ago and found it useful to hold information in the background.

The default view in the Management Studio is to use tabs for all the queries (see snapshot). I know some developers like to see one statement at a time, but I'm usually referencing more than one query at a time.

To change the layout of the queries, chose Tools > Options from the menu. The first item under Environment gives you the option to switch between Tabbed documents and MDI (windowed).

Here is the result, all the queries are no longer in a tabbed view:

My Holy Grail of Synchronization

2006-10-20T14:30:00.000-07:00

the-holy-grail-of-synchronization

I came across this blog post (the link above) the other day claiming to have the “Holy Grail of Synchronization”. I started to get really excited as I clicked on the link, hoping for some relief to an issue that’s bugged me for a long time. Alas, it was only a guide to hack your way to synching your Outlook, Google Calendar, Gmail, iPod, and Mobile Phone together. It didn’t solve any of my problems, the best I could hope for it would be to raise awareness of this issue. So I decided to write my own thoughts down, with the hope of furthering that awareness.

My example compares my experiences with Palm and Yahoo in the realm of contacts and calendar syncing, but I could equally apply this to any device that contains address and calendar information, including Outlook and Gmail. In this article I mostly mention the address book, but the same can be applied to the calendar as well.

If there was ever an easy one sentence statement that would sum up what I want everyone to get from this article, it is this: Let me easily access my data so that I can share it with myself!

My Setup

Yahoo (Past and Present)
As for my email setup, I use Yahoo Mail. Yes I have a Gmail account, yes I really like it, but it lacks some features of Yahoo that I simply cannot ignore. So much so that I even have a Yahoo Plus account, which I happily pay $25/year for the use of.

It should be noted that Yahoo used to provide a tool for syncing with the Palm Pilot. It used to sync during the Palm’s HotSync process, when the Palm was trying to sync with the host computer. Yahoo’s tool would make a (often slow) connection to Yahoo to make updates to your web account. Often time the process would time out, or didn’t work at all.

I often felt the application would have worked much better if it would forgo trying to update Yahoo during the HotSync process and just update directly with Palm Desktop. I even wrote a few emails to Yahoo about this, but as usual, they never seem to respond to any user requests. I noticed the other day that Yahoo doesn’t even offer the application anymore (at least for Yahoo Mail beta users).

The only current way to get contacts into Yahoo is through their import procedures, which just require a specially formatted text file (CSV, vCard, etc) to import your contacts. There are no syncing abilities available.

Palm
I have been a Palm user for 8 years now. I started with the Palm III, and I used it to my hearts content until the device was on its last legs. Then I waited with that device a few extra months to get the Palm Treo 650.

If there was ever a complaint that stuck with me since my very first Palm, it was that I couldn’t share my contacts between devices. That’s why I got the Palm Treo – I was tired of trying to get my contacts on my Palm to be in sync with my cell phone. Finally that issue has been solved with the Treo, but I still have one remaining: I can’t sync my contacts on my Palm to my email address book.

Palm gives you the choice of 2 different applications to use when syncing your Palm device with your computer: Outlook and Palm Desktop. It should be noted that there are some utilities that will sync with Outlook, but I want no business using Outlook. I use web-based email for a reason – I have multiple computers and want access to my email from anywhere I am. I have been a Palm Desktop man ever since owning my first Palm. Anytime I have tried using Outlook, it just hasn’t worked out too well and I end up back in Palm Desktop land.

What I’d like to see

An application that can sync with everything; it would have a common database that would contain my address book. It would have plugins able to sync with all my devices/services that require it. It could access a Yahoo API to update users in my Yahoo Mail’s Contact list. It could contact directly with the Palm Desktop on my computer (and leave my Palm alone). Heck, it could even sync with Outlook, Gmail, Thunderbird, etc. Any company that wanted access to that data could provide a plugin for the user to install. It could be so simple.

I would like to see the application be a free open source tool. I would understand if a company was behind this effort and wanted to charge for plugins, but the base application would be free and open source. This way the application could avoid political issues (or at least attempt to). It could be ported to run on any OS, and if someone wanted they could write a plugin for it on that platform.

The application could set itself up by requesting which plugin it should use to import the users, then it could go from there. Conflicts? You can easily map out what fields are available for each service and provide an easy way for the user to decide.

What’s available now

These are the present possibilities as I see them. There might be other solutions, and if there are I’ll be glad to take a look at them. I’ll start off with my current setup, then move on to other services.

Here is my present setup for syncing my Palm and Yahoo (as per the Yahoo instructions):
1. Export my Palm address book via the Palm Desktop as a vCard
2. Go into Yahoo and delete all my current address book entries
3. Import the vCard with all my contacts in it

Plaxo
Honestly, these guys seem to be the closest to achieving the goal. My disclaimer is that I have never used them. I’m a little afraid of giving out all my contacts to a service that wants me to email and invite them to Plaxo. Stuff like that makes your contacts question if you are trying to sell their information.

Plaxo has a tool that claims it can sync with Yahoo and Outlook, but it will only touch a Palm if it HotSyncs with Outlook. To use this tool I would have to convert my address book over to Outlook, and I don’t use Outlook. Their solution is to export my contacts from Palm Desktop and import them into Plaxo. Why use them at all then? I can cut out the middle man and import those same contacts directly into Yahoo.

Goodlink
Goodlink is an Exchange (Outlook) synchronization tool that allows corporate users to read their email and keep their contacts and calendar in sync via the phone’s internet service. It has applications available for both the Palm and Windows CE devices. It basically makes these Smartphone devices act like a Blackberry.

My work bought me a Treo setup with this service (so now I have two Treo’s). I work from home, and I like that I can access my work email and work contacts while I’m not in front of my computer. It works out great when I’m making breakfast and I get an important email that I wouldn’t have gotten unless I was constantly hovering over my computer.

However, I despise the tool’s interface. When installed onto your Palm, it replaces the Palm’s address book and calendar applications. You can’t access any of your old contacts or calendar events, and you have to import them all into Outlook one way or another. Its interface is sorely lacking in features and the navigation system is not intuitive.

Coincidently, I ran into an article on how to break this take-over mentality in Goodlink. By making this change it allows you to manage the exchange contacts/calendar separately from the Palm contacts/calendar. Thank goodness I found this link; it completely made my day when I found it.

Chad Dickerson's blog

Conclusion

I hate to say it, but it seems like Palm is the thing holding me back the most. No one seems to interface with Palm Desktop, and nothing else will interface with the Palm except for Outlook. It’s hard to believe, since it seems like the Palm Treos are more popular than ever. They have been around for so long it boggles my mind that there isn’t some sort of solution for this problem.

Palm Desktop stores all of its data in a binary file. I’ve looked into reverse engineering this file to figure out if I can grab my contact’s information out it. There are a few sites that have tried something similar and posted their notes, but they always give up at some point. It just shouldn’t be that hard, I think Palm should have realized by now that their application is being worked around, they should open it more to inspire more development. Give us an API please!

As far as Yahoo goes, I know that there are tools in place for the type of application I am proposing. Plaxo already has tools where they demonstrate how they can access your contacts on Yahoo, Hotmail, Gmail, etc. There is even a Yahoo Widget that can access your Yahoo contacts. You can also buy 3rd party APIs that access these services. So why hasn’t an official API been released from Yahoo? Or even Google (they already have a calendar API)? My explanation is either these tools are hacking into the service to get the data, or they are paying some money to get exclusive access.

So in the end, I’ll leave you with my original request: Let me easily access my data so that I can share it with myself!

pghCAST

2006-09-18T13:35:00.000-07:00

pghCAST was a ltttle project I started a while back. It was a podcast about topics going on in and around Pittsburgh. It all started after a series of events and a good conversation with friends. I started it up with one goal: at least get a free beer out of it. Well, I didn't, so I thought I might as well write about the experience.

The beginning

I've always had a good relationship with Pittsburgh. It's where I was born, and even though my family had to move away, we always keep our roots in Pittsburgh. It's also the place where I went to college – the University of Pittsburgh. After every move I have made away from Pittsburgh, I somehow ended up back in Pittsburgh. My friends call it the "rubber band theory". My most recent move away from Pittsburgh was to Seattle, where I stayed almost 3 years before the rubber band brought me back. The best way I've heard to explain my relationship with Pittsburgh is this: Pittsburgh is my mother and Seattle is my wife. I choose Seattle, but no matter what happens or changes in my life, Pittsburgh will always be there in my heart.

I would say the first seed for the show was laid when I moved back to Pittsburgh from Seattle. I've grown into a big fan of public radio, and Seattle has an excellent NPR station, KUOW (kuow.org). The station has 2-3 daily talk shows that discuss current events, usually with an expert guest and people calling in with their questions. It is a great format, and listening to their morning show made me a big fan of Steve Scher. He's really good at handling callers' different opinions, and always seems to find an elegant way of being fair to all. I've never heard another radio station (though I'm sure they exist) that has the mayor on every month to answer callers' questions, or feature all the candidates for an upcoming election.

Pittsburgh's NPR station has no such thing. Their main station, DUQ, has a lot of jazz, which I like to listen to while I'm cooking dinner, but no talk shows where I can listen to keep up with current events. I really wanted to feature something like this, and podcasting was the cheapest way I could think of to try. After discussing this with some friends in a pub, everyone thought it was a good idea. My friend Kristin even volunteered to be on the show.

You might be wondering why we started this when it seems that everyone and their brother has a podcast. Well, I did consider that angle. It seemed to me that every new podcast seemed to be targeting a national or global audience. I thought it might work to aim for a local audience - a niche that if caught on, could be a hit in an area like Pittsburgh.

The setup

The cost was extremely cheap considering my funds. The entire cost of microphones and mixers was around $300 dollars when it was all said and done. We could have done it a lot cheaper, but I wanted to try to do things right straight out of the box. My wife's opinion was that it would be worth the cost if it kept me busy for a month or two. Besides, I could always sell the equipment afterwards if things didn't work out.

While the cost of hardware was around $300 dollars (not including the computer I already had), we did had some other expenses. Mostly it was the $10 dollars per month for hosting and bandwidth from libsyn.com. They had a deal where the cost included all the bandwidth charges, which I really couldn't beat at the time.
I knew nothing about sound recording. In fact, I'd say I still know little about sound recording. I asked a friend for his input on this project; he used to be in a band and loved the production aspect of things. We went to Guitar Center and purchased 3 oval microphones with desk stands, and a 5-port mixer. I read that condenser microphones were better, but we heard that we could make these microphones sound good and the price was cheaper. Looking back, I would have spent more time up front with microphones. Some things are just easier if you spend a little more money, therefore you don't have to do as much work. The microphones were (and still are) a thorn in my side - they never sounded right to me and we couldn't figure out how to make them sound better.

For software, we used an old version of Cakewalk, which sucked. It was easy enough to pick up, but for some reason it would just stop recording in the middle of a recording session, probably because it was an old version of the software. We wouldn't find out until 15-20 minutes into recording, and let me tell you nothing takes the enthusiasm out of the room like telling someone we had to talk about the same topics again because all was lost. After a while I picked up a refurbished iRiver mp3 player/recorder (iRiver iFP-899) that had a line-in connection. It limited our editing abilities, but it didn't matter too much.

Podcasting involves putting up rather sizable mp3 files on your server and letting a potential large audience eat up your bandwidth, causing big charges from your web host. We didn't think we were going to become the number one podcast overnight, but we didn't want to be stuck with a 12 thousand dollar bandwidth bill if a particular show hit it big. For hosting the files, we chose libsyn. They were so cheap and made the entire process so easy that we could forgive some of their growing pains and hiccups. For $10 dollars a month we got hosting and unlimited bandwidth. Originally I wanted to host only the files on their site and run a separate server for the content; we were hoping to draw people to our website and have some areas where they could interact. But that plan was a little too far out, so we started with the default blog software that was supplied by libsyn. I would have loved to do more on the web side, but we just didn't have the time and resources.

It's hard to tell if a customized website would have mattered. Almost all our downloads were from iTunes, which meant that most people had the content delivered to them through a subscription. However, our website was comprised of mostly show notes, something that the user could see via iTunes anyway. We had a few links to an online store and photo-gallery, but the links were not laid out very nicely and were underused. Some of this had to do with the blog-style template system used by libsyn, but probably had the most to do with our lack of using them.

I bought pghcast.net and pghcast.com because of a Yahoo sale. That particular day I went to buy the domain names, I searched around for the best deal and ran into this sale at Yahoo for $1.99 domains. So I figured I could buy 5 years for about the same price as 1 year at other sites. Now that the show is over, I have no idea what to do with the domain names. If you're interested, let me know.

The Show

Originally, I thought I wanted to have 2 people host the show. I bought the 3rd microphone for guests, but when my friend (who helped with the microphones) expressed interested in joining me and Kristin, I figured the more the merrier. Internally this caused some problems, because everyone had a different view of what the show should do: some of our friends wanted more arguing-style debate, others didn't want that at all. If I had to do it again, I would be very cautious of how my friends participated.

At first we tried recording on Sundays, but after a while we recorded mid-week. It was much easier for us to get people over after the order of work than the disorder of a weekend. I guess we could have used Skpe, but we decided to all meet around the table and eat/drink afterwards. I definitely wanted to be on a schedule; the group and the audience would benefit from a schedule. There are a lot of choices out there on the web, and it's hard to keep someone interested for more than a few minutes at best. By setting a schedule we at least made it easy for fans of the show to know when to expect to see a new episode.

The show started on September 4th, 2005. The first couple shows basically relied on the news of the week, and to be honest, they were kind of weak. I would keep a list of topics I saw in the news during the week, and then form some sort of show from those notes. This clearly wasn't our best format - we were basically mimicking the local news. After a while we tried to make the show more personal, with a lot of commentary about local topics and events, and at the end we would interview some random person. At first we used some friends, but then we started lining up friends of friends, and eventually we started getting requests from other people. We started noticing that the format could really work, and I think if the show would have continued we would have strengthened with this format. It's amazing the stories that any random person will tell when you give them the floor.

I submitted the site to a couple of websites, and to my surprise our first pilot show had around 30 downloads. I wasn't complaining - we went from 0 downloads to 30 in the first week. The next couple weeks we were slowly rising in the ratings. It was kind of hard to get our numbers with libsyn. They showed their stats by who requested them: iTunes, odeo, direct download, etc. They also tried to filter out unique visitors by IP address, which didn't always work too well. I noticed after a while that there were "podcatching" networks that would stream our show off their site, and if multiple people listened to the show through that site, it would only register 1 listener, because of the same IP address being used over and over.

After a while we were slowly growing to almost 60 downloads per show, then 100. An amazing thing about podcasting is that most shows, whether you plan to or not, are timeless. People would discover our show around the 10th episode and then go and download all the past episodes. It got so bad that we were discussing removing the pilot episode from the list, because we felt it was so much worse than the others! The best show had to be the show immediately before the Super Bowl. Our downloads were in the 400-500 range, and even a couple months after the Super Bowl it was still getting some downloads. If we would have had some merchandise attached to the show, we probably would have made some money those few weeks.

The beginning of the end

Eventually it had to come to an end. The absolute nail in the coffin was when I found out I was moving back to Seattle. Truth be told, I was well aware of the possibility of moving before I even started the show, but I wanted to try it anyway. I had some pie-in-the-sky dreams that maybe someone would be interested in taking it over, but no one really seemed interested. This wasn't our only problem. We always had problems with enthusiasm, maybe someone was tired from working that day, or just being lazy. It was worse yet if the person came to the show but was growing bored of it. Voice recording has no pictures, but it was amazing how the recording exposed all these enthusiasm issues.

Finally, the thing that probably did us in more than the others was lack of time. One of the things I overlooked was that we were talking about things going on in the Pittsburgh area, and we really like to do those things. It didn't leave much time to organize and get together a group and talk about it. A lot of us would go for weeks at a time doing something in the city every night. The plays, concerts, the sport games all took their toll. If we missed recording the show one week, it seemed all the more likely that we would miss the next week.

Eventually I had to be done with it. I recorded our last episode, alone, about a month after the previous show. I made no promises, but I said basically the show was over.

Lessons learned

Some of the biggest things I learned from this experience:

* If you are serious about it, it's a lot of work.

I thought it would be a simple thing to gather a few things to talk about, get some friends together, and record the show. It was simple, but I had no idea how long it would take to do all those things. I often found myself not as prepared as I thought I was before a show. Then there's the actual recording of the show: sound levels, microphone placement, EDITING, compressing, uploading, creating show notes, etc. After all this, I barely had any time to think about designing the website.

* It's hard to do by yourself, but if you work with others you need to know where you and they stand.

I was very happy to have my friends involved. In some cases I was willing to let someone slack in one area because they were so good in another. However, I think we all underestimated the amount of work. I didn't set their expectations correctly because I didn't know what to expect. After a couple of weeks, I was asking them to help find stories on their own and do more than they thought they were signing up for. If I had to do it again, I would definitely try to set that expectation right away. Then again, I don't think you can ever get expectations correct - there's always something in any project that doesn't go as planned, and you need a team that is flexible and truly understands how to react.

* Spend some time (but not too much).

I would have definitely spent more time on show development up front. That's not to say that we didn't do any - we actually had a few meetings where we brainstormed some ideas for topics for slow weeks, etc. However, I think we probably could have used a little more time on the technical side. I don't blame us, we were eager to get started and I didn't want it to get old before even starting. I will also contradict myself in the same vein and say that you should also not plan too long - it's a amateur podcast for God's sake, it's not going to be perfect.

* Watch your shortcuts.

Be careful where you make shortcuts. Sometimes spending a little more time or money can provide a huge benefit down the line.

* I'm glad I did it!

Even though I had a good idea that I would be moving, I went ahead and started the show anyway. I wasn't sure what to think of it, but we got consistently 50-60 downloads a week, and around the Super Bowl we were in the 400-500 range. All these downloads just to hear our silly show.

The emails really made me feel like someone was listening and getting a benefit. We got a few emails from people who didn't even live in Pittsburgh anymore, and just wanted to write to say that listening to our show reminded them of their old home. Others would write to respond to particular topics in the show, or how much they laughed out loud (in public) at some story we told while they were listening on their headphones. Those stories always made me feel like we were contributing.

Conclusion

Would I do it again? If the conditions were right, I definitely would. I've learned by this point in my life that I'm not the type to sit around idling by and not get involved with something. As soon as some free time shows up, I have a way of eventually finding something to fill it up. Whether it's recreational, volunteering for public causes, or helping friends with their projects. There's a million things I'd love to have the time to learn, but I have to keep a cap on things or I'd never get anything done.

Project blog

2006-05-30T14:56:00.000-07:00

Well I guess it’s come to this. I figured that with all the “blog knowledge” going on in the world today, that the world really didn’t have any room for me. They say that most blogs are written by semi-pro/semi-amateur writers looking for an outlet. I thought about that for a while, because I’ve always kind of liked the semi-amateur writing style I have. So I figured I would finally answer all my fans’ requests to start writing a blog. All zero of you should be pretty happy about now.

No really, the real reason I decided to do this was after reading a post on a mailing list I like to read about Linux users in Pittsburgh (WPLUG). The person (he whom must not be named because I’ve become too lazy to switch between windows) mentioned started writing a blog about the projects he was part of, their problems, solutions, etc. It had two goals: provide some insight into their project for others to reference, and (I’d say mostly) to provide a sort of real-world resume for things he has worked on.

I immediately liked the idea - I had just read an article somewhere about more and more companies Googling job applicants to see what they have in their past. If this article sounds familiar - we probably didn’t read the same one. I think I might have read about 5-8 articles with this subject over the past couple years. Anyway, the article was obviously spelling out doom for perspective job-seekers. “Oh my god, look at this - he dressed up as a bunny on Halloween, he might cry if we pressure him too much!” Anyway - that’s not the point. My point is that there are two sides to every story - and my take on this story is that if a company cares so much to read past my resume, that they might actually find out more about my human side and find it to be a better fit.

It’s like my little photo-album on my website. I obviously take WAY more pictures, but I put a few up that I really like. I’m not a professional photographer - I’m obviously a computer geek who takes a million pictures and only shows the one that happened to look like I’m a professional. You should know the type - there are a million of us out there.

Anyway, back to the photo-album. I had a job interview that went pretty well. At the end I met the CEO - who only seemed to look at my website, not much else. He sat there and made guesses as to where each picture was taken. If you haven’t seen my album, it’s brilliantly simple (actually I was lazy, but I’ll take brilliantly simple if you’d let me) . Back to the point - the album did exactly what I wanted; it showed a side of me and instilled conversation.

So it's been a while and I’m thinking of trying the same thing on a sort of journal. Only now these journals are called blogs. Hope you read some more, let me know if you have any comments. Though no promises - I’m not sure if I want to use blog software, or just write a little code.