Quanajah Pinnock Define Version of SQL that which SQL is better for Creation of Database

Quanajah Pinnock 0 Reputation points
2023-11-12T11:20:30.4633333+00:00

Quanajah Pinnock | I want To Develop Some SQL Database in Server 2017. I Check that Best Server 2017 To Develop SQL Database with Different Features and Provide Extra Security.

SQL Server 2012 ?

SQL Server 2016 ?

Which one is Best ?

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,951 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Q&A Assist
    2023-11-12T11:20:30.5533333+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    Both SQL Server 2012 and SQL Server 2016 are good options for developing SQL databases with different features and extra security. However, SQL Server 2016 has more advanced security features, querying capabilities, Hadoop and cloud integration, R analytics, and improvements and enhancements compared to SQL Server 2012. Therefore, SQL Server 2016 would be the better choice for developing SQL databases with more advanced features and security.


    References:

    0 comments No comments

  2. ShaktiSingh-MSFT 14,081 Reputation points Microsoft Employee
    2023-11-13T05:19:39.2033333+00:00

    Hi Quanajah Pinnock •,

    Welcome to Microsoft Q&A forum.

    As I understand, you want to know which SQL Version to use for creation of Database.

    Could you please let us know if you are creating Azure SQL database or some other DB?

    If Azure SQL Database, it always runs on the latest version.

    Please let us know if this helped or you have a different ask.

    Thanks

    0 comments No comments