PASS Summit 2nd Day Keynote

Woohoo, we’ve made it to the second day of PASS Summit!  After an awesome first day running from the keynote, to my first session with Denise McInerney, late for my executive meeting with less than a dozen other attendees with Rohan Kumar and sessions/networking/parties, here we are for the second day of PASS Summit keynote!

Info and Awards

We started the day with Wendy Pastrick to tell us about the financial status of PASS (more...)

Bacon, Bloggin’ and First Day Keynote at PASS Summit 2019!

After a flurry of release announcements at MSIgnite this week, it was time to talk about the technology at a deeper level at PASS Summit.  I love this event, which has my undying loyalty due to the sheer amount of technical focus on everything in the Microsoft data platform and of course, was not disappointed with the first day keynote on Wednesday!

We started out with a great treat of information before the keynote, (more...)

My PASS Summit, Wednesday, Nov. 6th Recommendations from DBAKevlar!

I thought I would share the recommendations for the next day that I’m excited about this year at PASS Summit 2019!  There are some really great sessions and as most attendees, I’ve focused the list on topics that I’m interested in or can help me in my role.

Although Tuesday afternoon and evening may kill me with how many events are all planned, there’s still a lot going on for the rest of the (more...)

PASS Summit 2019 is NEXT WEEK!

I’m getting ready for SQL Saturday Oregon this weekend, (taking the train up from Eugene to Portland…) but its about time I talked about the exhilarating and exhausting event we call PASS Summit.

This year I was lucky enough to be chosen as a speaker and a blogger.  Bloggers at the conference get the opportunity to sit in special zones during keynotes and we write about the event.  We also get special access to Microsoft (more...)

The Complexity Defense and Other DBA Crimes

No matter how far my career and role has shifted, I will always view myself as a database administrator.  I know this because when I fill out any form asking me what role I fulfill in IT, I still choose “DBA” from the list.  No matter what claims the media and leading sources state, DBAs are an important role, even as technology shifts and traditional database tasks move to the cloud.  Deeper relational database skills are (more...)

Changing Your Bash Shell Prompt and Colors

I enjoyed the opportunity to test out my PASS Summit shell scripting session at SQL Saturday Denver.  It was the first run on it and Glenn Berry sat in my session.  Afterwards, this wise and long-standing member of the community had a very valuable piece of constructive criticism-  change the background on my bash terminal for Azure Cloud Shell, as the black background and colors could be troublesome for some attendees.

I agree (more...)

October 2nd, #SQLSatOregon in Portland and the #SQLTrain!

I’m still not sure where October went….well, actually I do-  it was a flurry of travel, writing, (but not blogging!) and working with customers on a ton of new projects for the next quarter.  With the end of October, comes the preparation for PASS Summit.  Last year, I had to pass on the SQL Train, but this year?

SQL Train is the annual pilgrimage from SQL Saturday Oregon, in Portland, (more...)

Oracle on Azure- Options, Options, Options

I’ve been very busy allocating 60% of my time towards Oracle on Azure migrations.  The biggest challenge right now isn’t getting Oracle on Azure, but keeping my percentage of time allocated to only 60%.

I love Oracle technology-  yes, a Microsoft employee who LOVES Microsoft and Azure cloud, also LOVES. Oracle.  I won’t apologize and I know I’m not the only one.   Every company I’ve worked for, even when I worked at Oracle, required (more...)

#24HOP and PASS Summit 2019

You know how busy I am by the amount of time I DON’T blog and yes, it’s been over a month.  I think that’s the longest I haven’t blogged in YEARS.

24 HOP and Facebook Live

I just finished my 24HOP, (24 hrs of PASS) session back on September 9th, the PASS Facebook Live session this last Monday and I’m thrilled with these virtual events each year I get the chance to participate. (more...)

Azure VMs with Oracle- Next Steps

Microsoft has done a great job of documenting how to create a VM with the appropriate VM image and Oracle version, then how to log in, startup the listener and create the database.  I just have some enhancements I’d like to make to it, hoping to help it move up one level.

I Bequeath to You

All instructions provided by the Microsoft documentation show how to connect to the database using a bequeath, (BEQ) (more...)

Linux Scripting, Part IV- Scripting for Longevity

We’ve learned a lot about commands, utilities and how to create a script, but we need to discuss the importance of scripting for longevity.

What is Scripting for Longevity?  We have a tendency to focus on scripting to automate something WE might not want to perform manually, but avoid what we think might void our value.  We may try to ensure there is necessity for our role or our knowledge as we create (more...)

Create an Oracle VM on Azure in Less than 5 Minutes

If there’s one thing I’ve been able to prove this week, it’s that even with the sweet 4G LTE, Wi-Fi setup in my RV, Montana still has the worst Wi-Fi coverage in the US.  Lucky for me, I work in the cloud and automate everything, because if there’s one thing I love about automating with scripts, is that I can build out a deployment faster and less resource intensive than anyone can from the (more...)

Best Practices for Oracle Data Guard on Azure

I keep saying I’m going to start sharing what I’m doing in the Analytics space soon, but heck, there’s too much I need to keep adding to on the Oracle in Azure arena!

So, as most people know, I’m not a big fan of Oracle RAC, (Real Application Cluster).  My opinion was that it was often sold for use cases that it doesn’t serve, (such as HA) and the resource demands between the nodes, (more...)

Oracle and Microsoft’s Cross-Cloud Partnership

A couple weeks back, Oracle and Microsoft announced their cross-cloud partnership.  This was wonderful news to me, as I’ve been working on numerous Oracle projects at Microsoft with Azure.

The Gist

To know that there is now a partnership between the two clouds and that there’s also a large amount of documentation about working between the two clouds is very helpful vs. the amount I’ve been working on based off just my knowledge.  (more...)

Power BI Reporting with Oracle Essbase

This last week, I presented a few sessions at ODTUG’s KSCOPE 2019 conference in Seattle.  One of these sessions was with my wonderful co-presenter and Oracle Application Cloud expert, Opal Alapat.  I connected with her when the call for papers opened and asked her if there would be interest in doing a session with Power BI connect to the Essbase in the Oracle Applications cloud, (OAC).  There was no desire to do a bake-off or (more...)

One Year at Microsoft

Hard to believe its been one year, but it was June, 2018 when I joined the unstoppable company known as Microsoft.

All-in Analytics

I joined, with the expectation that I would leave much of what I had specialized in behind me- Oracle, along with other non-Microsoft database platforms, Linux, optimization and DevOps. I was excited to start my journey in business intelligence. Power BI was already starting to take over the world. I’d noticed the (more...)

Linux Scripting, Part III

In the previous blog posts, we learned how to set up the first part of a standard shell script- how to interactively set variables, including how to pass them as part of the script execution. In this next step, we’ll use those to build out Azure resources. If you’re working on-premises, you can use this type of scripting with SQL Server 2019 Linux but will need to use CLI commands and SQLCMD. I will (more...)

Remove Files with Force and Other Bad Ideas

Almost every Linux or Unix person has seen the help forum post from a novice looking for an answer to a frustrating problem and the arrogant fool that responds with “Just type in rm -rf / and it will fix the problem.” For anyone who is part of the “do no harm” technical community, this can make us wish for a way to revoke the arrogant fool’s privileges to the internet— permanently.

Recycling Commands

(more...)