Upgrading an Amazon EC2 Delphix Target, Part IV

It’s finally time to upgrade our Linux Target!  OK, so we’re not going to upgrade the way a DBA would normally upgrade a database server when we’re working with virtualization. So far, we’ve completed: 1.  Updating our instances so that we’ll have a GUI interface if we’ll need one. 2.  Installed Oracle on the Linux …

Continue reading "Upgrading an Amazon EC2 Delphix Target, Part IV" »

Successful Evangelism

I’ve been asked what it takes to be a successful evangelist and realizing that what makes one successful at it, is often like holding sand in your hands- no matter how tightly you hold your fists, it’s difficult to contain the grains. The term evangelist is one that either receives very positive or very negative …

Continue reading "Successful Evangelism" »

Upgrading an Amazon EC2 Delphix Source, Part III

This is the Part III in a four part series on how to:  Enable VNC Viewer access on Amazon EC2 hosts.  Install DB12c and upgrade a Dsource for Delphix from 11g to 12c, (12.1)  Update the Delphix Configuration to point to the newly upgraded 12c database and the new Oracle 12c home.  Install DB12c and …

Continue reading "Upgrading an Amazon EC2 Delphix Source, Part III" »

Upgrading an Amazon EC2 Delphix Source, Part II

I’m finally getting back to upgrading the Linux Source for a POC I’m doing with some folks and picking up from where we left off in Part I… Address Display Issue Now that we have our VNC Viewer working on our Amazon host, the first thing we’ll try is to run the Oracle installer, (unzipped …

Continue reading "Upgrading an Amazon EC2 Delphix Source, Part II" »

The $50 Million Hyphen

There are a plethora of mishaps in the early space program to prove the need for DevOps, but Fifty-five years ago this month, there was one in particular that is often used as an example for all.  This simple human error almost ended the whole American space program and it serves as a strong example …

Continue reading "The $50 Million Hyphen" »

Upgrading an Amazon EC2 Delphix Source, Part I

For a POC that I’m working on with the DBVisit guys, I needed a quick, 12c environment to work on and have at our disposal as required.  I knew I could build out an 11g one in about 10 minutes with our trust free trial, but would then need to upgrade it to 12c. Disable …

Continue reading "Upgrading an Amazon EC2 Delphix Source, Part I" »

DevOps is Ruining the DBA?

Database Administrators, (DBAs) through their own self-promotion, will tell you they’re the smartest people in the room and being such, will avoid buzzwords that create cataclysmic shifts in technology as DevOps has.  One of our main role is to maintain consistent availability, which is always threatened by change and DevOps opposes this with a focus …

Continue reading "DevOps is Ruining the DBA?" »

Development and the Importance of Containerizing

I’ve been at KSCOPE 2017 all week and it’s been a busy scheduled even with only two sessions.  Its just one of those conferences that has so much going on all the time that the days just speed by at 140MPH. As with most major conferences, KSCOPE abstract submission was about 9 months ago.  This was …

Continue reading "Development and the Importance of Containerizing" »

Optimizer- Oracle and SQL Server, Hints

So you’re going to see a lot of posts from me in the coming months surrounding topics shared by Oracle and SQL Server.  These posts offer me the opportunity to re-engage with my Oracle roots and will focus on enhancing my SQL Server knowledge for the 2014 and 2016, (2017 soon enough, too) features, which …

Continue reading "Optimizer- Oracle and SQL Server, Hints" »

Virtualizing Big Data in the Cloud

I’m in sunny Phoenix this week at the Data Platforms 2017 Conference and looking forward to a break in the heat when I return to Colorado this evening. As this event is for big data, I expected to present on how big data could benefit from virtualization, but was surprised to find that I didn’t …

Continue reading "Virtualizing Big Data in the Cloud" »

Insider View of a Delphix VDB Rewind

I love questions-  They give me something to write about that I don’t have to come up with from my experience or challenges…:) So in my last post, Paul asked: I am not sure what happens to the other changes which happened while the release was happening? Presumably they are also lost? Presumably the database has …

Continue reading "Insider View of a Delphix VDB Rewind" »

Delivering Migration Projects on Time

I did a couple great sessions yesterday for the awesome Dallas Oracle User Group, (DOUG.)  It was the first time I did my thought leadership piece on Making Sense of the Cloud and it was a great talk, with some incredible questions from the DOUG attendees! This points me to a great [older] post on things …

Continue reading "Delivering Migration Projects on Time" »

The Chicken Before the Egg of Cloud Migrations

For over a year I’ve been researching cloud migration best practices.  Consistently there was one red flag that trips me that I’m viewing recommended migration paths.  No matter what you read, just about all of them include the following high level steps: As we can see from above, the scope of the project is identified, requirements laid …

Continue reading "The Chicken Before the Egg of Cloud Migrations" »

Conference Networking- Tips to Doing it Right

I was in a COE, (Center of Excellence) meeting yesterday and someone asked me, “Kellyn, is your blog correct?  Are you really speaking at a Blockchain event??”  Yeah, I’m all over the technical map these days and you know what? I love the variety of technology, the diversity of attendance and the differences in how the conferences …

Continue reading "Conference Networking- Tips to Doing it Right" »

Oracle IOTs against SQL Server Clustered Indexes

I’m itching to dig more into the SQL Server 2016 optimizer enhancements, but I’m going to complete my comparison of indices between the two platforms before I get myself into further trouble with my favorite area of database technology. <–This is sooo me. Index Organized Tables Index Organized Tables, (IOT) are just another variation of …

Continue reading "Oracle IOTs against SQL Server Clustered Indexes" »

Indexing in Oracle, Fragmentation

I just uploaded my slides from Collaborate 2017 to Slideshare, but also, the findings missing from my slide deck I used for Oak Table World on War of the Indices- Oracle and SQL Server.  Feel free to download them here. As I tested out Oracle vs. SQL Server Index performance, I ran across this great …

Continue reading "Indexing in Oracle, Fragmentation" »

Oracle and SQL Server Index Comparison

This post has a lot of the support code and data for my Oak Table Talk that I’ll be giving at IOUG Collaborate 2017 in Las Vegas on April 5th, 2017.   One of the Iceland 2017 SQL Saturday sessions got me thinking about indexing and how similar and different it all is in Oracle vs. …

Continue reading "Oracle and SQL Server Index Comparison" »