Plesk & SocialBee have teamed up. Save 30% now!

MSSQL

Commercially speaking, MSSQL is the most commonly used database management system (DBMS). It is true that Microsoft SQL Server is restricted to the Windows operating system, but companies who rely on Windows for their server operations will find this an advantage. MSSQL can be controlled both via a GUI and via a CLI. As the name suggests, MSSQL supports SQL commands – a command set introduced by IBM which is non-procedural and which is not case sensitive.

Top features of Microsoft SQL Server:

  • It is established that MSSQL offers top performance levels
  • MSSQL is a good choice if you run a Windows shop
  • You can run different versions of MSSQL on one serer
  • Using MSSQL you can generate scripts that help you move data

 

Temporary databases can be a real problem with some DBMS, but Microsoft SQL Server mitigates this common issue. Microsoft SQL Server also allows users to have separate security privileges and allows admins to maintain a standby server. As a SQL database, MSSQL supports standard SQL language. That said, importing files via Integration Services is a common problem, and many users would say that MSSQL is really only a good fit for large organizations.

Please note that technologies described on Wiki pages are not necessary the part of Plesk control panel or its extensions.

Related Posts

Knowledge Base

Plesk uses LiveChat system (3rd party).

By proceeding below, I hereby agree to use LiveChat as an external third party technology. This may involve a transfer of my personal data (e.g. IP Address) to third parties in- or outside of Europe. For more information, please see our Privacy Policy.