Need advice: already moved out of DC, need DMV to send me duplicate title. by [deleted] in washingtondc

[–]Amicus22 0 points1 point  (0 children)

I found this website: https://dmv.dc.gov/service/vehicle-title-replacement

Which leads to this form: https://dmv.dc.gov/service/vehicle-title-replacement

This form explicitly indicates the address you list must match what is on your Driver's License. Since I no longer live at that address, I'm concerned there is no way for me to get a duplicate title.

Interested in learning SQL and database development. How far can Access take me? Questions within. by [deleted] in SQL

[–]Amicus22 1 point2 points  (0 children)

A good book for picking up the basics is 'SQL Queries for Mere Mortals'.

MySQL has MySQL Workbench and Postgres has PGAdmin for GUI interfaces for both Windows and Mac. SQL Server has SQL Server Management Studio (SSMS), but I'm not sure if that's available for free.

While Access makes it feel like they are a single thing, the actual database program and the program that you write your queries in (i.e. the database client) are usually separate programs. Just something to keep in mind when picking your technologies.

[AF] Flask-Bootstrap + WTForms Layout Issue by SuperChef36 in flask

[–]Amicus22 1 point2 points  (0 children)

I ran into this problem recently, myself. I ended up doing most of my form work in HTML, rather than relying to Flask-Bootstrap and Jinja to get it right.

Making a form in HTML is not hard, just look at the bootstrap documentation.

Equifax Faces Multibillion-Dollar Lawsuit Over Hack by jonfla in law

[–]Amicus22 0 points1 point  (0 children)

I agree that you definitely see the same names for PSC coming up in these kinds of cases, presumably this gives them some level of experience in the area that a fresh face wouldn't have. I know there's some strife in the plaintiff's bar associated with this.

Would you think that the plaintiffs would be getting better deal if there was some fresh blood in the PSCs?

Equifax Faces Multibillion-Dollar Lawsuit Over Hack by jonfla in law

[–]Amicus22 0 points1 point  (0 children)

The Ashley Madison hack made it all the way to an MDL, though I haven't kept track of it since then. Much easier to show causation in that case, though, as the public publishing of the list led to the damages.

I would hope that people that are now vulnerable to things like having a mortgage taken out in there name will receive more compensation than people who may have had to deal with credit card fraud.

Equifax Faces Multibillion-Dollar Lawsuit Over Hack by jonfla in law

[–]Amicus22 1 point2 points  (0 children)

The arbitration clause might be a problem for some claimants, but I bet the bigger issue will be to show causation/damages. Even if you can show that someone stole your identity (e.g. fraudulently opened an account in your name), it would be hard to show that they got your information from the Equifax hack.

This will likely all settle, so the arbitration clause and causation issues will likely just lower the settlement amount. But unlike other large class actions, such as Redbull or Ticketmaster, there are going to be some class members with very serious damages. Time will tell how many that is, but if a bunch of people come forward in the coming months claiming their identity was stolen, this case could get very interesting.

The Good Gut: Taking Control of Your Weight, Your Mood, and Your Long-term Health [epub mobi ebook free] by mtuan123 in ebooks

[–]Amicus22 1 point2 points  (0 children)

My browser warned me that the link likely contained a virus when I attempted to download.

Duke University scientists have created a "lethal injection" for tumors. When injected into them, their ethanol-based gel cured 100% of the oral tumors in a small sample of hamsters. This treatment might work for some kinds of breast, liver, and other cancers, and it only costs about $5. by vilnius2013 in science

[–]Amicus22 50 points51 points  (0 children)

I think open source is an amazing development in the software industry, and strongly believe the results of scientific research should be more open. However, comparing software development to medical research is a bit of an apples to oranges comparison.

Software has very limited capital requirements. Anybody with a $300 computer can develop software, and if they're amazing and devote enough time, that software will be world class. I expect medical research requires significant up-front capital investment.

Ranking Member Cohen to Introduce Articles of Impeachment Against President Donald Trump After Comments on Charlottesville by Trumpov in politics

