Farming out your application to a hosting service really has a lot of appeal. Let someone else worry about backups, performance and uptime Service Level Agreements (SLAs), upgrades, etc. But do you really know exactly what your hosting agreement includes? What you will have access to? What is and is not covered? Picture courtesy Public [...]
database
Foreign Keys, a Foreign Concept?
Relational databases are powerful for many reasons, but you cannot deny the ‘relational’ part is pretty compelling. Rows or ‘tuples’ in a table are comprised of related data. So for one row in an Employee table, you can assume that each value or column pertains to that particular Employee. Of course you can’t – or [...]
Is it Possible to Learn without Doing?
No. For several years now I have been an Oracle database dude who eavesdropped on the SQL community. I hoped to pick up the lingo and become savvy enough that I could say “Yes, I do SQL Server.” If I’m being honest, then I must admit I have largely failed. Yes, I understand what people [...]
Oracle vs SQL Server, Take II
Missed PT I?: Read Part I my favorite aspects of each RDBMS platform Update: Read PT III where I talk about monitoring indexes I had the pleasure of hanging out with @oraclenerd and @SQLChicken earlier this year in Tampa, FL. It was remarkable for a couple of reasons, but what I remember most is playing [...]
Date Night
For most couples, ‘date night’ is something to look forward to, but unfortunately does not come around often enough. For others, even the word ‘date’ sends a chill down their spine. It’s not an adverse reaction to their partner, but rather a unpleasant reminder to the daily toil that is working with DATE formatted data [...]
Twitter
RSS
GooglePlus
Facebook