-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL & BI

Manish is a Data warehouse/Business Intelligence Solution expert. He has a Master’s degree in Computer Applications with 11+ years of experience resulting from associations with organizations such as Mahindra Satyam, Verizon, ITC Infotech and Aditi Technologies. While associated with these companies, he has had the opportunity to work with well-known names such as Microsoft (R&D, AdCenter India) and Danske Bank Denmark. He is MCITP (SQL 2008 Business Intelligence Developer) certified and his skills and expertise include Design and Architecture definition for BI/DW solutions. He has successfully implemented various BI & DW projects with coverage across ETL, Data Modeling, OLAP, Data Analysis, Data Quality, Analytical Reporting, Data Mining, Dash Board design and implementation as well in fine tuning complex queries and databases. Manish’s hobbies include writing and reading Hindi poems, cooking, hiking , sports, philanthropy, sharing technical knowledge and listening to music.

BI on SQL Azure - Yes you can


Just 4 years before, it was not possible to have end to end Business Intelligence (BI) solution on SQL Azure. Please read my blog here which was actually written 4 years back.

Now things have been changed dramatically. If you go through my blog than under conclusion at last section…

Read more

1 comments, 388 reads

Posted in SQL & BI on 10 September 2015

Master Data Services 2016 CTP 2.2 - Explorer functionality quick fix

Microsoft has recently released SQL Server 2016 CTP 2.2. I was concerned about the Master Data Services and was exploring the new features. I got surprised when I see that Explorerfunctionality was not working. Generally it is used to manage members for Entities and Hierarchies. It is one of…

Read more

1 comments, 756 reads

Posted in SQL & BI on 28 August 2015

Entity Sync Relationship - Master Data Services 2016


Entity Sync Relationship  is a new feature in Master Data Services 2016. It enables you to share entity data between different models. You can keep a single version of truth in one model and reuse it in an another model.

I was wondering where should I use it? Do…

Read more

0 comments, 805 reads

Posted in SQL & BI on 27 August 2015

Versions (Master Data Services) - Where to use


Multiple versions of the master data within a model can be created in Master Data Services(MDS). When you create a model for the first time, Master Data Services (MDS) creates a default initial version of the model data.

While working with MDS, I was trying to find when to use…

Read more

0 comments, 532 reads

Posted in SQL & BI on 21 August 2015

Introducing Python in Hadoop World

This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data and Hadoop environment. To discover more about Python please visit to official website of Python (http://www.python.org/).

Python is a powerful, flexible, open-source language that is easy to learn,…

Read more

0 comments, 408 reads

Posted in SQL & BI on 18 August 2013

Big Data: An Introduction with Hive


Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL. At the same…

Read more

2 comments, 276 reads

Posted in SQL & BI on 26 December 2012

Big Data - An Introduction to Pig


In my previous article, I have explained Big Data and Hadoop in details. In this article I would like to go little deeper with Pig. Pig is a high-level platform for creating Map Reduce programs used with Hadoop. Pig is made up of two components: the first is the…

Read more

0 comments, 262 reads

Posted in SQL & BI on 25 December 2012

Big Data And Hadoop Part 2


In my previous blog I have given more insight on Big Data and now we will take a closer look at Hadoop.

Hadoop

Hadoop is a software framework that supports data-intensive distributed applications under a free license. It enables applications to work with thousands of nodes and petabytes (a thousand…

Read more

3 comments, 278 reads

Posted in SQL & BI on 24 December 2012

Big Data and Hadoop Part 1


Big Data Definition

As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools to capture, curate, manage, and process the data within a tolerable elapsed time.

Big data is an opportunity to find visions in new and emerging types of data and…

Read more

1 comments, 270 reads

Posted in SQL & BI on 14 December 2012

Parallel Execution in SSIS 2008 and later version


SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration Services (SSIS) does allow parallel execution. Now question is how we can configure SSIS to run in parallel? In SQL Server 2008 and later on version Integration Services, pipeline parallelism has been enhanced with architecture improvements to…

Read more

4 comments, 560 reads

Posted in SQL & BI on 29 September 2012

RANKING Function in plain SQL

Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using RANK() function.

DECLARE @StudentScore TABLE
(StudentName VARCHAR(1)
,StudentScore INT)

INSERT  @StudentScore VALUES ('A',85),
('B',90),
('C',90),
('D',99),
('E',88)


---RANK ----

SELECT
SS1.StudentName
,SS1.StudentScore
,(
 SELECT
COUNT(*) + 1
 FROM
@StudentScore SS2

Read more

0 comments, 210 reads

Posted in SQL & BI on 11 June 2012

OFFSET and FETCH Query Options in SQL Server 2012


If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly introduced in SQL Server 2012. You might have used TOP operator to return the top number of rows from a table. Probably you might also have used TOP operator…

Read more

2 comments, 359 reads

Posted in SQL & BI on 3 May 2012

SQL Azure Federation





 What is Federation?

  • Federation is a database object like other objects such as tables, views, stored procedures or triggers.
  • It is also known as Sharding.
  • There can be multiple federations in a database.
  • It is data dependent/data directed routing so it can scale out across databases.
  • It is a feature that you…

Read more

2 comments, 543 reads

Posted in SQL & BI on 25 April 2012

CONCAT in SQL 2012


SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to 255 string or variable values in to one single string. It requires a minimum of two input values when calling the function and takes care of implicitly converting the data…

Read more

0 comments, 336 reads

Posted in SQL & BI on 19 April 2012

Welcome IIF() to SQL Server Family


IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that allows you to perform IF..THEN..ELSE condition within a single function. This helps in simplified code and easy to read conditions.

In earlier versions of SQL Server,…

Read more

0 comments, 154 reads

Posted in SQL & BI on 18 April 2012

MDM (Master Data Management) Business Scenario


Introduction
Master Data Management (MDM), the process of creating and maintaining master data. As per definition Master Data Management (MDM) is a set of coordinated processes, policies, tools and technologies used to create and maintain accurate master data. Master data describes key area of business like customers, products, employee, suppliers,…

Read more

1 comments, 603 reads

Posted in SQL & BI on 13 October 2011

BI on SQL Azure


Introduction

A newly emerged concept ‘cloud computing’ is a phenomenon which is quickly embedding into all sectors of IT industry. Data Warehouse (DW) and Business Intelligence (BI) is no exception and are already touching it. It’s right time to identify the potential of existing DW/BI applications post migration to Cloud. Below…

Read more

2 comments, 365 reads

Posted in SQL & BI on 20 July 2011