Chris May

I am a season ticket holder for the Chicago Fire, and over the last few years, they have infuriated me numerous times with what appears to be total incompitance in running the business.  I won't go into it all now, but to point out yet another way they have blown it.

Let's say you ran the Fire, and you were trying to use your website to promote your home opener.  Don't you think you would try to avoid confusing your fans as to what time the games starts?

 

If you print out the season sechedule, it says 7:00.   If you look at the ticket, it says 7:30!

This is just dumb.  Dumb.

There are threads going on among fans on the various soccer related websites trying to figure out what time the game starts??  What is this, Guadalajara?? 

 

People love Apple, and they love iTunes, but I continue to believe that iTunesis the worst piece of widely used software out there.

Today I was trying to add a podcast to iTunes, and like months before, I ran into the problem of not being able to find anywhere that I could click to add a podcast.

It seemed the only way to add a podcast was to do so through the iTunes store.

Last time I gave up and was lucky enough to find the podcasts I wanted through iTunes, but this time the one I wanted to add wasn't listed there (or at least I couldn't find it).

After even more searching I finally found how to do it.  You need the URL as a link, and then you need to drag the link from your browser window, onto the "Podcasts" navigation link that is on the left hand side of iTunes.

Totally... stupid.  There is no other way to describe it.

 

A coworker sent me this link.  You just bookmark it, and then click the bookmark when you want to examine the layout of your page elements.

javascript:prefFile='';void(z=document.body.appendChild(document.createElement('script')));void(z.language='javascript');void(z.type='text/javascript');void(z.src='http://slayeroffice.com/tools/modi/v2.0/modi_v2.0.js');void(z.id='modi');

And it will add a little floating window in the upper left corner to show you everything you mouse over:

Recently I wanted to find the time between 2 datetimes, but I wanted to exclude weekends.  To further complicate matters, I wanted to know hours, not just days.

The "standard" way to do stuff like this is to build out a calendar table that has every date for the next 50 years, along with info like "IsWeekend" or "IsHoliday".

But I found some snippets around that I hoped to use to my advantage, and what I came up with works very well:

DECLARE @start DATETIME
DECLARE @end DATETIME

SET @start = '3/7/08 12:50 pm'
SET @end = '3/11/08 1:50 am'

SELECT (DateDiff(hh, @start, @end) - DateDiff(ww, @start, @end)*2*24)/24.0
       

I won't spend a lot of time explaining why it works, but it basically counts the number of weekend "jumps" that are crossed between the 2 dates, and subtracts accordingly.

 

This is pretty cool: http://www.jwirc.com/chat.html.

 

Are you getting one of these errors?

Could not load file or assembly Microsoft.ReportViewer.WebForms

Could not load file or assembly Microsoft.ReportViewer.Common

Could not load file or assembly Microsoft.ReportViewer.ProcessingObjectModel

The problem is that some of these assemblies are supposed to be in the GAC, or at least when you create a basic application using .net, the application is expecting to find them.

You can deal with this in one of 2 ways.  You can find and download the ReportViewer.exe from Microsoft on the clients.  Or, you can copy the missing DLLs out of the GAC on your computer, and add them into your project.

Because I didn't want to have to download extra software to my clients, I decided to take the second option.

To do this, follow the instructions here:

http://www.chrismay.org/2006/08/09/Accessing+DLLs+Stored+In+The+GAC.aspx

To pull the dlls out of the GAC (you can just copy them).

Then add them into your project at the root level (not as references, but just like you were adding another file).  Then, in visual studio, highlight them and select "Copy always" as the option for the "Copy to Output Directory" field.

This will make sure that the DLLs are copied into the BIN directory for deployment.

 

Microsoft really does a terrible job explaining all the variations of Visual Studio .Net 2008 (and there are many):

