The way to go for your database implementations
September 12, 2019

The way to go for your database implementations

Gary Davis | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

I use Microsoft SQL Server primarily as the back end database server to ASP.Net C# websites. For authentication and authorization, the database uses tables and stored procedures to implement membership or identity for user login and defining roles. Of course, the database is used to hold data entities for the needs of the website. Use of stored procedures, views, and sequences full-text indexing are just some of the useful features I take advantage of.

Pros

  • Speed of selects with appropriate indexes.
  • Use through C# of Linq queries to the data.
  • Ability to use CLR assemblies to program in C#.
  • Replication to keep the database mirrored to another server.

Cons

  • I sure wish the T-SQL language was more like C# - it's really primitive.
  • I would like an easy way to pass an array to stored procedures and a way to iterate through the array in the code.
  • Integrated source control for the database would be appreciated.
  • Can be expensive to license.
  • Reasonable cost solutions are available via Azure and Express versions.
  • Many developers with SQL skills are available.
Elasticsearch is a very good alternative to using SQL Server full-text search. It is not a relational database like SQL Server but is open-source so cost is lower. MySQL is another open-source option to look into depending on the requirements of your projects.
Support is readily available from Microsoft or other 3rd party solution providers. Many answers can also be found via Bing-ing around the Internet.

Do you think Microsoft SQL Server delivers good value for the price?

Yes

Are you happy with Microsoft SQL Server's feature set?

Yes

Did Microsoft SQL Server live up to sales and marketing promises?

Yes

Did implementation of Microsoft SQL Server go as expected?

Yes

Would you buy Microsoft SQL Server again?

Yes

Microsoft SQL Server is well suited for various scenarios and solutions since it is a general-purpose relational database capable of easily and efficiently meeting the needs of your website or application. It is fast, reliable, scalable and easy to use. Due to its popularity, there are many sources of user help, tutorials, examples, and solutions available.

Comments

More Reviews of Microsoft SQL Server