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 server 2016 being the thirteenth one.
With its sixth edition in 1995, Microsoft launched SQL server for Windows NT. It did not start as a relational database but slowly evolved into one. After SQL server 6, all editions of SQL server kept on getting more and more advanced, outdoing the previous editions. Like it usually happens in the world of software and technology, it got updated, before you could get the hang of the previous version. Following are a few of the key developments in the evolution of SQL server.
- SQL server 2000– the eighth edition of SQL server, was codenamed ‘Shiloh’. It introduced user defined functions and made it easier for database administrator to place index on tables by introducing an ‘index tuning wizard’ suggesting potential indexes for the tables.
- SQL server 2005- the ninth edition of SQL server was codenamed ‘Yukon’, it was launched in November 2005. It introduced the user to ‘studios’: management studios and business intelligence development studio, both of which were closely integrated with Microsoft visual studios and Microsoft office system. It also introduced advanced security systems which provided the user with the power to implement defense-in-depth, for specific security risks.
- SQL server express 2008(advanced)– the tenth edition of SQL server was codenamed ‘Katmai’ , it introduced an advanced graphic management tool, reporting features and text-based search options. SQL server express with tools is the edition with basic graphic management tools. The editions of SQL server express are available for free downloads and can be used as both client database and server database.
- SQL server 2012– the eleventh edition of SQL server was codenamed ‘Dnali’. It introduced Dynamic Management Views and Functions with programmability enhancements along with spatial features. This was also the edition which introduced the Business intelligence, but did not go down well with the users. It had combination of so many features that it perhaps made it complex for users and was not as preferred as the other editions.
- SQL server 2014– This version introduced ‘in-memory’ which enables tables to be stored in memory, especially the small ones and the long ones being reserved for the disk. SQL server 2014 runs on Microsoft Azure, a cloud computing platform build by Microsoft.
- SQL server 2016– the thirteenth edition did away with the business intelligence introduced in 2012, being the most recent version of SQL server, it is obviously the most advanced with the best of everything. After almost 20 years of its launch, Microsoft SQL server has today become one of the most sought for database software with its own cloud storage, Microsoft Azure.
SQL Crashes has been prevalent in Ms SQL Server irrespective of the edition
SQL Crashes has plagued the MS SQL Server database from its initial days. Even today, the most sophisticated SQL Server 2016 Enterprise edition too can suffer a SQL crash. So if you are looking to avoid chances of data loss from a SQL crash, it makes sense to procure a sql server recovery software like DataNumen SQL Recovery application which can come to your rescue in the event of a crash. It has the prowess to handle gigantic files running into several TBs and can even recover data from a compromised SQL file stored on a virtual drive.
Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit https://www.datanumen.com/