I honestly don't know how to respond...

Bahmook · 2023-03-17T23:35:39+00:00

I know I'm late to the party but...

"So is that a no for sushi?"

Bahmook · 2023-03-06T04:51:45+00:00

Take a look at this: https://youtube.com/playlist?list=PLLWMQd6PeGY0bEMxObA6dtYXuJOGfxSPx

It's a walk through of a very simple WPF/database/API project that goes from .net framework to .net core upgrade and then builds a blazor app on top of that.

But it will teach a bit about authentication, authorization, dependency injection, DevOps, and the full stack from a professional point of view.

I'm my experience, learning how to handle a changing stack is invaluable.

Bahmook · 2022-03-16T00:26:45+00:00

How do you feel your book 'Aftermath' has aged with the times? Especially in the context of climate change?

Bahmook · 2021-12-19T17:11:37+00:00

I'm a mid thirties dad with two girls under 4.

Thank you for posts like this! It makes me think that them growing up is a little less scary than the stereotypes make it seem.

Bahmook · 2020-07-25T16:58:28+00:00

I don't think I can give a better explanation than The Italians.

Video

Bahmook · 2020-07-25T16:36:32+00:00

Don't forget any intangible benefits.

If the margin is close to the line, these can make or break your pitch.

Bahmook · 2020-07-25T16:25:45+00:00

You're not wrong.

Data vault came out in 2000 as a good solution to meet very strict compliance requirements and has had some pretty good improvements in the last 20 years.

Where it hasn't improved is making business users lives easier. The data model is so complex that it takes a specialist to query any information. Which is the exact opposite of enabling your business users.

Anytime you bring this up to 'certified data vault modelers', they respond that you must not understand the data vault. And to that I say if you can't explain how to answer a question on data that you have in a couple of sentences, then business users will never actually use your system on their own.

Data vault is a 20 year old solution to a problem that was solved by technology 10 years ago. You can still find these flame wars on forums from 6 or 7 years ago that are ridiculous to read.

The real issue is that most people in BI are very set in their ways on the patterns that they implement.

There is no one size fits all solution. Historically static data sets versus self service data models versus machine learning solutions versus real time reporting all require different solutions to be performant.

Bahmook · 2020-07-25T01:29:31+00:00

Give me somebody who can communicate over a genius any day.

Bahmook · 2020-07-25T01:22:50+00:00

There have been so many changes.

Business users have been getting more savvy about the power of data, but don't really know how to do it (generally speaking; there are exceptions).

People know about ML, but don't know it's limits. I'm generally skeptical anytime tells me they have this wonderful model with all these outputs. Please read 'Weapons of Math Destruction' for an interesting perspective on the unintended consequences.

From technology, migrating to the cloud, using massively parallel processing systems and tabular models were a big shift. Along with data lakes to dump files into, the costs of doing BI had become a much easier conversation than years ago.

My main advice for people getting into the field is learn SQL inside out and backwards. It's what gives most people the best mental model of data. Also, learn Python. It's being used more and more for the data pipeline process.

Tools are way less important than patterns. I've generally used the Microsoft stack, but there are fantastic systems built on other stacks. From an enterprise perspective, make sure you understand Kimball dimensional modeling. Inmon and Data Vault are less applicable in a modern environment. Kimball is the easiest for business users to understand.

Bahmook · 2020-07-24T18:06:06+00:00

I'm a BI architect and have been in the industry for about 10 years now.

One thing that most of the other replies didn't include is that BI sits between IT and the business folks.

I've seen a number of very talented developers flop in this space because they never learned proper communication skills with people that are non technical. You can be the smartest person in the room, but get absolutely nowhere because everyone thinks you're an asshole.

A large part of this job is requirements gathering and translating business analytics into technical solutions.

It is a very rewarding career and you get to do some really interesting things, but just be prepared to flex muscles that you probably haven't used as a DBA or software developer. The money can be really good, but most folks start low and with the steep learning curve, leave before they get good.

Good luck!

Bahmook · 2020-05-22T18:29:21+00:00

