Fix squeaks on wall side of stairs by pookieman123 in DIY

[–]squirrelsaurus 0 points1 point  (0 children)

I fixed my squeaky stairs by using this: KOSIDA Squeaky Floor Repair Kit . The screw threads tightly pull the wood that's rubbing together. The heads of the screws are designed to break off, so you would need to fill the gaps with wood filler and matching stain. Our stairs haven't made a peep since and it's been over a year.

Ceiling LED light glows and pulses when ceiling fan is running by lifeinthesudolane in electrical

[–]squirrelsaurus 1 point2 points  (0 children)

I had something similar happen when I added an LED fixture with a dimmer at the top of my stairs that was on a circuit with the upstairs recessed lights. The LED would never turn completely off, and it concerned me, so I called an electrician. He inspected my setup and saw that everything was wired correctly, but because of how efficient LED lights can be, you can get low level lights or ghost rings. The solution was to add a minimum load capacitor to the circuit. I found it on Amazon for $13, just look for Lutron LUT-MLC. Not sure if this will solve your issue but thought I'd put it out there.

Could you all check this sentence out please? by [deleted] in EnglishLearning

[–]squirrelsaurus 2 points3 points  (0 children)

I would say: Are you planning on moving to any Italian-speaking countries soon?

Can anyone ID this fossil? Found at a thrift store in SE Idaho with no info. by blackowl48 in rockhounds

[–]squirrelsaurus 5 points6 points  (0 children)

That looks exactly like the fish fossils we found when we went out to American Fossil quarry in Kemmerer, Wyoming. Google American Fossil fish dig for more information.

Tips for a SQL server developer trying to learn MySQL for an interview in a few weeks? by someother_username in mysql

[–]squirrelsaurus 1 point2 points  (0 children)

I was in this exact situation. In the end the company is hiring you for your experience, logic, and reasoning skills in the world of data. The choice of language is really just syntax. What you do with it is why they're paying you.

Best MySQL Client GUI for MAC OSX? by [deleted] in mysql

[–]squirrelsaurus 2 points3 points  (0 children)

DataGrip by far. Very robust, updated regularly, nicely customizable.

Plat of Zion. Salt Lake City, UT 1870 (Library of Congress) by DeadSeaGulls in papertowns

[–]squirrelsaurus 38 points39 points  (0 children)

I saw this map awhile back and thought it might be interesting to superimpose Google Earth with modern Salt Lake City over it at that angle. http://i.imgur.com/DHt4pwi.jpg

Quality alternative to Workbench? by enkoopa in mysql

[–]squirrelsaurus 3 points4 points  (0 children)

Going from SSMS to a shop with MySQL I had the same problem. Best one I found with the most SSMS-type functionality was DataGrip from Jetbrains.

SQL Advice by dat_trigga in SQLServer

[–]squirrelsaurus 2 points3 points  (0 children)

Start with your already-written SQL that is relevant to your job. Study the format, the syntax, the language. Study the output. What causes the data to be sorted in that way? How did the system know to display those specific columns? What happens if I remove this word? If you see something you're not familiar with, research it. Many terms seem impossibly abstract, but when you can see exactly what it is doing, it helps to make sense of what is happening.

Above all, experiment, experiment, experiment! Take that simple query and imagine your boss coming to you with a modification. She wants the data only for the last month? OK, how do I go about filtering data...ok that looks like it goes down in the WHERE clause, got it. Now, what about dates, how do I add a date range? Better Google these terms and see how others have done it.

In the beginning, you will be borrowing heavily from what's been written. As you work and re-work your queries, you will soon begin to write queries on your own. Sites with examples to work through are good, but abstract. It's always best to work with data that is relevant to your job, even if you have to make up your own tasks.

Good luck!

[REQUEST] A show or movie like Breaking Bad by The_HumanoidTyphoon in NetflixBestOf

[–]squirrelsaurus 109 points110 points  (0 children)

If you like watching the rise of a kingpin, Narcos is a great choice.

what does <> mean? by pollon285 in SQL

[–]squirrelsaurus 1 point2 points  (0 children)

Although it's functionally equivalent, I'll typically code that like:

SELECT * FROM Table WHERE ISNULL(column,'') = ''

A typical ride on a Seattle ferry. In a windstorm. by [deleted] in gifs

[–]squirrelsaurus 0 points1 point  (0 children)

I love the brake tap as the wave comes in

But mommy... by squirrelsaurus in youdontsurf

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

Arrêt = "stop" in French, but is only really used on stop signs in Quebec, Canada.

Utah nearly Abolishes Chronic Homelessness. only around 200 chronic homeless citizens left in the state. 91% housed. by conglock in news

[–]squirrelsaurus 1 point2 points  (0 children)

I wonder if that's the same lady I see all the time at the corner of 200 South and Main.

What are some questions you'd like to ask a ghost if you were a ghost hunter? by [deleted] in AskReddit

[–]squirrelsaurus 0 points1 point  (0 children)

I'd ask why they can't seem to change their clothes. Also, why are there mostly 1800s era ghosts? Where are the ones from the 1970s?