*Previously on the Microsoft Tech Community Data Architecture Blog A number of our customers and my peers have asked me how to use the Excel sizing template to estimate an Oracle workload without access to the AWR. This is actually quite easy to do with Oracle Statspack. The statspack report is the predecessor to the Automatic Workload Repository,(AWR). It is also the option for those databases that are Oracle standard edition or are enterprise edition but haven’t licensed the diagnostic management pack. This product requires a manual installation that requires either manual snapshots be taken or scheduling via cron or another scheduler. …
-
-
*Previously on the Microsoft Tech Community Data Architecture Blog There are considerable focus areas to infrastructure that the IaaS DBA needs to be aware of, so Part I of this blog can be found here. Now that we’ve covered storage and VM series in Part I of this blog post on Infrastructure, we can go onto the detail areas for performance. Let’s start on performance gains with host caching. Cache it Out Right Host caching, by default, for premium SSD is turned off. This is a feature only available on certain VM series, (look for an ‘S’ in the D, E…
-
*Previously on the Microsoft Tech Community Data Architecture blog Those responsible for data will tell you that no matter what they do, at the end of the day, they’re value is only seen when the customer can get to the data they want. As much as we want to say this has to do with the data architecture, the design, the platforming and the code, it also has to incorporate the backup, retention and recovery of said data, too. Oracle on Azure is a less known option for our beloved cloud and for our customers, we spend considerable time on…
-
*Previously on the Microsoft Data Architecture Blog in the Tech Community An an Oracle SME at Microsoft, it’s always important to find new ways to make the few of us that specialize in Oracle scalable. One of those is to find ways to provide documentation, blog posts and tools available to others so they can do some of the work we’re commonly brought into. Infra vs. the RDBMS It’s a standard practice in a lift and shift to simply take the existing server and move it to the cloud. This is rarely the best approach with an Oracle database, but…
-
*Updated 03/10/2022 This is a consistent question I receive often and although RAC isn’t supported in any third-party cloud by Oracle, it’s an important topic as more workloads lift and shift to Azure and there is absolutely a reason to have or not to have Real Applications Clusters, (RAC) as part of them. The only current option for RAC on Azure available is: Flashgrid using Azure VM Images in IaaS The goal of this post is to push past the idea that a lift and shift should always be a 1:1 move. It’s important when moving to the cloud to use…
-
I had an interesting opportunity with a complex Oracle environment that exemplified the challenges of technical debt and dependency on database platforms. There are those that believe a database should only be used to hold data and should be completely platform interchangeable. As DBAs, we know this results in very little usage of relational database features and platform strengths and rarely, if ever can scale. I fully support using the strength of RDBMS platform features, but what happens when we embrace what a feature does and attempt to build it better at the database layer than the RDBMS vendor? …
-
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…
-
Anyone interested in viewing the PDF to either of my presentations from MOW2012, which was held in Billund, Denmark this last week, the slides are now available via the following links: Making EM12c Work for You and ASH Analytics, Top Activity the Next Generation If you have any questions, please let me know, I’ll be glad to add the speaker content that may not be visible in the slides! ~Kellyn
-
I am preparing to fly out to Denmark tomorrow for Miracle Open World, 2012 in Billund, Denmark, MOW2012 It will be my first time to Europe, so I’m highly anticipating the journey and conference. I also had the pleasure of guest blogging on ODTUG’s blog this week: ODTUG’s Blog I’m all packed, ready to go and ramping up for KSCOPE 2012 in June!! Enkitec will have a huge booth, no doubt and we will have a solid group of folks speaking at the event!
-
~ 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…
-
This is another little known feature, but one you have to work with to get a solid feel for and find value in. When I came upon it in EM12c, I was not that impressed, but quickly became more impressed with the “just the facts” and “all in one” interface that it is, especially if you are working in a RAC environment. Its another one of those features the DBA can stumble upon as they are working through issues, but to purposefully utilize it, the quickest way is after logging into the Enterprise Manager, click on Targets –> Hosts and…
-
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
-
Congratulations to my coworker, Andy Colvin who just received his Oracle ACE!! Just one more immensely technically gifted individual who is very deserving of this award at Enkitec and makes me proud to be part of such a great group of folks!
-
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…
-
Originally submitted at REI The REI Monorail Sling bag has the volume of a daypack and the features to meet all the challenges of the daily urban grind. Outdoor-inspired details make hauling the load comfortable and convenient. REI Monorail Sling Bag Light, Sturdy, Roomy and Comfortable!! By dbakevlar from Westminster, CO on 3/17/2012 5out of 5 Pros: Lightweight, Easy To Access Items, High Quality, Comfortable, Good Capacity, Easy To Carry, Stylish Cons: No Zipper pocket in main Best Uses: Weekend Trips Describe Yourself: Modern, Stylish, Practical, Comfort-Oriented, Career Travel Frequency: 6-10 Annual Trips Primary use: Business Was this a…
-
Due to scheduling conflict though, it’s on a Thursday evening for once! I will be presenting for the first time as an Enkitec employee in Colorado Springs, March 22nd. All you SQL Server folks out there that want to come on out, here are the details: SpringsSQL
-
I’m forwarding out the latest KSCOPE 2012 Email. I love their stuff!! ———————————————————————————— The stars at night are big and bright, deep in the heart of Texas… And some of the brightest stars of the Oracle world will light up the scene at ODTUG’s Kscope12, San Antonio, June 24-28. Celebrated around the world for its top-notch content, outstanding networking opportunities, and memorable special events, ODTUG Kscope is unquestionably THE premier user conference for Oracle training. Kscope12 promises to deliver the goods again this year! At last year’s special event, ODTUGgers were putting on the Ritz aboard the Queen Mary. At…
-
I’ve been again, unfortunately, reminded what makes a poor work environment for a DBA or Developer. Eddie Awad had sent this out and the second one really resonated with me: http://www.washingtonpost.com/national/on-leadership/how-to-completely-utterly-destroy-an-employees-work-life/2012/03/05/gIQAxU3iuR_story.html?tid=sm_twitter_washingtonpost I refer to this in the IT world as the “technical bully syndrome” and it’s quite common in the arena. It’s not because it’s a male dominated group- I’ve seen bullies come in all shapes and sizes, along with being of both genders. In fact, there are a couple studies out there that say women managers and leads are more likely to bully a subordinate than a male is.…