Monday, November 30, 2015

How to Avoid CXPACKETs?

CXPACKET is one of the famous wait type that database administrators are experiencing. Before moving into the details of CXPACKET wait type, - See more at:

Eight Types of Slowly Changing Dimensions (SCDs)

We typically talks about three SCDs which are Type 1, Type 2 and Type 3. In Ralph Kimball and Margy Ross Third edition of the Data Warehouse Toolkit book, they talked about eight types of SCDs.


Tuesday, October 20, 2015

Time Series Algorithms in SQL Server

This is the fourth article on data mining series. The below are the previous articles in this series.

Shopping Basket Analysis in SQL Server

Using Decision Trees in SQL Server

Data Mining Cluster Analysis in SQL Server

This article focuses Time Series Algorithms which are a forecasting technique. One of the most common algorithms used in industry are time series algorithms which can be used to answer questions on the future values such sales volume for the next season, or petrol prices in winter. Most of the cases, time series algorithms are limited to prices and quantities. However, using the same theories and techniques, they have the capabilities of predicting trajectory or a moving object and next video frame.

Tuesday, September 29, 2015

Microsoft Readies Big Data Service That Includes New U-SQL Language

Earlier this year, Microsoft revealed plans to offer a new HDFS-compatible Hadoop File System data store that could run large analytics workloads called Azure Data Lake. So far, the technical preview hasn't appeared but the company today reiterated that the service, which it will actually call Azure Data Lake Store, will be available later this year and also announced some new services planned for its Azure-based Big Data portfolio.

More at