Common Sense Relational and Development Patterns : RDBMS_Best_Practices Great Articles on SQL Magazine Talk: SQL Magazine Best Practices Part One SQL Magazine Best Practices Part Two RBAR – If you are a relational database professional, you know RBAR ( Row By Agonizing Row ) is …
LAMP Stack Setup on El Capitan
Very Good article on Setting up LAMP Stack on El Capitan: http://coolestguidesontheplanet.com/get-apache-mysql-php-and-phpmyadmin-working-on-osx-10-11-el-capitan/ On OS X Yosemite/El Capitan to start/stop/restart MySQL post 5.7 from the command line: sudo launchctl load -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
Multi-Tenant Configurations
Multi-Tenant Configurations: I have worked at multi-tenant environment and some of the things worked well in supporting multi tenant environment are listed here. These are based on my personal experiences. I have seen close to flawless design and execution as well as pretty bad design and …
Configurations : Web Config or Database?
Configurations : Web Config or Database? Web Config: Database Connection Strings. OfCourse. You can’t connect without that details. Changes you want trigger Application Pool refresh. Things need to be available when the database is unavailable. (such as a list of email addresses and an smtp …