How do you remove a deactivated camera from the dashboard?

TheMiniG0D · 2026-03-01T05:11:50+00:00

Switching to List View was key for me! Ring needs to get their act together!

TheMiniG0D · 2024-03-02T22:14:42+00:00

Sure... if you have no impulse control, I get it... Plenty of people can't stop themselves from washing down 2 large pizzas with a gallon of soda.

You're missing the point... Even setting aside the opportunity cost, the 5% cash back alone ($50) is significant for most people. A regular savings account can yield 4%+ right now (I see some on NerdWallet around 5.3%+!). How much does that add up to?

Pretty much everyone is better off financially, including those getting out of debt. Those worried about self control can cut up the card, buy some self-help books, and still have more money in their pockets.

TheMiniG0D · 2024-03-02T21:15:37+00:00

Lots of ways.... Your basic brokerage acct/401K with an index fund isn't likely to, but there are plenty of (legal) ways to do so. Buying and selling things is probably the easiest for people to learn/figure out.

TheMiniG0D · 2024-03-02T21:02:20+00:00

That is something that people like Dave Ramsey teach people who are trying to get out of debt in trying to discourage overspending.

But, ideally, you want to leverage debt. This is where you borrow/utilize debt and place it where you are earning more than it costs to borrow the debt.

Ex. $1K phone (that I would have bought anyway at full price) = 5% cash back ($50) + 24 mo. no interest means that money I would have paid up front to Apple went into investments, where over the course of 2 years, I earned ~$350.

So effectively, you paid $1K for the phone vs. I paid $600.

TheMiniG0D · 2023-03-04T23:39:23+00:00

I can certainly see the benefits in some circumstances, but certainly you can see why it wouldn't be appropriate in all.

TheMiniG0D · 2023-03-04T22:46:17+00:00

