DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!

Database

SIOUG and HROUG Fall Conferences, 2014!

I’ve just returned from my honeymoon in Venice with the wonderful Tim Gorman, but before we enjoyed our week in this picturesque city, we spent a week doing joint keynotes and two sessions each on our own tech topics at these two incredible conferences in neighboring countries. SIOUG, (Slovenia Oracle User Group) in Ljubljana, Slovenia […]

 

The CTAS, a.k.a. Processing Data the Jetson’s Way

**Note-  This is an article I wrote about 4 years ago that, as far as I know, can only be found in hard copy and although I’ve changed my stance on statistics, etc. with 11g/12c, the main point of CTAS benefits still stands the test of time.   As a kid did you ever watch […]

 

Andy Colvin is Now an Oracle ACE!

Congratulations to my coworker, Andy Colvin who just received his Oracle ACE!! Just one more immensely technically gifted individual who is very deserving of this award at Enkitec and makes me proud to be part of such a great group of folks!

 

My Review of REI Monorail Sling Bag

Originally submitted at REI The REI Monorail Sling bag has the volume of a daypack and the features to meet all the challenges of the daily urban grind. Outdoor-inspired details make hauling the load comfortable and convenient. REI Monorail Sling Bag Light, Sturdy, Roomy and Comfortable!! By dbakevlar from Westminster, CO on 3/17/2012   5out […]

 

SQL Saturday Presentation!

Due to scheduling conflict though, it’s on a Thursday evening for once! I will be presenting for the first time as an Enkitec employee in Colorado Springs, March 22nd. All you SQL Server folks out there that want to come on out, here are the details: SpringsSQL

 

The Technical Bully Scenario

I’ve been again, unfortunately, reminded what makes a poor work environment for a DBA or Developer.  Eddie Awad had sent this out and the second one really resonated with me: http://www.washingtonpost.com/national/on-leadership/how-to-completely-utterly-destroy-an-employees-work-life/2012/03/05/gIQAxU3iuR_story.html?tid=sm_twitter_washingtonpost I refer to this in the IT world as the “technical bully syndrome” and it’s quite common in the arena.  It’s not because it’s […]

 

Kellyn’s Presentation Schedule, Spring/Summer 2012

Kellyn’s Schedule of Presentations, 2012, 2nd and 3rd Quarter March 24th, 2012, Colorado Springs, CO SQL Saturday Oracle for SQL Server DBA’s April 19th, 2012, Billund, Denmark MOW 2012 ASH Analytics- Top Activity, the Next Generation April 20th, 2012, Billund, Denmark MOW 2012 EM12c: Making Oracle Enterprise Manager Work for You May 30th, 2012, Hämeenlinna, […]

 

11g, Sherlock Holming it with Statistics, Histograms and Bind Peeking

Yes, my dear Watson, Bind Peeking is still an issue in 11g…. We recently upgraded from 10.2.0.4 to 11.2.0.2.0 and come across a couple interesting performance challenges. I do like this type of problem and have been quite busy working on the fixes for each one that has shown itself. This was one of the […]

 

Restarting a Duplicate Process From a VERY Failed State

As part of an 11g Upgrade, it was found that a database environment could be built from one of the upgraded databases through a duplicate.  As this process had never been performed before in this fashion, a test was in order.  The test was an excellent chance to discover that the OSUser that performs the […]

 

The NO_INVALIDATE Option in DBMS_STATS with 10g

I had worked hard on a report, 47 SQL statements in all to tune it down from 5 hrs to under 30 minutes.  The first runs had been quite successful, so when a third run sent an alert on temp usage, I knew something was wrong. SID PROCESS MACHINE SQL_TEXT SQL_ID TOTAL MB ——– ———— […]

 

  • Facebook
  • Google+
  • LinkedIn
  • Twitter