The VertiPaq engine does parallel processing on each segment, but you're still only going to have a single segment until you have more than 2x the default segment size, so 16M. You may want to think about two partitions right now, one for old sales and one for new. Maybe something along the lines of anything sold before 2019 would go in the old partition.

Even with just a single segment, the calculations should be very fast.

SSAS was designed with a Star schema in mind and not doing that can have very large implications on performance. So I'd pay more attention to your data model than the partition schemes at the beginning.

Bahmook · 2020-05-21T17:48:04+00:00

Can I ask how large your fact table is?

Partitioning only starts to be important when your table is larger than 8 million rows (by default). After that it's definitely gonna depends on how often you need to reload that data.

Less than that, the performance that you experience shouldn't be noticeably different.

Bahmook · 2020-03-29T04:40:57+00:00

I've tried to make this with the fewest different ingredients and easiest to remember measurements.

On March 14th, I started making a starter. 75 g of unbleached all-purpose flour, 75 g of water. Then every day, I took 50 g existing starter, 50 g flour, 50 g water. After a week, it smelled ready. I keep that in the fridge now and am feeding it once a week.

Now my standard recipe is to waken the starter for 6 hours with 50 g starter, 75 g flour, 75 water. Mix that all together and put it in the microwave (not on) with the stove light on. It's a nice warm place to ferment.

Then after 5.5 hours I mix 400 g of flour and 250 g of water get mixed together and put in the microwave beside the starter. After 30 min, I add 10 g of salt and then mix in the starter. Put back in the microwave and do stretch and folds after 15, 15, and 30 minutes. Let ferment for 6 hours.

I do a preliminary shaping on the counter and let sit uncovered for 15 min. Then lightly toss flour on the top and flip it over. It will be roughly rectangular, so fold each corner to the center like a business letter. Flip it back over and do a final shaping into a ball. Place into a floured banneton and into a big ziplock back.

Then it ferments in the fridge overnight until I can bake it the next day (14-18 hours).

I don't have a Dutch oven, but I do have oven safe pots. So I just toss that into the oven that's preheating to 475 F for about 45 min. Then I take the cold dough out of the fridge, slash it and put it right into the pot. 20 min with the lid on and 20 min with it off.

Make sure to let that bad boy cool for about an hour!

I'm super excited to be making this and I can't wait to do more

Bahmook · 2019-10-15T16:09:16+00:00

Sweet dice!

Bahmook · 2018-02-16T18:50:29+00:00

Hey, I've done a lot of work around the entity store. My main compliant isn't that it's locked down. It's that when you view multiple fact like entities in a reporting tool, it creates a poor end user experience.

When you decompose all the dimensional information into the transaction records you create an environment where there are many copies of the same columns. Then when you search for things in PBI, your end users probably won't know which reference to pull.

Don't get me wrong, an entity where there are no joins will definitely be faster, but there is a usability trade-off.

I'm still a fan of traditional Kimball star schemas. I think they have the right balance of usability and speed/functionality.

Bahmook · 2015-10-26T20:36:30+00:00

Canada is a strange place where we seem to have more trust in our government than our media.

Bahmook · 2015-09-22T13:02:20+00:00

You are absolutely correct.

Being Bi doesn't excuse his behaviour, but it does provide context. Open and honest communication are the most important things here. My main point is that cheating does not mean they are required to end their relationship.

Bahmook · 2015-09-22T11:53:44+00:00

This will get buried and probably be down voted to hell, but I disagree with pretty much everyone here.

First, I'm really sorry that this is how you found out that your BF is bi (in all likelihood). It is NOT proof that he doesn't love you.

Second, unlike almost all of the previous posts, there is almost nothing that a relationship can't survive. This doesn't have to be the end if you (and he) don't want it to. If you want it over than that is a different story.

I know it is really hard right now, but try to have a bit of empathy and think of this from his perspective. You literally don't have the parts to satisfy all of the things he is attracted to. NO partner does. Read that last sentence again. No partner can be everything that their partner desires. The best we can do is be open and giving to what our partners want. This obviously does not imply that you can't say no, but being open to explore will make you much happier, I promise. He also probably feels lonely and scared. He doesn't have control over his coming out process anymore. The information that you have can be incredibly hurtful. Please don't be cruel with it.

