For me, it’s leading. If I have a code or syntax problem, I find it easier to see the line missing the comma if I can look at the first char position. Of course you may say that’s crazy, and any reasonable programmer would demand trailing commas. I’m guessing your IDE offers formatting options that allow you to choose what works best for you. A few minutes investing these could save you hours of searching…
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 are talking about, I can read the blogs and get what they are saying. But as Robert Heinlein coined in…
Disclaimer: I wrote this before I started working at Oracle. I still believe what I wrote more than 10 years ago, how trippy is that? One of the most dangerous phrases to be uttered in an organization is ‘Oh, we have an Enterprise license.’ Once that gets out, everyone will think they can deploy/use as much as product X as they want. It does not take much of an imagination to realize where this can…
I love books. I remember when my local school system had a partnership (evil plan) with Pizza Hut. For every six books I read, I earned a free personal pizza. I was reading upwards of 10-20 books a month when I was in elementary school. This may have been partly due to me living in a rural area with no local kids my age to play with, but I’ll pretend it was because I was…
A better title might be ‘Tools are Too Cool for School’ or ‘If you don’t use Tools You are Dumber Than a Caveman’ or…well, you get the idea I think. My focus of course falls squarely in the IT and RDBMS domain. It is also not a huge secret that I spend a lot of time advocating a specific database tool for a little independent software company. I want to take a step back this…
Many moons ago, this was a pretty straightforward question. It also had a very easy answer, the DBA owned performance. By that I mean if the database or it’s applications did not perform as expected, it was the DBA who would step in and fix it. Several years ago this began to change. More and more shops started to expect the developers to have more than a passing awareness that their applications relied on a…
Twitter came through for me in a big way again today. I’m constantly being asked why I do ‘the Twitter’, and this experience sums it up nicely. Updated 10-05-2010 First things first. # – denotes a hashtag, useful for finding/categorizing posts on Twitter FTW – acronym for ‘For the Win’, geeky way of saying ‘Woohoo!’ I am an idiot. I recently bought a wiring harness for my car stereo, this was going to let me…
I am continuously chiding my customers to upgrade their software, particularly the software they bought from Quest. Why? Well, for starters it’s in my financial best interest to do so. But, I have no problems sleeping at night because it’s also in their best interest. Why? Companies spend a lot of money on software maintenance renewals. Anywhere from 10-25% of the list price every year goes to this. Software companies love that revenue stream. It’s…
I recently had the opportunity to attend a SQL Saturday event, #46 in Raleigh, NC. Techie Training, on a Saturday. Really? Yes, really. And I had some reservations before attending. However the fact that this event was free, minus $10 for breakfast/lunch, and the entire #SQL universe on Twitter has had nothing but good things to say about the event convinced me to give it a shot. Why does an Oracle guy care about SQL…
Don’t you just love managing your 3,247 accounts and passwords in cyberspace? Imagine being a DBA who manages several hundred databases and requires a password for each of those. And of course said passwords expire after X days, right? Password rules, which cover things like limit of failed login attempts password lifetime reuse max password expiration grace time are defined by Profiles. You can view profile information by querying SYS.DBA_PROFILES. I was approached for help…