Some folks find this hard to read
SELECT a,
b,
c,
d,
e
FROM table;
If your computed column code or column names are very long, they’ll often trail off the edge of the [...]
|
||||||
  |
I was perusing the SQL Developer Feature Requests Exchange and was not surprised to see this – a request to have the Query Builder disabled. My favorite (and most predictable) comment among the voters for this request is something along the lines of ‘feature totally useless for us professionals’ Let’s explore that for a second. First [...] How much time to do you spend debugging database application problems? Probably more time than you want. How much of that time is spent capturing the SQL that is being submitted by your application to the database? I’m going to guess that it’s a significant amount. Asssuming you have access to production (or a test [...] Oracle 11gR1 Enterprise Edition with the Diagnostic and Tuning packs has a very compelling new feature, Real-Time SQL Monitoring. Oracle thinks enough of the feature that it was highlighted prominently in whitepaper by ACE Directory Arup Nanda titled “Oracle Database 11g: The Top Features for DBAs and Developers” (read it here) Long story short: Too late [...]
License and registration please. Did you realize how many tables you had locked back there? 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 [...]
The 1980's called, they want their technology back! Disclaimer: I work for Oracle now. This post pretty much pertains to any and all database IDE and GUIs. –Thanks, Jeff 1/25/2012 Let’s get this out of the way, because anyone who knows me, knows that I have a HUGE bias in this argument: I work for Quest [...] So the news is out, Charlotte NC is a destination city! image courtesy Wikipedia 2012 Democratic Presidential Convention 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 so [...] 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 [...] 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 [...] Database developers and DBAs often play the role of gunslinger, or a hired gunman. Someone brought in to ‘kill’ the bad guy, in this case, an under-performing database. Our tools of the trade are not as dramatic as firearms, but we can do just as much damage. Every heard of Angry Birds? In this mobile game, [...]  |
|
||||
|
Copyright © 2012 That Jeff Smith - All Rights Reserved 
This site has been fine-tuned by 3 WordPress Tweaks
|
||||||
Twitter
RSS
GooglePlus
Popular Posts