ThatJeffSmith

Tag: database

What Databases Should You Back Up?

Some of my earliest memories involve trips to the dentist when I was maybe 3 or 4 years old. To this day, my blood pressure rises whenever I go in for a simple cleaning. There’s a particular poster I can’t seem to get out of my head, like a bad 80’s song. The intent was […]

Similar Posts by Subject Areas: , ,

Toad Jobs

A lot of good news this week about jobs here in the United States and a bunch of new hires for the month of April has many people feeling much better about the US economy. After being hammered with depressing reports for the past two years, it’s very nice to see the pendulum swing in […]

Similar Posts by Subject Areas: , , , ,

Are You Illiterate?

I know you can read, you’re here. But maybe you’re a functioning illiterate. Here’s what I mean. You spend a lot of time in the database writing queries, analyzing data, doing important stuff. Most of the time, things go great for you. You can answer questions for people. You make things happen. The wheels of […]

Similar Posts by Subject Areas: , , , ,

Hosting Shouldn’t Be A Grey Area

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 […]

Similar Posts by Subject Areas:

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 […]

Similar Posts by Subject Areas: , ,

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 […]

Similar Posts by Subject Areas: , ,

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 […]

Similar Posts by Subject Areas: , , , , , ,

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 […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , , , ,