Testing is <redacted by HR>

Cool your jets. I’m not talking about Certification tests or the like. I’ll leave that idea to ponder on later. I’m talking about at an earlier level: elementary school. (Warning: Rant Coming.)

In the US, elementary, middle/junior-high, and high schools generally administer tests throughout the year “to understand their students’ needs and to personalize their teaching methods”. What they often don’t say is that they use it to place kids in advance classes. What’s that you say? That makes complete sense? While it may seem like it on a surface level, I encourage you to think about it a little deeper. Because it’s a circular loop that grants some kids benefits that result in more opportunities later in life, even though their initial ability was no greater.

Think about it. Most of the time you aren’t even told when these tests are coming. Maybe your kid didn’t get enough sleep one night, has an illness coming on, just got in a fight with their BFF, or whatever. BOOM! They take a test. A test that determines if they are able to get into some extended learning program or not. A line is drawn in the sand and those who meet that number or higher get the option to have advance learning taught to them.

The score that is often used is based on a percentile, sometimes from a previous year. Does the child’s score fall into the 95th percentile? So the next time the kids are tested, the kids that have had higher learning taught to them in class, are way more likely to be in that top percentile. Knowledge is cumulative, and there is a direct correlation to kids that are receiving this benefit to having a higher score during the next testing period.

Let’s give an example: Maybe your third grader isn’t taught fractions yet (I have no idea when fractions are taught, so maybe this isn’t an exactly accurate example.) But one day, Joe looks at his older siblings book and learns something about fractions. Ok – good job Joe and good job Joe’s sibling for not cleaning up. Joe’s able to answer that question on the achievement/growth test. (Incidentally, at this level the difference of 1-2 questions can really affect where you fall in the percentile depending on the question.) Joe’s put into the extended learning program (ELP).

But maybe Sally is an only child or may she had a bad day. She doesn’t get the fraction question, and thus is 5 points lower than Joe. She doesn’t get ELP. Her ability may be exactly the same as Joe’s, but she will not get the extra math that Joe is receiving by being in ELP. A few months go by, and now Joe has learned a ton more in ELP (as well as the other children there) and they all are in a higher percentile (because they’ve formally learned more) than children not given that opportunity. By middle school, they are put in more advanced math classes and thus the cycle continues.

Let’s further complicate this by adding gender. As a mom of twins, I can tell you the social structure of girls is WAAAAAYYYY different than boys. And maybe not all girls follow it, but geez louise, some of the stories I could tell you starting over 25 years ago are startling. Girl culture can be super complicated and intense. I mean seriously – 2nd graders in full blown psychological warfare against each other for MONTHS.

I once had a 7 year old girl call another 7 year old girl from MY HOUSE, unbeknownst to me, to tell her not to come to my son’s birthday party. She told the other girl that my son didn’t want her there. My son had no idea that the call even occurred. WHY did said caller do it? Because she had a crush on my son. That was not a fun conversation to have with the callee’s mom BTW.

All this to say, I’m willing to bet that the stress that comes with the complicated lives of young girls, may also, occasionally, result in just an ever so slightly lower score on the one test that changes everything when all other things are equal. And I haven’t gone down the rabbit hole yet, but I’ll bet there are other things besides stress with girls that can have an adverse affect. And that’s just the tip of the iceberg. The same concept could apply to many kids: neurodiverse, POC, stressful conditions at home, etc.. An entire group of kids, with the complete capability to be able to learn the higher level math, are not given the opportunity.

What’s that you say? Teach it to them yourself? Yep – great idea and we do it that in our family, but not every family has that option. Single parents, lower educated, overworked, sick, caregivers, etc.. all may have limitations on being able to do additional at-home education. Even free options for students like Khan Academy (which I love BTW), may not even be available or known to many parents.

I don’t know the answer, but as someone who is personally having to deal with an unresponsive school system about a highly advanced young lady that is fully capable and willing, I’m mad. I’m mad that the boy in the family is being given the chances from the school, while the girl is not. And with everything being the same for both kids learning at home, he’s been advancing more because he gets to have extra time at school with more advanced topics. All because of a few points on 1 test many years ago.

