Database Solutions

A quick lowdown on enhancements rolled out in SQL Server Management Studio 2016

In this article we look at key enhancements that have been incorporated in SQL Server Management Studio 2016 The SQL Server Management studio is one of the multiple applications launched with SQL Server. It was first launched in the 2005 edition of SQL Server, and from 2015 onwards Microsoft decided to ship SQL Server Management Studio separate from the SQL Server. The SQL Server Management Studio was designed with the purpose of negotiating, configuring and handling the SQL Server and its...

Read more »

Starting with Ms SQL Server – Do Learn the Basics about Indexes

In this article we introduce you to the concept of Indexes in Ms SQL Server In SQL Server, indexes are used to make the task of data access comparatively faster.  With the help of indexes, we are able to glance at the entire database file in a single scroll. Like in every book we see an index at the beginning; it makes the presentation of our data more systematic and organized. Indexes are mostly in the form of tables. They have entries of topics and sub-topics. It works in a...

Read more »

Key Reasons Why Ms SQL Server tops MySQL any day

In this article we look at why Ms SQL Server is a better choice than the open source MySQL for many companies. MS SQL and MySQL are two different database solutions, with very distinctive origins. While the MS SQL server is a proprietary solution from Microsoft, the MySQL database is an open source solution which has found quite a fan following amongst web developers. However from a pure play enterprise database solution, the Ms SQL Server application is considered way superior to MySQL....

Read more »