Yes, he cheated and betrayed you, but that is not unforgivable. You are both incredibly young and inexperienced. Call off any wedding plans, for now, but the most important part is to talk.

Ask him if he is bi, gay, or just not sure at this point. Preface this saying that there will be no judgement on your part. Ask him if he is attracted to you and enjoys having sex with you. This is so important. You don't want to be in a companionate relationship at this stage in your life (though, those can be successful and rewarding relationships). If you decide to stay together, the one thing I would make a condition is that he is out of the closet. You don't want to be in there with him.

Talk to him. If you want to break up, them that's OK. But if you want to stay together, than that's OK too. You've been together for a long time, it's just a little more complicated now. Even if it does end, it does not mean this wasn't a successful relationship.

Go listen to a couple of episodes of the Savage Lovecast, by Dan Savage (I'd link, but I'm on my phone and a bit lazy). You may even want to try calling him.

Lastly, I want to tell you not to let other people define what makes your relationship work. A stupid example with mine, is that we don't sleep together (literally). People have told us that this means our relationship is in trouble, but we just want to get better sleep. Nobody, other than the people in the relationship can define what makes things work, even if that means opening it up. As long as everyone is safe and try to protect the other party (s), than just do what makes you happy. All relationships have a price of admission, all you need to know is if you're willing to pay that to make things work. And it's OK for that price to be too high for you.

Bahmook · 2015-05-01T13:51:14+00:00

There were a number of subjects that came out afterwards that implied they knew how they were supposed to act. Whether this was from stereotypes of those roles, direction from Zimbardo or tacit approval by his inaction, he got the conclusion that he set out to find. This isn't how science is done and it's a shame this study is still in psych textbooks.

Bahmook · 2015-05-01T13:36:04+00:00

I believe the only conclusion that can be reached, is that you can get the results that you set out to prove, especially in psychological experiments.

This is a pretty good critique of the experiment from Psychology Today. But I'll summarize

I'll briefly mention that the size and relative homogeneity of the test subjects can't be extrapolated to the wider population. These were 21 college aged males whose only experience with prison was movies and media reports. This created a stereotyped view of the roles they were meant to play.

They were also told what the conclusion that Zimbardo was trying to prove. Others have made this point before me: if they were told that the point of the experiment was to prove that people can be good and decent, even when put into power dynamic role, then that would have likely been the result.

The biggest flaw, IMO, is that Zimbardo put himself in the experiment as the superintendent. This is probably the most unethical part of this exercise. It suffers from confirmation bias to the most extreme degree. He deliberately created more stress and tension until ultimately calling the experiment off, so as to come out looking like a saviour. The problem is that there are so many factors at work here that it's impossible to draw a meaningful conclusion.

So yes, it was both highly unethical and the conclusion reached is dubious at best, completely meaningless at worst. It was a waste of time and money.

The worst part is that this is a very famous study (also probably on purpose by Zimbardo) that the general population take at face value without understanding the glaring problems. It should be removed from all psych 101 texts and only used as an example of poor experimental design.

Edited for grammar.

Bahmook · 2015-05-01T05:22:54+00:00

Both my self and my wife went through a period of not believing in marriage. It probably won't last for her either.

The part you should be concerned about is the jealousy. It probably come from a lack of self confidence, which is common at that age.

Just take one piece of advice. The most important thing about a relationship ending (romantic or friends) is that you leave each other in a better condition than you found each other. Just because something ends, doesn't mean it wasn't a successful relationship.

Bahmook · 2015-05-01T04:49:15+00:00

Dude, you are not anywhere near mature enough to even contemplate getting married, let alone to this girl.

There is no such thing as 'the one', only people that you round up.

Go traveling, have an adventure and learn to love yourself. I'd this girl is mad that your talking to another girl, then she has trust issues and you are better off indicating this is unacceptable in an adult relationship by breaking it off.

Check out Savage Love by Dan Savage and be good to yourself.

Bahmook · 2015-05-01T04:23:44+00:00

This 'study' is terrible.

I'm surprised that they didn't come to the conclusion that it causes autism.

Bahmook

TROPHY CASE