The Official Status Thread
-
@weng said in The Official Status Thread:
@tsaukpaetra If you're using a modern version of SQL server (or any competitive product) fuck your trigger use a sequence and set the default value to the function that gets the next sequence value.
Keep all your hardcoded IDs under, say, 10k and start the sequence at 10001.
How do I do that and tell Entity Framework it's OK to insert the identity in some cases and not in others?
-
@tsaukpaetra
You can't just manually script the data rows across every once in a while when you need to resync?
-
@dcon said in The Official Status Thread:
I think they only do ours on a yearly one. Maybe bi-yearly...
That would have been the evacuation practice. I was always very quick to leave when that happened, mostly because staying put was truly not an option due to way too much racket from the pair of sirens. Even one might have been overkill, but two just pushed everything nicely over the pain barrier; fingers in ears, check time and day (to see if it was a regular test), stand up, grab coat, out, dead simple.
It was the shittiest office I've ever worked in, even worse than the one that tended to be nicknamed the Black Hole of Dresden for the total lack of natural light and the preponderance of Germans from that city working there with me. In fact, I actually quite liked the Black Hole; it was quiet and nobody came and bothered you so you could get work done without distractions. There were 8 people in there, and none of us was talkative. ;) But it truly sucked for light (and was happy to move after a few years) especially when there was a power cut and it turned out nobody'd tested the emergency lighting for a decade…
-
@izzion said in The Official Status Thread:
@tsaukpaetra
You can't just manually script the data rows across every once in a while when you need to resync?BTDT, really painful and annoying when doing much more than a screenful of them, especially when I'm being very selective of which rows move over. This is why I'm working on an easier way.
-
@tsaukpaetra said in The Official Status Thread:
write up a trigger to handle inserts
I think this should do the trick:
CREATE TRIGGER dbo.MyTableIdentity ON dbo.MyTable INSTEAD OF INSERT AS BEGIN SET NOCOUNT ON; DECLARE @LastID int = (Select MAX(ID) FROM MyTable) INSERT INTO MyTable SELECT CASE WHEN ISNULL(ID,0) = 0 THEN ROW_NUMBER() OVER(Partition by ID ORDER BY ID) + @LastID ELSE ID END ID --Whatever else columns FROM inserted END
Something tells me I need to set a table lock (I think that's what it was called) for most correctness with this method, but since inserts are few and far between I won't worry about it too much...
-
Digital Antiquarian finally got to Lemmings.
Now I'm remembering Mac Lemmings had the best soundtrack ever.
0_1507335984765_03- Tailor Made For Blockers.mp3
0_1507336088998_09- Smile If You Love Lemmings.mp3
Listen to that gorgeous QuickTime 2.0 software MIDI synth.
-
@dkf said in The Official Status Thread:
That would have been the evacuation practice.
I've been here a bit over 4 years. We haven't had one of those yet.
edit: Oh wait. I do remember 1...
-
@tsaukpaetra When you need to let it use the sequence don't give a value for the field - it will use the default.
When you need to specify, specify the PK.
-
@weng said in The Official Status Thread:
don't give a value for the field - it will use the default.
I must be doing something wrong then, because (essentially) it just used
0
and then SQL Server said "Wah, you can't insert a duplicate identity!"
-
Status: Smart aleck...
-
@blakeyrat said in The Official Status Thread:
Huh. Don't remember that one. I do remember the other tune (and heck, that was a long time ago!), but perhaps I simply never played enough levels in a row to get Smile If You Love Lemmings enough for it to stick in my memory…
Thanks for reactivating the memories, BTW.
-
Status: I frickin hate Windows Event Viewer.
How is it possible to be so low performance on a LOG FILE?!?!?
-
Yay! Phone spontaneously bricked itself again!
Edit: confirmed after yet another reset: trying to install (not run) the Yahoo Mail app breaks the phone.
Edit 2: hooray! Replacing Cyanogenmod 13 with LineageOS 14 seems to have fixed it!
-
@dkf https://www.dropbox.com/sh/bpz1jlc8v8ozb1f/AADLR0IoEg7Qzkv00mwJ_8Tga?dl=0
A couple years back I set up an emulator and digitized all of these from the original QuickTime 2.0 software synth. Wasn't a real Mac, so I can't say they're 100% accurate to what you heard back in 1991, but.
EDIT: actually I think those came from a file sharing download. It was Marathon's soundtrack I did myself.
EDIT: fact I learned today, the tracks that are based on like folk songs or other out-of-copyright music used to be riffs on popular music of 1990 and 1991-- Psygnosis were concerned about copyright, so they asked him to make new tracks based on public domain works.
-
STATUS: Activated my free 3-month trial of Apple Music. Could be nice to compare the selection to Spotify, especially in the obscure departments like mongolian folk metal and shinjuku-kei.
The opening experience showed that iTunes has a horribly broken interface where I managed to cause several graphical glitches before completing the inital "choose some genres and artists you like" for initial suggestions. And then I caused several more browsing albums, like having the mouseover indicator on several rows at once.
And I'm using iTunes on a Mac. I would have expected a horribly broken interface on the Windows version from having a minimal.effort port, but considering how much Apple likes polishing their interfaces I'm a bit surprised tbh.
Oh, well. It did have Ayumi Hamasaki's latest album, something Spotify doesn't (yet). So there's that!
-
@blakeyrat said in The Official Status Thread:
Digital Antiquarian finally got to Lemmings.
Now I'm remembering Mac Lemmings had the best soundtrack ever.
0_1507335984765_03- Tailor Made For Blockers.mp3
0_1507336088998_09- Smile If You Love Lemmings.mp3
Listen to that gorgeous QuickTime 2.0 software MIDI synth.
Not bad actually - even though it's still not quite the original Amiga edition where the music used actual samples bundled with the game played back at different rates to be the notes which is the original version.
Did the Mac Classic version have the 4 special Psygnosis levels with Psygnosis artwork and music? (Fun 22 / A Beast of a Level using Shadow of the Beast; Tricky 14 MENACING!!!! using Menace; Taxing 15 AWESOME using Awesome and Mayhem 22 / A Beast II of a Level using Shadow of the Beast II)
-
@arantor I don't remember, since I played it when I was like 12.
IIRC though it was pretty much an exact port of the Amiga version, made as faithful as possible. By the time it came out a lot of Macs supported 256 colors, so. Plus both platforms used 68k chips and used mouses for interaction. Macs nominally had a better sound chip than the Amiga, but not like hugely better. The major difference was just what facilities were provided by the OS. And that a lot of Macs were still black-and-white machines at the time, so on a lot of Macs, Lemmings looked like this:
(Actually kind of cool. I dig it.)
-
STATUS: Bought a new car this morning. Spent about half of the afternoon/evening figuring out why the fancy new stereo system that plays stuff from USB media didn't like half my audiobooks, and writing a program to fix them.
-
Status: Fizzle-pop Berry Twist.
That is all.
-
Status: I have been at the vacation rental for 2 hours. I am 2 hours in to an 8 day vacation and 1/4 the way through a 1.75L of Jack Daniel's.
My calculations may have been off.
On the bright side, the vacation rental is pretty fucking awesome. They have a PiArcade machine. On the not-so-bright side, the kids have already unplugged it and plugged it back in a half dozen times and it appears to have stopped working.
-
@polygeekery said in The Official Status Thread:
the kids have already unplugged it and plugged it back in a half dozen times and it appears to have stopped working.
We here at What the Daily Worse Than Failure understand how disappointing it can be to lose access to your entertainment services and will partner with you to provide the best resolution to your issue.
Unfortunately, each device does have a limited number of Miracle Powercycle application uses, and it appears you may have used all of them prematurely.
However, through our Tech Gurus here at What The Daily Worse Than Failure and positive negative reinforcement, it may be possible to restore a few Miracle Powercycle application uses.
But first, may I have your name and a good callback number in case we get disconnected?
-
Okay brain. This depression low is REALLY just fine. We can stop ignoring the coping mechanisms and going deeper.
We can especially stop recognizing that the coping mechanisms are coping mechanisms and going deeper because we need coping mechanisms.
I went for a drive today.
Just a short little one. Normally I'm never happier than when I'm on the road with nowhere in particular to get to but... It didn't help.
This is emblematic of my life right now.
I couldn't even be arsed to get out of the car and see what some idiot had done to the bridge
-
@weng said in The Official Status Thread:
my life right now.
You should review the Cute Things thread.
Failing that, maybe some ponies might help?
-
Status: Error: Improper execution of swallow.
Food stuffs currently lodged in upper thoracic esophagus section.
Automated internal resolution in progress... failed, autonomous reload unavailable.
Automated secondary internal resolution in progress... failed, insufficient saliva available to initiate full swallow action.
Attempting internal reset... Failed, internal resonance controls non-responsive.Notice: Ouch.
Attempting manual reset... Failed, percussive maintenance action insufficient.
Attempting secondary manual reset.... Partial success.Warning: Possible implicit nervous disconnect detected. Adding to ongoing monitoring.
Resolution status: Issue mitigated to ability. Ongoing temporary maintenance task has been added. ETR: 1 hour. Primary Major systems not permanently impacted.
-
@tsaukpaetra said in The Official Status Thread:
@weng said in The Official Status Thread:
my life right now.
You should review the Cute Things thread.
Failing that, maybe some ponies might help?
Boom goes the dynamite.
https://www.youtube.com/watch?v=ZxPfEgGD1Yw
Filed Under: Fan-made dynamite is the tastiest dynamite.
-
@tsaukpaetra said in The Official Status Thread:
Status: Error: Improper execution of swallow.
(At lunch today) Swallow interrupted by a cough. Aqueous solution of sugar, caffeine and carbon dioxide (a.k.a. carbonic acid) transferred from esophagus to nasal pharynx. That was not comfortable.
-
@hardwaregeek said in The Official Status Thread:
That was not comfortable.
I'm still not comfortable. Saliva production is currently at ~4ml/min above normal so I can continually (kinda) try swallowing again. Quite annoying, but it's almost all the way down!
-
Ordered a new phone yesterday since mine likes to say"nice charging cable there. Be a shame if anything... Happened to it" before spitting it out.
New phone is a Sony Xperia XA1, which has USB C and twice the storage of this one. Now I need to buy a load of USB C cables to replace the micros I have all around the house
-
Status: Heh. Such a pretty error message...
-
-
status: ugh. Continuing intestinal issues.
Is it normal to feel like you need to vomit from the sternum?
-
@jaloopa Monoprice Pallette series USB-C cables are the best I've yet found.
I've only managed to destroy one in total over 1.5 years versus the 1 every 1-to-2 weeks I averaged with micro USB.
-
status: system critical warning triggered: constipation prevention.
An emergency action has been triggered: forced defecation.
Warning: a malfunction has been detected with autonomous component 6m implicit status: blocked.
Defecation failed.
Cancelling activity rule: fast.Assessment recommended action: mild laxative coupled with ten cups water.
Sending upstream impetus.
System alert status Yellow set.
-
@weng If the upper loop area is part of the route you covered, you came very close to my neck of the woods.
-
@tsaukpaetra sure you don't mean brown alert?
-
@arantor I think the problem is a non-brown alert, no?
-
@e4tmyl33t said in The Official Status Thread:
@arantor I think the problem is a non-brown alert, no?
If there's a laxative involved, brown alert is most definitely a thing.
-
There is status, and there is TMI. Recent discussion crosses the line into the latter category.
-
@hardwaregeek We do (or did) have a thread for just such topics, as it happens. Some necro might be called for here.
-
@e4tmyl33t Yeah. I was originally headed up above Scranton but I saw a really long dirt road on the GPS and decided to hang a left.
-
@weng I used to get enjoyment from driving to nowhere in particular, but now all the roads around here are crammed with traffic all the time and that's no fun at all.
-
Status: Just been to see Blade Runner: 2049 and wow! that is a good film. Extremely recommended, especially if you can go somewhere where they've got a top-notch sound setup.
-
@arantor said in The Official Status Thread:
@tsaukpaetra sure you don't mean brown alert?
If we're going by output, no. Definitely not.
status: ugh. I feel like I didn't get any sleep tonight.
Judging by the annoying cycling pain and mental chirps repeating every ~47 seconds and 113 seconds (respectively), something happened.
From the above posts and IPC messages, I seem to have a kink? Gah! I hate not having full sensing access to my internals. Who thought that was a good idea?!
In other news, searching for ibuprofen...
-
Status: Have begun watching Alien: Covenant.
Nice to see that the Moron Ball still gets passed around like it's the best thing evar.
Obviously no one ever in the history of such movies heard about quarantine protocols. And no, I'm not talking about what to do when they're infected - I'm talking about the stuff before that.
So, you're landing on a planet no one has ever been to before? Who needs full body suits with internal life support in case an unknown pathogen comes along?
Oh, so the planet has a fauna which mysteriously resembles Earth's? Hell, we surely don't need rebreathers and shit because if the fauna has evolved similar to Earth's then surely the pathogens haven't followed a similar pattern!
Jesus Christ. It's always the same with these movies - the "heroes" in it are usually the type of people you shouldn't let within a lightsecond of a starship.
That's what I liked about the first Alien: They did take reasonable precautions and Ripley did want to follow the protocol - but she was betrayed. That made sense.
This stuff? It only makes them all look very, very stupid.
-
@tsaukpaetra said in The Official Status Thread:
I didn't get any sleep tonight.
Judging by the annoying cycling pain ... every ~47 seconds- You're not supposed to take your bike to bed with you.
- That's a ridiculously low cadence; you'll never get anywhere if you only pedal once every 47 seconds.
-
@hardwaregeek said in The Official Status Thread:
@tsaukpaetra said in The Official Status Thread:
I didn't get any sleep tonight.
Judging by the annoying cycling pain ... every ~47 seconds- You're not supposed to take your bike to bed with you.
- That's a ridiculously low cadence; you'll never get anywhere if you only pedal once every 47 seconds.
One word: Hyperloop.
-
@tsaukpaetra said in The Official Status Thread:
Gah! I hate not having full sensing access to my internals. Who thought that was a good idea?!
I for one count myself lucky! Imagine how many status updates you'd post if you did. :tmi:
-
@japonicus said in The Official Status Thread:
@tsaukpaetra said in The Official Status Thread:
Gah! I hate not having full sensing access to my internals. Who thought that was a good idea?!
I for one count myself lucky! Imagine how many status updates you'd post if you did. :tmi:
I'd post less if there were less problems, a situation likely to be found by the preventative measures enabled by improved monitoring and sensor data...
-
Status: Ate one cup of white rice and 1/2 pound pork. And drank 9 ounces of gravy (from sad pork), 17 ounces of root beer soda, and 16 ounces of water.
mmm.... Satisfied.
-
@tsaukpaetra said in The Official Status Thread:
Status: Ate one cup of white rice and 1/2 pound pork. And drank 9 ounces of gravy (from sad pork), 17 ounces of root beer soda, and 16 ounces of water.
mmm.... Satisfied.
Does depression/misery make it taste better? Inquiring minds want to know...