SQL Server 2016 and Big Data – Learn How they play well together

In this article we explore the exciting concept of Big Data and SQL Server working in tandem While in a layman’s term it can be defined as nomenclature for lots of data, but in definition, Big Data refers to extremely large and complex data sets which cannot be managed and processed with the help of conventional data management tools. It is heterogeneous data generated at high speed, requiring new tools, applications and frameworks for its processing and managing. An example of Big Data is...

Read more »

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 »

3 Different Methods to Refresh Pivot Table when the Source Worksheet Data are Updated

Pivot table is quite potent in Excel. In this article, we will talk about 3 methods to refresh pivot table in Excel. The pivot table will not refresh automatically in Excel. Thus, if you have modification on the original data, you will certainly need to refresh it. For example, this worksheet records the sales volume of two products.   Besides, in another worksheet, there is a pivot table for the data and information. If you modify the original worksheet, you need to refresh the...

Read more »