Top.Mail.Ru
? ?
jfroebe, posts by tag: sql - LiveJournal
Me :)
 
Profile
Image
User: Imagejfroebe
Name: Jason L. Froebe
Page Summary
Latest Month
December 2013
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Links
Search
Entry Tags
ראש השנה, .net, 2006, 2006 bookcrossing convention, 2007, 2008, 3 day, 3 day 60 miles, 3 day walk, 3day, 50/50 debate, 60 miles, Gert Fröbe, abuse, activestate, ada, addict, adolf hitler, advent calendar, aerial drones, air force one, airlines, airport, alan cox, albert einstein, alerts, alien life, alien vs. predator, alzheimers, american airlines, amiga, amiga 3000, amish, ando momofuku, andy borowitz, anime, ann coulter, anti semitiism, anti spyware, anti-war, apache, api, apple, argonaut, army, art, art festival, ase, asiq, assholes, astronomy, attachments, audrey hollinger, author, award, awesomeaud, azureus, baby, baby gifts, baby shower, bad drivers, bad joke, bally total fitness, bank of america, battery, bbc, bbc america, bbq, bbq sauce, bears, beauty, becca, becca is yummy, beer, beet juice, best buy, betrayed, bible, big tattas, bigotry, birthday, bisman, bismarck, bk, blackmail, blind, blog, blood, board of directors, body suit, bond girls, book, bookaday, bookcrossing, bookcrossing chicago meetup, bookczuk, books, boots, boxers, breast cancer, breast cancer 3day, brother in law, brutality, bug, bush, busy people, butt, buttons, buy, buying, c, c program, c#, c++, caffeine, cake, calendar, camera phone, cameras, camp okutta, canada, canberra, cancer, canon, car, caribou coffee, cartoons, cartwheels, casanova, cat, catnip, cell phone, centipede, centos, cgi, chain letter, challah, channukah, chapter 11 bankruptcy, charger, charity, chat, chernobyl, chicago, child army, children, choose your own adventure, christianity, christmas, circuit city, class, closed captioning, cloves, cnn, coffee, comedy, comics, commodore, common sense, compusa, computer, computer chronicles, computers, concentration camps, conference, contest, contraceptives, convention, conventions, conversion, cops, corporate overlords, coupons, course d&d, cpan, cr 406473, crack whore zombies, crappy support, crayons, crazy people, creation science, creationism, crochet, crocodile hunter, crt, cube life, cubicle, cult, customer service, cygwin, dad, dadlabs, dancing, databases, db artisan, db2, dbd, dbd::sybase, dbi, dbms, death, debate, deception, defrag, democracy, democracy player, denmark, destruction, development, digg, diner, directio, disassembly, discworld, dispatch tables, distant cousin, distortion, distribution, do not fly list, doctor who, donuts, doom, dos 5, dove, downs syndrome, dr who, dragonmount, drawing, dream, dreamsweaver, driver, driver's education, drivers, driving test, drywall, dss, duke nukem forever, dune, dungeons & dragons, dutch, eclipse, edgewater apartments, eff, election, elephant, email, embroidery, encryption, engineering, engineers, epic plugin, erik-jan hanussen, eugenics, evil, evolution, ewoks, ewr, expectant mother, extremism, führer, faa, faith healing, family, fascism, fascist, fashion, favorites, fcc, felony, felted, ferrari, festival, fiancee, fiddler, filipino men, firefly, firefox, first attempt, flickr, floss, flourish, flu, flu shot, flying spaghetti monster, fm transmitter, food, fool, forensic analysis, foundation, fps, fraud, freddie mercury, free software, free speech, freedom to read, french maid tv, froebe, froebe fibers, froebe.net, froebel, frog pond, fry's, fud, fun, funny, gadgets, game, games, gandalf, gardening, geek, geek spotlight, geek women, geeks, geneva convention, genius, gentoo, george w. bush, gert froebe, gestapo, ghost hunters, gift, girl, girls, girlz, global warming, gloucester, god of war, google, grandma, graphic novel, graphic novels, greek, groceries, guinness, gym, hack, hackathon, hand dyed yarn, hanukkah, health, hebrew, helix, heng, heroism, hi def, hi def television, hiding, hitler, hole, holiday, holocaust, holocaust survivor, home, homeland security, honeymoon, hope, hot stuff, house, houston, howto, hubby, humor, husbands, i smell a law suit, ibm, id3v1, id3v2, ideas, idiot, idiot administrators, ie, ikea, illegal, illinois, im, in-laws, indiana, insect, international sybase users group, internet archive, invention, ipod, iq, irack, iran, iraq, iron chef, iron science teacher, islam, israel, israeli, isug, itunes, jack thompson, james bond, jedi, jesus, jewish, jews, jews for jesus, job, jogging, john allemang, joke, joliet, jouko ahola, judaism, k2p2.net, karaoke, kari, kate, kde, kernel, kick ass wife, kidnapped, kitty, kmail, knitting, konqueror, kopete, korean, labels, lady, laptop, las vegas, lasagna, laughing my boots off, lax, lebanon, leonard nimoy, liar, life, light, linux, linux::inotify2, lions, little m, little munchkin, livejournal, lmao, locales, locked out, logs, lombard, lost aussie, lost luggage, lynne's scifi news, lyrics, m4b, mac, maildir, mainframe, make, mandan, manga, mars, mason, mass murder, massacre, mbox, me, meetup, mel gibson, melissa, meme, memory, men, messiah, michigan, microsoft, microsoft access, miles, military, mime, mindmap, miriam, miriam nicole froebe, mod_perl, mom, money, monitor, monitoring, monty python, morgan webb, mother's day, mouse, movable type, movie, movie trailer, movies, moving, mp3, mp3 player, mpaa, ms. kitka, msdn, munchkin, muppets, music, muslims, my god i am tired, mystery, mythbusters, na 2006 convention, na convention, naming scheme, nate, navy, nazi, nerd test, nerds, network, neumann homes, new born, new born baby, new house, new jersey, new orleans, new york times, newborn, news, nicola worthington, no child left behind, north american convention, north dakota, not a religion, o_async, o_direct, o_directio, oh crap, oh my!, ohare, oklahoma, olbermann, olympics, omg, ooo writer, oops, open office, open source, oracle, osx, outrage, outsourcing, overtime, owner operator, p&t, p2p, packing, pancakes, parody, parsing, pat robertson, pattern swapping, paul harvey, peace, performance, perl, perl foundation, perlmongers, perlmonks, pete, photos, pickle, pie, pilots, piracy, planet nerd, playing, playstation, pledge, podcast, podcasts, poe, poe::wheel:run, police, policy, polishing, poof, poor customer service, pos, potato, ppm, president, president da, president dumb ass, president dumb-ass, prime rib, princess bride, printer, printers, privacy, proactive dba, professor, programming, project, projects, prophecy, protest, proud, ps/2, puppet, putty, quantas, queen, questions, quilt, rabbits of doom, racism, racist, radio, radio shack, ramen king, ramen noodles, reading, realaudio, realistic, rebecca, religion, religious right, replication, rest, revelry, review, rfid, riaa, rights, roar, rob verschoor, robert jordan, robots, roman catholic church, romania, rosh hashanah, royally pissed off, rumpole, rumsfeld, run, satellite, satire, saving, scam, scarf, scarf of doom, scheduler, school, school system, science, scientist, scientology, scifi, scifi channel, sco, scooter, sdk, security tab, semi, serenity, series, services, she would kill me, shells, shoes, shooting, short story, show, shrimp boil, sick, simpsons, sims 2, singing, sith lord, six apart, skokie, skyring, slashdot, slashdot mythbusters, slaves, sleepless in seattle, smell, snafu, snake oil, snb, socks, soldiers, song of the day, sonic, sony play, sony playstation 3, spam, spamcop, spiderman, spinoff, spock, spray paint, spy, spybot, spyware, sql, sql anywhere, sql server, sqlserver, sqsh, squirrels, star trek, star wars, starbucks, starwars, steve balmer, steve irwin, steve jobs, stoler, store, stored procedure, story, strategy, strawberries, students, studying, stumped, stupid, stupid parent, stupid people, stupid politicians, stupidity, sub-human slime, subversion, super suit, survivor, susan g. komen, suspenders, swmbo, sybase, sybase techwave, sybase workspace, sybase-dba, sybase-dba-moderated, sybase::repagent, sybase::tdsserver, tagging, taylor mali, teachers, teasing, techdoc 1040311, techie, technical support, techsupport, techwave, ted talks, teething, terry pratchett, testing, the becca takes over the world, the challenge of poseidon, the incredibles, the walk, the world, thief, thinking, thong, three dead trolls in a baggie, tickle, tim roth, tim tam slam, tim tams!, tinley park, tips, tonks, top 10, tor, tor publishing, torah, torchwood, toronto, toshiba, trademark, trailer, training, translation, travel, troops, truck driver, trucker, truckers, tutorial, tv, tyrant, tzurriz, tzurriz dream, tzurriz the yummy, u.s. postal inspection service, u.s. president, ubuntu, ucla, uk, united states, unix, update, upgrade, us embassy, us government, us mail, us-cert, usa, uwtv, va, vampires, verizon, vi, via ljapp, vidcast, video, video podcast, videocast, videos, vim, vinyl siding, violent crime, virgin, virginia tech, virtual audio, virtualdub, vista, vista business, visual studio, visually impaired, vmware, voodoo kitty, voyeur, vpn, vulnerabilities, wabbits, walk, war, war monger, warp speed, warren dunford, water, webbalert, webnation, wedding, welcome reception, werner herzog, wfh, wheel, wheel of time, wheelchair, white hat, white trash, whitesands, whore, wife, wifi, wild times, win98, windows, windows 7, windows 98, windows media format sdk, winxp, wireless, wives, women, woot, wordmark, work, working, workspace, world domination, wot, writing, wtf, xp, yahoo, yahoo!, yarn, yossi vardi, youtube, zishe breitbart, zombies
30th-Aug-2007 03:36 pm - Tying it all together: Extracting SQL Batches, Highlighting Code with Kate, and Sending an email
blue man
Imagejfroebe

