Oracle: Disable ArchiveLog Mode

Sometimes it is unnecessary to use ArchiveLog mode with the Oracle database. If you do not know what ArchiveLog Mode is – here is a short statement: “Any Oracle database that contains important data should be running in ARCHIVELOG mode. Running in Archive log mode enables you to take hot backups and perform point-in-time recovery.” […]

Read More

How to drop multiple tables in MySQL


February 9, 2011


No Comment

If you want to drop multiple tables in MySQL (current version 5.05 or before) you will find no command for that. But there is a simple way using some console commands, just hit your shell and simply paste this snippet: [crayon-5c9988486a961708598032/] Do not forget to replace [USER], [PASSWORD] and [DATABASE] with your settings. As always […]

Read More

ISPConfig3: Mail aliases for login to Dovecot

If you knew ISPConfig2 you probably remember the user login approach which was done there: [crayon-5c9988486be2f356071724/] Now with ISPConfig3 this has changed to the better by using the users email address – sounds cool – it is! But what about migration from ispconfig 2 to ispconfig 3 – you do not want to drive around […]

Read More

Mac OS X: Ever wanted to integrate your Macs in a Active Directory environment with Two-factor authentication (Part 1)?

Simple AD Integration using knowledge as authentication key, is for some data to protect not enough. So if you want to raise the bar you add ownership (Smartcard, USB Dongle, e.g.) to the knowledge only authentication system. So first stone on your way if you use Snow Leopard, you have to be aware that the […]

Read More

SEO: Blackhat Tactics – Part 1

During working on a customer SEO project I just came across a competitor which is massively using black hat SEO tactics. Ethically now the question pops up, if the right approach is to respond by using the same or even better tactics. So here are some interesting reads on how to approach this situation. Black […]

Read More

iPhone OS: Enterprise Business Tools

If you need to manage iPhones or iPads in a big enterprise business, your should read Apples Support Documents: and in any case download the iPhone Configuration Tools for Mac OS X: and for Windows: You can then setup configuration profiles, that reflect the setup of your environment: • Passcode-Richtlinien • Funktions-Einschränkungen […]

Read More

iPhone OS: Design a nice InApp Purchase View

To get up a nice InAppPurchase View for Apple’s AppStore, we first need some good looking buttons: There are also some tweaks for the UITableView you might consider using: more information upcoming…

Read More

iPhone OS: Setup an additional Security Layer

As you might already know the iPhone is itself not that secure that people might think (news is german): How do you prevent intrusion of your customers data? As a really pragmatic approach, we can just set up additional encryption for our application data: So if you use for example core […]

Read More

iPhone OS: ffmpeg for the iphone – Part 1

I am just checking if it is possible to get WMV9 support for one of my applications on the iphone using ffmpeg. The good point a lot of people tried to get these working, but actually none covered if his application was approved for the AppStore. Due to Apples guidelines there might be some problems […]

Read More

Terminal: Search and Replace text in all files in a folder and its subfolders

I just stumbled across a neat idea using perl to replace the content in files To replace all occurances of a string: find ./ -name “*.txt” | xargs perl -pi -e ‘s/stringtoreplace/replacementstring/g’ for every of these examples you can also use sed find ./ -name “*.txt” | xargs sed -i ‘s/stringtoreplace/replacementstring/’ or rpl rpl stringtoreplace […]

Read More