This application was developed for anyone who works with Microsoft SQL Server and is strictly for FUN!

Abstract:
Extracting the individual TSQL objects from a valid TSQL script, and assigning them musical notes. Then those notes are processed through a MIDI program to create a song.

Each of the 104 TSQL Objects have 2 notes assigned to them, a static note and one random note. The random note helps produce a melody along with the Time and Tempo. The larger the difference between the lower range and the upper range will increase the variety of possible sounds.

Acknowledgements:
The Midi code (Toub.Sound.Midi), used in this application was developed by Stephen Toub. All other code including the TSQL Parsing and handling was developed by Robert Vallee.



Download TSQL Music Generator - Requires Free Registration

Getting Started:

1. The TSQL Music Generator is divided into 3 parts, TSQL Objects you want to use, Time\Tempo, and Note Range\Key Signature.
2. TSQL Objects: There are 104 TSQL objects to choose from. By default all TSQL objects are checked and will be used in the music creation process. If you do not want to use a TSQL object, simply uncheck the checkbox next to the TSQL object on tab one. There are 8 TSQL objects that are defined as “Percussion” objects. Use the dropdown box next to each one to change the instrument.
3. Time\Tempo: You can change the default settings under the second tab, Time\Tempo. The default settings are 4\4 time. Tempo can be changed by using the slider. Tempo has 7 hard coded values in this application to keep it simple. Use the slider to change from slow to fast. To get a better understanding of “time signature”, I recommend http://www.dxarts.washington.edu/courses/490a/doc/dict/midi-time-signature-cls.html
4. Note Range\Key Signature: On the third tab you can change the Note Range and Key Signature. The larger the difference between the lower range and the upper range will increase the variety of possible sounds.
5. Primary instrument: At the top of the application, on the main menu bar, is the “Select an Instrument” dropdown box. From here you can change the primary instrument to be used in your music.

 Basic Music Creation:

1. Populate the main query window with any valid TSQL script.
2. Select the TSQL objects that will be used in the music. (tab: TSQL Objects) Assign what percussion instruments are to be used from the dropdown boxes.
3. Select the Time\Tempo to be used. (tab: Time\Tempo) Default is 4\4 time.
4. Select a Note range (between 3 – 126); the larger the difference between the lower range and the upper range will increase the variety of possible sounds. Then select the Key and either “Major or Minor”. (tab: Note Range\Key Signature)
5. Select a primary instrument.
6. Click the “Create Song” button.
7. The TSQL Music Generator will produce a simple Midi file. That file will show up in the “TSQL Music Library” window. If the window is not visible, go to the menus at the top of the application and select, “Tools\Show Music Library”
8. Double click on the file you want to play and your default music player will begin to play your song.