Database Recovery

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 »

A quick overview of how SQL Server has evolved over the years

In this article we look at how the Ms SQL Server database solution has evolved the years Microsoft launched its version of SQL server in 1989 as Sybase SQL server by collaborating with Sybase and Ashton -Tate; it was a variant of the older Sybase SQL server for IBM. With its own version of SQL server Microsoft forayed into enterprise- level database market, with rivals like Oracle, IBM and Sybase. Starting from 1989 till now, Microsoft has launched a dozen editions of the SQL server with SQL...

Read more »