ThatJeffSmith

Tag: sql

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

Who Owns Performance in the Database?

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

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

Excel and Oracle? Yes, but Should You?

Microsoft has a lot to be proud of. They helped pioneer desktop computing. They have very successful platforms like SQL Server and Sharepoint. They are even working on a new mobile phone that doesn’t support copy and paste. But, I would argue their most popular product in use today is Excel. Mayhaps ‘popular’ isn’t the […]

Driving Blind?

I travel quite frequently for my job. Number one on my list of ‘must have things’ on the road is a Navigation device. This used to be my trusty Garmin, but now thanks to my new Android device, I have Google Maps. There have been times and places where I don’t have the device available […]

SELECT * FROM Re-Visited

In an earlier post, I discussed the merits and deficiencies around using the * syntax in a SELECT statement. I have been using this topic as a way to bring up lively discussions while doing database tools demos for our SQL and Oracle customers. I must admit I am extremely dismayed by the amount of […]

This Mostly Isn’t Goodbye, Mostly

I had to check out Brent’s LinkedIn account to see just how long he had been at Quest. Wow, 2.25 years. It was only about a year ago that I became aware of Brent’s presence. I actually can’t remember if I stumbled across his blog first or heard his name mentioned in a conference call. […]

Teaching Toad or Teaching SQL?

So for the past two days I’ve been taking a group of about 15 people through the paces of Toad and working with SQL Server. These folks are coming from an all Oracle environment to a completely SQL Server one. Tangent: Yes, they are actually migrating an entire application over. They are in year 3 […]

#OracleHelp

I think it’s safe to say that the Twitter hashtag #SQLHELP has been an unqualified success. Why do our SQL Server friends have such a vibrant community on Twitter while us Oracle folks seem to be a bit resistant to all of this Web2.0 stuff? That’s largely a rhetorical question, although my gut tells me […]