Hey Guys,
I've got a bit of a problem I'm working on. It seemed like an easy problem, but I'm running into lots of issues. If anyone has any tips, I would appreciate it!
So I have lots (just over a hundred) of SQL express instances running on essentially POSes. When a transaction is made, an entry is made to a table. At the end of the day, the application also updates a couple other tables with a bulk insert.
I want to replicate all that data back home so it's all in one place to query (SQL Standard). As near real time as possible/reasonable.
My plan was to setup merged replication with the central server the publisher and the site the subscriber. That mostly worked (with some tweaking), but bulk inserts do not fire triggers, so those entries do not replicate. I could setup a separate job to update the bulk inserts to fire the triggers, but that's pretty hacky and not ideal.
Is there a better way to do what I'm trying to do? Some SSIS package that will be annoying to maintain (although I'm worried these subscriptions will be annoying too)? Log shipping?
I feel like this should be a pretty common problem, but I can't find anything. Am I going about this completely wrong?
So, you all know I post my relationship stuff here. I this space as a place to collect my thoughts and share things that I normally can't share in my day to day life. Ready? Here we go.
My sister texts me Friday night. She's pretty upset about something and wants to meet with me and my brother ASAP. We arrange to meet for breakfast the following morning. I have no idea what she wants to meet about, but I'm assuming it's something about my Mom (who I think has started drinking again occasionally...). She made a slightly odd request about meeting somewhere other than her house, so I was kinda suspicious that maybe something is up with her relationship... But probably it's just something about Mom.
So we meet up, we start eating breakfast and she tells us that she's been having an affair for the last 6 months and her husband caught her with the guy the previous day. She's apparently been dating her boss (the CEO). This guy is fucking 60 years old! (She's 30) Oh, and they are in love.
Meanwhile... this guy is also married and has 5 kids (some that are the same age as my sister). My sister has a 9 month old infant, meaning this whole thing started when the baby was ~3 months old. Apparently this guy was going to tell his wife about the affair yesterday, but I have my doubts. I am skeptical that he'll give up 1/2 of everything -- including his company I'm assuming -- to his wife. We'll see I guess.
So my sisters marriage is over. She can't go back to her job that she loved. She's basically a single mom now. Stupid fucking choices.
My sister's (future ex) husband has been working really hard lately. He had a full time job, while simultaneously working toward an MBA, while also having a newborn. That's a full workload. My sister said that she felt that he wasn't spending enough time with her and felt lonely, so she went to find affection elsewhere. I get that, but there is a right way and a wrong way.
I'm pretty pissed off for a couple reasons. 1) This guy is twice her age. 2)Her husband got royally fucked over. 3) Her baby will never know her parents together and will have to perform the 'divorced parent shuffle' for the rest of her life.
Are you having problems in your relationship? TALK TO THE PERSON YOU LOVE! Tell them how you feel. Feel lonely? TELL THEM. Want more touch? TELL THEM! A relationship runs on trust, and that includes telling your partner when you are unhappy about something. How can your partner make you happy if they don't know what you need?
I'm about 2 months in to dating another woman.
I met her on Tinder. I was bored one day and feeling a little lonely, so I updated and reactivated my tinder profile. Tinder seems to give you a pretty big visibility boost if you have been inactive for some time, so I was able to get a match within a couple hours.
Her name is Jasmine. She's a Speech Therapist that helps people with various levels of disability communicate. I would classify her as a book worm type. We've seen each other about 10 times and so far, things seem to be going really well.
My love language is touch, and I really like how she touches and caresses me. Little things like touching my waist or a gentle touch on my cheek make me feel good.
It's been over 4 years since my wife and I opened our marriage. This is the most serious thing that I've found so far. I'm really enjoy spending time with her. I think that this has the potential to at least last for a few months. Who knows... I'm enjoying the moment though. It's taken a lot to get here.
When I was looking back to see what number this entry was in my 'Relationship Hacking' series, I see that the last Journal entry was when I wrote about having problems getting it up on an earlier date. On my first date with this woman, we had a pretty normal first date. We met at a restaurant, shared an appetizer and had a couple drinks. After a couple hours, she invited me back to her place. I, of course, said yes, and we went to her condo. I couldn't get it up for her either.
Since that first date, I haven't had any issues. Most times we can go at it twice in an evening. Apparently I physically can't do one night stands. I think i get way too nervous and that just shuts things down. I guess I need to feel comfortable with someone first, which makes sense, but it's against the stereotypical male image of always being ready for sex.
Tomorrow, November 15 @ 04:40UTC, the biggest computer battle that has ever happened will take place.
The Bitcoin Cash network is secured by about 5EH of compting power (5,000,000,000,000,000,000 dSHA256 hashes/second). At the moment, a malicious actor, Craig Wright, is controlling about 75% of that power. He intends to cause a hard fork on November 15 and make BitcoinSV the leading Bitcoin Cash implementation.
His goal appears to be to destroy Bitcoin Cash. His twitter feed (seriously, check this out) has become crazy over the last few weeks. He appears to want to take away the permissionless aspect of Bitcoin Cash. Transactions that use 'non-allowed' op codes would become recoverable by miners (of which, he is conveniently, the majority miner). He also talks of recovering funds from addresses that have been inactive for a long time. I believe that the end goal is to recover Satoshi's coins.
In just under 24 hours, the war will start. It is likely that hashrate will be diverted from BTC to defend this attack. This will result in lower hash rate for BTC, slower block times, and likely transaction congestion.
During this time, block reorgs on the bitcoin cash network are likely. Transactions may be undone during the attack. It is also possible that only empty blocks will be mined, preventing any transactions from occurring.
There is also speculation that 'poison blocks' will be used as part of the attack. The new SV client allows upto 128MB blocks. However, the current software only has a throughput of ~22MB before other limits come into play. It is speculated that Craig Wright will use malicious pre-computed blocks to 'poision' the network. These blocks would take a long time to validate on honest nodes giving CW an advantage.
This is going to be an epic battle. It's the most expensive computer attack to ever be launched and is going to be a critical moment for the future of all cryptocurrencies, not just Bitcoin Cash.
It's going to be interesting... information during the attack can be found here: https://reddit.com/r/btc and here: https://cash.coin.dance/
EDIT: Ars just picked it up.
On or around November 15, 2018 Bitcoin Cash will undergo its 3rd hard fork. There has been quite a bit of drama over this upcoming fork. On one side we have Bitcoin ABC, and the other we have BitcoinSV.
When Bitcoin Cash was forked from the original Bitcoin on August 1, 2017, it did so with the Bitcoin ABC code. When that happened, the Bitcoin ABC implementation became the de facto reference client. In my opinion, while Bitcoin ABC has done great work on progressing the Bitcoin protocol, their communication and community involvement leaves something to be desired.
Bitcoin ABC has proposed and implemented a few changes for the upcoming fork. The biggest and most controversial of these changes is something called Canonical Transaction Ordering (CTOR). In the current implementation, transactions can be included in a block in any order. If/When CTOR is accepted, then transactions will have to be ordered in a specific way.
CTOR offers some advantages with block propagation. There are a number of technologies (Compact Blocks, Thin Blocks, Graphene) that allow faster block propagation. Essentially, when a block is found, the block needs to be propagated to the rest of the network. As blocks get larger, the time to transmit the block also increases. In order to propagate blocks to the network in a timely fashion, Bloom Filters are used. Having a fixed order of transactions inside a block means that the order of transactions don't have to be transmitted to propagate a block. This results in a significant (>50%) reduction in data required to transmit a block.
On the other side, we have BitcoinSV. Craig Wright is BitcoinSV's Lead Scientist. He has been claiming for several years now that he is the real Satoshi. Gavin Andresen (one of the earliest Bitcoin coders) even agreed that Craig Wright was Satoshi. Craig started a company called nChain that has been working on their own implementation. They are closely affiliated with Coingeek who operates a mining operation/pool.
There have been criticisms of both sides. Criticisms of Bitcoin ABC's CTOR include that it's too big of a change too fast. Changes to consensus rules should happen very slowly and be tested very thoroughly. Impact on CPU usage is not fully understood at this time and if there are any bugs in the CTOR implementation that could result in an unintended chain split.
On the other side, we have BitconSV and Craig Wright. Craig is a character. He constantly makes outrageous claims and consistently fails to provide any proof to his claims. Any papers he produces contain mostly plagiarized content. His personality would definately fall into the 'asshole' category. BitcoinSV did not have any publicly released code until several weeks ago -- Way too late to be taken seriously IMO.
Craig has made claims that there will be no chain split. He has stated that his BitconSV implementation will win and he 'will prevent' a chain split from happening and will use his hash power offensively if required.
So here we are, two weeks away from the date the fork must occur, and no one really knows what will happen. We are about to witness the first true 'Nakamoto Consensus' hash war. It's going to be exciting to watch.
My predictions: Bitcoin ABC will easily win (will be clear winner in less than one hour). BitcoinSV was released way too late in the game to be taken seriously. They do not even have a testnet. How can we even know that it will work as advertised?
However, will the minority chain persist? There is intentionally no replay protection as part of this fork, so a transaction submitted to one chain will be valid on the other chain. People have stated that they will be replaying transactions from each chain to the other. There are still ways to force your coins to split however.
My prediction on persistance is that the minority chain will persist for quite some time (months-years), much like Bitcoin Gold persisted. It will have very little value, but it will have some value.
There's never a dull day in Bitconland.
DRAMA UPDATE!!!: Craig Wright says that he will blacklist any address that uses a new op code introduced by Bitcoin ABC. Very un-satoshilike.
Mike, assuming you have a normal sized kidney, tomorrow you will be approximately 150g lighter... Unless the surgeon leaves some tools inside you, then it will be a little less.
I'm sure you are in good hands and I hope everything goes well and I look forward to you getting back on here and posting random Unix commands and updates on your current mental state.
Godspeed MDC, godspeed!
Three weeks ago, I got a call from my brother. He said that Mom had fallen and that my Mom's roommate wanted to call an ambulance. I didn't think too much of it. Maybe a broken bone at worst. Anyways, the ambulance took her to the hospital. I called the Emergency department at the hospital an hour later and they said that they think she had a stroke and that I should get there ASAP.
I live close to the hospital, so I was able to get there in about 10 minutes. I was rushed in and was sat down by a doctor who explained that my Mom had a pretty severe stroke caused by a blood clot blocking the artery delivering blood to the right side of the brain (affecting the left side of her body).
The doctor was a researcher and said that he was working on some sort of medicine that (as I understand it) messes with the cell death process with the hope of keeping more of the brain alive that would otherwise have survived without the drug. It was still in trials, so it was a double-blind test and we wouldn't even know if my mom got the drug or a saline solution until some time next year.
Anyways, we (my siblings and I) decided to try it out. It was weird to be deciding something like that on behalf of my Mom. Hopefully we decided right. During all of this, my mom was in surgery to remove the clot. They were able to successfully remove it and she was moved to the acute stroke unit.
It was jarring to see my mom in that condition. She acted like she was pretty heavily sedated, although she was not. While she was able to move the left side of her body (hands and feet), she was extremely weak. She could not hold her arm up for more than a couple seconds. Her face was droopy and it was hard to understand her.
It's been three weeks now since that night. She has since been moved to a short-medium term care facility that feels like a nursing home. They take excellent care of her there and she has been recovering well. She can walk unassisted for very short distances (like 20ft) and further with a walker.
I think that she will be able to mostly recover in the coming weeks and months and should be able to go back to living alone at home.
I am noticing some changes though other than the expected weakness in the left half of her body. She seems to be laking emotion. I don't know how to describe it, but she just seems flat. I don't think she has laughed once since the stroke. She smiles, but it doesn't seem to be a genuine smile. I don't think she has cried despite the life changing event.
My siblings and I all agree though that she has gotten funnier. It's like a little bit of that filter is gone, so the makes some quite funny observations.
I am SO SO SO thankful for our Canadian health care. The doctors and nurses have all been amazing and patient. They took the time to make sure I knew what was going on despite them probably telling the same thing to my brother/sister earlier that day. The nurses have been caring and kind. The hospital stay, operation, drugs, short-term care facility, physiotherapy, occupational therapy, meals, and nursing care is all covered. The only thing we have had to pay for is parking. We are very fortunate.
So, that's why I've been kinda missing here the last few weeks.
So, the dating world, there is a term - Catfishing. I guess that is the practice of using someone else's photos that are super hot and then basically trolling people. There is apparently a lesser form of this called kittenfishing where you use deceiving photos that are actually you, but are not exactly truthful. Last week, I was kittenfished.
I started chatting with a woman on OKC. She had only two photos (flag #1) of her, and both were from the same angle (flag #2). She looked really cute, so I messaged her. There was a pretty good exchange of messages. She eventually dropped a hint that she might be fat, so I asked for some photos that showed her body.
Now, this is where I feel bad. I'm sure it can be difficult being a fat woman. I asked for photos as nicely as I could - "Hey, so I love your pics, but I notice that you only have two photos that are practically identical to each other. Do you have any photos that show your body that you would be able to share?"
To her credit, she did share actual photos that showed a rather large woman. I've dated a larger women in the past who I got along with well, but I wasn't attracted to her and it didn't work out. I will not do that again.
So, anyways, she posts actual pictures that show her body. I said thank you, and complimented her dress. The next day, I sent a message saying that I didn't think it would work out because I felt that I had been deceived and that deception is not a good way to start a relationship.
She didn't take that well. Here are the last two messages of the exchange:
ME> So I've had some time to think and I'm sorry, but I don't think that it would work out. I really enjoyed our conversations, but ultimately I feel like I was misled.
> I Understand that everyone cherry picks some of their best photos to post to dating websites, but I believe that the photos should reflect the person that you will be meeting. Starting a relationship on deception is not a good way to begin.
> I'm sorry things had to go this way and I hope you eventually find what you are looking for.
>Take care,
>-- Snow
-----------------
HER> I've been thinking about this as well. We would not have progressed past being frientds ...as sitting in Church on a Sunday knowing I was dating a married man would have made me a rather large hypocrite.
>But since you have brought up the subject... You asked 'my story' In it I said... 'Currently I am good enough to fuck but too fat to date.' That should have been a big fucking indicator as to what I might actually look like body wise.
> I have my reasons as to why I don't post body shots. After the 100th message of 'Hey wanna Fuck' I hope you can at least appreciate why...then again maybe you can't...hopefully one day you will. If it's imperative to see my body...fine...If it's not to you liking...fine...there is the door don't let it hit you in the ass on the way out. You are not the first...you damn well won't be the last...and make no mistake on this...the loss is never...EVER...mine
> I wish you all the best in your future endeavors...
> So Long Boyo...
> HerName
** She disabled her account **
I feel pretty bad. I'm sure it's tough being a fat woman doing online dating. I was caught between a rock and a hard place. I didn't find her body attractive at all and I'm not going to go on a date with someone I'm not somewhat excited about. I did feel mislead and I was hoping that by telling her that, she would realize that deception up front leads to disappointment later. Maybe I should have just said 'Sorry, this isn't going to work out' and left it at that. I wanted to call her out on the photos though.
Anyways, I hope I didn't break this poor woman who obviously had body issues and had had a rough time dating. I don't feel good about how that one ended. I honestly don't know if I'm the asshole in this situation or not, so I'm here asking SN.
So, SN... Am I the asshole here? Please place your judgement below.