Jump to content

Wikipedia:Reference desk/Computing

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by AboutFace 22 (talk | contribs) at 16:45, 23 May 2023 (→‎Licensing MS SQL Server ?). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Welcome to the computing section
of the Wikipedia reference desk.
Select a section:
Want a faster answer?

Main page: Help searching Wikipedia

   

How can I get my question answered?

  • Select the section of the desk that best fits the general topic of your question (see the navigation column to the right).
  • Post your question to only one section, providing a short header that gives the topic of your question.
  • Type '~~~~' (that is, four tilde characters) at the end – this signs and dates your contribution so we know who wrote what and when.
  • Don't post personal contact information – it will be removed. Any answers will be provided here.
  • Please be as specific as possible, and include all relevant context – the usefulness of answers may depend on the context.
  • Note:
    • We don't answer (and may remove) questions that require medical diagnosis or legal advice.
    • We don't answer requests for opinions, predictions or debate.
    • We don't do your homework for you, though we'll help you past the stuck point.
    • We don't conduct original research or provide a free source of ideas, but we'll help you find information you need.



How do I answer a question?

Main page: Wikipedia:Reference desk/Guidelines

  • The best answers address the question directly, and back up facts with wikilinks and links to sources. Do not edit others' comments and do not give any medical or legal advice.
See also:

May 16

is it possible to save a rare youtube song to a format that i can play on apple music on my phone

i love this tango song my grandma used to play its not very popular and not available on the marketplace but it is on youtube what can someone email me a copy of it to my phone that i can play on my playlist please its this one https://www.youtube.com/watch?v=Gv28a2MCmR8 2600:1700:9758:7D90:C5BF:5F1C:A46C:C83A (talk) 00:05, 16 May 2023 (UTC)[reply]

There are many programs that can be used to download and save the audio from a Youtube file. Which one you want is highly dependent on your operating system. 12.116.29.106 (talk) 12:23, 16 May 2023 (UTC)[reply]
iphone x os 16  — Preceding unsigned comment added by 99.145.194.98 (talk) 14:28, 16 May 2023 (UTC)[reply] 
This process probably violates the YouTube terms of use. If when you play the video on Youtube, you see a "download" icon, then you can use that. Or you can look at Comparison of YouTube downloaders, but your operating system is not listed. Since most of these programs are open source and free, they are unlikely to appear on the Apple Store, but you could use them on another computer to extract an audio file. Graeme Bartlett (talk) 07:39, 19 May 2023 (UTC)[reply]

May 17

Why 2FA such as Google Authenticator is safe? If I know someone's password, open a bunch of programs to submit all the codes generated in one minute to make a Brute-force attack, is it still safe? -Lemonaka‎ 07:55, 17 May 2023 (UTC)[reply]

Generally you cannot submit more than a few codes a minute (say 6 or so) and the code to use changes every 30 seconds. So theoretically you could get lucky, but your chances won't be very high. Not sure what the opening of a bunch of programs has to do with it.... —TheDJ (talkcontribs) 09:27, 17 May 2023 (UTC) In other words you get locked out if you fail three times.[reply]
The authentication servers I am familiar with (RSA for example) allow only three tries to match a randomly generated code. No, brute force attacks will not work. Elinruby (talk) 04:03, 20 May 2023 (UTC)[reply]
It appears that the suggestion is to open 10,000 instances of the login for some secured application and automate the process of logging in with a username and password and then have each of the 10,000 instances try every possible 2FA sequence from 0000 to 9999 all at the same time. One of them (technnically 2 to 4 of them) will get it correct. If the backend is developed by someone who doesn't know what they are doing, this could work. The backend should recognize that the same username/password is being used 10,000 times all at once and each of those is waiting for 2FA at the same time. So, even if you use the correct 2FA, it won't be allowed. But, security is only as good as the ability of the person implementing it. 97.82.165.112 (talk) 13:03, 17 May 2023 (UTC)[reply]
Any competent WAN admin will have multiple layers of security, yes. Authentication is just one measure, and 128 bit is ideal. But beyond that it depends a lot on whether the setup is for Joe's Bait Shop or Pemex so it is pretty much impossible to discuss this in the abstract. And BEANS. Elinruby (talk) 04:16, 20 May 2023 (UTC)[reply]
Without regards to a specific implementation or use; many systems have a login throttle implemented, which is designed to prevent brute-force attacks; it only allows a relatively small number of login attempts in a set period of time. --Jayron32 14:24, 17 May 2023 (UTC)[reply]
Note that standard Google Authenticator TOTP is 6 digits, so 10k is off by two orders of magnitude. Nil Einne (talk) 06:38, 18 May 2023 (UTC)[reply]
Yeah, thanks for clarifying. I didn't want to say it so comprehendible. Some LTA is trying to crack everyone's password and letting these out maybe WP:BEANS for them.
Anyway, I didn't test whether wikimedia has such protection against brute-force attacks. It's unlikely common login attempts because all the attempts are with correct password and hackers just have to leave a lot of pages for 2FA certification. Then they will submit bunch of 2FA codes, nearly 10K. If one of them got right, then they can have your account's access. -Lemonaka‎ 19:19, 18 May 2023 (UTC)[reply]

May 18

Licensing MS SQL Server ?

