|
..works?
Started with this thread[^], where Scott Serl[^] says it works. So I tried. And it does 
Lots of you will now say that you already knew that, since you have it as a VM in Azure.
There was some error on not being able to install "mssql-tools" due to a missing dependency. Apt-get that dependency, get a similar message on a new package. Try that, another dependency. After four of those, a Y/n on install, and work your way up through the dependencies. That's the tools (like SqlCmd), Sql Server was already running.
Connection error; so this idiot tried to connect using Windows Authentication 
Try Sql Server authentication and login with sa, new connection error. Quick google teaches me that SqlWb needs to have the (default) port number after the instance name. So, add ",1433" after the instance name, and it connects, acting like a normal Sql Server instance would.
Created a database, created a table, from MS Sql Wb running on a Win10 machine. No additional errors, which must mean I done something wrong. Reboot, and it still works! It's running on not-so-great hardware (hence Linux), but it is still bloody fast (not much other stuff installed). If it works on that machine, then it may work on my Raspberry. Imagine a backup-databaseserver the size of a creditcard. Now all I need to build my own cloud[^] is to get RAID5 working on cheap USB pendrives.
Thank you Microsoft (and Scott) 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Eddy Vluggen wrote: get RAID5 working on cheap USB pendrives.
THIS IS MADNESS! 
When I was growin' up, I was the smartest kid I knew. Maybe that was just because I didn't know that many kids. All I know is now I feel the opposite.
|
|
|
|
|
|
Just think twice before implementing it.
I would recommend a stripe size equal to the block size of the flash drive.
I would also use non-volatile write-back cache rather than write through.
|
|
|
|
|
Thanks for the tips 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
We are testing MSSQL on Linux since 2016 (betas) and we actually try to convince our customers to make the move...
In manners of performance/hardware ratio it seems to work much better...
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
Eddy, have you not read the rules? Thou shalt not praise MS. No matter what.
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[ ^]
|
|
|
|
|
Well, if you... Wait, you said NON sarcasm 
|
|
|
|
|
Don't think it will work on ARM devices - please tell me if it does 
"We can't stop here - this is bat country" - Hunter S Thompson - RIP
|
|
|
|
|
MS hardware requirements says it won't work; now looking if I can find Pi-like hardware (in terms of size and price) that contains an x64 processor
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
I don't know about price, but take a look at pico-itx boards
|
|
|
|
|
Or even smaller, mobile-itx
|
|
|
|
|
Thanks for the tip.
MB+CPU, less than 60 euro. 17cm x 17cm.
Nice
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Eddy Vluggen wrote: then it may work on my Raspberry.
I've been wanting to do that, but SQL Server on Linux only supported Intel processors (or so I thought) - has that changed?
|
|
|
|
|
Marc Clifton wrote: I've been wanting to do that, but SQL Server on Linux only supported Intel processors (or so I thought) - has that changed?
No, according to the specs you're right; 2+Ghz x64 is required, which the Pi isn't. Would have been fun though
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
just wondering because i just finished a huge article and i want to time the post for maximum coverage.
When I was growin' up, I was the smartest kid I knew. Maybe that was just because I didn't know that many kids. All I know is now I feel the opposite.
|
|
|
|
|
Post it right after the next daily build comes out? That way you have max time for the next one
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
good call although they do tend to update the main page throughout the day so if i update too early i minimize my coverage there.
When I was growin' up, I was the smartest kid I knew. Maybe that was just because I didn't know that many kids. All I know is now I feel the opposite.
|
|
|
|
|
If you that worried about the audience, go for a friday and not a monday morning.
If it is good, it will get shared no matter the timing. Stop worrying, hit "publish"
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
honey the codewitch wrote: i want to time the post for maximum coverage.
Why worry? The only people who are going to read it are those who are interested in the subject. And the people who are really interested will surely search it out.
|
|
|
|
|
Congratulation!
|
|
|
|
|
To my recollection, as long as you get the article in by 11:59 CodeProject time, it's in the next day's Daily Build.
Thanks,
Sean Ewington
CodeProject
|
|
|
|
|
thanks. I appreciate it!
When I was growin' up, I was the smartest kid I knew. Maybe that was just because I didn't know that many kids. All I know is now I feel the opposite.
|
|
|
|
|
Read quite a bit of it this morning when I was at the doctor with my daughter.
Looks really good! Easy to read and understand while not being shallow.
Impressed so far, hope it keeps that way when finish it. 
|
|
|
|
|
It's posted and complete now except the latest bits are still awaiting approval but as long as you get them using the GitHub link you'll be okay.
When I was growin' up, I was the smartest kid I knew. Maybe that was just because I didn't know that many kids. All I know is now I feel the opposite.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
