SQL Server 2012 - Denali SSIS Enhancement Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “Denali”. This post comes as a supplementary addition to the earlier post which can be found here In this post, we shall have a walk through on the changes made in Annotation Annotation: A note by way of explanation or comment added to a text or diagram Before I begin I would...
Read More
SQL Server 2012 - Denali SSIS Enhancement Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “Denali”. This post comes as a supplementary addition to the earlier post which described one of the SQL Server T-SQL Enhancement In this post we shall preview Group and Connection Managers Group This is one of many new features added to the latest community release of SSIS. ...
T-SQL New feature for OFFSET and FETCH Please note the table is completely fictitious and all data is just for presentation purpose Consider a scenario below: English Product Name Reorder Point Dealer price Item 1 100 1000 Item 2 200 2000 Item 3 150 3000 Item 4 250 4000 Item 5 190 5000 Item 6 200 6000 Item 7 300 7000 Item 8 190 8000 Item 9 300 9000 Item 10 200 10000 This represents a limited data set. Assume you have a wide array of data with you. Now what if you were to list the rows from Row 1...
Find 4 th , 5 th and 6 th ranked entity Let me first confess. This blog was never a planned effort. It just happened. How it happened…that’s equally interesting. Most of the time you might find questions to determine “Nth highest/lowest salary” of an employee. I was thinking on the similar lines but to determine the 4 th , 5 th and 6 th highest/lowest ranked employee on the basis of their salary. The first idea that followed was to create a CTE (Common Table Expression) ...
Role Playing Dimension Yet another very important and rather very interesting feature of any successful implementation of an enterprise DW. As a matter of fact, the decision of using should be ideally be decided when in early stages of data modelling. The benefits are supreme, but again, it like every great feature there are short comings. In this following article, let us have a walk-through of Role Playing Dimension. In this article, we will try to have a brief understanding of Role Playing Di...
Of late I was asked to prepare a case study for 'Vertica' and therein the picture for ' analytic database ' and ' Big Data ' made me do more and even more study and explore opportunities. Perhaps, if you are still mesmerized like I am, the manner in which the ' Big Data ' has now become the talk of town, I am sure you will find the below mentioned links useful. Rainstor: http://rainstor.com/ Parstream: http://www.parstream.com/en/home/index.html and a wonderful post describing the market segment...
Data warehouse - A recession proof technology is now moving towards a whole new spectrum and with the advent of newer data architectures and better proposed solution engineering the mentioned references below aims to impart awareness about major facts for DW 2.0. URL: http://www.acs.org.au/nsw/sigs/bi/BI_SIG_20081126_Master_Copy.pdf AND URL: http://www.devgear.co.kr/pdf/bill-inmon-data-warehousing-2-0-whitepaper.pdf Thanks, Raunak Jhawar
Hello, I found this brilliant article on www.ssas-info.com . This piece of information is composed by Sorna Kumar Muthuraj . URL : http://www.ssas-info.com/analysis-services-scripts/3049-get-ssas-objects-with-amo-using-c - Kudos to the author!! Thanks, Raunak Jhawar
SSAS PERSPECTIVE Hello, So far I have compiled an article on SCD and the variety of transformations made available to us. The earlier post was divided into 2 parts. Part 1: Click here Part 2: Click here Let us now equip ourselves with perspectives. Before we learn about the mechanics of the perspectives, I propose we take a step back and do some elementary math. Yes you got me right!! Please follow the link by clicking here or just copy and paste the URL in the address bar. URL: http://www.sqlse...
Slowly Changing Dimension Pre-requisite: Understand what a dimension in a datawarehouse means Nothing in life is for permanent. The same applies to the underlying data at your data warehouse or data marts. In the following text I wish to highlight one of the brilliant aspects of data upserts (INSERT and/or UPDATE). The information provided will elaborate more about the Slowly Changing Dimension or commonly attributed as SCD and its types. To begin with, there exist 6 different types of SCD imple...