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 location –> database –> runInstaller) but it’s going to fail because we’re missing the xdpinfo file. To verify this, you’ll need to open up a terminal from Application –> System Tools –> Terminal: $ ls -l /usr/bin/xdpyinfo ls: /usr/bin/xdpyinfo: No such file or directory We’ll…
-
-
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 of why DevOps is essential as agile speeds up the development cycle. The Mariner I space probe was a pivotal point in the space race between the United States and the Soviet Union. The space probe was a grand expedition into a series of large,…
-
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 snapshots to Delphix Engine This is a simple prerequisite before you upgrade an Oracle source database and takes down the pressure on the system, as well as confusion as the database upgrades the Oracle home, etc. Simply log into the Delphix Admin console, click on…
-
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 on methodologies like agile, continuous delivery and lean development. Residing a step or more behind bleeding edge has never phased the DBA. We were the cool kids by being retro, those refusing to fall for the latest trend or the coolest new feature, knowing that…
-
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 a time when I was just coming to grips with how much Delphix could solve in the IT environment and may have been one of the first abstracts I submitted as a Delphix employee. I wasn’t too thrilled with my choice and thank KSCOPE for…
-
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 I’m behind in. I’m going to jump right in with both feet with the topics of hints. The official, (and generic) definition of a SQL hint is: “A hint is an addition to a SQL statement that instructs the database engine on how to execute the…
-
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 have a lot of luck finding customers utilizing us for this reason, (yet). As I’ve discussed in previous presentations, I was aware of what a “swiss army knife” virtualization is, resolving numerous issues, across a myriad of environments, yet often unidentified. The Use Case To…
-
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 to go down while the data is reverted? The Setup In our scenario to answer this question, I’m going to perform the following on the VEmp_826 virtualized database: Add a table Add an index Include transactions, both inserts and deletes Rewind the database using the…
-
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 IT can do to help guarantee tech projects are more successful. DevOps is a standard in most modern IT shops and DBAs are expected to find ways to be part of this valuable solution. If you inspect the graph, displaying the value of different projects…
-
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 out and a project team is allocated. The next step in the project is to choose one or more clouds, choose the first environments to test out in the cloud, along with security concerns and application limitations. DBAs are tested repeatedly as they continue to…
-
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 are managed. Now that last one might seem odd and you might think that they’d all be similar, but its surprising how different they really are. Getting to Know You Today I’m going to talk about an aspect of conferences that’s very near to my heart,…
-
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 a primary b-tree index, but unlike a standard table with an index simply enforcing uniqueness, the index IS the table. The data is arranged in order to improve performance and in a clustered primary key state. This is the closest to a clustered index in SQL…
-
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 script to check for fragmentation from Franck Pachot. You’ll need to simply update the script to declare the table and index name or simply edit the script as is, adding those two values correctly before running it. The outcome when run against my ugly index…
-
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. SQL Server. There was some really fun, (well, at least what I call fun…) test cases built out and referenced by Paul Randal. After looking through some of it, I decided it might be interesting to try to replicate it to Oracle, (as close as…
-
Every year I make the trek to Vegas for the large Collaborate conference and 2017 is no different! It’s a busy schedule for me at Delphix, so buckle up and hang on for this next week’s events! Sunday, April 2nd, 9am-1pm Pre-Conference Hands on Lab Location: South Seas C Session# 666 Registration is required for this special conference event and it will give the registered attendees a chance to get hands on experience with databases with virtualization. This is an important skill set for Database Administrators as they discover how easy it is to migrate to the cloud with virtualized…
-
Azure is the second most popular cloud platform to date, so it’s where Delphix naturally is going to support second on our road to the cloud. As I start to work with the options for us deploying Delphix, there are complexities I need to educate myself on in Azure. As we’re just starting out, there’s a lot to learn and a lot of automation we can take advantage of. It’s an excellent time for me to get up to speed with this cloud platform, so hopefully everyone will learn right along with me! We’ll be using Terraform to deploy to…
-
I ended up speaking at two events this last week. Now if timezones and flights weren’t enough to confuse someone, I was speaking at both an Oracle AND a SQL Server event- yeah, that’s how I roll these days. Utah Oracle User Group, (UTOUG) I arrived last Sunday in Salt Lake, which is just a slightly milder weather and more conservative version of Colorado, to speak at UTOUG’s Spring Training Days Conference. I love this location and the weather was remarkable, but even with the warm temps, skiing was still only a 1/2 hour drive from the city. Many of…
-
Now that I’ve loaded a ton of transactions and did a bunch of work load on my source database with the SH sample schema and Swingbench, I’ve noted how little impact to the databases using different cloud tools, (which will come in a few later posts) now I’m going to show you how easy it is to create a new VDB from all of this, WITH the new SH data included. During all of this time, the primary users of my Delphix VDB, (virtualized databases) would have been working in the previous iage, but someone wants that new SH schema…