TiggTV Episode #2

[TJ_Tigger]

TiggTV Episode #2

Show Length 23:20

Objectives
- Review the SQL SELECT and INSERT statements
- Create a function that will read the database and display the information from the selected record
- Create a button to Clear the data entry fields
- Modify the Text on our Add Entry button to make it an Update Entry button

I appologize for the sound quality on this episode. I tried to make the sound consistant throughout the episode but there are a few spots where it is not even. Please bare with me while I work on bringing the shows into a consistant state.

I highly recommend that you watch the trainig videos provided by IndigoRose as they cover a lot of the basics that may not be covered in this series. I would also like to request that if you have ideas of a topic you would like to have covered please post them here or semd me an e-mail at tiggtv at gmail dot com.

Tigg

Disclaimer: I am not a professional coder nor am I a professional voice over artist. But I do enjoy coding and working with AMS and have a wee bit of experience in education and adult learning practices.

[GAV]

Excellent!!!

[Intrigued]

Ah, TJ, you updated?



Nice player skin ya?

[Animl]

You can try running the audio portion of the video as a .wav format through something like CoolEdit\Adobe Audition and set to "Normalize" the audio file to "absolute 0".

Note:
This process works off the peaks of the sound wave, so if there is a massive peak it may effect the volume of the rest of the file. All peaks will be within your setting.

I like to go to -1 or -2 for a head-room buffer. If you do this for all videos this will make the audio the same exact volume from file to file. Not sure what's avaiable to extract the audio from the video. Movie Maker or Premier?

BTW, thanks for providing the videos.

[eric_darling]

Tigg - your coding savvy is great to watch in action. Thanks for the free advice on SQL stuff - that's something with which I'm pretty unfamiliar.

[bule]

You can try running the audio portion of the video as a .wav format through something like CoolEdit\Adobe Audition and set to "Normalize" the audio file to "absolute 0".

I'd rather go with the hard limiting for that purpose... try it!

[TJ_Tigger]

Tigg - your coding savvy is great to watch in action. Thanks for the free advice on SQL stuff - that's something with which I'm pretty unfamiliar.

Thanks Eric. Reminds me of a scene from the Wizard of Oz. "Pay no attention to the man behind the curtain". I plan the code ahead of time, build and test the project and code so it looks and works the way I want. Then I open that project in the Code Viewer have it on the botton of the screen ready for cutting and pasting, and awayayay we go.

Tigg

[Animl]

I'd rather go with the hard limiting for that purpose... try it!

Not saying you're wrong, but ,..just another POV

Hard limiting will work, in a different way. Hard limiting crushes the peakes and leaves the rest as is. This MAY work for vox, but for music etc.. it will kill the dynamics. Normalizing is going to bring the total file volume up, or down to meet 0, not tampering with peaks at all. When hard limiting works it flattens the peak sound wave. So it can't get any louder, BUT it doesn't bring the quiet sound level up to a perfect level from file to file. If you are going to go Hard limiting you're better off using a compressor in this case at a 3:1 or 4:1 ratio, so that quiet sounds are now audible and loud peaks are compressed to meet that. In live speeches a common compression level is like 6:1 or 7:1 ratio.

Just FYI type stuff

[bule]

Thanks for the tip!

[Intrigued]

It may not just be normalizing but position of the microphone. As on a lot of them if you are just a few inches further or close the sound loudness can clarity can be greatly affected.

I've realized this when coding my own video training CDs in Camtasia Studio 3.

Just another angle to keep in mind for anyone recording audio. (including headsets)

ps. TJ, I liked your second video offering as well. It's neat to watch how you are refining your technique. I like to see that when folks (or myself) understand that point.