• 0 Posts
  • 28 Comments
Joined 1 year ago
cake
Cake day: July 17th, 2023

help-circle

  • Going through The Expanse again. Such a good show that unfortunately got soured towards the end by a bad egg in the cast. But I’m enjoying it regardless, the work everyone else put into that show deserves praise. They found such a good balance point on the hard vs. soft sci-fi spectrum. Just enough realism and scientific accuracy to make the setting feel authentic without getting in the way of the story.

    And Dominique Tipper as Naomi effortlessly code switching as she interacts with Inners and Belters is astounding. Not just her, all the Belter actors do such a great job with their dialects, but because of her screen time and back story it’s a lot more varied for her.



  • I love both, but I actually prefer Atlantis’s ongoing series arc over the more episodic/season arc structure of SG-1.

    Possibly unpopular opinion (?): Universe was a fantastic show that got cancelled right as it was getting really good. Stargate’s answer to Voyager and Battlestar Galactica. Really wish we could have gotten more of it. With the way they left things, it’s not too late to revive it if they can get actors on board. They can easily explain cast aging or not returning with the final cliffhanger.










  • doctordevice@lemm.eetoMemes@lemmy.mlpoor Dean
    link
    fedilink
    arrow-up
    9
    ·
    edit-2
    6 months ago

    One Dean Koontz book isn’t a great sample size. He writes a LOT and most of it isn’t very good, but every once in a while he gets it just right and puts out a really good one.

    Though tbf, I haven’t re-read his stuff in probably 10 years so I don’t know if it holds up to modern scrutiny. Odd Thomas was always my favorite of his.



  • I doubt that would affect Wi-Fi, but what does affect it (at least 2.4 GHz frequencies) is microwaves. They operate at the same frequency and interfere with the router’s output waves.

    My wife refused to believe me until I had her run a speed test and watch the signal drop when I started up the microwave, then rise again when I turned it off.



  • Basically scripts you can run on the fly to pull calculated data. You can (mostly) treat them like tables themselves if you create them on the server.

    So if you have repeat requests, you can save the view with maybe some broader parameters and then just SELECT * FROM [View_Schema].[My_View] WHERE [Year] = 2023 or whatever.

    It can really slow things down if your views start calling other views in since they’re not actually tables. If you’ve got a view that you find you want to be calling in a lot of other views, you can try to extract as much of it as you can that isn’t updated live into a calculated table that’s updated by a stored procedure. Then set the stored procedure to run at a frequency that best captures the changes (usually daily). It can make a huge difference in runtime at the cost of storage space.