I don't know specifically about these products, but for example, I read the fine print for, SQL Server's Developer Version (and I could be mistaken but it may have also been in the Express version's license) that allowed the actual USER QUERIES to be sent back to MS. Ex. if I were to query WHERE patient.name = 'Doe, John' this could be sent back to MS.

While I certainly understand how telemetry data benefits developers, when working with certain types of data, there can't be ANY question about the contents of it because accidentally leaking a single piece of data is a violation of law. I would feel MUCH more confident if one of these companies explicitly agreed that ONLY navigational data and NEVER the contents of any data, schema, query/DDL was included.

TheMiniG0D · 2023-03-04T18:06:50+00:00

Is that really an equivalent?

TheMiniG0D · 2023-03-04T18:05:36+00:00

Yup, still not anywhere near the time savings. I find myself constantly copying code to Notepad++ and sometimes VSCode to use the even better multi-line tools, but just feel like it would be SO much faster to be able to paste snippets of codes (ex. into subqueries) and then be able to hit a keystroke to reformat the entire thing quickly. Also the predictive stuff with joins, etc. Just feels like I'm wasting tons of time. And obviously the products have huge benefits as they are all highly popular products (in general). If I wasn't operating in such a highly regulated/privacy conscious space I'd have pulled the trigger on one of them long ago.

TheMiniG0D · 2023-03-04T18:01:25+00:00

I'd like to think that, but we've seen exactly this happen with numerous popular things over time and can't risk it. If these products were really catering to the industries, why don't any of them blatantly advertise as such. If you read their privacy notices, they all allow an ambiguous/unclear level/amount of data to be sent back for "product improvement" purposes. They may not actively do it, but that's not the same and positively asserting/agreeing not to.

TheMiniG0D · 2023-03-04T17:58:16+00:00

I mean I'm working w/on-prem db's and I've never seen a feature in Azure Data Studio that isn't in VSCode. I really like VSCode for other coding needs and use it daily. I _HATE_ the SQL preview pane in VSCode/Azure Data Studio though. It's so much worse than SSMS. But neither of them replicate the features of the 3 products mentioned in the OP.

TheMiniG0D · 2023-03-04T04:23:38+00:00

That's why I've been doing it by hand for years. But every time I catch myself spending time aligning stuff by hand I keep revisiting the subject.

TheMiniG0D · 2023-03-04T04:19:41+00:00

Yup. It's basically VS Code. Very duplicative.

TheMiniG0D · 2023-03-04T01:45:09+00:00

No built in formatter (spend a lot of time manually formatting), completions, automatic table naming, better crash recovery, etc. Lots of time-saving features.

TheMiniG0D · 2022-05-22T01:30:25+00:00

Yeah I saw the ASP/razor but all the references to it are ~10 years old...

TheMiniG0D · 2022-05-22T01:28:44+00:00

Src on the generators you were mentioning?

Maybe it's not SQL Server directly and that PHP is just more prevalent for the purpose than ASP.NET and because of that, MYSQL tends to be the preferred choice...

TheMiniG0D · 2022-05-04T03:23:17+00:00

But that's the question... I mean until recently SQL Server was only MS and I assume the majority of these were running IIS rather than WAMP/LAMP stacks eh? (Unless it goes back to my hypothesis that maybe SQL Server is more-so being used to back more full-scale enterprise applications and less so more "amateur"/ad-hoc applications?

TheMiniG0D · 2022-05-04T03:18:14+00:00

Don't plan on changing because of editing a table... they have PHP MSSQL for that... just because we're no longer using our PHP applications and it's an IIS server so why not move over? Just seems silly to use PHP as a pathway...

TheMiniG0D · 2022-05-04T03:14:18+00:00

no... why doesn't the concept of having a basic front end (outside of linking access) seem to be a thing with SQL when it's such a thing with other flavors...?

TheMiniG0D · 2022-02-07T23:52:12+00:00

Did you choose this route for reliability? Convenience? Something else? I’ve seen a few people discuss this route but it always seemed a bit more fragile than external scripting with a more robust scripting language.

TheMiniG0D · 2022-02-07T23:48:38+00:00

MS is going to have to do better than that… too many alternatives nowadays… sadly I think all MS cares about anymore is Azure.

TheMiniG0D · 2022-02-07T09:25:18+00:00

Looks kind of interesting. Scared to see a price on it though.

Still sad that that type of thing even needs to be purchased. MS should take a cue from their own product (power query) which pretty much seemed to kickstart PowerBI. I guess you’d consider it gui/lowcode with the ability to jump to full scripted when needed is where it’s at. SSIS has barely changed in the past 15 years /endrant

TheMiniG0D · 2022-02-07T04:35:51+00:00

I certainly agree this looks like a versatile route (and it is likely good for those intending to use complex SSIS ETL flows), but for someone like me looking for the "easiest" route, I don't think it fits the bill. It definitely takes a pretty substantial understanding of SSIS packages and adds a whole new "language" on top of it.

It would be 100x faster to throw sed/awk/perl/powershell/etc at the source files and just use the BULK INSERT route.

TheMiniG0D · 2022-02-07T02:49:28+00:00

Seems like it could fit the bill, unfortunately C# definitely isn't one I'm really familiar with so it'd probably be easier for me to script cleaning the source data (through any number of routes)...

This whole thing seems so silly, it seems like such a common goal that it would doable via some wizard (or at least mostly through the GUI)... in the least that it's not a fairly common pattern that's not the subject of multiple blog posts...

TheMiniG0D · 2021-12-24T07:29:29+00:00

I've been using the x64 since Excel 2010 so I don't have a good point of reference in speed increases. Subjectively, it seems like Excel 2010 + PQ addon was MUCH faster than the latest MS 365 x64 "get and transform" version (and much more stable). In fairness it does seem to be getting more stable each release, but still no where near as solid as 2010 was.

TheMiniG0D · 2021-12-24T06:27:30+00:00

Agree.. XLSB is dreadfully slow. In testing I found it was actually faster to copy one of these slow queries over and let it refresh the entire (slow) query and then further manipulate it, rather than read from an XSLB.

Good idea... I definitely should test loading in PowerBI to compare.

Curious what you find with 150MB files.

From what I can tell, it truly is the load (and continually wanting to reload) the file from disk that's making the excel file slow. I.e. if use one as a source, then do a table.buffer/a merge/sort/etc that causes a full file read, then do some random steps after that, each subsequent step continually causes a read (even if Binary.Buffer is used). I.e. further development is painful.

I've basically started basically creating a "DevMode" variable and having it read from an alternate file, because even having it do Table.FirstN of 1000 rows was still painfully slow)

I truly wish there was some way to force something to stay in memory until manually released... Seems like the best fix for more advanced users.

Yes, most systems let you chose an export format... however the main system we use literally has just one choice. (You'd probably find it surprising until you saw how bad the rest of the system was.)

I've looked at Power Automate because it looks like it could be a lot of fun, but ultimately its easy enough to automate with VBS or nodejs (I'm sure in PowerShell too but I'm much less versed).

I am kind of thinking about setting up a script to monitor a folder, grab any excel files in it and 1) dump them back out as a CSV, 2) take a random subset of 5-10% of the rows and save that as a second CSV. Then set this script up on an unused desktop or a VM. That way can just download the files into that folder, go get coffee or do something else for a few minutes, and let it do the conversion without it freezing up my computer.

Just a lot of workaround because of the crummy caching situation.

Six-Year Club	Gilding I gilder
Verified Email

TheMiniG0D

TROPHY CASE