• Visual Web Developer 2008 Express Edition
• Visual Basic 2008 Express Edition
• Visual C# 2008 Express Edition
• Visual C++ 2008 Express Edition
• Visual Studio 2008 Standard Edition
• Visual Studio 2008 Professional Edition
• Visual Studio Team System 2008 Architecture Edition
• Visual Studio Team System 2008 Database Edition
• Visual Studio Team System 2008 Development Edition
• Visual Studio Team System 2008 Test Edition
• Visual Studio Team System 2008 Team Suite
  

After a lot of searching, I finally found this data sheet that explains most of it.

Why this was so hard to find is anyones guess.

One one of my dasBlog sites that was built before Akismet was supported, I accientally allowed for pingbacks to be tracked.

Ping backs are supposed to happen between blogs whenver you link to another blog article.

It's really a great idea!  If you are reading a blog post, you might see a list of 4 ping backs at the end.  These URLs are the locations of other blog articles that reference the article you are reading, so you might want to check some of those out to get those authors poing of view on whatever topic is being discussed.

But, of course, spammers ruin it for everyone.

Yesterday I got 18,000 pingbacks from sites selling prescription drugs in a matter of a hour or 2.

So I turned off ping backs, but that left me with a ton of spam to clean up.

Lucky for me, someone else has already run into this, and built a tool for stripping it out!

Really nice!  The only problem I found was that it didn't report issues with my config file (I had a bad character in there).  Actually, it WOULD report them, but would immediately begin processing the files (with no patterns to match against) so you couldn't tell that it was reporting it.

So if you run into a problem with this tool, try putting in a bad content path.  This was throw an exception and you will have time to read any debug info in the command terminal indicating if there was a problem with your config file earlier in the process.

After I fixed this issue, it worked great!

Thanks!

 

I recently wrote about some issues I was running into with Lenovo computers losing drive space.

I detailed it in this article:

What happened to my drive space (on my Lenovo laptop)?

Well, I think I found the solution.   My Lenovo came with built in Rescue and Recovery software (Under Thinkvantage).

This software tries to make local backups so you can rollback if you get a virus or something.

The problem is, it is very tricky, and doesn’t let you know that it is eating up your hard drive. 

The files never show up on your C:.  So, right now your C drive might show 80 GB total, 500 MB free… but if you show all files on the C drive, and select the properties of them, they all only add up to 45 GB (where is the rest?).

Well IBM hides these backup files somewhere.  I just noticed now that mine, even though I have never knowingly clicked “OK” when prompted to do a Rescue and Recovery backup, is saving 30GB of backup data.

So if you want to delete these, you can do the following:

1. Run Rescue and Recovery
2. Click on Advanced in the lower left hand corner
3. Click on Advanced (again) in the title bar
4. Select "Delete backups"
5. Select some backups to delete.

Thats it!
 

When Google Desktop first came out, I loved it.

It gave quick search results searching across multiple categories on my machine, and it was fast.

But the more I used it, the more I noticed things I didn't like.  Links to files that didn't exist.  Missing search results.  Incomplete results.

So even though I had a bad experience when I first tried Windows Desktop Search when it was in beta, I decided to try it again.

There is no quesiton, this is a clear cut total win for Microsoft.

Windows Desktop is fast, gives much more complete results (espically from my email), and has a much nicer user interface when compared with Google Desktop.

I have to say, I am suprised, but happy that it works as well as it does.

Give it a shot, cross your eyes just right and see the words that pop out.

This is some useful stuff from 4guysfromrolla.com. 

BEGIN TRY
   BEGIN TRANSACTION    -- Start the transaction

   -- Your code here

   -- If we reach here, success!
   COMMIT
END TRY
BEGIN CATCH
  -- Whoops, there was an error
  IF @@TRANCOUNT > 0
     ROLLBACK

  -- Raise an error with the details of the exception
  DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int
  SELECT @ErrMsg = ERROR_MESSAGE(),
         @ErrSeverity = ERROR_SEVERITY()

  RAISERROR(@ErrMsg, @ErrSeverity, 1)
END CATCH

We recently ran into a problem with SSRS where our email subscriptions were processing, but no emails were going out.

SSRS doesn't really give you any info in the web interface to give you any clue that something isn't work right, let alone help you figure out what the problem is.

