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…
-
-
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…
-
I thought I’d do something on Oracle this week, but then Microsoft made an announcement that was like an early Christmas present- SQL Server release for Linux. I work for a company that supports Oracle and SQL Server, so I wanted to know how *real* this release was. I first wanted to test it out on a new build and as they recommend, along as link to an Ubuntu install, I created a new VM and started from there- Ubuntu Repository Challenge There were a couple packages that were missing until the repository is updated to pull universe by adding…
-
OK, so I’m all over the map, (technology wise) right now. One day I’m working with data masking on Oracle, the next it’s SQL Server or MySQL, and the next its DB2. After almost six months of this, the chaos of feeling like a fast food drive thru with 20 lanes open at all times is starting to make sense and my brain is starting to find efficient ways to siphon all this information into the correct “lanes”. No longer is the lane that asked for a hamburger getting fries with hot sauce… 🙂 One of the areas that I’ve…
-
It’s Friday and the last day of my first Summit conference. I’ve wanted to attend this conference for quite a few years, but with my focus on the Oracle side and scheduling date so close to Oracle Open World, I couldn’t justify it before joining Delphix. When I was offered a spot to join the Delphix team and attend, I jumped at the opportunity. Look at this booth and these impressively talented Delphix employees- how could you resist?? Pass Summit 2016 The Summit event has around 5000 attendees and is held in Seattle each year around the last week of…
-
I’ll be attending my very first Pass Summit next week and I’m really psyched! Delphix is a major sponsor at the event, so I’ll get to be at the booth and will be rocking some amazing new Delphix attire, (thank you to my boss for understanding that a goth girl has to keep up appearances and letting me order my own Delphix ware.) Its an amazing event and for those of you who are my Oracle peeps, wondering what Summit is, think Oracle Open World for the Microsoft SQL Server expert folks. I was a strong proponent of immersing in…
-
This is a living document that I will continue to update and will add new database platforms to as I go along in my career. I spend a lot of time translating database platforms I’ve worked in for all tiers of the technical business. It just seems natural that we might need a location on the web where that information is kept. I’ll add some diagrams at a later date, but we’ll start with a simple spreadsheet of common terms and questions and how each of the terms or tasks in Oracle, (the current #1 RDBMS) translates in other platforms.…
-
A couple folks have emailed me, looking for my slides from Oracle Open World. Both presentations can be viewed here at Enktiec’s website, along with all my great coworker’s presentations, as well. If you are still looking for my interview with Oracle Technology Network on contributing to the Oracle community and User group involvement, that can be found here. I’m thoroughly busy right now with KSCOPE database track abstract selection, the RMOUG Training Days planning and abstract selection and finishing up the chapters along with my wonderful co-authors on the EM12c book for Apress. I’m really proud of this collaboration…
-
I’m seeing a light at the end of the tunnel and it’s not a train, so that has to be good, right? 🙂 I wanted to send out a quick post and remind folks that I will be presenting at SQL Saturday #169 in Denver, hashtag #sqlsat169 presenting on the seemingly popular “Oracle for the SQL Server DBA”. I really enjoy these sessions, as the MsSQL DBA’s are always a refreshing change from the more common Oracle world I’ve been in the last year and they are in turn, happy to talk to an Oracle consultant who really, truly believes…
-
I ended up so wrapped up in everything going on when I returned home that I never did get my Miracle Oracle World 2012 post out on my blog, (bad DBA Goth Princess!:)) so here it is! Miracle Oracle World, (aka MOW2012, hashtag #MOW2012) is a yearly event held by Mogens Noorgard and his company Miracle, (http://www.miracleas.dk/ ) at Hotel Legoland in Billund, Denmark each year. This year was no exception and I was thrilled when Mogens asked me while in attendance at RMOUG’s Training Days if I would come to Denmark and do my presentation on EM12c, (then let…
-
~ The least questioned assumptions are often the most questionable ~ Paul Broca I’ve always found assumptions to be one of the most common cause of failures in software releases/maintenance windows. If I had a dime for every time I’ve heard, “I thought you were going to take care of/do that…” or “I didn’t involve you earlier because I thought the steps you were responsible for were so easy…”, well, you know the saying and I’d be rich. Assumptions causing participation of the DBA too late into a project, release or maintenance is widespread enough when you are onsite, but…
-
Chris Shaw from Colorado Springs SQL Server SQLPass group invited me to come speak at this wonderful group last week and I promised a few folks that I would upload my slides to my site, (they are also available via Chris, too…) The group is a small, close knit group that I was very pleased to have the opportunity to speak to and look forward to having more interaction with in the future! Thank you to Chris and the rest of Springs SQLPass! Oracle for the SQL Server DBA Slides
-
Two things to be happy about today! 1st- Enkitec did a lovely announcement on Enkitec regarding my coming on board. I just arrived last night after three days at the main office in Irving, Tx, (Dallas area is lovely with all the fields of Blue Bonnet flowers this time of year…) and am psyched about working remotely for them from my home, northwest of Denver. 2nd- I have a wonderful opportunity to speak this evening at Colorado Springs SQL Pass group on “Oracle for the SQL Server DBA”. SpringsSQL It’s only going to get crazier the next two months from…
-
Users complained that a monthly financial report would no longer run SQLServer Reporting Services, (SSRS.) Upon investigation, it was found that this was a stored procedure that ran from one Annex database, sourcing from another and outer joins to a SQLServer database on a remote server through a linked server configuration. In attempts to run the report, my SQL Server Profile traces on both the source SQL Server and the remote SQLServer resulted in consistent sp_reset_connection results from the source and no activity in the remote. I ran my trusty and favorite script to tell me what processes were…
-
Part of this is going to be the SQL Server DBA in me ranting, so be patient and know as it says in the lovely site disclaimer, this is MY OPIONION and yes, I stick by this opinion 100%. I have very strong feelings on who and how a SQL Server, especially one with SSRS is installed. Microsoft’s continued mis-marketing, (albeit successful for sales) and ease of installation has created database environments that are misconfigured, poor-performing and poorly designed- BY DEFAULT. Few experts in .Net or SSRS, when asked, know what transaction logs, filegroups, lock escalation or sp/dbcc procedures are. …