Database

Using a Rank Over a Partition When Working with Transactional SQL Tables

You will often encounter a transactional table in a SQL database.  This is a table that typically is only inserted into.  A good example is a bank account ledger where every transaction you

  • Jonathan E. Ross
    Jonathan E. Ross
3 min read
Code

Find any Column in a SQL Server Database

Let's say we're working with a Microsoft SQL Server and we have no idea what table or column stores a particular value. Trying to find a database column where we know what the

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Poetry

The Worst Dairy Queen Blizzard Flavor

When I see Gumbo I cannot resist. Chicken, shrimp, sausage or even all of this. Make it spicy or make it sweet. But don’t you dare forget the meat! Now if you

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

10 Tricks to Appear Smart During Meetings

Like everyone, appearing smart in meetings is my top priority. Here are my ten favorite tricks to quickly appear smart during meetings. 1. Draw a Venn diagram Getting up and drawing a Venn

  • Jonathan E. Ross
    Jonathan E. Ross
3 min read
Funny

What She Said

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

Pterodactyl Bathroom Joke

Why can't you hear a Pterodactyl go to the bathroom? Because the P is silent.

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

The Cookie Fitness Program

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

Programming is Like Writing a Book

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Blog

Teamwork Makes The Dream Work

To me, this picture represents everything a good team is not. Notice how no one is rowing? This team is making no forward progress. When we're not working together, teams will sink just

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

GIT The Princess

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

A UNIX Christmas Song

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

Don't Hate PHP

I think the reason why people hate PHP is because its very versatile. You can write code any which way you want and it will work every time at least part of the

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

The Never Ending Curly Bracket War

Apparently some programmers get pretty pissed off about this. I say whatever makes your brackets curly, go with it. Just be consistent about it and don't go around changing someones code. Remember: Last

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

QA Engineers

QA Engineers are special people. They don't think how normal people think, let alone programmers.

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Videos

The Automatic Transmission

There are some pretty amazing inventions that have shaped our daily lives. One such invention is the automatic transmission. We've all got them in our cars, but just how do they work? I

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Linux

AWS CloudFront SSL Install

Using the Amazon CoudFront as a CDN is a great way to accelerate your website. If you run with HTTPS enabled, you will also want to reference the files you have hosted on

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Linux

Clearing UNC Hard Disk Errors

One of the advantages of running a Linux RAID configuration is that it simplifies clearing of UNC errors on your hard disks. If you have such a setup, you may follow the process

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Blog

How to Chop an Onion

Chopping an onion is not a difficult task in the kitchen, if you know the right way to do it. Watch this video where the master, Gordon Ramsay, shows us how it's done.

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

Infinite Ninja Battle

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

The Best Peter Griffin Fart Videos

Peter Timing his Farts to Thunder Storms Peter Craps his Pants Peter Hides his Farts

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Tech Guides

CUPS Command Reference

Show Printing System Status lpstat -t Show Queue Status lpq -Plaser101 Create a PostScript Laser Printer Queue lpadmin -p office-printer-1 -v lpd://office-printer-1/lp -m postscript.ppd.gz -E Create a JetDirect Socket

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Funny

CSS Jokes

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Blog

Drone Technology

The following information was gathered during the 2016 DetroitDevDay [http://detroitdevday.org/] Conference held at United Shore [https://www.unitedshore.com/] in Troy, MI on November 12, 2016. The speaker for this topic

  • Jonathan E. Ross
    Jonathan E. Ross
2 min read
Tech Guides

HP ProCurve CLI Reference

Configurations Show Running Configuration procurve1# write terminal Save Running Config to Startup Config procurve1# write memory Show Mac-Address, Port, and VLAN procurve1(config)# show mac-address Show Port Descriptions procurve1# show name Show Port

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
Tech Guides

Ubiquiti EdgeSwitch CLI Reference

Configurations Show Running Configuration (ubnt1)# show running-config Show Saved Configuration (ubnt1)# show startup-config Save Running Config to Startup Config (ubnt1) # write memory VLANs Create a VLAN (ubnt1) # vlan database (ubnt1) (Vlan)# vlan 10

  • Jonathan E. Ross
    Jonathan E. Ross
1 min read
© 2023
Latest Posts Ghost