Run script with ssh as if I had ran it from the remote computer's UI
SSH to open GUI on target machine?
I'm trying to determine the best way to truncate or drop extra decimal places in SQL without rounding.  For example:  declare @value decimal(18,2)  set @value = 123.456   This will automatically round @value to be 123.46, which is good in most cases.  However, for this project, I don't need that.  Is there a simple way to truncate the decimals I don't need?  I know I can use the left() function and convert back to a decimal.  Are there any other ways? A student prepares for an exam by studying a list of 12 problems. She can solve 9 of them. For the exam, the instructor selects 7 problems at random from the 12 on the list given to the students. What is the probability that the student can solve 5 of the 7 problems on the exam?  I am really confused by this problem. My first initial thought was to do:  (5 chose 7)(7 chose 0)/ (12 chose 7)  I am not 100% sure about this though. How should I structure my URLs for both SEO and localization? When I set up a site in multiple languages, how should I set up my URLs for search engines and usability?  Let's say my site is www.example.com, and I'm translating into French and Spanish. What is best for usability and SEO?  Directory option:  http://www.example.com/sample.html http://www.example.com/fr/sample.html http://www.example.com/es/sample.html   Subdomain option:  http://www.example.com/sample.html http://fr.example.com/sample.html http://es.example.com/sample.html   Filename option:  http://www.example.com/sample.html http://www.example.com/sample.fr.html http://www.example.com/sample.es.html   Accept-Language header:  Or should I simply parse the  header and generate content server-side to suit that header?  Is there another way to do this? If the different language versions don't have different urls, what do I do about the search engines?    UPDATE 2011-12-06  Google has new recommendations for meta tags for explicitly pointing to other language content: .  UPDATE 2012-05-25  Related but not precisely:   UPDATE 2013-06-12  includes discussion of several URL schemes directly relevant to the question. Importing single symbol from MnSymbol How can I keep recent files from appearing in Unity? I sometimes browse erotic media files but I would like to avoid having them appear in files &amp; folders / recent. How can I do that?  The old "making .recently-used.xbel a folder" trick from 10.10 and older doesn't work any more.   Plus I'd prefer to turn off tracking only temporarily.  I also prefer not to use a separate user for this, as switching users sometimes isn't fast enough. Are C++ Templates just Macros in disguise? I've been programming in C++ for a few years, and I've used STL quite a bit and have created my own template classes a few times to see how it's done.  Now I'm trying to integrate templates deeper into my OO design, and a nagging thought keeps coming back to me: They're just a macros, really... You could implement (rather UGLY) auto_ptrs using #defines, if you really wanted to.  This way of thinking about templates helps me understand how my code will actually work, but I feel that I must be missing the point somehow. Macros are meant evil incarnate, yet "template metaprogramming" is all the rage.  So, what ARE the real distinctions? and how can templates avoid the dangers that #define leads you into, like   Inscrutable compiler errors in places where you don't expect them? Code bloat?  Difficulty in tracing code? Setting Debugger Breakpoints? Is it possible to reference an excel cell in a comment? I have an Excel balance sheet with a total at the bottom. On that cell I have a comment that says that the reason the total is X is because of what happens in J2. What happens if I insert another row before that, now my comment is wrong because all the rows jumped up a value.  Is there any way to reference a cell dynamically in an Excel commment? Which one should should I use? For some reason I have always used "towards", but I see some people saying "toward", like :     A great deal of his work in economic   theory has been directed toward   strengthening the foundations of our   understanding of central banking and   social insurance--indeed, one of my   most advanced macroeconomic classes   was nothing but a set of changes rung   upon a particular model that Peter   Diamond had advanced at...   Is there a difference between the two? When should they be used? 'both in terms of' or 'in terms of both'? Mobile web refresher, part 3 How can Linux/Ubuntu be installed safely on ChromeBook? Is installing Ubuntu on my Chromebook potentially dangerous to anything on my Chromebook? I got it as a gift, so I don't want to destroy anything that is important on the laptop. Also, which is better for being able to safely install Ubuntu: ChrUbuntu or Crouton? I'm using the Samsung Chromebook 3 (as described by the quick-start manual). Does that make any other differences as well? How do I get started with Translations? My friend and i would like to translate Ubuntu. where should we start? where to find translation tools? Why is the observable universe so big? Bibtex true unsort How do I calculate the challenge rating of monsters that feature abilities that do not directly do damage?  For example, my homebrew monster has the two following abilities:     The target takes a Constitution saving throw. On a failure, it drops to 0   hit points.   This one could be used on a character with 10 hit points, or 100, which creates drastically different damage results depending on character level.     All creatures within 60ft take a Wisdom saving throw. Each target that fails is stunned for 1 round.   This can be extremely dangerous if this monster is paired with monsters that can make use of the stun condition, but it is virtually useless if the monster is alone.  I'm sure there are infinitely more examples of this type of thing.  How do we calculate CR for monsters that do not rely on standard attacks? Apparently, .  How the heck did that happen? How to unplug a network cable that's stuck? Review counts in top-bar and /review don't match So far, I thought that the number shown in the orange box in the top-bar was the number of items available for review. However, when I acually visit /review, the numbers don't match:    Note that top-bar shows 15 items (?) but the queues only add up to 8.  Since I can't think of a reason for this being by design (which, as experience shows, is not a good indicator for "this is not an SE feature) I'm tentatively labelling this a (UI) bug. Disable RAM stick in Windows 7 I have 2 8gb RAM sticks on my motherboard. One is faulty on some bytes and is giving me BSOD once in a while.  Is it possible to disable one of them without removing it physically? I want to keep it inside the motherboard as I dual boot with Xubuntu and I can block the fauly bits there, and as far as I know, it is impossible to block them in Windows. is it possible to display a Google Earth map INSIDE Excel? Is there any way, using the scripting available to Excel 2007 to display a Google Earth map inside a sheet?  I've used Excel to house the data that I've then gone and generated a KML file to load into Google Earth, but now they want to see a pretty little cell with a client address mapped out in Excel directly to pretty up the presentation.