MS SQL SSMS license

hi,

is MS SSMS for SQL server is free for all desktop ?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Which edition?

If I am not mistaken, SQL Server is licensed by CPU cores. You can refer the detailed documentation at: https://www.microsoft.com/en-in/sql-server/sql-server-2017-pricing
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Yes. SQL Client and SSMS are free to deploy and use. The licensing is applied to the server and its added services.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Sorry, I misread the question. I agree - SSMS is free. The server component is what needs a license.
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

marrowyungSenior Technical architecture (Data)Author Commented:
Nakul Vachhrajani,

yeah, only referring to SSMS.

anyone here know MySQL and Maria DB? any kind of tools for them is free and as powerful as SSMS.


Qlemo,

"The licensing is applied to the server and its added services."

this is true as long as a company has MS SQL, what is that company don't have ? install it without MS SQL server will break license?
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
You can download and use SSMS without having to license anything.
marrowyungSenior Technical architecture (Data)Author Commented:
Qlemo,

I believe so, any link/URL  to say it is free even on any company didn't buy SQL Server ?
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
This documentation indicates that SSMS is free: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

For other databases, I would recommend evaluating tools from Toad to see if they have something.
marrowyungSenior Technical architecture (Data)Author Commented:
"For other databases, I would recommend evaluating tools from Toad to see if they have something."

Yeah I knew it but this tools is expensive !

not the first choice!
Olaf DoschkeSoftware DeveloperCommented:
SSMS is free, you can even have a fully free stack with SQL Express Editions, also for commercial use. So even if you still have concerns you need a bundle, install an Express server. You don't profit from SSMS without any SQL Server backend anyway, it's specialized to make connections to MSSQL services. You can use SSIS projects to connect to any other DB via  ODBC and OLEDB, but that topic is embedded with a Visual Studio edition, not SSMS nor MSSQL though the main idea of SSIS is the integration of other data with MSSQL, you can define transfers between any two data sources and sinks without involving MSSQL, but in itself such projects are not the workbench functionality, they rather define ETL processes.

In regard to MySQL/MariaDB, you have Workbench as similar tool or, well, workbench. There are many more general query, reporting, or case tools, specialized on different aspects they can cost up to a fortune. I'd always address that from the guts. On one side when they wouldn't be worth it, they'd be cheaper, on the other side, when you think they are too expensive, your needs are simpler than what they provide. Going for free is at least a decision and start, may cost you in investing time in something not fitting your needs.
marrowyungSenior Technical architecture (Data)Author Commented:
"You can use SSIS projects to connect to any other DB via  ODBC and OLEDB, but that topic is embedded with a Visual Studio edition, not SSMS nor MSSQL though the main idea of SSIS is the integration of other data with MSSQL, you can define transfers between any two data sources and sinks without involving MSSQL, but in itself such projects are not the workbench functionality, they rather define ETL processes."

Did you try migrating Oracle DB to MS SQL using SSIS? any kind of tools you can suggest ?

Also is R service and R server in SQL 2016 and 2017 included in the license already ? R server is free anyway as it is open source ?

 "n regard to MySQL/MariaDB, you have Workbench as similar tool or, well, workbench. "

workbench can do good execution plan as MS SQL ? I find out a lot of tools for MariaDB yesterday (PMM and Monyog) , all of them still relies on explain plan, which is extremely hard to read and their demo is focus on very simple queries ! and the explain plan already hard to read and we can GUESS what it mean ! just add an index ! too simple.

can it show what kind of process is involving, e..g parallel processing or what kind of index it is looking for in an easy way?   data flow diagram as well ?
Olaf DoschkeSoftware DeveloperCommented:
Just some aspects (I don't have the time to answer all):

1. Using SSIS is an inferior way to work on any data, as tools you have within SSMSare missing, but then you can program flows. No, I never had much contact with Oracle, but bigger migrations will go through CSV, though SSIS can mean to spare a read/write cycles of data to memory to CSV back to memory, if Oracle and MSSQL are on the same machine.
2. What does it help you that SSMS has the better visualization of an execution plan, if SSMS can't query MySQL/Maria DB data?

You're still looking at SSMS, as if it was a universal query tool, it isn't. It's not an option for that. And I mentioned SSIS projects as your only way to have universal data access, it's still not the same functionality. So if you look for a general query tool you look for something else. When you're interested in good query plan visualization of any db, as vendor of query tools you depend on the information you can get from the database module, in MYSQL that is EXPLAIN and EXPLAIN EXTENDED and then you may draw some graph, but it won't compare, there is no universality of index types, for one reason. In the end, if a tool may offer this, there's much work in that feature and it would be no surprise such a query tool has a price.

Bye, Olaf.
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Though the point made by Olaf is a valid one, the question is answered - SSMS is free. Yes, it makes sense with MSSQL only, but that is not the scope here. Expanding the scope to cover more DBMS is a different question, and should be asked again in a new question.
marrowyungSenior Technical architecture (Data)Author Commented:
Olaf Doschke,

"2. What does it help you that SSMS has the better visualization of an execution plan, if SSMS can't query MySQL/Maria DB data?"

I mean any tools work with MySQL/Maria can show execution plan in visual form like SSMS.

"So if you look for a general query tool you look for something else"

no.  I am looking for same type of tools for MySQL/Maria too .
Olaf DoschkeSoftware DeveloperCommented:
Sorry, I know nothing like that, as I never was much interested in a nice visualization. Buy a book on MySQL Performance, for example http://shop.oreilly.com/product/9780596003067.do, that should help you much better to organize your data to get what you need, because it never just is a matter of the single query or index composition anyway.

See at it this way: If I get a list of steps and a weight (percentage of execution time), sorted descending, I already know what mainly to address. The diagrams of SSMS don't tell me much more than that.

Bye, Olaf.
marrowyungSenior Technical architecture (Data)Author Commented:
"See at it this way: If I get a list of steps and a weight (percentage of execution time), sorted descending, I already know what mainly to address."


other free tools  for ms SQL from other company can do this. but I agree with you.
marrowyungSenior Technical architecture (Data)Author Commented:
how can I award other experts too ?
marrowyungSenior Technical architecture (Data)Author Commented:
that one is "was this helpful?", right ?

so we have to do this first before saying "I have my answer". then close ,right?
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.