The 2019 Year in Review

Uncategorized
| Dec 31, 2019

It’s that time of year where everyone is doing a “Year in Review” post and why not?

It’s good to gain perspective, plan for 2020 and celebrate all that was wonderful about 2019, (outside of politics, that was an utter failure on all fronts, pretty much most countries… :))

The DBAKevlar blog:

  • 46 published posts for 2019
  • Over 800 posts on the site
  • Over 600K in visitors for 2019
  • Daily views have increased steadily, with (more...)

ADHD and Certification Tests- A Tale of Disaster

Uncategorized
| Dec 30, 2019

I don’t talk too much about my Attention Deficit Hyperactivity Disorder, (ADHD) brain outside of the occasional squirrel joke and more often view it as a super power, but when it is a challenge, I think it’s important to share what we go through.  You can’t solve a problem if you don’t know it is one.

ADHD and Autism

For those that aren’t aware, I was diagnosed with ADHD/on the spectrum for autism back (more...)

Tools To Monitor and Work with Oracle on Azure

Uncategorized
| Dec 26, 2019

I’ve been studying for over a week for my certs.  It really is a challenge for my ADHD brain, as I learn by interacting and using a product, not be reading about it and guess what?  Most of what the certs are on are not in my technical area.  Yeah, this is not fun for me.  I find that my brain hits a limit on what it can absorb before the (more...)

Installing Microsoft SQL Server 2019 on Linux, Part II

Uncategorized
| Dec 12, 2019

This is a 2-part blog post, the first in the series can be found on the Microsoft SQL Server blog here.

The recently released SQL Server 2019 on Linux includes several updated features, including replication, support for Microsoft Distributed Transaction Coordinator, and Change Data Capture (CDC) support. If you’re running SQL Server 2017 on Linux, these are great reasons to upgrade to SQL Server 2019 to take advantage of these updates.

Microsoft SQL Server 2019 (more...)

Securing Data in Power BI- an Interactive Diagram

Uncategorized
| Dec 5, 2019

I haven’t been very good at sharing my analytics work as often I feel others are more skilled in this area than I am, just starting out, but today I’d like to start to fix that by sharing an interactive diagram.  I know, some of you may be saying, “infographic”, but as it’s has links vs. a paginated design, I’ll call it as I see it.

Not the Kitchen Sink

This diagram I built (more...)

Failed Installation of MSSQL-CLI on Ubuntu

Uncategorized
| Nov 26, 2019

So you want to run mssql-cli on Ubuntu Linux, but you received a number of errors and even if you got through some errors, you’re still stuck?

I’m here to try to help you get through them and hopefully I’ve captured them all.  Trust me, the Oracle DBAs have been here-  our databases and tools failed for a very long time until Linux administrators came to know what we needed and started to build (more...)

PASS Summit 2nd Day Keynote

Uncategorized
| Nov 7, 2019

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!

Uncategorized
| Nov 6, 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!

Uncategorized
| Nov 5, 2019

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!

Uncategorized
| Oct 31, 2019

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

Uncategorized
| Oct 30, 2019

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

Uncategorized
| Oct 29, 2019

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!

Uncategorized
| Oct 23, 2019

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

Uncategorized
| Oct 15, 2019

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

Uncategorized
| Sep 26, 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

Uncategorized
| Aug 13, 2019

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

Uncategorized
| Jul 31, 2019

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

Uncategorized
| Jul 17, 2019

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...)