I was able to solve the problem by looking at the various log files that SSRS creates:  ReportServerWebApp__X, ReportServerService__X, and ReportServer__X.

In these config files I was able to find some errors coming back from our mail server. 

This lead me to discover that the problem was with how the email addresses were formatted. 

The issue was that we recently changed which mail server we used for sending out these emails, and we have moved from an Exchange 2003 server to an Exchange 2007 server.

Exchange 2003 would accept domain accounts as destinations for emails, so you could send an email to "cmay" and it would be delivered.  It seems that Exchange 2007 requires that you provide the full email address: cmay@company.com. 

After changing some of the SPs that served up the data, all worked once again.

 

Do you need to come up with some Use Cases?  Maybe you need to create a Software Requirements Specification document.  Or, how about something as simple as writing up some test cases.

ReadySET provides (for free) a set of software engineering document templates to help you come up with these articles.

Just select the type of document you are interested in and customize as needed.

Chances are I will never get time to do this, but still it would be nice.

Very funny:

http://garfieldminusgarfield.tumblr.com/

"Who would have guessed that when you remove Garfield from the Garfield comic strips, the result is an even better comic about schizophrenia, bipolor disorder, and the empty desperation of modern life?

Friends, meet Jon Arbuckle. Let’s laugh and learn with him on a journey deep into the tortured mind of an isolated young everyman as he fights a losing battle against lonliness and methamphetamine addiction in a quiet American suburb."

Just a few of them:

 

 

 

Sometimes you might need/want to know what ports on your machine are being used.

If you try to start up a process listening on some port and it reports that the port is alread in use, what do you do?

The answer is to use this command:

netstat -a -n -o

This will show you all port activity including the PID so you can open up task manager and find which process is using which port.

Craigslist is good for laugh every now and then.

Usually it comes in the form of someone looking to hire someone to develop a site "Just like MySpace" with a budget of $500.  Or "I have a great way to run auctions online, a real Ebay killer.  Need you to implement my ideas.  Budget $1000 plus equity in the new company."  LOL.

But you can get a good laugh too by posting your own listing and reading the responses.  For example, I posted recently looking for someone with experience integrating business systems with quickbooks.  I wrote that, initially, I just wanted to sit with the person for a few hours to point me in the right direction, and to talk about some of the best practices for doing tihs type of work, but I might have them do some of the development work.

Here is one of the responses I got:

** CRAIGSLIST ADVISORY --- AVOID SCAMS BY DEALING LOCALLY
** Avoid: wiring money, cross-border deals, work-at-home
** Beware: cashier checks, money orders, escrow, shipping
** More Info: http://www.craigslist.org/about/scams.html

That is a hard program to automate, but I do have some experience with it when I worked for a large union construction company. You are better off not using it, I have some better methods of keeping your affairs in order using Excel. Call me if you want at XXX-XXX-XXXX for any questions. Marty

LOL

 

I was working on my father-in-laws laptop the other day and noticed that he was using up a lot of drive space.

I started poking around, but things were not adding up.  Of his 80 GB drive, about 30GB was unaccounted for.  I called a buddy of mine who was also running Vista to see if he had the same problem, and as it turned out, he was.

After some more investigation, it looks like this might not be a Vista issue, but is instead caused by IBM/Lenovo's Rescue and Recovery software.

I will have to confirm this later by actually fixing his computer, but I wanted to get this out there in case anyone else has a Lenovo laptop that is missing drive space.

Keywords:

Missing drive space, Missing disk space, Where is my drive space, Lenovo hard drive missing space.

I just noticed this while working on a windows forms .net application.

I made some changes to the underlying business objects that I had bound to a datagridview.  Things looked like they should at runtime, but when I opened up the designer, several of my columns were missing!

After some testing around, I realized that any column that was bound to a property on the object, where I had changed the name of the property, was no longer showing.

I figured it would fail the databind or something, but at least let me change the column details to get things working right!

So I added in fake empty property definitions to the business objects and presto: back come the columns.

After that, I was able to update the databinding field and remove my bogus properties.