Hot Computers & Programming How-Tos

How To: Make filenames case sensitive in Windows and Linux

It may not seem like a big deal, but sometimes when your filenames are being saved in the incorrect case, it is. If you save a file with uppercase letters in the name, your computer may change them to all lowercase. This occurs when downloading files form a host server to a local hard drive. But what if you want them back how you had them? Well, there's a small Windows tweak you can use to stop it from happening. Learn how!

How To: Format a hard drive with the Mac Disk Utility

Formatting a hard drive is not exactly an essential computer skill, but it certainly is if you're a technie who's looking to start building your own computers. Hard drive formatting involves erasing/formating a hard drive or USB flash drive to be compatible with different formats like MAC OS Extended and Windows OS.

How To: Free up hard drive space on a Mac

http://AskTheTechies.com Brandon Jackson is back with D.Lee Beard to answer "What files are safe to trash on a Mac to free up hard drive space?" What files are the biggest hogs? Have you really trashed all the files you thought you had? Also in this episode: how to sort web browser bookmarks.

How To: Find free audiobooks online and network a Mac and PC

In this episode, Brandon Jackson joins D.Lee Beard to present an in-depth review of the Slingbox A/V, explore where to find free downloadable audiobooks online, and to answer viewer questions on using an iMac as a display and how to share files over a local network between a Mac and a Windows PC . Be sure to check out our next video to learn how you can win the Techies' Slingbox and begin watching your home TV from all over the world via the internet.

How To: Defragment or format a Mac hard drive

In this episode of Ask the Techoes, D.Lee and Brandon answer viewer questions on how to defrag a Mac hard drive, erasing an NTFS hard drive on Mac OS 10.4, how to uninstall programs and their related files on a Mac, questions with Parallels, and how to create a wireless USB hub. Send us your questions at askthetechies@gmail.com Hosts: D.Lee Beard & Brandon Jackson http://AskTheTechies.com

How To: Use basic HTML with Notepad

This is an introduction to HTML using Notepad. While some prefer to use a WYSIWYG editor, HTML can be a great benefit if you want to modify your MySpace profile, embed video clips on your blog, etc. The second part of this video series expands on using HTML, introduces a WYSIWIG (What You See Is What You Get) editor into the mix, and gives a basic introduction to Microsoft Front Page.

How To: Use expressions in SSIS

Expressions are new in SSIS (meaning that they were not in DTS) but they allow you to create extremely flexible packages. Expressions can be used to assign values to variables, help you determine whether to execute a task, and to assign properties. If you ever found yourself writing ActiveX code (VBScript) in DTS to determine which task to execute based on a variable's value, then you probably can forego the scripting all together in favor of expressions! They are very powerful in SSIS and yo...

How To: Use SQL Server Enterprise

Watch this demonstration on Spotlight on SQL Server Enterprise by Quest Software. Spotlight on SQL Server Enterprise is a part of the Quest Management Suite for SQL Server as well as standalone offering. This demonstration shows the use of Spotlight on SQL Server Enterprise within the Management Suite

How To: Track database changes with Oracle

It has often been said that the only constant is change. IT's ability to manage change is an important business success criteria in today's competitive markets. Change can either be planned or unplanned. This presentation will help you understand the effects of change, and how to manage change properly. It will help Oracle database administrators better prepare to implement changes and measure the positive (or negative) affects those changes produce on the system.

How To: Optimize SQL performance

Gain insight into best practices for SQL Server optimization and ways to alleviate many root causes that can impact performance of your SQL Server database. Kevin also will discuss how to manage for planned and unplanned changes, speed time to implementation of your applications and ensure that your databases are running as they should.

How To: Create Internet usage rules on an ISA server

One of the uses of an ISA Server is to act as a proxy server. A proxy server allows your Windows XP and other desktop computers to make requests to the ISA Server and the ISA Server will then go and fetch the results from the internet or, if the ISA Server has cached the page(s), it can serve the pages from cache thus speeding up client browsing.

How To: Use an ISA server

So what exactly is ISA Server? ISA Server, which stands for Internet Security and Acceleration Server, is Microsoft's software-based firewall, proxy, and web caching service/product. Now what does all of that mean? This video helps explain it!

How To: Use JOIN vs. UNION in SQL

So many newbies to Transact-SQL have difficulties determing when to use a UNION or a JOIN to satisy their query. This video teaches you some guidelines to help you quickly and easily identify whether your query will likely need to become a JOIN or UNION. Disclaimer: these are just guidelines and they will not work in every situation but they are applicable for most SQL developers most of the time.