SQL Server Solutions

Running a Mid tier firm – Here’s why you need to upgrade your SQL Server database to the 2016 edition

In this article we look at motivators for midsized firm to upgrade to the 2016 edition of SQL Server. For any kind of business it is always important to have a well managed database, as it can help it grow vertically as well as horizontally. A mid tier firm is most likely to use the standard edition of SQL Server 2012, which lacks a very important function of Business Intelligence (BI). BI as the name suggests, helps perform lot of important and intelligent functions, essential for the...

Read more »

Database Partitioning – Key concepts every DBA must know

In this article we would go through the key concepts associated with Database partitioning in SQL Server Partitioning in SQL Server is used for easy maintenance and improved performance of the database. It allows splitting of large tables along with individual tables. Queries which require access to limited data can be performed quickly as the data to be scanned is lesser. Maintenance task like rebuilding indexes or backing up tables, can be performed quickly. Partitioning does not always...

Read more »

A Quick lowdown on SQL Server Clusters

In this article we take an in-depth look into SQL Server clusters and learn how they can prove beneficial to an organization. Clustering in SQL Server refers to the installation of multiple instances of SQL Server into one or more physical servers, preferably ones running on Microsoft Windows. This is done to add on to the availability of the database, as a clustered SQL Server database will be available across the clustered servers at all times. So in case either of the server crashes, the...

Read more »