In How to read batches of SQL from a file in Perl, we learned how to read a SQL file and extract individual batches and created the Perl module dbS::Sybase::Parse::SQL_File. In How to colorize your code using Perl and Syntax::Highlight::Engine::Kate, we learned how to make HTML highlighted arbitrary code and created Perl module dbS::misc. Finally, in Sending email with attachments from Perl - the easy way, we learned how to send email with attachments and created Perl module dbS::EMail.

Now, we are going to tie them all together so we can send ourselves colorized SQL code and a screenshot of an application going screwy!

27th-Aug-2007 04:09 pm - How to read T-SQL batches from a text file using Perl
blue man
Imagejfroebe
It is often so easy to just call isql from within your Perl script, but do you really want to depend on Sybase's / Microsoft's isql program for *YOUR* application? Just read the file in your Perl app yourself and avoid isql. Handle the errors in whatever way you want.

Read more...
9th-May-2006 06:15 pm - Reduced a query from 80 seconds to 2 seconds!
blue man
Imagejfroebe
The original developers of the stored procedure had some wonky ideas of optimization.  There were two queries within the stored procedure I had to rewrite.

I can't provide the actual code but it went something like this:
( queriesCollapse )

Life is good :)
This page was loaded Feb 27th 2026, 2:57 pm GMT.
Image