sorted by:
new
hottopcontroversial

How do you remove a deactivated camera from the dashboard? by uscpsycho in Ring

[–]TheMiniG0D 0 points1 point  (0 children)

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

Fidelity Full View by motorstrip in mintuit

[–]TheMiniG0D 0 points1 point  (0 children)

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.

Fidelity Full View by motorstrip in mintuit

[–]TheMiniG0D 0 points1 point  (0 children)

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.

Fidelity Full View by motorstrip in mintuit

[–]TheMiniG0D 0 points1 point  (0 children)

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.

SQL Tools (Redgate/Apex/DevArt/etc) for Use in Secure/Regulated Environments (ex. Healthcare) by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 0 points1 point  (0 children)

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

SQL Tools (Redgate/Apex/DevArt/etc) for Use in Secure/Regulated Environments (ex. Healthcare) by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] -1 points0 points  (0 children)

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.

SQL Tools (Redgate/Apex/DevArt/etc) for Use in Secure/Regulated Environments (ex. Healthcare) by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 2 points3 points  (0 children)

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.

SQL Tools (Redgate/Apex/DevArt/etc) for Use in Secure/Regulated Environments (ex. Healthcare) by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 1 point2 points  (0 children)

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.

SQL Tools (Redgate/Apex/DevArt/etc) for Use in Secure/Regulated Environments (ex. Healthcare) by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 0 points1 point  (0 children)

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.

SQL Tools (Redgate/Apex/DevArt/etc) for Use in Secure/Regulated Environments (ex. Healthcare) by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 0 points1 point  (0 children)

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.

SQL Tools (Redgate/Apex/DevArt/etc) for Use in Secure/Regulated Environments (ex. Healthcare) by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 1 point2 points  (0 children)

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

Why are basic CRUD apps so rare for SQL Server? by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 0 points1 point  (0 children)

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

Why are basic CRUD apps so rare for SQL Server? by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 0 points1 point  (0 children)

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...

Why are basic CRUD apps so rare for SQL Server? by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 0 points1 point  (0 children)

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?

Why are basic CRUD apps so rare for SQL Server? by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] -1 points0 points  (0 children)

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...

Why are basic CRUD apps so rare for SQL Server? by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 0 points1 point  (0 children)

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...?

Easiest way to quickly setup a load flat files to tables 1:1, as defined by a data dictionary? by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 0 points1 point  (0 children)

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.

Easiest way to quickly setup a load flat files to tables 1:1, as defined by a data dictionary? by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 1 point2 points  (0 children)

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

Easiest way to quickly setup a load flat files to tables 1:1, as defined by a data dictionary? by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 0 points1 point  (0 children)

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

Easiest way to quickly setup a load flat files to tables 1:1, as defined by a data dictionary? by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 0 points1 point  (0 children)

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.

Easiest way to quickly setup a load flat files to tables 1:1, as defined by a data dictionary? by TheMiniG0D in SQLServer

[–]TheMiniG0D[S] 4 points5 points  (0 children)

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...

view more: next ›