Search

OakieTags

Who's online

There are currently 0 users and 24 guests online.

Recent comments

Oracle

SQL Developer 4 EA2 Connecting to SQL Server

I wrote a blog post some time ago about using SQL Developer 3.x to connect to SQL Server. I tried the same thing today from SQL Developer 4 EA2 and it works just fine.

You have to download the 3rd party JDBC driver and point SQL Developer to it. You can read how to do it here.

Cheers

Tim…

Update: My colleague just told me this.

“If you at any point decide to use Windows authentication to connect (like I just did), you might hit this error:

Status : Failure -I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

Being Friends with Larry Ellison… :)

So I tried to finish out some of my OOW posts, but I ended up talking about this with a friend and thought I would share how I became Facebook friends with Larry Ellison instead….

My Oracle OpenWorld 2013 Presentations

Oracle OpenWorld was fantastic, as usual. The best show in San Francisco. This is the seventh year in a row that I’m attending – 3 times as HP employee, 3 times as Pythian employee, and now as a Clouderan. My life changes, but the event and people are always fantastic.

There will be a separate blogpost about what I learned at the event, new exciting products and my thoughts of them. But first, let me follow up on what I taught.

A System for Oracle Users and Privileges with Automatic Expiry Dates

Tired of tracking down all the users in the database to deactivate them when they cease to exist, or change roles, or fulfill their temporary need to the database? Or, tracking down privileges you granted to existing users at the end of their requested period? The solution is to think out of the box - developing a system that allows you to create a database user account with an expiration date. This fire-and-forget method allows you to create users with the assurance that they will be expired (locked or dropped) at the expiration date automatically, without your intervention. Interested? Read on how I developed such a system--along with source code for you to try.

Introduction

What is a database user? In my opinion, there are two kinds of users:

Virtual Integrity

A recent question on the Oracle-L list server described a problem with data coming in from SQL Server and an oddity with referential integrity failing on Oracle because (for example) a child row was in lower case while the parent was in upper.

This raised a few comments on how you might handle referential integrity while allowed case to differ. No doubt it’s been done before – by Tom Kyte if no-one else – but the first thought that crossed my mind was to use virtual columns:

Oracle OpenWorld 2013 : It’s a wrap

I’m back home from my 8th Oracle OpenWorld. Here are the posts I wrote during the event.

Free Beta Exam Vouchers : The Winners

Just before I left for OpenWorld I started a competition to win 5 vouchers for an OCP beta exam, kindly donated by Oracle Certification. I’ve just got back, so it’s time to announce the winners.

(1) In first place comes Steve Karam, with not one, not two, but three entries, including one to the tune of Fresh Prince of Bel-Air. I met Steve at OOW2013 and he kindly offered to forgo the prize if I felt someone else was more deserving, but he was head and shoulders above the rest, so he simply must get a prize!

Virtual Stats

Or – to be more accurate – real statistics on a virtual column.

This is one of the “10 top tips” that I came up with for my session with Maria Colgan at OOW13. A method of giving more information that might improve execution plans when you can change the code. I’ll start with a small data set including a virtual column (running 11.1.0.7), and a couple of problem queries:

Oracle OpenWorld 2013 : Thursday

I got up late, so I missed the morning gym session.

When I got to Moscone at about 08:30, I headed straight for the speakers room to play catch-up on emails, questions, blog posts and work emails. I expected that to take a few minutes, but it actually took me up to midday. It’s crazy how much time we spend on this community stuff. :)

I spent most of the afternoon in the OTN Lounge geeking out with a variety of people. I was initially expecting to spend the whole day in presentations, but it turned out I didn’t manage to get to a single one. I spent some time chatting with the ladies and gents from the RAC SIG about ideas for future directions for user groups and collaborative efforts like RAC Attack. It’s interesting to hear the different opinions and motivations of the people involved.

Oracle OpenWorld 2013 : Wednesday

A familiar morning. Up at silly o’clock, went to the gym, then read in my room for a while…

The plan for Wednesday was pretty much the same as Tuesday. Most of the day was spent at RAC Attack. I thought we were meant to be helping people install RAC on their laptops, but I quickly came to understand this was a cover for watching Yuri take photos of people jumping in the air… :)

A big thank you to all the people involved in making RAC Attack happen again! A lot of people helped in making the new 12c install notes. Lots of people dedicated two days of OOW2013 to this, rather than watching presentations or swanning off to the boat racing. Thanks also to the OTN crowd for giving up so much space to us.