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 just returned from a week in Paris and it was fantastic! No amount of terrorist attack could hinder my enthusiasm for the week of vacation and although Tim and I were unaware a man with a hammer at Notre Dame would garner so much attention from the news outlets, I realized quick enough that I was in a slew of online, video and print as the major American tourist who witnessed…well, a person lying wounded on the pavement with police over him, guns drawn. I also became quickly alerted that there was a massive crowd coming towards me looking…
-
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…
-
Happy National Goth Day! Although I consider myself “Goth Lite”, it’s a national holiday in my little world and I’m pondering what books I’ll write after I run out of tech titles. Needless to say, I’ve chosen the title, “Staying Geeky and Goth After 50” and chosen the following for the cover art: I’m considering adding a black choker to Ma Goth and maybe some facial piercings to Pa- we’ll see. As May winds down, I look forward to a vacation in Paris the beginning of June with my favorite person, Tim Gorman. As much as we travel together, we…
-
After looking at my upcoming schedule for 2017, I realized that I need to start posting on where and what conference(s) I’m at regularly. With that realization, I present “Where in the World is Goth Girl” posts that will help keep track of me, (before my husband has a homing device surgically implanted in my brain….:)) This week I’m in Manhattan for Data Summit 2017, presenting on Wednesday on Database Virtualization. As soon as I’m done presenting on Wednesday, I’m heading to the airport to fly to Cleveland for the second day of NEOOUG, Great Lakes Oracle Conference, (GLOC) 2017…
-
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…
-
Different combination in the game of tech create a winning roll of the dice and other times create a loss. Better communication between teams can offer a better opportunity to deter from holes in development cycle tools, especially when DevOps is the solution you’re striving for. It doesn’t hurt to have a map to help guide you. This interactive map from XebiaLabs can help offer a little clarity to the solutions, but there’s definitely some holes in multiple places that could be clarified a bit more. The power of this periodic table of DevOps tools, isn’t just that they are broken…
-
So since I already complained about what I hate about tech from a diversity and culture perspective, I felt I needed to explain all the things I love about tech and why I wouldn’t want to be anywhere else. Everyone would expect me to start with databases or virtualization, but I thought I’d keep everyone on their toes and start with my favorite programming language- PYTHON! 1.Timed Pauses, Stops and Waits Sometimes systems are just too fast for humans. It’s important to have proper delays between tasks so that people are able to interact or systems are able to respond…
-
I love working in tech. I can honestly say that nothing gives me greater satisfaction than working on a technical challenge or having a brilliant conversation about technology with peers. Other days I feel like a broken record having the same conversations with the women in technology around me, facing a lack of diversity and the consistent exclusion in tech. Until this changes, the beatings will continue and my expression may often look similar to Alan Rickman’s below: “Rants are good for the soul and even better for the world. Some times, some things just need to be said.” Delphix has done an…
-
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 recently switched to a Mac after decades use with PCs. I loved my Surface Pro 4 and still do, but that I was providing content for those I thought would be on Macs, it seemed like a good idea at the time. I didn’t realize at the time I’d be doing as many SQL Server conferences as Oracle in my next role with the Delphix… 🙂 With this change, I found myself limited to VMs running on my Mac with SQL Server, then I was working with Azure and it seemed like a lot of extra “weight” to just…
-
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…
-
How many times have you had a developer come to you and say, “I just did a bad thing in the database. Can you recover from what I just did?” With Delphix virtualization, we make this pretty easy to address from the user interface with a simple slider to recover from a PIT before the catastrophic mistake, but today, we’ll discuss how to do this from the command line 1.Log into the Delphix engine as an admin user. ssh delphix_admin@<yourengine> delphix > timeflow delphix timeflow > ls 2. Depending on the platform that you’re using, (in our example, we’ll use…
-
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…