For many years I have had my own MS SQL Server. I got it through a MS program which was sort of training. You paid about 1,500 a year or so and MS would give you access to a bunch of software: servers, language compilers, etc. It was all raw, that is you had to build applications of your choosing. I used it to design a database in C# and SQL Server. They imposed limitations. You could not use that stuff commercially. I never did,

Well, now I have a need to really purchase a new SQL Server. I went to MS website and found that a standard edition will cost me 860 some dollars. This is not all. It turns out I need a license to run it. In order to purchase a license, I need to know how many cores my new SQL Server will have. I never had any ideas that SQL Server should have cores. Hardware, like a processor, yes, but the Server, no. Anyhow, a girl in service of MS quickly calculated that my SQL Server will cost me almost 6,000 dollars.

I used to like MS, not anymore. I have other complaints also, but let's focus on this. Why do they say in one place that I need to pay $860 and then hang a license on it? Is it a rip-off? I also do not understand the concept of cores when applied to software, not hardware. I need help. Thanks AboutFace 22 (talk) 00:13, 18 May 2023 (UTC)[reply]

Well the core count would apply to the hardware you run the software on. If you have a higher core count, the software can do more. This is how Microsoft make more money out of those that have a bigger hardware. Perhaps you can supply hardware with only one core, or whatever is the minimum for licensing. If you don't want to pay you can use something different, such as MySQL, but probably a lot of work to convert whatever uses it. Graeme Bartlett (talk) 02:05, 18 May 2023 (UTC)[reply]
I don't want to start a war, but given those figures have you considered moving to Linux and one of the databases such as MariaDB or PostgreSQL? For $6,800 you could get quite a lot of training and help moving your applications over. Martin of Sheffield (talk) 07:27, 18 May 2023 (UTC)[reply]
But for what purpose do you need an SQL server? Ruslik_Zero 16:24, 20 May 2023 (UTC)[reply]
Rather than buying your own server, you could use a hosting service. For example, WinHost gives you an SQL server for between $5 and $45 per month, depending on what you need.[1] Msclusters has similar prices. [2] There are many similar services; just Google "microsoft sql server hosting". (I have not used any of them, so I am not recommending any particular one.) CodeTalker (talk) 01:16, 21 May 2023 (UTC)[reply]

I am answering the question by one of the previous contributors: "Why do you need an SQL Server?" The answer is familiarity. When I first got mine, many years ago I never heard about Internet, let alone "hosting services." Since then, My SQL Server has served me well. I have a database of my own design sitting on it. Switching to another system means a lot of trouble. I am old now and can work only a couple of hours a day. I don't want to learn a new system now. I know pretty much everything about the SQL Server. And I need to move my database to a new much faster computer.

AboutFace 22 (talk) 19:16, 21 May 2023 (UTC)[reply]

Can you not just buy new hardware and re-install the original MS SQL Server program on it? MinorProphet (talk) 05:12, 22 May 2023 (UTC)[reply]
If yes, please reply 'yes'. If no, why not? Have you lost the install CDs / 1.44MB floppies? No-one who knows anything about SQL server writes "I know pretty much everything about the SQL Server." Which version of MS SQL Server are you using? Or did you stop paying the license fee some time ago and are afraid that Bill Gates will personally appear at your front door demanding payment for the last 20 years of free SQL Server usage? MinorProphet (talk) 18:25, 22 May 2023 (UTC)[reply]
@AboutFace 22: There are two free editions of the Microsoft SQL Server: Developer and Express. You can try to use one of them. Ruslik_Zero 20:06, 22 May 2023 (UTC)[reply]

Thank you @minorProphet. Buying a new Dell compurer is a simplest part of the job. Using the old disk to install SQL server presents problems. My present SQL Server I downloaded from a MS website as a part of the program to familiarize the developers with what MS had available. Theatrically my SQL Server is free, although I always paid annual fees at that time. SO it still belongs to MS. I cannot use my SQL Server commercially and now I may need to do just that. $860 for a server that will buy me a peace of mind is not a big deal for me. I did not expect the server core variable getting on my way, otherwise I would have already bought it.

Well I want to tell you a horror story. Before I began working with MS SQL Server, many-many years back I played with MS Visual dBase which was a combination of a database and a programming language. I already finished my design spending perhaps hundred of hours, when MS one day said that they would discontinue support for Visual dBase. I had already hundreds of items stored in its columns. I had to redo everything from scratch with C#. and then I wrote a small program that copied/transferred items from dBase to SQL Server. I discussed the issue with MS and a woman said that my SQL Server belongs to them and I cannot use it commercially. I want no trouble.@Ruslik, I have developer. AboutFace 22 (talk) 01:00, 23 May 2023 (UTC)[reply]

Why cannot you use the Express Edition? Ruslik_Zero 14:33, 23 May 2023 (UTC)[reply]

I've always thought that express edition unlike the developer edition is much simplified. I do need some level of sophistication. It is comforting. AboutFace 22 (talk) 16:45, 23 May 2023 (UTC)[reply]

May 22

Does FaceTime Audio work on Macs purchased in China?

The article about FaceTime mentions that the Audio only version does not work on iPhones or iPads purchased in China, but it never mentions Macs. Does FaceTime Audio work on Macs purchased in China? Félix An (talk) 10:53, 23 May 2023 (UTC)[reply]