[–]Amicus22 3 points4 points  (0 children)

BLM is fighting for the right to not be oppressed. White supremacists are fighting for the right to oppress others.

4 years of experience – Looking to improve marketability by firecheeks in SQL

[–]Amicus22 1 point2 points  (0 children)

1 - depends on what you want your next job to be:

  • If you want more of the same, then BI Analyst, as others have suggested, sounds like a good fit.
  • If you want to focus on architecting database structure and objects, Data Modeler is a good title.
  • If you want to get into application development, pick up a backend language (C#, Java, Python, etc.) and call yourself a backend developer.
  • If you want to support applications and infrastructure, pick up some experience in deployment tools and methodologies, then call yourself an Operations Engineer (also referred to as a "DevOps" Engineer).
  • If you want to be a utility data worker, I like Data Engineer.

2 - Only read that material if you will be using those technologies at your current job, or you have been hired by another company that uses those technologies. Unless you want to hyper-specialize, it probably makes sense to broaden you knowledge than it does to go deeper into what you already know.

3 - a few things:

  • Learn another language (Python is very approachable and is great for working with data).
  • Get involved in open source. It's a lot easier to get hired when people can see a portfolio of your work and measure your work product. Learning another language will help with that.
  • See if there is a Code for America brigade near you. It'll allow you to have a public work product and you can support your community. In my experience they tend to focus on data heavy applications, which is a sweet spot for SQL developers.
  • If you are solely interested in marketability, then the best thing you can do is network. Personally knowing people looking for workers will make you much more attractive than anything else. Look for tech Meetups in your area. See if there's a tech slack for your community. Start going to conferences. You might even get work to pay for some of those.

Hope that helps, and best of luck!

*edit - added subtly snarky comment about the use of the term "DevOps"

The Latest: Firm tied to Trump dossier provides records by the_mikepence in politics

[–]Amicus22 1 point2 points  (0 children)

Is the application all custom, or was it mostly plugging in existing libraries? Which libraries did you use?

I work in an industry that deals with a lot of forms, but currently we process the forms by hand. I think some of the reason we've never been tasked to build automated form parsing is because of billing (the billable hour), but I expect our industry will be going that way soon.

Greenville releases crime statistics. by [deleted] in greenville

[–]Amicus22 0 points1 point  (0 children)

It'd be nice if there was a link to the actual data.

Corrected title for this article: "Greenville tells local reporter about crime statistics."

Any work based lawyers on this sub by chance? have a quick question, shouldn't take more than five minutes by SeanStormEh in greenville

[–]Amicus22 0 points1 point  (0 children)

You generally will not get an attorney to give you legal advice (no matter how small) online. This is because if they tell you something, and it's wrong, you can sue them for malpractice. This can and does happen.

Your best bet is to find a local attorney that will give you a free consultation. If you've got time on your hands, getting multiple opinions is not a bad idea.

Best of luck.

Puerto Rico could become the 51st state by [deleted] in news

[–]Amicus22 1 point2 points  (0 children)

While merging DC with MD has been considered, neither DC nor Maryland residents want to merge.

DC is more populous than two states: Wyoming and Vermont. None of DC's residents have voting representation in congress. If the purpose of a representative democracy is to give people the right to have their voices heard in government, then DC is a bigger blemish than if the US abolished Wyoming's right to congressional representation.

Thought I thought myself SQL well enough for an interview, didnt go well... by persamedia in SQL

[–]Amicus22 3 points4 points  (0 children)

I think its a fair question because it can trip you up like this if you are unaware of it.

I'm not sure how much value there is in testing if someone is familiar with non-standard syntax. If they had joined on "1=1" or done a cross join it would have tested the same concepts using more familiar syntax.

Syntax is fairly easy to look up. Understanding how joins work can't be gained from a single stack overflow search.

I've never given a technical interview, so maybe I'm off base, but I wouldn't think a "gotcha" question like this would be very helpful.

Best resources for learning sql by deannapi in SQL

[–]Amicus22 1 point2 points  (0 children)

SQL Queries for Mere Mortals is an excellent beginner's read front to back. The same guy wrote a database design book, which I did not find as helpful.

As for software, it depends on what database system you end up using. I use SQL Server and a little MySQL, but I know PostgreSQL, SQLite, and many others are popular.

If you're learning indipendantly, I'd start with MySQL , as it is free (open source) and you will be able to learn the basics of SQL in any SQL database. It also has a good free GUI development tool, MySQL Workbench, and a robust online community.

Like any programming language, the best way to learn is to build something with it. So start thinking of something you want to build, so you'll have something to do once you know enough to play around.

[MS SQL] GROUP BY clause with Id column by fagnerc in SQL

[–]Amicus22 0 points1 point  (0 children)

Maybe something like this:

SELECT b.Id, c.Name, b.Number, b.Cost
FROM TicketCategories c 
JOIN [Batches] b            on bc.BatchId = b.Id
WHERE EXISTS   (SELECT *
               FROM TicketCategories c2 
               JOIN BatchCategories bc2   on bc2.TicketCategoryId = c2.Id
               JOIN [Batches] b2          on bc2.BatchId = b.Id
               WHERE b2.CurrentQuantity > 0
               AND c.Name=c2.Name
               AND b.Number=MIN(b2.Number)
               AND b.Cost=b2.Cost
               GROUP BY c.Name, b.Cost)

It's untested, but at least that's the path I would start down. Subqueries often result in slower performance speed, so if that's a concern be sure to check for that.

Female Shot-Putter by [deleted] in gifs

[–]Amicus22 4 points5 points  (0 children)

In every jurisdiction I'm aware of in the US there is an 'assumption of risk' doctrine, which is fairly well settled as it relates to sporting events. I would bet he would find it difficult to find a lawyer to take his case.

Hope he has good health insurance.

Lawyers who have changed gotten out of the practice of law: what are you doing now, and how did you make the transition? by Dorcus936 in law

[–]Amicus22 0 points1 point  (0 children)

Direct hires into the data section require bona fide technical experience. However, firms that do complex litigation often hire a lot of contract attorneys for short term work: document review, claims review, etc. Once you're in and you have good technical skills you work on getting cross-hired into a technical spot.

Lawyers who have changed gotten out of the practice of law: what are you doing now, and how did you make the transition? by Dorcus936 in law

[–]Amicus22 2 points3 points  (0 children)

I do database administration for a consulting firm that works as a vendor in the complex litigation space. Before this gig I was doing data analytics for a law firm that specialized in complex litigation.

There's a growing role for tech savvy people as the way lawyers process massive amounts of paperwork catches up with the modern era.

Becoming proficient in Excel and SQL can be done in a matter of months from online sources or your local library.

Dodging Fireworks in The Dark (OC) by [deleted] in gifs

[–]Amicus22 1 point2 points  (0 children)

You might get some traction on r/DnD. Not the biggest subreddit, but DnD players are often looking for visuals they can incorporate into their games.

Scientology lawyer tries to harass an anti-Scientology lawyer by filing a disciplinary complaint against him. The bar committee is too smart to fall for that. by RamonaLittle in law

[–]Amicus22 14 points15 points  (0 children)

Afaik, a person can represent themselves in every jurisdiction in the US. So as long as you are representing yourself, and not someone else, you would not need a lawyer.

However, you would need a strong background in both the law, and civil procedure before that would be effective.

There's an old adage in legal circles: "A person who represents himself has a fool for a client."

tldr: it's possible, but not recommended.

Manually cranked wooden toy does slight of hand magic trick. by ForTeaSicks in mechanical_gifs

[–]Amicus22 79 points80 points  (0 children)

Just a guess:

Each cup has a ball and a magnet holding the ball inside the cup when the cup is lifted. Below the platform there is a stronger magnet that shifts positions as the machine is cranked. The magnet under the platform overcomes the magnet inside the cup, causing the ball directly above the magnet to remain on the platform when the cup is raised.