ThatJeffSmith

Tag: oracle

Toad 11 Sneak Peek Part Deux

I had some time to beta test this morning, and I thought I would share some of the new tweeks and features that will be available in version 11.0 of Toad for Oracle. I spent some time previously showing off a new feature for you PL/SQL geeks out there, Code Analysis. If you are a […]

Similar Posts by Subject Areas: , , , , ,

Database Driver’s License

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

Similar Posts by Subject Areas: , ,

BEFORE SELECT TRIGGERS

After a year of blogging and living out loud on Twitter, I have started to build a nice network and community. One of the people in my new network is Martin Berger (blog | Twitter). Earlier this week, Martin responded to my Toad Challenge with a question about ‘Before Select Triggers’ (conversation) So let’s get […]

Similar Posts by Subject Areas: ,

I Just Wanna Connect to Oracle!

I have had quite a few SQL Server folks tell me their first experience with Oracle (database) was a very bad one. It’s easy to understand why. Microsoft makes it very easy to connect to SQL Server from a Windows OS. If you have installed SQL Server on your machine, you also get a very […]

Similar Posts by Subject Areas: , ,

ORA-03113: end-of-file on communication channel

Don't ignore the warning signs. This crash was completely avoidable.

My database crashed today. My ‘production’ database that is. The one I rely on for product demonstrations, that thing I do that Quest gives me money for. Pretty funny considering in the last few weeks my blogs have included such gems as: Are You a Real DBA – I argue that you are indeed NOT […]

Similar Posts by Subject Areas: , ,

Oracle Quick Hit: You Can Bypass TNSNames

Ever spin up a database for some quick and dirty work, and you JUST WANT TO CONNECT (!!) without going through the whole ‘add the service to your local TNSNames.ORA’ rigmarole (Oracle Net Configuration Assistant)? Oracle’s Net Configuration Assistant was one of the first JAVA powered GUIs I had run into as an Oracle user. […]

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: , , , ,

Toad for Oracle v11 Sneak Peek: PL/SQL Grammar Checking

Are you a PL/SQL developer? Do you think your IDE should promote better coding practices, and guide you to build more robust and reliable programs? If so, then Toad v11 might be just the IDE you are looking for. Toad version 11 introduces a new feature in the Professional and higher editions – Code Analysis. […]

Similar Posts by Subject Areas: , ,

Are you a real DBA?

I’m sorry, I didn’t realize there was such a thing as a ‘fake’ DBA Jeff! Ok, so labeling someone as a ‘real’ DBA is a bit insulting to DBAs everywhere. If you have children, that makes you a parent. If you are responsible for a database, then you are a DBA. So what exactly am […]

Similar Posts by Subject Areas: , ,

My Oracle is broken, can you fix it?

“Look for things that make them go!” – from ST:TNG, “Samaritan Snare” (Wiki) I have a tendency to relate everything in life back to a Star Trek or South Park episode – it’s a personal problem and I’m currently in therapy, courtesy my DVR. But back to Oracle… How often have you been asked to […]

Similar Posts by Subject Areas: , ,

Oracle XE: Xtra-Awesome Edition (FREE)

Did you know you can run Oracle RDBMS for free? Updated on 11/25/2011 – 11gR2 now available for Windows x32 and Linux x64 Yes, there are limitations (fine print), but just about anyone can take advantage of this offering. So, why should you care? Maybe you are a developer, and your DBA refuses to grant […]

Similar Posts by Subject Areas: , ,

Killing in the Name

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,