Learning SSAS Part VII – Attribute Relationships Hello and welcome to the latest article in the Learning SQL Server Analysis Server series. The series started with the basic terminologies and techniques in Analysis Services before moving on to more complex things like building cubes. In the previous few articles we started diving deeper with hierarchies, advanced dimension properties and the...
Author: Kautuk Pandey
Learning SSAS: Part VI – Creating Hierarchies
Learning SSAS: Part VI – Creating Hierarchies Hello and welcome to the latest article in the Learning SQL Server Analysis Services series. Till now you must be familiar with a lot of things in SQL Server Analysis Services. In the previous articles of this series I have shown you how to create dimensions, facts and more importantly a cube using...
Learning SSAS: Part V – Creating Dimensions
Learning SSAS: Part V – Creating Dimensions Hello and welcome to the fifth part of the series. In the previous articles I showed you how to create an SSAS cube and build and deploy it to a target Analysis Server. In the process you should have learnt how to create Data Sources, Data Source Views, Diagrams and Calculated Columns etc....
Learning SSAS-Part IV: Deploying and Processing a cube
Learning SSAS-Part IV: Deploying and Processing a cube Hello and welcome to the fourth part of this series dedicated to learning SQL Server Analysis Services. In the previous articles you learnt the basics of Analysis Services. I talked about data sources, data source views, diagrams, calculated columns etc. before actually building an OLAP cube based on a star schema using...
Moving your SSIS package to a new server
Moving Your SSIS Package to a New Server by Kautuk Pandey Generally I do not write about SQL Server integration Services, keeping myself restricted to SQL Server and SQL Server Analysis Services. But, recently during the development of a data warehousing solution using Analysis Services I used Integration Services extensively (for dynamic partitioning and processing of the cube but that...
Learning SSAS: Part III- Building Cubes
Learning SSAS: Part III- Building Cubes Hello and welcome to the third part of this series dedicated to learning SQL Server Analysis Services. In the first article I talked about the basics of dimensional modeling and business intelligence. Also, the reader was acquainted with the jargon associated with data warehousing. In the second article the reader learnt few things about...
Learning SSAS-Part II: Data sources, Data source views
Learning SSAS-Part II: Data Sources, Data Source Views Welcome to the second part of the Learning SQL Server Analysis Services series. In the first article of the series you learnt the basics of business intelligence and data warehousing. You also understood about various terms like cube, dimension and facts. Now it is time to use this understanding and apply it...
Learning SQL Server Analysis Services: Part 1- Introduction
Learning SQL Server Analysis Services: Part 1- Introduction I recently decided to write about SQL Server Analysis Services and it didn’t take me long to realize that it will be a lot better to write a series of articles rather than making a mess of it in an all-in-one article. So, I am going to begin the series with an...
Columnar Databases and SQL Server Columnstore Indexes
Columnar Databases and SQL Server Columnstore Indexes Lately I have been working with Vertica – a column based database from HP and I have to admit that I am amazed by its capabilities and the functionalities it offers, especially when we are talking about relatively big data. The basic difference between SQL Server and Vertica is the way they store...
Spool Operators: Index spool and Window spool
Spool Operators: Index spool and Window spool In my previous article I talked about a few spool operators (Eager Spool, Lazy Spool and Rowcount Spool), now it’s time to talk about the remaining spool operators that the query optimizer uses to make our queries run faster. In this article I will talk about the Non Clustered Index Spool. Then I...