In a movie filled with some truly great moments, this inane exchange between Halloran and Larry might be where you can see/hear Kubrick in The Shining most clearly. Plus, the office details remind me of the Console Living Room exhibit here at UMW.
Watch the bava blog trailer!
about
is an ongoing conversation about media of all kinds ...
Testimonials:
Generations from now, they won't call it the Internet anymore. They'll just say, "I logged on to the Jim Groom this morning.
-Joe McMahon
Everything Jim Groom touches is gold. He's like King Midas, but with the Internet.
-Serena Epstein
My understanding is that an essential requirement of the internet is to do whatever Jim Groom asks of you while you're online.
-James D. Calder
@jimgroom is the Billy Martin of edtech.
-Luke Waltzer
My 3yr old son is VERY intrigued by @jimgroom's avatar. "Is he a superhero?" "Well, yes, son, to many he is."
-Clint Lalonde
Jim Groom is a fiery man.
-Antonella Dalla Torre
“Reverend” Jim “The Bava” Groom, alias “Snake Pliskin” is a charlatan and a fraud, a self-confessed “used car salesman” clawing his way into the glamour of the education technology keynote circuit via the efforts of his oppressed minions at the University of Mary Washington’s DTLT and beyond. The monster behind educational time-sink ds106 and still recovering from his bid for hipster stardom with “Edupunk”, Jim spends his days using his dwindling credibility to sell cheap webhosting to gullible undergraduates and getting banned from YouTube for gross piracy.
I am Jim Groom
Find out more about me here.
Recent comments
- Reverend on Punk’s Not Dead
- Reverend on Punk’s Not Dead
- Martin Weller on Punk’s Not Dead
- Maren Deepwell on Punk’s Not Dead
- Jim Groom on Punk’s Not Dead
- Jim Groom on Punk’s Not Dead
- Scott Leslie on Punk’s Not Dead
- Alan Levine on Punk’s Not Dead
- Jim Groom on You’re definitely Dr Detroit …
- Jim Groom on Atari 2600 Game Cartridge Display Stand
- Jim Groom on Conference, Camera, ILTA!
- Jim Groom on Conference, Camera, ILTA!
- Tom on Conference, Camera, ILTA!
- Zach Davis on Atari 2600 Game Cartridge Display Stand
- GNA Garcia on You’re definitely Dr Detroit …
-
Recent Posts
- Punk’s Not Dead
- Unscripted Futures
- Conference, Camera, ILTA!
- You’re definitely Dr Detroit …
- The Reclaim Student Showcase Returns for 2026
- Domain of One’s Own Version 2
- Heigh Ho, Heigh Ho, It’s Off to ILTA’s EdTech 26 We Go
- Atari 2600 Game Cartridge Display Stand
- Building a Blog You Can Walk Into
- Deferred Maintenance: Upgrading Mastodon and PeerTube
browse the bavarchive
Contributors
some favorites
- Alan Levine
- Andy Rush
- Audrey Watters
- bava.social
- Bonnie Stewart
- Brian Lamb
- Bryan Alexander
- Chris Lott
- Clint LaLonde
- Cole Camplese
- Darcy Norman
- David Kernohan
- David Wiley
- Gardner Campbell
- GNA Garcia
- Grant Potter
- Jeffrey Keefer
- Jon Beasley-Murray
- Jon Udell
- Kate Bowles
- Kin Lane
- Laura Blankenship
- Leslie Madsen-Brooks
- Lisa M Lane
- Martha Burtis
- Martin Hawksey
- Martin Weller
- Mike Caulfield
- Mikhail Gershovich
- Mountebank
- Paul Bond
- Scott Leslie
- Serena Epstein
- Shannon Hauser
- Stephen Downes
- The OLDaily
- Tim Owens
- Tom Woodward
- Tony Hirst






















Server Admin Tips: SQL Command for Mass Deletion of Moderated Comments in WordPress
Tim Owens and I hung out in a coffee shop for a couple of hours before our afternoon visit with the folks at Georgetown’s CNDLS about UMW Domains (more on that in my next post). We were doing some maintenance work on UWM Domains server, and I am trying to learn as much from Tim as I can about server stuff. So, he gave me a pro-tip about the best way to delete large numbers (thousands) of moderated comments in WordPress other than point and click.
With comments marked as spam you can empty the folder (though if there are too many this might be less of load on the server), but there is no easy way to get rid of moderated comments that are spam. And if you get 10,000+, this could take hours to delete manually. Below is a quick trick using an SQL command in phpMyAdmin.
Here’s how:
Make sure you know the proper database for your WordPress blog if you have several installed. You can find this in databases or the wp-config file in the blog directory (use File Manager for this). Once you know the proper database, click on phpMyAdmin in the CPanel dashboard.

From there, find the database of the site that has all the moderated spam.

After that, look for the wp_comments table in the database, and click on that table.
You should now be in the wp_comments table. From there, click on the SQL tab.
You can now add the SQL command
DELETE FROM 'wp_comments' WHERE 'comment_approved' = 0You’ll get a dialog box confirming the command.
After that, you should have gotten rid of every commented that has not been approved.
This was a huge time saver yesterday, and I am logging it here because I don’t want to forget this trick. Although, as Jason Parkhill noted on Twitter, when it’s WordPress, there is always a plugin for that 😉