Database Solutions

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 »

Top 5 Backup Practises to Follow While using Ms SQL Server

In this article we explore five distinct best practices for backing up data from an Ms SQL Server application. Regular backups of your SQL Server database are extremely essential for assuring the security of data. It is recommended that before compiling small databases one must assure that they are supported by large back up files. This prevents loss of data. It also makes recovery of data possible, in case of any technical failure or hardware malfunction. Many Business firms create Back...

Read more »

Real world tips to help you improve the performance of Ms SQL Server

In this article we explore few handy tips designed for DBAs which can help them better improve the performance of their SQL Server implementation. Microsoft SQL server is one of the best database management system software in vogue today; both in terms of features and performance. However there are instances when we need to boost its performance. You can always have a hardware that is advanced enough to enhance the performance of your software, but enhancing the hardware is not always...

Read more »