THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

Pythian Blog

perl-achievements, the return

So there I was, leisurely perusing my twitter feed… Oh, an entry by brian d foy? Should be interesting. So I clickety clicked, and let my eyes wander and almost immediatly fall on

Yanick already has perl achievements (although it’s not on CPAN, wtf Yanick? :)

Read the rest of this entry . . .

When DBCC INPUTBUFFER disappoints

Today we have an alert from one of the client server about blocking, I have immediately start looking at it using below statement

SELECT * FROM
MASTER..SYSPROCESSES
WHERE BLOCKED != 0;

Read the rest of this entry . . .

Log Buffer #257, A Carnival of the Vanities for DBAs

With new year many new projects, new technologies, new frameworks and new ideas are springing up at the speed of light and bloggers in the database arena are keeping up with this pace and this Log Buffer Edition is also living up to that pace and covers some of those posts in Log Buffer #257.
Read the rest of this entry . . .

Installing Oracle VM Manager 3.0.3 under Dom0 host, or How to save resources on your sandbox

If you are wondering why anyone would possibly need to Install Oracle VM Manager in such an unsupported way, please read my previous Oracle VM 3 related blog post.

In this post, I will share with you my experience installing OVMM 3.0.3 under OVM 3.0.3 Dom0 host, including:

  • A short and sweet action plan to get it up and running ASAP
  • A detailed explanation with error messages and solutions
  • Clean run output

Read the rest of this entry . . .

Log Buffer #256, A Carnival of the Vanities for DBAs

Searching for the blogging inspiration? On the look-out for that Eureka moment for your next blockbuster blog post? Finding the exact ingredients for your dream rambling? Well in the Log Buffer Edition, there are some awe-inspiring posts in this Log Buffer #256. Get Inspired, keep blogging.

Read the rest of this entry . . .

RIP Flash-based My Oracle Support

The end is nigh for Adobe Flash at My Oracle Support. The first step will happen during this weekend’s planned maintenance of My Oracle support, when all of MOS will be down for 5 hours starting at midnight eastern, Saturday January 28. Once it comes back up, the unadvertised non-Flash supporthtml.oracle.com will come up as a quasi-user acceptance test of the new application, while the flash-based support.oracle.com stays as-is. And once the bugs get worked out (“in the coming months”), the flash-based support.oracle.com will cease to exist and point to the new HTML-based site.
Read the rest of this entry . . .

A Quick Pas de Deux with Dancer

This is going to be a short one, but potentially useful for anybody writing a Dancer template module, or just plain curious about Dancer‘s guts. So here goes:

A few weeks ago, it came to my attention that Dancer’s Dancer::Template::Abstract, the base class for its template modules, added a test to verify that the template it receives as an argument is really a file. Yay. Sanity tests are awesome. Except… what happens when a templating system is not file-based? A lot of exceptions and a very sad web application, that’s what happens.

Read the rest of this entry . . .

Pythian at RMOUG Training Days 2012

Pythian is very excited to return to the much-awaited RMOUG 12 held in Denver, Colorado from February 14-16, 2012. Keep your eyes open for Alex Gorbachev, Marc Fielding, Don Seiler and Gwen Shapira in attendance. We have a fantastic line-up of speakers this year featuring a total of seven papers presented by Alex, Marc, Don and Gwen. If you have any feedback on our sessions, please send your comments directly to the speaker or to Vanessa Simmons, Pythian Director of Marketing. Please also follow this link to sign up to receive notice of future speaking engagements, webinars or Pythian news.

Be sure to stop by our booth (#3,6,7,10) to say hello to our friends from the OakTable Network, and enter our draw to win the new Amazon Kindle with software provided by Cary Millsap (MR-Trace, MR-Tools & Method-R Profiler) and a pack of digital e-book downloads courtesy of Apress. Also slated is the RAC Attack workshop, which was first offered at Oracle Open World and UKOUG, and is now in its second year at RMOUG. Pythian is co-sponsoring this event with Apress and it’s a fun and informative way to learn from our experts how and when to properly build a RAC environment.

Read the rest of this entry . . .

T-SQL: Retrieve all users and associated roles for ALL databases

A frequent inquiry concerning databases’ security is to retrieve the database role(s) associated with each user for auditing or troubleshooting purposes.

Each database user (principal) can be retrieved from sys.database_principals and the associated database roles can be retrieved from sys.database_role_members

The following code runs against ALL the databases using SP_MSForeachdb and all roles for one principal is concatenated in one row Read the rest of this entry . . .

Log Buffer #255, A Carnival of the Vanities for DBAs

With winter and its cold weather starting to set in across most of the world, now is the time when travelers start to think about warming things up. For most, that means flying to hot and sunny destinations. Another way of looking at it, however, is to head out for a different kind of sizzle. There’s perhaps no better way to heat up the chilling months with blogging. Let’s snuggle up in this Log Buffer Edition with hot blog posts in Log Buffer #255.

Read the rest of this entry . . .

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @pythianfielding: My #ukoug2011 #Exadata IORM presentation starts in a few mins in hall 7A
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more