Have I made you mad? Good. Now what are we going to do about it? For all those kids missing out.

Synapse Link Error: Can’t find the environment

On Today’s episode of “What’s the Problem in Synapse Now?” we take a look at Synapse Link for the Dataverse (shocker – I know.)

Let’s get right too it – we are talking about the error message: “You have not linked a Dynamics 365 Finance and Operations environment. Link an environment to see tables. See https://aka.ms/FnOTablesInSynapseLink“*. And oddly enough, our D365 F&O tab will have some variation of x of 0 selected.

Wait a minute – this was working perfectly fine a few days ago – ok – that may be – or maybe this is your first go at it, either way you are going to use the same solution.

So what do you do? Simple, close the managed tables tab. Next, and just as a precautionary, make sure you are in the correct environment, and that the environment is running. It’s not uncommon for lower environments to have a nightly shutoff switch. That’s probably not the cause, but it doesn’t hurt to check.

Now that you’ve checked the environment and have ruled that out, let’s discuss a common cause: your authentication has gotten boogered up. That’s the technical term for it: BOOGERED UP.

If using Managed Identity (which you should be), then the easiest fix is to click on that button at the top called Use Managed Identity.

That’s it. Soon you should see some movement for anything currently in place or if you were adding/changing some current tables, click on the Manage Tables button again to get back to where you were. Your error will hopefully be resolved. If you didn’t use managed identity with D365 F&O and Synapse Link, you may want to revaluate your life choices like I recently did. (JK – kinda of.) But if you didn’t, then you’ll have to make sure your storage account can talk to your Power Apps D365 F&O Synapse Link. I’ll save that rabbit hole for another day.

* Note, there is actually some good stuff in the link that the error message provides which at the time of this writing, resolves to: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-select-fno-data
It’s a lot of information so hopefully this tip will save you a bunch of time reading through the whole thing. But if you are starting a Synapse Link for Dataverse from scratch, or if this post doesn’t correct your issue, definitely go back to that link and step through each part. It won’t be your first or last visit…

An Important Post About Women Speakers

As I try and balance speaking, taking over a user group this last summer (more on that later), and life in general – I’m reminded of this important post by Deborah Melkin a wonderful speaker, community advocate, and all around great human being. Please take the time to read.

Why Data Work Mom?

A few years back, a junior associate and I were out to lunch and he informed me that I was the official Work Mom for our company. Our company only had a few senior people, no HR, and lots of junior people. Evidently I had become the go to person for all things data and “off the record” related. How to deal with a client that screams at you? Go talk to Kristina. How to do that thing in SQL? Go to Kristina. Feeling overwhelmed and burned out? Kristina. Want to know how to get to the next level? You guessed it – Kristina.

Given my adult son was similar in age to most of our junior staff – it really made sense. A dose of pragmatic, from someone who cares. For anyone that wanted to succeed, I wanted to help. I was tired of all the websites and people moaning and groaning about millennials and Gen Z – their expectations made sense to me. (Incidentally, I think this is why females in my generation potentially make great leaders for younger generations – but that’s a topic for another day.)

The more I thought about being a work mom, the more I liked the idea. Because I like being the person you trust with your professional problems; be it data related or not. And with decades of experience, I’ve helped people of all generations along the way. So here I am: your Data Work Mom. The mom that wants you to succeed. No matter if you are 12 or 82. The mom that also learns things along the way and passes it on.

This blog will serve to help others learn data related topics, find reliable resources, learn architecture/engineering topics, alert you to happenings in the community, assist in lifting people up, discuss leadership topics, and include things that fall into that “off the record” category. Technical items will mainly focus on Microsoft products such as SQL Server, Azure, PowerBI, Synapse, etc. – but that may not always be the case. I’ve done a lot in R, Python, AI, and some may be published as is – irrespective of the platform. I may even sneak in some Google CoLab from time-to-time and general theory topics that are not restricted to any one platform or product.

Let’s get to work!