How-to's

How to Get SQL Records Starting with Numbers Only
Here's a quick SQL tip on how to get records beginning with numbers only. Use the query string LIKE '[0-9]%' For example: SELECT u.UserId, u.UserName FROM dbo.aspnet_Users u WHERE u.UserName LIKE '[0-9]%' ORDER BY u.UserName Keep in mind, If you are using...  more »

How to Make Homemade Vegetable Soup
Thanks to my Mom... this homemade vegetable soup has become my all-time favorite soup, especially during the fall football season. It goes really well with a beer and a fresh piece of bread/roll and butter. Ingredients 1 lb stew beef - cut into bite size...  more »

How to Code RegEx for Positive Number w/Optional Decimal places and Whitespace
Here's a tip on how to create a Regular Expression to validate a positive number that can optionally have a decimal with decimal places. The Regular Expression will also be valid if there are any whitespace before or after the number. I'm using this Regex...  more »

How to Zip Files or Folders in Windows 7
Zipping a file or folder up can be a great way to compress the file in order to make the file size smaller and easier to manage. It can be especially useful when you want to send a large file to someone via email, since most email hosts limit the file...  more »

How to Fix ESPN Radio iPhone App after Upgrading to iOS 4.0
Ever since upgrading my iPhone to iOS 4.0, the ESPN Radio app that I had downloaded previously stopped working. Basically, the ESPN Radio app would just freeze and shut down if I tried to access it and would never get past the stations are loading screen....  more »

How to Setup Split Screens in Windows 7 to View 2 Windows on One Screen
If you only have one monitor, but want to split your screen to work in two different windows at the same time, you can now easily do that with Windows 7. The new split screen feature in Windows 7 allows you to view 2 windows side by side on your screen...  more »

How to Turn On an iPhone
Here's a quick tip on how to turn on an iPhone. To turn on your iPhone after it's been turned off follow these steps: Press and hold down the sleep/wake, on/off button on the top of the iPhone for about 3 seconds until the Apple logo icon appears on the...  more »

How to Get Photoshop Thumbnail Previews of .PSD Files in Windows 7 (32 or 64bit)
Ever since moving to a Windows 7 (64 bit) computer, I haven't been able to view Photoshop thumbnail previews of .psd files in Windows Explorer. However, today I decided to find a solution to this anonying problem, so that I could start seeing previews of...  more »

How to Make a White Russian Cocktail Drink Recipe
The White Russian (or Caucasian) cocktail drink became popular in the 1960s and 70s. More recently the movie 'The Big Lebowski' brought about a new resurgance for the sweet cocktail. A classic White Russian is made from vodka, coffee liqueur (e.g.,...  more »

How to Code a Search Helper Class to Clean Stop Words with C#
How to implement a StopWords filter in C# that will filter out certain woulds from a query.  more »

How to Turn Off AIM Instant Messenger from Starting when Windows Starts
I just installed the latest version on AOL's Instant Messenger (AIM) version 7.3. The first time after rebooting my computer, I was instantly hit with AIM starting up as well as the AIM Welcome Page popping-up much to my surprise. To say the least, this...  more »

How to Code a Date & Time Picker Control in ASP.NET
So below I'm going to share with you a fairly easy to use and understand ASP.NET User Control that allows you to pick a Date (with the ajaxToolkit CalenderExtender) and also select the Time of day using a drop down list. I've named the control...  more »

How to Keep Batteries Stored Safely and Well Organized
For the longest time I would just store all my batteries in my kitchen junk drawer. I would try keeping the various batteries in their original packaging, but over time the drawer just became a giant mess with batteries and other junk strewn about. This...  more »

How to Edit More than 200 Rows in SQL Server 2008 Management Studio
In SQL Server 2008 Management Studio, you may want to change the default settings to allow you to edit more than the 200 rows at a time, or select more than 1000 rows, which are the default settings for SQL Server. To modify "Edit Top 200 Rows" or "Select...  more »

How to Make a Cat Maze Playhouse with Cardboard Boxes
Today I decided to build a cat maze playhouse for my cat, to help pick his spirits up after a traumatic day at the vet (where he had his head shaved and got a rabies shot). Anyway, I wanted to make him something fun to play around in, so I decided to...  more »

How to Open Link in New Page on iPhone (Safari)
When using the Safari browser on your iPhone, you may want to open up a link in a brand new page (window). To open links in a new page (or copy the URL of a link) on an iPhone do the following: On your iPhone, open a web page within the Safari web...  more »

How to Fix “Validation (): Element ‘xxxxx’ is not supported” Visual Studio 2010 (VWD 2010 Express)
So yesterday, I started getting green squiggly line validation warnings at design time on ASP.NET server controls within the HTML Design view for my Visual Web Developer 2010 Express project in Windows 7. Essentially, intellisense on all the ASP.NET...  more »

How To Fix "There was a problem sending the command to the program." in Visual Studio
While using my new Windows 7 64-bit computer, with Visual Studio 2010 running as Administrator, I began getting the following error while trying to open up individual c# files or asp.net files in VS2010: "There was a problem sending the command to the...  more »

How to Determine the Bing.com Homepage Background Image Photo Details
So if you're like me, you may think that the photographs shown on the Bing.com homepage are pretty damn cool. I've actually decided to set Bing.com as my permanent homepage just for the cool pictures they put up everyday. But if you're also like me, you...  more »

How to Uninstall Windows Live Messenger
Windows Live Messenger can be pretty annoying if you have it installed on your computer, but don't actually use it. Messenger will by default load during start-up of Windows, and also pop-up when opening Internet Explorer or using the Bing search bar,...  more »

How to Disable Microsoft Security Essentials
At some point, you may need to disable Microsoft Security Essentials (MSE) in order to install other software. To disable MSE follow these steps: Open Microsoft Security Essentials Click on the Settings tab. In the left-hand menu, select Real-time...  more »

How to Listen to FIFA World Cup 2010 Soccer Matches Live Online
Want to listen to the FIFA World Cup 2010 Soccer games live online? You can actually listen to the radio broadcasts for free of the World Cup soccer matches from ESPN Radio. Here's the link to ESPNRadio.com. You can Watch FIFA World Cup Matches on ESPN+....  more »

How to Organize Computer Cords for Storage on the Cheap using Ziploc Bags
For the longest time, I had just thrown all of my extra computer cords, printer cords, monitor cords, firewire, telephone, and stereo rca cords all in a box, junked together with no real organization. This meant that when I wanted to find a particular...  more »

How to UrlEncode Plus Sign "+" in QueryString and UrlDecode Plus Symbol in ASP.NET
Here's how you can UrlEncode the plus sign (+) in a URL querystring in ASP.NET and then retrieve the plus symbol after UrlDecoding the string. In this example, I will do a postback and redirect the Server.UrlEncoded string to another page. First we will...  more »

How to Enable Remote Connection to SQL Server 2008 Express Database
Here's a step by step process to enable a remote connection to your SQL Server 2008 Express database that is configured on Windows Server 2008 using an assigned port #. 1) First make sure the SQL Server Authentication is enabled and the User name that...  more »
... 42 ...

Ask a Question

Article Categories

Most Popular Tags
football (343) mlb radio (32)
college football (268) nhl hockey (31)
basketball (202) milb radio (30)
college basketball (152) minor league baseball (30)
nfl (80) nfl radio (30)
baseball (79) triple-a (30)
mlb (65) windows 7 (24)
iphone (48) facebook (21)
nba (47) asp.net (20)
radio (42) major league soccer (19)
soccer (40) mls radio (19)
hockey (36) premier league (19)

Follow Us