This week I had the opportunity to present at Microsoft’s Pass Summit, which was one of two events I had on my list for this year, (the other was Oracle Open World.) Although I’m still learning about all the events on the Microsoft side, unlike Oracle, where there’s one, massive event in San Francisco each fall, Microsoft has split their annual events into three to focus on each audience. In less than two months, there was MS Ignite in Florida, focused on tomorrow’s technology, IT Dev Connections, geared towards development and then this week, Pass Summit, for the Data Platform…
-
-
Thursday started out calm, self-assured that I knew where I needed to be all day and was prepared. I tweeted happily that I had found a lovely spot to work during the keynote, (day job!) Yeah, this: At the keynote, there was a table with my name on it where I was supposed to be. Thank you so much to Brent Ozar for letting me know so I could apologize for the miscommunication with the organizers of the blogger table, (which is not the same thing as the blogger meetup- oops!!) The rest of the day was crazy busy, but…
-
I’ve plenty of rest after arriving in Seattle yesterday to get my registration for Pass Summit, attended the Women in Technology Happy Hour and then received my Idera ACE! Now Wednesday morning, I spent it reworking my slides for the third time and preparing while the main keynote was going on, (my session was right after and was streamed.) After all that work, I then came to realize after adjusting my resolution, we loaded the previous deck and I had to think fast, skipping some older slides during my presentation. Lucky for me, I had an awesome audience and the…
-
So we’ve covered a few basics of a Linux host in Part I– The File System Users, groups Basic Commands with basic arguments And file and directory permissions Hopefully, what I share next will build on the first post and enhance your knowledge as you move forward with Linux. Reading the contents of a directory, gathering information on files and locating files are some of the most common tasks a DBA will perform as they work on a server. Many of the following commands require you to “pipe” a second command onto the first. This is done by joining the…
-
For the Oracle DBA, Linux is life. When I was at Oracle, Linux projects were the easy part of my job, unlike the ones on Windows, AIX, HP-UX and at times, even Solaris. You knew the Linux ones received the most love from development, had the most time towards patching and received attention if there was a bug. History Linux was introduced in 1991, thanks to Linus Tovalds and has been in active development, with introduction of different “flavors” of the OS over the years. As many folks know, Linux was carved out of the GNU open license project, which…
-
So now that I’m finished just taking it easy, playing hooky from Oracle Open World and Oak Table World…uh, yeah…. I get to recover from emergency surgery for another week and while I’ve been busy writing slide content, building out new abstracts for the new year, along with content for a couple books, I’m finishing chapters on. My ebook is about to come out for DevOps for the DBA: The Next Frontier, (I’ll be giving a few hard copies away at events in the next couple of months, but you can get a free copy at Delphix.com soon!) This is…
-
The network has often been viewed as “no man’s land” for the DBA- Our tools may identify network latency, but rarely does it go into any details, designating the network outside our jurisdiction. As we work through data gravity, i.e. the weight of data, the pull of applications, services, etc. to data sources, we have to inspect what connects it to the data and slows it down. Yes, the network. We can’t begin to investigate the network without spending some time on Shannon’s law, also known as Shannon-Hartley Theorem. The equation relates to the maximum capacity (transmission bit rate) that…
-
Data gravity and the friction it causes within the development cycle is an incredibly obvious problem in my eyes. Data gravity suffers from the Von Newmann Bottleneck. It’s a basic limitation on how fast computers can be. Pretty simple, but states that the speed of where data resides and where it’s processed is the limiting factor in computing speed. OLAP, DSS and VLDB DBAs are constantly in battle with this challenge. How much data is being consumed in a process, how much must be brought from disk and will the processing required to create the results end up “spilling” to…
-
I’m off to Columbus, Ohio tomorrow for a full day of sessions on Friday for the Ohio Oracle User Group. The wonderful Mary E. Brown and her group has set up a great venue and a fantastic schedule. Next week, I’m off to SQL Saturday Vancouver to present on DevOps for the DBA to a lovely group of SQL Server attendees. It’s my first time to Vancouver, British Columbia and as it’s one of the cities on our list of potential future locations to live, I’m very excited to visit. Speaking of SQL Server- Delphix‘s own SQL Server COE, (Center…
-
In my latest blog post on the Delphix site, I continue my conversation with why DevOps is the next step for DBAs and how DBAs can embrace this next step in their evolution. This is an extensive series of blog posts, (four so far) to be followed by an ebook, a podcast and two webinars. One is to be announced soon from Oracle called, “The DBA Diaries” and the other will be a from Delphix, titled, “The Revolution: From Databases and DevOps to DataOps“. The goal for all of this is to ease transition for the Database community as the…
-
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 responses. I’m not a fan of the term, but no matter if you use this term or call them advocates, representative, influencer- it doesn’t matter, they are essential to the business, product or technology that they become the voice for. Those that I view as…
-
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,…
-
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 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…