ThatJeffSmith

Tag: oracle

Trailing or Leading Commas?

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

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

Toad for Oracle Tip: Custom Queries

There are SO many little nuggets in Toad that you can take advantage of. To list all of them would be a daunting task. Here’s one that you may have overlooked, Custom Queries. If you right-mouse-click on an object in the Schema Browser, you’ll see a list of operations you can perform. Take a second […]

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

Enterprise Doesn’t Mean What You Think It Does

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 lead. Standard VS Enterprise VS […]

Replaying Activity in SQL Server

Load testing is an interesting topic. Application load testing is what most people are familiar with. They either use something like LoadRunner, or they ask half the company to ‘jump on the website and start clicking buttons.’ But what about the database? In this case, what about SQL Server? Will it be able to sustain […]

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

My goto Oracle Resources

Someone suggested I document where, who, and what I use to get things done in my day-to-day dealings with all things Oracle RDBMS. Since I am very open to suggestion, here it is: Official Stuff Unofficial Stuff Twitter Folks Updated Dec 14, 2014 Oracle Docs Official Link Oracle’s official online documentation. I generally just ‘Google’ […]

Oracle Vs SQL Server

Disclaimer and Update: I now work FOR Oracle. So keep that in mind when you read these posts. Of course I wrote them BEFORE I started at Oracle, but I still figure you ought to know that…does that mean I think that Oracle wins the debate now? I’ll let you guess how that works I’ve […]

Oracle Open World Brain Dump

So this was my 3rd Oracle Open World, and not much has changed in terms of my experience as a ‘booth boy’ in the Vendor Exhibition Hall. However a few things definitely got my attention. I will need to re-evaluate how I treat the opportunity to attend this conference going forward. I should get registered […]

SQL Saturday for an Oracle Guy

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

My Toad Bible

Ok, I admit, I threw that title up because I wanted to draw attention to my site, guilty-as-charged. However, this is pretty close to being my ‘Toad Bible‘, i.e. my authoritative take on Toad. I reckon it’s my job to educate the market on all things Toad, so that’s where the authoritative piece comes in. […]

Password Expiration and Profiles

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

Quest Backup Reporter for Oracle

Quest just released a new tool into the wild. DBAs and systems administrators can now get a better handle on the state of their Oracle backups with a very light-weigh easy to install tool called Quest Backup Reporter for Oracle. You can read a complete overview of the product here, but here are the basics: […]

DBAs Versus Developers

On Thursday, September 30, 10:30AM EST, Bert Scalzo and I will be doing a Quest sponsored Webcast – “DBAs Versus Developers.” Sign Up/Register for the Webcast That sounds awfully contentious, Jeff! When visiting customers I am often talking to a group of developers in the morning and DBAs in the afternoon. In the morning, I […]