Author: Kautuk Pandey

Pro Members SQL Server Standard Members

Learning SSAS Part VII – Attribute Relationships

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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…....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register