Database Driver’s License

thatjeffsmith Database Stuff 4 Comments

Do you just hand your keys to whoever wants access to your car or your house? Why do so with your database? Just because someone wants to look at ‘your’ data, doesn’t mean you have to let them in without asking a few questions, right? While the person won’t be driving your car, they’ll be driving data in your database. …

Things to Keep in Mind for PASS 2013, Charlotte NC

thatjeffsmith General 5 Comments

So the news is out, Charlotte NC is a destination city! image courtesy Wikipedia 2012 Democratic Presidential Convention 2013 PASS Summit Already folks are wondering, hey, where is Charlotte? And, can I get good sushi there? Charlotte is a city I visit frequently. Here are a few things I’ve picked up along the way: It’s the ‘Queen City‘ – but …

Are You Illiterate?

thatjeffsmith Database Stuff 6 Comments

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 the business bus go round-and-round. …

Killing in the Name

thatjeffsmith Database Stuff 3 Comments

Do you take pleasure in killing peo…people’s sessions in the database? If so, you are not alone. If you have Blocking Locks, the easiest way to fix that is kill the offending session and free up the requested resource. But, who should win this battle? What transactions take precedence? Should the business analyst have his report kiboshed because a developer …

SQL_IDs, Plans, and Baselines, Oh My!

thatjeffsmith Database Stuff 1 Comment

Do you run a 3rd party application that uses Oracle RDBMS under-the-hood? Do you experience performance issues? Frustrated that you do not own the application SQL that is causing the issues? Maybe an upcoming upgrade to 11g might give you some relief. Many of the customers I speak with are unaware of a new 11g feature called ‘SQL Plan Management’ …

Is Your Query Running?

thatjeffsmith Database Stuff 4 Comments

You better run and catch it then! You know you’re getting old when the new crop of kids don’t get this joke, or even worse, don’t understand what a prank phone call is. I’m pretty sure that folks still get phone calls from frustrated people who want to know how much time is left before their query will finish executing. …

Partitioning and DBMS_REDEFINITION

thatjeffsmith Database Stuff 1 Comment

Unscientific research and Twitter gossip reveals that fewer than 15% of folks out there take advantage of Oracle’s partitioning (Oracle Docs) support for tables and indexes. Folks that build their own solutions in-house are more likely to discover and use partitioning. If you use a packaged 3rd-party database solution and it uses partitioning, then I would love to hear about …

Access of Evil

thatjeffsmith Database Stuff 3 Comments

A play on words – the Axis of Evil, three countries that foster or promote terrorism. This is not a history lesson or political discussion, go here for that. So what is the Access of Evil? I would propose that the following practices conspire to bring down any well-ordered collection of data: MS Access MS Excel SELECT *. So do …