Speeding up Power BI Interface for sp_Blitz/First Responder Kit

So Tracy Boggiano told me about the great First Responder kit that Brent Ozar had available to use with sp_Blitz using Power BI desktop for a UI, but that it was really slow to non-responsive as data grew. As this was focused on performance data and also included my new love of Power BI, I asked to take a look at it. Tracy was kind enough to send me a copy of her database and (more...)

Women in Tech Book and Upcoming SQL Saturday Events

Its been a busy holiday for me. Tim and I spent the days traveling since the weekend after Christmas until January 2nd moving the RV from California to Texas. I’m not the biggest fan of the Southwest- I just like green and water too much… 🙂

Crushing IT Bias Book

The evenings and nights were spent finishing up my book on Women in Technology, called “Crushing the IT Gender Bias” with Apress. I’ve been working on (more...)

Ode to Azure Cloud Shell on Christmas

When I arrived at Microsoft, I knew I would hopefully get to use my Linux skills for more than teaching SQL Server DBAs about Linux and was pleasantly surprised as I began working in Azure to find that, of course, it’s ALL LINUX.

After almost six months at the company and coming into the Christmas week, I’m thankful for all the technology I’m working with and what many assume that Microsoft won’t be about-  the (more...)

Clean Data = Happy Analytics

I just finished cleaning up the example data that I was offered for my own demos and solutions. Working in Education requires you use education data to ensure what you’re presenting resonates with the users you’re working with. Otherwise you just look silly presenting something that makes utterly no sense to the individual you’re hoping to impress.

Having been given the gift a large data set from demos and solutions, I quickly took the data (more...)

Visual Studio 2017 Incompatibility on *PROJ/SLN Files

Upon joining the Analytics and AI Team at Microsoft to support education, it became quickly apparent that my automation skills were needed more than getting me up to speed on Power BI.  My predecessor had built some great solutions, but to be more scalable, it would pay forward in the end for me to do the automation work, knowing I’d be granted a greater understanding of the products in the long run.

See the source image

The task (more...)

Extended Events with Azure Analysis Services

Its almost standard fare to be using Azure Analysis Services with our customer deployments these days.  As our customers evolve the value of their data.  SSIS integration runtimes were pivotal to this and now that there is Azure Analysis Services, it’s even easier to get started with just a few clicks in the portal interface, (or for me, a simple step in a script… :)) and migrate runtimes to the cloud.

One of (more...)

That’ll Be Fun

I have a t-shirt that says, “Underestimate me, that’ll be fun” on the front of it.  This statement pretty much sums up my life and I continue to both impress and annoy people, which means I’m living up to it.

The session evaluations came out for PASS Summit and I was surprised by some of the reviews I received.  The opportunity to under estimate you is kind of expected.  I’m pretty comfortable (more...)

Sizing Up #SQLPass Summit 2018 After the Fact

This is my third time attending PASS Summit and second time as a speaker.  I applaud the PASS organizers, the community, the volunteers, the sponsors and the attendees for another incredible event.  In less than four days, I came home and tried to isolate one defining moment from the event and it was impossible to do so.

My Scrutiny

I love RV life and I thought I’d be just find with customer and (more...)

PASS Summit, Women in Technology ROCKS!

PASS Summit 2018 is the 16th annual WIT luncheon.  Many of the men are wearing kilts in support of the women in the SQL community, (it’s a thing here…) there’s a luncheon, there’s special panels and highlight on the women authors and speakers.

 

Women in Tech Speaker

The WIT speaker was Lauri Bingham, the Director of Technology Engineering Project Management at T-Mobile.  

Lauri shared her early life, the challenges her mother (more...)

PASS Summit, Day 2 Keynote!

After a long night in a coma to restore my energy expel for the first day of Summit, (anyone else exhausted already???)  I showed up bright eyed and bushy tailed for the second day’s keynote and the blogger table.  

Me this week…

PASS Time

The awesome Wendy Pastrick started us out letting us know what goes on behind the scenes deciding how PASS makes decisions…and then broke into song.  She will survive…. (more...)

Pass Summit 2018 Keynote 11/7

So I made it to PASS Summit 2018.  After a flight from an airport with one gate-  yes, you heard me right, one gate.  No Wi-Fi, no connectivity and four employees at the airport.  It was a new level of disconnect.

After a number of parties last night, I’m at the bloggers table for the first keynote this morning.  The first keynote started with an energized talk from PASS president and (more...)

PASS Summit 2018- Times up!

I’ve had my nose to the grindstone for almost four months now investing my brain in new technology, reinvesting fully in performing technical work and prioritizing it all to ensure that I’ll be successful.  I stepped back from many speaking events to make sure my private and professional life would succeed in this transition, but that doesn’t mean I would skip PASS Summit.  What I didn’t expect was the event would arrive so quickly and (more...)

Dynamic Firewall Creation for Azure Cloud Shell

I’ve been hesitant to post too much on my blog until since the hack, as there were some residual issues after the restoration of the site that took a bit to correct.  I’m finally feeling confident enough to start posting on everything I’m doing currently working with Azure and the education customers for Microsoft.

One of the powerful tools I’ve been taking advantage of is the Azure Cloud Shell.  This cloud tool has (more...)

Let Them Finish, Stories From the Trenches

The first of three books that I’ve been working on this year is out!  From Melody Zacharias’ “Let Them Finish” series, this is the Stories from the Trenches, a collection of stories about diversity in tech and how to survive and overcome the challenges.

Second Book in the Let Them Finish Series

The book can be picked up via hardcopy from Amazon and a Kindle version is around the corner, if like me, (more...)

Simple Template Pull In Azure

 

The I’ve been busy automating a solution we provide many of our Education customers that I discovered, due to a variety of technical skills, was hindered on using the solution while spending significant time deploying it.  New to Azure, I wanted to use templates with a bash script as my first deep dive into auto deployment, but was frustrated with the auto deployment templates “JSon’ing me to death”.

I wanted to quickly post (more...)

Ignorance is Bliss, Until it Isn’t

My blog was hacked last week, deliberately and maliciously.  I was hacked because my lacking knowledge in the area of website management and saved by my control issues as a Database Administrator.  It was a valuable lesson to learn in regards to being a woman in technology and new technical skills.

If you ask most women, they’ll most likely say that they haven’t had too many difficulties with men harassing them, especially if (more...)

Use Azure CLI…I Beg You.

FYI-  this was the one post I had to restore manually after my blog was hacked a week back.  Its intact, but the post may appear a bit different than before, as I copied and pasted from the emailed version that occurs as part of my RSS feed.  Enjoy!

Azure CLI made me feel right at home after working at Oracle in the Enterprise Manager CLI, (EMCLI)  The syntax is simple, powerful and (more...)

Three Months at Microsoft

Time Flies when you’re having fun or when you’re crazy busy-  I’m unsure which is more true.

I just completed my first review as an employee at Microsoft and good news!  They’re going to keep me. 🙂

I still get a number of questions surrounding my job at Microsoft.  Since I worked for Oracle for 2 1/2 years, much of it speaking between customer engagements, many didn’t realize that I started out, and have always been, (more...)