Problem: Oracle error maximum number of expressions in a list is 1000
Solution:

-- Instead of
select * from foo where id in (List)
-- use
select * from foo where id in (Sub-query)

link

From a business perspective:

– 1. Think Ahead and Anticipate
– 2. Say Something
– 3. Know the Law
– 4. Remember, You’re Not Alone
What to Do When Your Website Gets Hacked

From a technical perspective:

1. Check That It Has Actually Gone Down
2. Figure Out What Has Gone Down
3. How Bad Is It?
4. Check Your Web Server Software
5. Logging Into Your Server
6. Has It Run Out Of Space?
7. Has It Run Out Of Memory?
8. Has Something Crashed?
What To Do When Your Website Goes Down

And remember, don’t just stand there, reboot something 🙂

From a fun perspective:

Bonus: What Flickr did when their website went down:

AARRON WALTER: Designing for emotion
In July 2006, a storage failure struck Flickr, the popular photo sharing service. Though photos were safe and no data was lost, thousands of enthusiastic users were inconvenienced as
their favorite photo site took a temporary nap (roughly three hours). Tensions ran high as engineers worked to bring the site back online. Inquiries from concerned users poured in.
During the crisis, the Flickr team had a stroke of genius.
[..] They posted a message that explained the outage, asked users to print a page, and do something creative with it to win a free, one-year Flickr Pro account:

The websites below have something in common: they are all modern-looking and there is a lot of attention behind every page. Most important, they are designed for emotion.
Without any other presentation, here they are:

• 10. boagworld.com – for excellent use of Museo Sans font, for the free book and for the mobile version
• 9. carsonified.com & thinkvitamin.com & teamtreehouse.com/ – because they all love the web 🙂
• 8. paulirish.com – for the bubble comments similar to the ones on the iPhone messages and for the freespace he left us for playing. Also, for moving the web forward
• 7. apple.com – for the transition effect on the iPhone page and for keeping it simple
• 6. justcreativedesign.com – for the awesome logo
• 5. reederapp.com – for the great iphone/ipad/mac CSS3 animation effect and for the simplicity
• 4. ramotion.com – for the website, icons and the sky rocket to take the user back to top
• 3. owltastic.com – for the responsive design, nice fonts, icons and overall feel
• 2. webdesignerwall.com – for the nice, responsive website and the tutorials
• 1. smashingmagazine.com – for their new responsive website, because of the books they published and because I am following them since 2008 🙂

(more…)