New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
I didn’t see any extra security feature on WIN server. I always use Linux. It's cost effective and secured from my point of view.
Only SQL Server database engine runs on Linux. The SSMS (graphical management studio for sql server) is available only on Windows OS.
yes, one SSMS can be used to connect to multiple SQL Server databases.
Yes I know.
Also, I don't remember asking. Do you know who asked?
My comments were in response to someone who wrote this
“Plus, it being available on Linux is very helpful for us migrating away from Windows VMs”
I could've phrased it better, but the subject in the comment was SQL Server; the bit about SSMS was just a side comment on the SQL Server ecosystem.
Your comment doesn't really make sense when you're replying to someone who has explicitly stated that they use the product, obviously I would know SSMS doesn't work on anything other than Windows because I use it.
The intent was to share that SQL Server for Linux is mot 100% replacement from SQL Server for Windows
It is though, life will be a bit harder without SSMS but you can live without it; there are a plethora of SQL Workbenches that work well with SQL Server (I use DBeaver when I don't have access to SSMS).
To be fair, a failed Linux upgrade is a system restore, not a simple windows rollback and reboot.
Complaining about needing 8GB free space for your OS partition. Are you still in 2001?
There's a correlation of IT bitching with lack of skill, IMO. People surprised they actually have to do stuff and expect everything on silver plate while hand held.
Ubuntu got millions of new users? Or just more support calls?
Generating a SSIS package for import/export data, for example, is much easier with SSMS.
SQL Server activity monitor is another example.
Defining SQL Server Agent job and viewing job history is one more example.
And not to mention, third party add-ons available for SSMS.
List goes on and on ….
There is a reason behind high demand for folks with excellent SQL Server skills, Windows Administrators, Powershell script gurus ….
The best admins like challenges and solving them. Shit ones just whine and bitch.
With that I agree, administration of an SQL Server instance is nearly impossible without SSMS. But for dev stuff, you won't die without it if you're hardcore Linux-only type of guy.
Point is, running SQL Server for Linux is not as impractical as you would imagine. A single workstation that runs Windows for sysads is definitely cheaper than running a bajillion Windows VMs just to run SQL Server instances.
SSIS package is not administration, it is part of SQL Server usage , ETL, data cleansing , feed to other DBs, list of active SQL logins, Audit reports ….
No, Microsoft used their marketing muscle to make Dell install Windows!
https://www.dell.com/en-us/work/shop/overview/cp/linuxsystems
Check the post above. ✔️
To be fair, I don't like the usually bloated M$ programs. But good luck finding a job in this marketplace If you don't know at least a few MS programs, especially ASP and MS SQL.
@dev_vps Changed days: this wasn't the case a couple of decades ago. Looks like it's a very limited range, particularly in the UK.
linux is best .
In MS SQL Server, I can write a stored procedure in c# language, make a REST API call to consume data on the fly (for example- weather for next 5 days for a given input zipcode) and data would be returned by stored procedure as if data is being presented from a table, not from a live rest api data.
This shows how well different technologies are integrated with MS SQL Server.
If you are trying to insult me with "yo mama", good luck. She's been dead for over 30 years, I couldn't care less. Also, I'm not from the part of the world that uses trailer homes, so again an assumption pulled out of your ass.
True that. Trying to be one of the "cool guys" by trashtalking windows seems to be a popular strategy amongst the clueless.
From a long and bitter experience in my case.
In my experience, if you use the right tools for the job the experience becomes a lot less bitter. There are places where windows is the right tool, and there are places where it is not. Knowing what to use where is usually what separates the pro's from the wannabes.
People trying to do everything with Windows regardless of if its suited for the job or not always makes me cringe. So does people trying to do everything with foss.
I just realized that that might have sounded like I was calling you a wannabe. That was not my intention, since I have no clue about who you are or your qualifications.
Well, that would explain why she just lays there most of the time. But it doesn't stop her from waffle wrestling. As for the trailer, I know it's not yours. Moms bought it from her bingo winnings and is letting you stay there until you can get back on your feet.
No, just that I had no clue what I was talking about and a complete plonker with regards to IT.
Try experience of CP/M (pre-DOS), various DOS incarnations including with the likes of SuperCalc, Windoze since the first Pagemaker, Unix since the venerable SysVR4.2 plus SCO, Novell etc..
Various roles from Support through some programming, network engineering and Enterprise Management
Oh and a Masters in IT Systems Integration - not that the piece of paper means anything.
I am pleased to see that there's an option to strip Windoze from the GUI (deliberately worded that way:not before time!) and with that it may become a more suitable server OS. It doesn't however excuse the piss poor basic underlying architecture of the OS, though 'stealing' ideas gradually from other OSes is closing the gap. IMHumbleO.
I agree. You have a point.