Month Over Month and Newer Schtuff- Power BI

Today’s Post is brought to you by Patrick LeBlanc of Guy in a Cube.  I learn best by doing, so I was working with different features while watching along on Quick Measures:

As a newbie, yes, I had problems with my quick measures just as Patrick said I would, but with a twist-  It wasn’t that I didn’t want to learn DAX, quite the opposite, I could get the expression to work just fine  (more...)

Data Modeling, Dates and DAX

Presenting data in the format to ease visualization is required for any BI product.  Power BI provides much of this with Data Analysis Expressions, (DAX).   As a DBA, I admit to cringing every time a reference was made how similar it is to functions in Excel or other non-database platforms.  I’m a DBA and I naturally am going to see data at a much larger, more complex level.  I love (more...)

I Got Here On My Own

Click bait worthy title, eh? 🙂

That’s what I thought after I read the article from the Harvard Biz Review with the lead in comment, “Women who have already made it to the top say that the only person who will get you there is yourself.”  I found this utterly misleading and the article missing many of the important areas, proving this incorrect.  We are highly critical of women and we’re uncomfortable with women’s ambition, (more...)

Automation and Analytics

They say the devil is in the details and as I come from the DevOps side of the house, it would only be natural that I’d be attracted to how Microsoft Flow works with Power BI.  For those that aren’t familiar with Microsoft Flow, think of it like If This Then That, (IFTTT) from Microsoft.

I used IFTTT to automate a number of tasks at my previous company-  everything from posting to social (more...)

Power BI and the Speed(ier) Desktop

I can be an extremely impatient person about anything I think should be faster.

I’m diving in deep with Power BI and for most of the early on lessons, the data sources used are Excel and…ahem…Microsoft Access.  I don’t know a DBA alive that enjoys working with Access.  Its great for the common user to have a database application, but we can barely use the words “Access” and “Database” in the same (more...)

The Journey Begins- Power BI and AI

I’m back!!  I know you missed my posts…be honest…. 🙂

So its time to start drinking from the fire hose and its important for me to go back to the very beginning, start from scratch and learn from A to Z.  I learned Power BI on my own and there is undoubtedly pieces missing from my knowledge base that need to be filled in.  No way I’d be able to spell if my A to Z (more...)

First Day at Microsoft, the Satya Way

So I’ve finally crawled my way back out of the hole I dug myself in this last month.  The house is empty, the 5th wheel is ready for us to move into and I’m not in Redmond, doing my NEO, (New Employee Orientation.)

I swear this is all I see in my head every time I hear “NEO” 🙂

D&I Epiphany

The first epiphany is that Microsoft, unlike most companies, is really walking the walk (more...)

Time is Gold

So many have asked me when I’m starting at Microsoft and the official date is Monday, June 11th now.  Many also wonder what my upper limits are on how much I can handle, well folks, it looks like we’ve reached them!

I was supposed to start this last Monday, but as my last day approached, it became all the more clear that there was a need to change my ending and start date.  Individual deadlines (more...)

This is GDPR Reality

How many updated policies for use of personal data did you sign off the last couple days? As I had observed the EU procrastinating on their compliance for General Data Protection Regulations, (GDPR) until December of 2016, (it went into effect in April, 2014 with a deadline in the EU of December, 2016) I wasn’t surprised that we’re seeing a flurry of requests to sign off on data usage this week. The deadline is tomorrow, (more...)

Time for #GLOC, #SQLSatDallas, #DataSummit18

The next nine days, I’m traveling to three cities for four events. We’ll just call this the 9-3-4 gauntlet of speaker life. I booked this travel as four, one-way flights to get the itinerary
I needed to make the most of my schedule and will have breaks between each event to make sure I don’t kill myself my last two weeks at Delphix.

GLOC

Today I’m heading to the Great Lakes Oracle Conference, (https://gloc.neooug. (more...)

Be the Change You Want to See In the (Tech) World

The only thing that stays the same is change….

As the time flies by and the world turns, I often am jarred back to reality when I discover how the little things we do can have a larger impact on the world around us.

Flying back from Interop ITX and StarEast conferences last week, I was reminded of this.  While reading the latest copy of Wired , I came across a story on D-Tech (more...)

Broadening Your Audience

I spent this week speaking at two conferences that may not be familiar to my usual crowd:
Techwell StarEast Testing Conference in Orlando, FL
Interop ITX Data Conference in Las Vegas, NV

StarEast Testing Conference

Techwell’s event is attended by testers and had over 2000 attendees at the Hyatt Regency Orlando’s Convention Center. This is a huge convention center and I won’t lie- I did try to first register at the Mazda event (more...)

StarEast, InteropITX and GDPR

I’m getting ready to get on a plane between two events today and have been so busy, that there’s been a break in blogging.  That’s right folks, Kellyn has let a few things slide….

For those people on top of all the happenings in Kevlar’s life, I’ve been busy removing 15 years of possessions from my home so we can sell it in the next month, along with the purchase, upgrade and consolidation into a (more...)

Lady Coders Conference, Denver 2017

This weekend I’m not going to have to say, “No, this is not my husband’s code” for a change.

This weekend will be about supporting everyone in technology and how technology will benefit by making everyone part of tech.

This event is the brain child of my peer, Elaine Marino, owner of Equili.  Equili’s mission is to “To build a stronger, more diverse tech community that levels the playing field for all underrepresented and underutilized (more...)

DMV for Log Statistics in SQL Server

There aren’t too many changes to the Dynamic Management Views in SQL Server 2017, but one was mentioned that I worth a second look and often have a lot more going on than upon first look.

Gif Credit: ancsy55.tumbr.com

DM_DB_LOG_STATS

This is an addition to SQL Server 2017 and available in Azure Database/Azure Data Warehouse to simplify and synchronize how we query information about log statistics, not just backups.  The added benefit (more...)

GDPR Solutions in the Day of Automation

There’s something for having job security and many of the solutions that I see offered for RDBMS challenges offer just that. With compliance with EU’s GDPR, (General Data Protection Regulations) just around the corner, (mark you calendar, May 25, 2018) you’d think we’d all be scrambling for a simpler solution to discovering and addressing all that GDPR data.

Quick refresher for those of you going, “What is GDPR?”

Data security is a known focus (more...)

Where in the World Has Goth Geek Girl Been

I’m on track to fly home tomorrow, March 11th after nine days and three events.  I’m pretty exhausted and just ready to go home and catch up on some sleep…:)

I started out last weekend in Victoria BC and was thrilled to be on this emerald island of the Pacific Northwest.  British Columbia is gorgeous as it is, but Victoria is a special place that quickly became one of my favorite places in (more...)

Can You DIG It?

As I dig deeper into Linux for the SQL Server DBAs and for Oracle HotSos, I’m digging into DIG.  Yeah, I went there with that first sentence….

What is DIG?

DIG stands for Domain Information Groper, (no, not that kind of groper…)  and it’s an important part of deeper Linux learning for all database technologists.  You can’t connect to data if you don’t know how to get from point A to point B (more...)